How does bank reconciliation relate to accounts receivable — how are customer receipts and deposits reflected in reconciling the bank account?

Where do receivables and the bank account actually meet?

Accounts receivable is a record of promises: an outstanding customer debt on a credit sale. When you invoice, accounts receivable increases and sales revenue increases, and no cash is involved. The bank reconciliation looks only at cash: it compares the cash balance in your accounting records with the balance on the bank statement, so that you can identify differences and record any adjustments.

The two records touch at one moment. When a customer pays, cash increases and accounts receivable decreases for the amount of the payment. That entry is the bridge: the receivable is relieved, and a cash debit is created that must later find its partner on the bank statement. Every receivables question you meet in a bank reconciliation is a question about that bridge: whether the receipt was recorded, whether it was banked, in what amount, and into which account.

Which receivables events will show up on the bank statement, and which will not?

Sort your receivables activity before you open the statement.

Events that never produce a bank item:

• Issuing an invoice. It raises the receivable and revenue. No money moves.
• Issuing a credit memo. It lets a customer reduce their open balance; it is not a payment of money.
• Writing off a bad debt. Under the allowance method, the allowance for doubtful accounts decreases and the specific customer's receivable decreases. Cash is not part of the entry. If you keep no allowance and charge the write-off straight to bad debt expense, the same is true: no cash moves.

Events that do produce a bank item:

• A customer payment that is deposited. Relieves the receivable and, once the bank credits it, appears as a deposit.
• A returned or bounced payment. Appears as a debit on the statement, often with a bank fee beside it.
• A refund you pay a customer. Appears as a withdrawal.
• A deposit, prepayment, retainer or overpayment from a customer. Appears as a deposit but relieves no invoice.

If you are searching the statement for a credit memo or a write-off, stop: its absence is correct.

Why is a receipt in the books but not on the bank statement?

There are four explanations, and only the first is harmless.

1. It is in transit. A deposit in transit is cash and checks you have received and recorded that the bank has not yet recorded. It happens when a deposit reaches the bank too late to be recorded that day, or is mailed, and at month-end it becomes a reconciling item. You add it to the bank statement balance in the reconciliation. You do not touch the receivable: the customer paid, and the receipt entry stays as it is.
2. It was recorded into the holding account but never banked. The check is still in a drawer, or was lost. The receipt sits in your holding position (see below) with no deposit behind it.
3. It was banked into a different account. The deposit is on the statement of another account you hold. Move the cash entry to the account that actually received the money.
4. It was deposited and then returned. Treat it as a returned payment, below.

A deposit in transit should clear within days, so run a report of deposits that have been in transit longer than usual, which may indicate processing issues or errors. When an old receipt refuses to clear, do not delete it to tidy the reconciliation. Deleting it re-opens the customer's invoice and erases the record of a payment the customer may genuinely have made. Find the check, the deposit slip or the customer's proof of payment first, then correct whichever of explanations 2 to 4 applies.

Why does one deposit on the statement cover several customer payments?

Because that is how banks record deposits. Deposit five $100 checks from different customers at once and the bank records one $500 deposit. The reconciliation therefore matches a deposit total, not individual receipts, and your books must let you rebuild that total.

The standard tool is a holding or clearing account (QuickBooks calls it Undeposited Funds), a temporary lockbox for payments until you record a formal bank deposit. Each receipt is recorded individually against its invoice, relieving each receivable, but the debit goes to the holding account instead of the bank. When you take the batch to the bank, one deposit entry moves the combined amount from the holding account to the bank account. That entry is what matches the statement line.

QuickBooks notes you do not need that account if you are downloading transactions directly from your bank. With a bank feed, pick one route and stay on it: either match the downloaded deposit to the receipts behind it, or keep using the holding account and match the feed line to your deposit entry. Do both and the same money is recorded twice.

