Accounting › Section G · Fraud, internal controls, and cash › Topic G.5

Bank reconciliations

The bank statement and the company's Cash account almost never show the same balance on the same day. A bank reconciliation explains every difference, finds the entries the company still has to make, and is one of the most effective controls over cash.

Why the two balances differ

The company and its bank both keep a record of the same account, but they learn about transactions at different times. When the company writes a cheque, it records the payment at once, yet the bank deducts it only when the cheque is presented, days or weeks later. When a customer pays by electronic transfer, the bank records it before the company may notice. Mistakes happen on both sides too. A bank reconciliation is an internal schedule, prepared by the company, that starts from both balances, adjusts each for the items it does not yet include, and ends with one adjusted balance: the true cash figure.

Adjustments to the bank balance

Some items are already in the company's books but not yet on the bank statement. These adjust the bank side. A deposit in transit is cash the company has recorded and deposited, often late on the last day, that the bank has not yet processed: add it to the bank balance. An outstanding cheque has been written and recorded by the company but has not yet cleared the bank: subtract it. Bank errors, such as a cheque belonging to another customer charged to this account, are corrected on the bank side and reported to the bank. None of these items needs a journal entry, because the company's books already show them correctly.

Adjustments to the book balance

Other items appear on the bank statement but not yet in the company's books. These adjust the book side. Add amounts the bank has collected for the company, such as electronic customer payments or a note collected on its behalf, and any interest earned. Subtract service charges and other bank fees, and any NSF cheque: a customer's cheque the company deposited that bounced because the customer had nonsufficient funds, so the bank took the money back. Correct the company's own errors, such as a cheque recorded at the wrong amount. Every book-side item needs a journal entry, because the company's Cash account is wrong until it is recorded.

The procedure step by step

Start with the balance on the bank statement and the balance in the Cash account on the same date. Compare each deposit in the books with the deposits on the statement; any recorded deposit missing from the statement is in transit. Compare the cheques written with the cheques the bank has paid, including last month's outstanding cheques; those still unpaid are outstanding. Read the statement for charges, credits and bank memos the books do not show. Look for errors on either side. Then work out both adjusted balances, which must be equal. Finally, journalise every book-side item so the ledger's Cash balance agrees with the adjusted figure.

Worked example: preparing the reconciliation

On 30 June, Ridgeway Print Studio's bank statement shows $18,460 and its Cash account $15,901. 1. Bank side: add a deposit in transit of $3,150; subtract outstanding cheques of $1,280, $905 and $2,340, totalling $4,525; add $260 for another customer's cheque the bank charged in error. Adjusted bank balance: $18,460 + $3,150 − $4,525 + $260 = $17,345. 2. Book side: add a $1,900 electronic payment from a customer and $14 of interest; subtract a $480 NSF cheque and a $35 service charge; add $45 because cheque 410 for the electricity bill was written for $627 but recorded as $672. Adjusted book balance: $15,901 + $1,900 + $14 − $480 − $35 + $45 = $17,345. 3. Check: both sides agree.

Worked example: recording the book-side items

Only the book-side items from Ridgeway's reconciliation are journalised; Accts Receivable is short for Accounts Receivable. The increases can be combined into one entry:

\begin{array}{lrr} \text{Account} & \text{Debit} & \text{Credit} \\ \hline \text{Cash} & 1{,}959 & \\ \quad\text{Accts Receivable} & & 1{,}900 \\ \quad\text{Interest Revenue} & & 14 \\ \quad\text{Utilities Expense} & & 45 \end{array}

The decreases form a second entry:

\begin{array}{lrr} \text{Account} & \text{Debit} & \text{Credit} \\ \hline \text{Accts Receivable} & 480 & \\ \text{Bank Fee Expense} & 35 & \\ \quad\text{Cash} & & 515 \end{array}

Check: Cash rises by $1,959 − $515 = $1,444, taking it from $15,901 to $17,345, the adjusted balance. The $45 credit reduces Utilities Expense because the bill was really $627.

Why NSF cheques go back to receivables

When a customer's cheque bounces, the company has lost the cash it thought it had, but the customer still owes the money. So the entry debits Accounts Receivable, re-creating the customer's debt, and credits Cash. The company then contacts the customer for payment and may pass on any fee its bank charged. If the cheque came from a cash sale with no customer account, the business still records the amount as a receivable from the person who wrote it. Collecting it later, or writing it off if it proves uncollectible, follows the methods in the topic "Uncollectible accounts and the allowance method".

Hunting for an unexplained difference

If the two adjusted balances do not agree, the size of the difference is a clue. If it equals a single item, look for that item missed or counted twice. If it is twice an item, that amount was probably added when it should have been subtracted, or the reverse. If it is divisible by 9, suspect a transposition, two digits swapped: Ridgeway's $672 recorded for $627 gives a difference of $45, and $45 ÷ 9 = 5. A slide, such as $1,250 entered as $125, also leaves a difference divisible by 9. Recheck the additions last, since arithmetic slips are common when the reconciliation is done by hand.

The reconciliation as a control

A reconciliation is a detective control, and it works only if the right person does it. It should be prepared monthly, soon after the statement arrives, by someone who neither handles cash nor records cash transactions, and reviewed by a manager. Otherwise a cashier could take money and hide the shortage by inventing a deposit in transit or leaving out an outstanding cheque. Warning signs include deposits in transit that are old or never clear in the next statement, outstanding cheques months old, and reconciling items that are round numbers with no support. Many banks now let the company download transactions daily, so differences can be caught within days.

Common mistakes to avoid

First, journalising bank-side items such as deposits in transit or outstanding cheques; the books already show them correctly. Second, forgetting to journalise book-side items, which leaves the ledger's Cash balance wrong after the reconciliation balances. Third, adding outstanding cheques to the bank balance instead of subtracting them. Fourth, treating an NSF cheque as an expense; the customer still owes the money, so Accounts Receivable is debited. Fifth, correcting a book error in the wrong direction: a payment recorded at more than its true amount understates Cash, so the difference is added back to the book balance.

Key takeaways

A bank reconciliation explains why the bank balance and the book balance differ and arrives at one adjusted cash figure. Bank side: add deposits in transit, subtract outstanding cheques, correct bank errors; no entries needed. Book side: add collections and interest, subtract service charges and NSF cheques, correct book errors; every item needs a journal entry. Both adjusted balances must be equal. An NSF cheque re-creates a receivable. A difference divisible by 9 suggests a transposition or slide. The reconciliation should be done monthly by someone independent of cash handling and recording, and reviewed, which makes it a strong detective control.

Flashcards

Flashcard

Bank reconciliation

A schedule explaining the differences between the bank balance and the book balance

Ends with one adjusted cash figure.

Test your understanding

Question 1 of 5

A bank statement shows $9,200. There is a $1,400 deposit in transit and $2,150 of outstanding cheques. What is the adjusted bank balance?

Question 2 of 5

Which reconciling item requires a journal entry in the company's books?

Question 3 of 5

A customer's $320 cheque, deposited last week, comes back marked NSF. Which entry does the company make?

Question 4 of 5

A cheque paying a supplier was written for $529 but recorded in the books as $592. How is this handled on the reconciliation?

Question 5 of 5

Who should prepare a company's monthly bank reconciliation?

← Previous topicNext topic →