How Do You Do a Bank Reconciliation? A Guide to Matching the Bank Statement with Your Records, the Reconciliation Table and Finding Differences
How do you do a bank reconciliation? Matching the statement with your records, the reconciliation table, timing and recording differences, and finding the difference: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is a bank reconciliation and why do it?
- Lesson 2: Why do differences arise between the bank and your records?
- Lesson 3: How do you prepare before reconciling?
- Lesson 4: How do you match statement transactions with your records?
- Lesson 5: How do you prepare the reconciliation table?
- Lesson 6: Which items make up timing differences?
- Lesson 7: How do you correct recording differences and find the remaining difference?
- Lesson 8: How do you set up a month-end bank reconciliation routine?
- What are the most common mistakes in bank reconciliation?
- How does NetKasam make tracking bank accounts easier?
- Mini quiz: Test what you have learned
- Conclusion: Match the statement with your records this month end
- Frequently Asked Questions About Bank Reconciliation
Month end has arrived: the bank statement says ₺184,500, your records show ₺187,250. Where is the ₺2,750 in between? A cheque may not have reached the bank yet, a card collection may not have been credited to the account, a bank charge may not have been recorded. The only reliable way to find the difference is to match the statement with your records transaction by transaction and classify the differences that emerge. This is called bank reconciliation.
This article is not just an explanation; it is an 8-lesson practical course. It answers how to do a bank reconciliation with numbers; using a single month-end example, we will work through the reasons for the difference between the statement and the book balance, the reconciliation table, the distinction between timing and recording differences, the effect of card and marketplace collections, and methods for finding differences. At the end there is a mini quiz and a month-end routine. What is covered here is reconciling your own bank account with your records; for account reconciliation with customers and suppliers, see the article what is account reconciliation and how is it done.
What will you be able to do by the end of this training?
In short: You will match the statement with your records, classify the open items, prepare the reconciliation table, correct recording differences and apply methods for finding the remaining difference.
- 01DataGet the month-end statement and the bank records for the same period.
- 02MatchingMatch each statement transaction with a record by amount and date.
- 03Open itemsList the unmatched transactions and sort them by type.
- 04TablePrepare the reconciliation table from both sides.
- 05CorrectionClose recording differences with correcting entries.
- 06ApprovalIf the adjusted balances are equal, sign and keep the table.
The 8 lessons of the course: (1) what bank reconciliation is, (2) why differences arise, (3) preparation, (4) matching transactions, (5) the reconciliation table, (6) timing differences, (7) recording differences and finding the remaining difference, (8) the month-end routine.
Lesson 1: What is a bank reconciliation and why do it?
In short: Bank reconciliation means confirming that the balance on the bank statement agrees with the bank balance in your own records. Its purpose is to catch errors, forgotten transactions and unauthorized transactions early, and to make your cash information reliable.
| Which reconciliation? | What is compared | Who does it? |
|---|---|---|
| Bank reconciliation | The bank statement and your own bank records | The business (accounting) |
| Cash register closing | Counted cash versus expected cash | The cashier; see cash register closing |
| Account reconciliation | Mutual balance with a customer or supplier | The business and the counterparty; see account reconciliation |
This article covers only the first row. A bank confirmation letter, obtained from the bank and usually requested during an audit, is a different document. If records are not kept regularly, reconciliation becomes hard work; that is why recording at the time of the transaction is essential.
Lesson 2: Why do differences arise between the bank and your records?
In short: Differences arise for two reasons: a transaction has not yet appeared on one of the two sides (a timing difference), or one side recorded the transaction incorrectly or not at all (a recording difference). The first is expected; the second is corrected.
| Type | Example | On the statement | In the books | Transaction |
|---|---|---|---|---|
| Timing | A cheque written on the last day of the month, not yet presented | None | Yes | Wait; it closes when the cheque is presented |
| Timing | Cash or a card collection deposited at month end, credited the next day | None | Yes | Wait; it closes when it is credited |
| Recording | Bank charge or commission deduction | Yes | None | Create an expense entry |
| Recording | A transfer received without a description | Yes | None | Find which customer it is from and record the collection |
| Recording | The same payment recorded twice | Once | Twice | Cancel the duplicate entry |
| Recording | Amount entered incorrectly | Correct | Wrong | Correct the entry |
Lesson 3: How do you prepare before reconciling?
In short: Take the same period (e.g. September 1-30) on both sides with the same dates, add the previous period's open items to the list and keep the statement in digital form (PDF, Excel). If the periods are not the same, an artificial difference appears.
- Get the statement: Get the statement from the bank with the month-end balance and all transactions.
- Pull your records: Report the bank transactions for the same account for the same period.
- Check the opening balance: Both sides should start with the previous month-end balance; if not, the previous month's reconciliation is incomplete.
- Bring in the previous open items: Check whether last month's cheques and collections in transit closed this month.
- Separate the accounts: Do a separate reconciliation for each bank account and currency.
In NetKasam, cash and bank records are created automatically at the same time as your transactions; having the records ready shortens the reconciliation work. You can save reports with filters, export them to Excel and put them side by side with the statement (reports).
Lesson 4: How do you match statement transactions with your records?
In short: Match each statement line with the line in your records by amount, date and description; tick the matched line. The unticked lines that remain are your open items.
- Match by amount: Find transactions with the same amount; where an amount repeats on more than one line, look at the date.
- Look at the date: There may be a few days' gap between the bank date and the record date; set a reasonable window.
- Read the description: A transfer description may contain the customer name or invoice number.
- Break down bulk transactions: One statement line may consist of several records (a bulk collection, a daily card collection).
- Tick and count: Count the matched and unmatched lines.
- Matched directly₺10890%
- Timing difference₺97.5%
- Recording difference₺32.5%
Prepared with sample values. The match rate is 108 ÷ 120 = 90%.
As the number of transactions grows, manual matching becomes tiring. Recording transactions correctly at the time they happen is the best safeguard. To keep collections and payments matched with accounts, see the online collection and expense management pages.
Lesson 5: How do you prepare the reconciliation table?
In short: The reconciliation table is two-sided: to the statement balance you add deposits in transit and subtract outstanding cheques and payments; to the book balance you apply the unrecorded statement transactions. The two adjusted balances must be equal.
- Adjusted bank balance = Statement balance + Deposits in transit − Outstanding cheques and payments
- Adjusted book balance = Book balance + Unrecorded inflows − Unrecorded outflows
- Reconciliation difference = Adjusted bank balance − Adjusted book balance
- Match rate = Matched transactions ÷ Total transactions
- Raw difference = Statement balance − Book balance
- The 9 check = If the remaining difference is divisible by 9, digits may have been transposed
When the reconciliation difference is zero, the table is closed.
Example: At the end of September the statement balance is ₺184,500 and the book balance is ₺187,250 (raw difference −₺2,750). Open items: a ₺12,000 collection deposited at month end and credited the next day, an issued cheque of ₺9,600 not yet presented, and a bank charge of ₺350 that appears on the statement but was not recorded.
- Statement balance₺184,500
- Collection not yet credited₺12,000
- Cheque not yet presented−₺9,600
- Adjusted bank balance₺186,900
Prepared with sample values.
| Book side | Amount |
|---|---|
| Book balance | 187.250 ₺ |
| Unrecorded bank charge | −350 ₺ |
| Adjusted book balance | 186.900 ₺ |
| Reconciliation difference | 0 ₺ (186.900 − 186.900) |
Both sides are equal: the reconciliation is complete. The only thing that needs correcting is recording the ₺350 charge; the cheque and the collection are timing differences and close on their own.
Recommended ReadingHow Do You Track Cheques and Promissory Notes?Lesson 6: Which items make up timing differences?
In short: The most common timing differences are cheques not yet presented, cash deposited at month end and credited the next day, card collections not yet credited to the account, and marketplace payouts. These are listed, and you confirm that they close in the next period.
| Item | Why is it a timing difference? | How does it close? |
|---|---|---|
| Cheque issued but not yet presented | Paid in your records, not yet debited at the bank | Appears on the statement when the cheque is presented |
| Cheque handed to the bank but not yet collected | Recorded as an inflow, not on the statement | When the cheque is collected |
| Cash deposited at month end | The bank transaction rolls over to the next day | Appears on the statement the next day |
| Card collections | Credited after the bank's waiting period and commission | When credited; the net amount is lower than the sale |
| Marketplace payout | Paid according to the marketplace's payment schedule | When the payment arrives; tracked as a receivable |
- Collection not yet credited₺12,000
- Cheque not yet presented₺9,600
- Unrecorded bank charge₺350
Prepared with sample values. The first two items are timing differences; the third is a recording difference.
For card collections, the amount credited to the account is the net amount after commission; for rates see the pricing page, for how payments taken by link reach the account see the article how to accept payment by link, and for recording marketplace payouts see the article marketplace accounting. For handing cheques and promissory notes to the bank, see the question can I send cheques and promissory notes to the bank for clearing.
Lesson 7: How do you correct recording differences and find the remaining difference?
In short: A recording difference is closed with a correcting entry: an unrecorded charge as an expense, an undescribed transfer as a collection, and a duplicate entry by cancelling it. If the remaining difference is divisible by 9, digits have been transposed; if it equals the amount of a single transaction, look for that transaction.
- Search for the difference amount: Is there a statement or book transaction of exactly that amount?
- Check half the difference: If the difference is an even number, a transaction of half that amount may have been posted in the wrong direction (outflow instead of inflow).
- Apply the rule of 9: If the remaining difference is a multiple of 9 (e.g. 90, 270, 450), two digits may have been transposed. If 1,980 is written instead of 1,890, the difference is 90.
- Look for duplicate entries: Are there two entries with the same amount and date?
- Check the previous period: Are the opening balances the same?
| Difference | Correction | Recording |
|---|---|---|
| Bank charge on the statement, not in the records | Create an expense | Expense and bank outflow |
| Undescribed transfer | Find the customer and invoice, record the collection | Collection and account reduction |
| Duplicate payment entry | Cancel the repeated entry | Reversing entry |
| Wrong amount | Correct the entry with the right amount | Correcting entry |
In NetKasam, the expense voucher for bank charges arising from collections or payments is created automatically by the system, and if the charge belongs to a different cash account it is posted to the relevant account (how can I create my bank charges). When you cancel an expense voucher, all movements of the transaction are updated with a reversing entry. The internal source of recording differences is usually transactions not entered on time; to monitor cash flow, you can also see the cash flow statement guide.
Lesson 8: How do you set up a month-end bank reconciliation routine?
In short: The reconciliation is done on the same day at every month end, signed and kept. With high transaction volume, weekly partial checks shorten the month-end work.
| When? | What to do? | Who? |
|---|---|---|
| Every day | Record incoming and outgoing transactions | Accounting |
| Every week | Quickly match the latest statement transactions with your records; resolve undescribed transfers | Accounting |
| Month end +1-3 days | Get the statement, match it and prepare the reconciliation table | Accounting |
| Month end +5 days | Correct recording differences, approve the table and keep it | Manager |
| Next month | Confirm that the previous month's open items have closed | Accounting |
- −₺2,750raw difference (statement − books)
- ₺186,900adjusted balance on both sides
- ₺0$0reconciliation difference
- 90%direct match rate (108 ÷ 120)
What are the most common mistakes in bank reconciliation?
- Comparing only the balance. If you do not look at the transactions, two errors that cancel each other out stay hidden.
- Not aligning the period. If the statement ends on the 30th and the records on the 28th, an artificial difference appears.
- Not following up on timing differences. If a cheque or collection in transit does not close the next month, a problem is hidden.
- Dumping the difference into an account to close it. A difference whose cause is not found grows later.
- Not recording bank charges and commissions. Your records constantly look higher than the bank.
- Leaving an undescribed transfer waiting. The collection stays open on the customer's account.
- Reconciling once a year. The difference cannot be found at year end.
How does NetKasam make tracking bank accounts easier?
- Automatic cash and bank records. Cash and bank records are created at the same time as your transactions; no manual double entry is needed (expense management).
- Automatic bank charges. An expense voucher is created for bank charges arising from collections or payments.
- Cancellation by reversing entry. When you cancel an expense voucher, the whole transaction is updated with a reversing entry; the record history stays intact.
- Cheque and promissory note tracking. You track cheques and promissory notes with their bank handover and collection status (cheques and promissory notes).
- Saved reports. You save the bank transaction report with its filters, export it to Excel and compare it with the statement (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If the statement balance is ₺50,000, deposits in transit are ₺4,000 and outstanding cheques are ₺6,500, what is the adjusted bank balance?
- If the book balance is ₺47,600 and an unrecorded bank charge is ₺100, what is the adjusted book balance? Does it reconcile with the balance in the first question?
- Is a cheque not yet presented a timing difference or a recording difference?
- If the remaining difference is ₺270, what is the first thing you think of?
- Why is a card collection credited to the account at less than the sale amount?
Answer key:
- 50.000 + 4.000 − 6.500 = 47.500 ₺.
- 47,600 − 100 = ₺47,500; yes, the two balances are equal and the difference is 0.
- A timing difference; it closes on its own when the cheque is presented.
- 270 is a multiple of 9; check whether two digits may have been transposed (e.g. 1,980 instead of 1,890).
- The bank deposits the net amount after deducting its commission, and it is delayed by the waiting period.
Frequently Asked Questions About Bank Reconciliation
How do you do a bank reconciliation?
Transactions on the month-end statement are matched with your records by amount and date, unmatched items are separated into timing and recording differences, a two-sided reconciliation table is prepared, and you confirm that the adjusted balances are equal.
What is a bank reconciliation table?
It is a two-sided table: one side starts from the statement balance and applies deposits in transit and outstanding cheques, the other starts from the book balance and applies unrecorded transactions, and it shows that the two results are equal.
What is the difference between a timing difference and a recording difference?
A timing difference means a transaction has not yet appeared on one of the two sides (such as a cheque not yet presented), and it closes on its own. A recording difference means one side recorded the transaction incorrectly or not at all, and it requires a correcting entry.
How often should you do a bank reconciliation?
At least once a month, at month end. If your transaction volume is high, weekly partial matching shortens the month-end work.
What should I do if I cannot find the remaining difference?
Look for a single transaction equal to the difference, check half the difference (a sign error), check for transposed digits if it is divisible by 9, look for duplicate entries and verify the previous period's opening balances.
How do you record a bank charge?
It is recorded as an expense and deducted from the bank account. In NetKasam, the system automatically creates an expense voucher for charges arising from collections or payments.
Why does a card collection appear lower than the sale on the statement?
The bank deposits the net amount after deducting its commission, and the payment reaches the account after a short waiting period. That is why the sale amount and the amount credited to the account differ.
Can I monitor my bank accounts in NetKasam?
Yes. Cash and bank records are created automatically at the same time as your transactions, bank charges are recorded as expense vouchers, and you can export reports to Excel and compare them with the statement.
Conclusion: Match the statement with your records this month end
Bank reconciliation may look like a complicated accounting task, but its logic is simple: bring two balances to the same point. This month end, get the statement, match the transactions with your records, separate the open items into timing and recording differences and fill in the reconciliation table. The first time may take an hour; done regularly, it drops to minutes and your cash information becomes reliable.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.