A balance left in the holding account after the deposits have cleared means a receipt was recorded but never included in a deposit: it is still on hand waiting to be banked, lost, or recorded twice. The bank reconciliation can still agree while this happens, because the holding account is not the bank account. Check that it empties as deposits clear, and investigate anything older than your normal deposit cycle.

Do not record a batched deposit as a single receipt from one customer so the bank line matches. The reconciliation clears, but every other invoice in the batch stays open and one customer is credited with money they did not send.

What does it look like with three receipts, two deposits and one still in transit?

Invoices outstanding at the start: Customer A 1,200.00, Customer B 800.00, Customer C 500.00 (receivables 2,500.00). Books and bank both show cash of 10,000.00.

• June 28: payments from A and B are recorded against their invoices into the holding account.
• June 29: A and B are deposited together; the bank credits one line of 2,000.00 that day.
• June 30: C's payment is recorded and deposited after the bank's cutoff. The bank credits it on July 1.

Balances after each step:

At June 30 the reconciliation reads: bank balance 12,000.00, plus deposit in transit 500.00, equals book balance 12,500.00. Receivables are zero because all three customers paid. The holding account is zero because every receipt was deposited. The only difference is timing, and it clears when the July statement shows 500.00 credited on July 1.

How do you record a receipt that arrives net of a fee or deduction?

Relieve the receivable for the full invoice amount and record the deduction separately. The textbook card sale records revenue at the original sales amount and the card company's fee as a separate expense, with only the net amount ever due from the card company. Apply the same principle to an invoice you have already raised: the customer owed, and paid, the full amount, so the customer's receivable is relieved in full and the fee is your expense.

For a 1,000.00 invoice paid by card with a 30.00 fee deducted before the money reaches the bank:

The statement shows 970.00, the invoice closes at zero, and the fee is a visible cost. Relieve the receivable for 970.00 instead and the invoice carries a 30.00 unpaid residue forever while the fee never appears as an expense. A customer who simply short-pays is different: the shortfall stays open on the invoice until you resolve it with the customer.

What changes when a card or online processor settles for you?

When most receipts come through a processor, the bank line is no longer a customer payment. It is a settlement of a batch of payments and other transactions, released on the processor's timetable; what your processor deducts before paying out is stated in its own documentation. Stripe, for example, says your payout schedule determines when it sends money to your bank account, and that the schedule does not change how long a pending balance takes to become available. Its payout reconciliation report for accounts on automatic payouts exists to match the payouts you receive with the batches of payments and other transactions they relate to, and it separately lists transactions not yet settled at the report's end date.

In your books, the processor balance behaves like a second holding account. Customer payments relieve receivables into a processor clearing account at gross. Where the processor deducts its fees before paying out, fees reduce that clearing balance, and each payout moves the net amount to the bank. At month-end, the clearing balance should equal what the processor reports as not yet paid out. Tying an individual payout to the sales, fees and refunds behind it is a separate procedure, covered in the payout guide listed below.

What do you do when a customer's payment is returned?

A bounced check or reversed electronic payment appears as a debit on the statement, often followed by a bank fee. Reversing only the cash is not enough. A returned insufficient-funds check needs a journal entry that reflects the non-payment on the customer's account: the receivable the original receipt relieved comes back. In invoicing software, check that the amount shows as owed again against that customer; a bare journal entry may leave the original invoice marked paid.

Record bank charges shown on the statement as expenses. If you do charge the customer for it, record that as a separate charge, not as part of the original invoice.

Why is there a deposit nobody can explain and an invoice still showing open?

A deposit on the statement that matches no recorded receipt has four explanations, and each has its own confirming check.

1. A batched deposit. Add up the receipts in the deposit entry, or the checks on the deposit slip, and compare that total with the statement line.
2. A net settlement. Check that the gross receipts less the deduction, or the processor's payout report for the period, comes to the amount credited.
3. A customer payment never recorded, or recorded without being applied to the invoice. This is the only one of the four in which a receivable is overstated. Confirm it with the open-invoice search below.
4. Not a customer receipt at all. Loan proceeds, owner contributions, transfers between your own accounts, tax refunds and vendor refunds all produce deposits. Confirm from the payer in the bank description or from the loan or transfer record; only money that belongs to a customer should touch receivables.

