Rent Payment Reconciliation: Match Your Ledger to Bank Deposits

Set the scope before comparing totals

Choose a period, the properties or units included and the accounts you will review. Save a copy of the ledger and the relevant statement or payment report. For this guide, the scope is fictional October receipts for three units, with all amounts expressed in US dollars.

A rent ledger records charges and payments for a tenancy. A bank statement records money moving through an account. Stessa’s documentation illustrates another important distinction: a rent-payment entry and its later payout to a bank can be two records of one payment flow. Recording both as new rent would double count the same receipt.

Create a matching worksheet with separate fields

Use columns for unit, rent period, receipt reference, receipt date, ledger payment amount, bank reference, bank date, bank deposit amount and review status. Add a note for any unresolved difference. Keep each receipt identifiable even when several payments arrive in one bank deposit.

Start with the reference, then compare the amount and timing. A matching amount alone is weak evidence: two units may both pay $900. Where the bank reference is incomplete, consult the payment-provider report or supporting receipt before assigning a deposit to a tenant. Use anonymous unit labels in any sample you share publicly.

Work through four fictional receipts

October example: ledger receipts compared with deposits
Reference	Unit	Ledger receipt	October deposit	Review result
A-01	Unit A	$1,200	$1,200	Matched
B-01	Unit B	$900	$900	Matched
B-02	Unit B	$300	$0	Receipt dated 31 Oct; deposit confirmed 2 Nov
C-01	Unit C	$800	$800	Matched
Total		$3,200	$2,900	$300 timing difference

The calculation is $3,200 − $2,900 = $300. In this example, the later statement and payment reference confirm that B-02 arrived on 2 November. Record that evidence in the note. The October worksheet can show a documented timing difference; it should not silently change the October receipt date to force the totals to match.

If you cannot find the later deposit or supporting payment confirmation, leave the item unresolved and investigate. An expected transfer is not proof of receipt.

Use formulas as checks, not substitutes for matching

In a simple worksheet, put the ledger amount in E and the bank amount for the review period in H. The row difference in I2 is =E2-H2. Copy it down. With four receipts in rows 2–5, =SUM(E2:E5)-SUM(H2:H5) returns $300 for the example.

A zero total can hide two offsetting mistakes, so still inspect the rows. For example, one deposit assigned $100 too high and another $100 too low will cancel at total level. Check duplicate references, missing units and blank dates separately. Preserve the original bank values so that a correction remains explainable.

Handle grouped payouts and deductions explicitly

If a provider sends one payout for multiple receipts, create a separate payout group and connect each receipt to it. Compare the sum of those receipts with the provider’s payout detail before comparing the payout with the bank deposit. Do not repeat the full payout amount on every tenant row.

Where a payout includes deductions, record the gross receipts, documented deductions and expected net deposit separately. For an illustrative $1,000 receipt with a documented $20 deduction, the expected deposit is $980. A $980 bank deposit does not by itself explain which tenant paid or what the deduction represents. Retain the source record and use the treatment appropriate to your bookkeeping system.

Finish with an exception list

Give every unmatched item an action: find a missing receipt, check a duplicate, confirm a later deposit or ask the payment provider about a transfer. Record the owner of the follow-up, the evidence consulted and the date resolved. Keep unresolved items visible when carrying the review into the next period.

This worksheet checks rent-payment records. It is not a complete bank reconciliation, a trust-account reconciliation or a determination of tax or legal treatment. A full bank reconciliation may include other receipts, withdrawals and account adjustments. Rentec Direct’s three-way worksheet shows why property-management account reconciliation has a wider scope than matching rent receipts alone.

Download the example and connect it to your ledger

Download the fictional reconciliation CSV. It contains the four receipts and review notes from this article, with no real tenant details. The CSV contains example values, not an automated workbook; use it to inspect the column structure before building your own checks.

For recording charges and partial payments before this review, see our rent ledger with partial payments guide. SheetChief also sells a Rental Property and Tenant Rent Ledger spreadsheet for Google Sheets and Excel. Check its current Etsy previews for the included layout and features; this article does not imply that the product imports bank data or performs automatic reconciliation.

Put this into practice

Rent Ledger, Rental Property & Hospitality Tracking Templates · Try the free calculator

Compare the actual product previews and included files before choosing a paid template.

Sources and further reading

The explanations and worked examples are prepared for SheetChief. These sources support the referenced methods or platform instructions.

Questions, answered

Why do rent receipts and bank deposits differ?

Possible explanations include a later settlement date, a grouped payout, a documented deduction, a missing entry or an incorrect match. Verify the underlying records before deciding which explanation applies.

Does a zero reconciliation difference prove every payment is correct?

No. Offsetting mistakes can produce a zero total. Match individual references, amounts and dates and review duplicate or incomplete rows.

Is this a complete bank reconciliation?

No. The example matches rent receipts with deposits. A full bank or property-management account reconciliation can include other transactions, balances and requirements.