Reconcile a returned resident payment across three records

A returned resident payment should move back to an open exception until the property record, QuickBooks record, and bank activity tell the same supported story. Preserve the original receipt and return evidence, reopen the resident obligation under the approved process, and document any fee separately. Do not delete the original payment merely to make the current balance look right.

The exact correction method depends on the property software, accounting design, and responsible accountant. This workflow controls the evidence and reconciliation across systems.

Start with the bank evidence

Collect the original deposit reference, bank return or reversal, effective date, amount, resident and property identifiers, and any bank fee shown separately. Confirm whether the bank reversed one resident payment or a grouped deposit containing several payments.

Do not infer the resident from the amount alone. If the bank description is incomplete or the payment was part of a batch, keep the item open until the processor or deposit detail identifies it.

Build a three-record returned-payment bridge

Use one exception ID and compare these records:

1. Property record. Identify the resident charge, original receipt, property, unit, and current resident-ledger status.
2. QuickBooks record. Identify the related receipt, deposit, clearing entry, or summary reference under the documented system-role design.
3. Bank record. Identify the original credit, returned debit or reversal, effective date, and any separately stated fee.

For each record, capture the amount before correction, approved action, amount after correction, reference, and reviewer. The bridge should show whether the resident balance is open, whether a clearing or cash difference remains, and whether a fee needs separate treatment.

Intuit’s current guidance describes recording a returned customer payment so the original invoice becomes open again and treating the bank fee separately.¹ Intuit also cautions against deleting an original electronic payment merely because it was later returned or reversed.² Product navigation and available features vary. The responsible accountant decides the transaction method and accounting date.

Worked example: one payment, one separate fee

Illustrative example. Property software shows a $1,850 resident payment as received on September 8. QuickBooks includes the same amount in deposit batch D-908, and the bank credits that batch. On September 11, the bank returns the $1,850 payment and separately charges a $25 fee.

The $1,850 return restores the supported resident obligation; it does not create a second charge. The $25 fee is a separate fact and should not be added to the resident ledger without the firm’s approved policy, agreement support, and accounting treatment.

If QuickBooks holds only a summarized property-to-company transfer, document whether that summary needs adjustment. Do not reproduce every resident-level transaction in QuickBooks when the system-role map says the property software is the resident subledger.

Resolve grouped-deposit differences carefully

When the original payment was part of a grouped deposit, reconcile the full batch before changing a deposit entry. Tie the batch total to its resident receipts, isolate the returned item, and retain the unchanged items. A return for one resident should not make the other receipts appear unpaid.

If the processor nets the return against later deposits, record both the gross return and the net settlement relationship in the bridge. A later net deposit is not proof that the resident repaid the obligation.

Close only after all three records agree

Before closing the exception, confirm that:

• the original receipt and return evidence remain traceable;
• the resident ledger shows the approved current status;
• QuickBooks reflects the approved accounting effect without a duplicate receipt or charge;
• the bank return and any fee reconcile to the statement;
• grouped-deposit items not involved in the return remain unchanged; and
• any unresolved amount has an owner and review date.

Use the property-software and QuickBooks system-role guide before deciding where the correction belongs. Keep any unmatched return in the reconciliation exception log until the evidence supports closure.