The third explanation is the one that pairs with an invoice still showing open, so treat the two as one problem until proven otherwise. The payment reached the bank but was posted straight to an income account, or matched from the bank feed as a new sale. The reconciliation shows a deposit with no receipt behind it, or one coded to revenue, while the receivables report still shows the invoice unpaid, and revenue is counted twice: once on the invoice and once on the deposit.

The check that connects the halves: for each unexplained deposit, search open invoices for the same amount, for combinations of invoices that sum to it, and for the payer's name in the bank description or remittance detail. When you find the match, correct both sides at once: take the deposit out of income and apply it to the open invoice, so revenue is counted once, the invoice closes and the deposit is explained. If the deposit falls in a period you have already closed or reported, do not re-code it there without checking with your accountant, because the correction changes that period's income. Working through a longer list of wrongly open invoices is covered in the unpaid-invoice guide listed below.

How do overpayments, deposits and retainers fit in?

These produce a bank deposit without relieving any invoice, because the money arrives before or beyond what is owed.

• Customer deposits, prepayments and retainers. A customer deposit is initially recorded as a liability. Once you perform the work, the liability is debited and revenue credited, or the deposit is applied against the invoice. Record a 2,000.00 advance as a debit to cash and a credit to a customer-deposits liability, not as a credit to receivables, which would create a negative customer balance nobody can explain later.
• Overpayments. If a customer overpaid by accident, you can refund them; otherwise hold the excess as a credit on the customer's account and apply it to their next invoice.

In the bank reconciliation these are ordinary deposits that match normally. The work is on the other side. An advance belongs in a customer-deposits liability, not in revenue. An overpayment you intend to apply is held as a credit on that customer's receivables account: it will show as a negative balance in the aging, which is correct as long as you can name the overpayment behind it. Where money received belongs to the client rather than to you, the rules for holding it come from the authority that governs that account and are outside this answer.

What if your books are on the cash basis?

On the cash basis, transactions are recorded only when there is a related change in cash, so there are no accounts receivable to record; no transaction is considered to have occurred until the customer pays. The relationship described here largely falls away. A deposit is revenue on the bank date, with no invoice to relieve and no receivable for a returned payment to reinstate. If you report on the cash basis but still issue invoices and record payments against them in your software, the invoice ledger exists and everything above still applies to it.

What still applies: batching (split the deposit total by customer and income type), net settlement (record gross revenue and the fee separately), deposits in transit at period end, returned payments (reverse the revenue and record the bank fee), and the rule that loans, transfers and refunds are not revenue.

What does a finished bank reconciliation prove about receivables?

At period end, receipts recorded but not yet credited appear as deposits in transit on the reconciliation, supported by the deposit slip and by their appearance on the next statement. That makes the cash balance supportable, and shows that every deposit you recorded in the bank account actually reached the bank. It says nothing about receipts still sitting in the holding account, which the reconciliation never sees.

A receipt still in the holding account at period end is not a deposit in transit and does not appear on the bank reconciliation. Support it separately: list the items making up the holding balance and confirm each was banked in the first days of the next period.

That is the limit. A balanced reconciliation proves the cash account agrees with the bank. It does not prove the receivables balance is right. Errors that never touch cash pass through unexamined: invoices raised twice or to the wrong customer, credit memos not applied, bad debts not written off, and a payment applied to the wrong customer's invoice (cash is right; customer balances are wrong). Receivables still need their own checks: an aging review for stale and negative balances, a review of the holding and processor clearing accounts for receipts that never reached the bank, and a tie-out of the customer ledger to the receivables control account.