EN
Payments and Collections

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is a bank reconciliation and why do it?
  3. Lesson 2: Why do differences arise between the bank and your records?
  4. Lesson 3: How do you prepare before reconciling?
  5. Lesson 4: How do you match statement transactions with your records?
  6. Lesson 5: How do you prepare the reconciliation table?
  7. Lesson 6: Which items make up timing differences?
  8. Lesson 7: How do you correct recording differences and find the remaining difference?
  9. Lesson 8: How do you set up a month-end bank reconciliation routine?
  10. What are the most common mistakes in bank reconciliation?
  11. How does NetKasam make tracking bank accounts easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Match the statement with your records this month end
  14. 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.

Course mapThe six steps of bank reconciliation
  1. 01
    DataGet the month-end statement and the bank records for the same period.
  2. 02
    MatchingMatch each statement transaction with a record by amount and date.
  3. 03
    Open itemsList the unmatched transactions and sort them by type.
  4. 04
    TablePrepare the reconciliation table from both sides.
  5. 05
    CorrectionClose recording differences with correcting entries.
  6. 06
    ApprovalIf 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 comparedWho does it?
Bank reconciliationThe bank statement and your own bank recordsThe business (accounting)
Cash register closingCounted cash versus expected cashThe cashier; see cash register closing
Account reconciliationMutual balance with a customer or supplierThe 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.

TypeExampleOn the statementIn the booksTransaction
TimingA cheque written on the last day of the month, not yet presentedNoneYesWait; it closes when the cheque is presented
TimingCash or a card collection deposited at month end, credited the next dayNoneYesWait; it closes when it is credited
RecordingBank charge or commission deductionYesNoneCreate an expense entry
RecordingA transfer received without a descriptionYesNoneFind which customer it is from and record the collection
RecordingThe same payment recorded twiceOnceTwiceCancel the duplicate entry
RecordingAmount entered incorrectlyCorrectWrongCorrect 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.

  1. Get the statement: Get the statement from the bank with the month-end balance and all transactions.
  2. Pull your records: Report the bank transactions for the same account for the same period.
  3. Check the opening balance: Both sides should start with the previous month-end balance; if not, the previous month's reconciliation is incomplete.
  4. Bring in the previous open items: Check whether last month's cheques and collections in transit closed this month.
  5. 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.

  1. Match by amount: Find transactions with the same amount; where an amount repeats on more than one line, look at the date.
  2. Look at the date: There may be a few days' gap between the bank date and the record date; set a reasonable window.
  3. Read the description: A transfer description may contain the customer name or invoice number.
  4. Break down bulk transactions: One statement line may consist of several records (a bulk collection, a daily card collection).
  5. Tick and count: Count the matched and unmatched lines.
ChartMatching result for a sample statement of 120 transactions: most match automatically
  • 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.

FormulaSix formulas of bank reconciliation
  1. Adjusted bank balance = Statement balance + Deposits in transit − Outstanding cheques and payments
  2. Adjusted book balance = Book balance + Unrecorded inflows − Unrecorded outflows
  3. Reconciliation difference = Adjusted bank balance − Adjusted book balance
  4. Match rate = Matched transactions ÷ Total transactions
  5. Raw difference = Statement balance − Book balance
  6. 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.

ChartBank side: from the statement balance of ₺184,500 to the adjusted balance of ₺186,900
  1. Statement balance₺184,500
  2. Collection not yet credited₺12,000
  3. Cheque not yet presented−₺9,600
  4. Adjusted bank balance₺186,900

Prepared with sample values.

Book sideAmount
Book balance187.250 ₺
Unrecorded bank charge−350 ₺
Adjusted book balance186.900 ₺
Reconciliation difference0 ₺ (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.

ItemWhy is it a timing difference?How does it close?
Cheque issued but not yet presentedPaid in your records, not yet debited at the bankAppears on the statement when the cheque is presented
Cheque handed to the bank but not yet collectedRecorded as an inflow, not on the statementWhen the cheque is collected
Cash deposited at month endThe bank transaction rolls over to the next dayAppears on the statement the next day
Card collectionsCredited after the bank's waiting period and commissionWhen credited; the net amount is lower than the sale
Marketplace payoutPaid according to the marketplace's payment scheduleWhen the payment arrives; tracked as a receivable
ChartOpen items at the sample month end: the collection in transit is the largest item
  1. Collection not yet credited₺12,000
  2. Cheque not yet presented₺9,600
  3. 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.

  1. Search for the difference amount: Is there a statement or book transaction of exactly that amount?
  2. 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).
  3. 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.
  4. Look for duplicate entries: Are there two entries with the same amount and date?
  5. Check the previous period: Are the opening balances the same?
DifferenceCorrectionRecording
Bank charge on the statement, not in the recordsCreate an expenseExpense and bank outflow
Undescribed transferFind the customer and invoice, record the collectionCollection and account reduction
Duplicate payment entryCancel the repeated entryReversing entry
Wrong amountCorrect the entry with the right amountCorrecting 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 dayRecord incoming and outgoing transactionsAccounting
Every weekQuickly match the latest statement transactions with your records; resolve undescribed transfersAccounting
Month end +1-3 daysGet the statement, match it and prepare the reconciliation tableAccounting
Month end +5 daysCorrect recording differences, approve the table and keep itManager
Next monthConfirm that the previous month's open items have closedAccounting
Takeaways from the exampleFour numbers from the sample reconciliation
  • −₺2,750raw difference (statement − books)
  • ₺186,900adjusted balance on both sides
  • ₺0$0reconciliation difference
  • 90%direct match rate (108 ÷ 120)
Recommended ReadingHow Do You Do a Month-End Close? A Guide to the Bookkeeping Closing Checklist, Reconciliations and Monthly Reporting

What are the most common mistakes in bank reconciliation?

  1. Comparing only the balance. If you do not look at the transactions, two errors that cancel each other out stay hidden.
  2. Not aligning the period. If the statement ends on the 30th and the records on the 28th, an artificial difference appears.
  3. Not following up on timing differences. If a cheque or collection in transit does not close the next month, a problem is hidden.
  4. Dumping the difference into an account to close it. A difference whose cause is not found grows later.
  5. Not recording bank charges and commissions. Your records constantly look higher than the bank.
  6. Leaving an undescribed transfer waiting. The collection stays open on the customer's account.
  7. 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.

  1. 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?
  2. 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?
  3. Is a cheque not yet presented a timing difference or a recording difference?
  4. If the remaining difference is ₺270, what is the first thing you think of?
  5. Why is a card collection credited to the account at less than the sale amount?

Answer key:

  1. 50.000 + 4.000 − 6.500 = 47.500 ₺.
  2. 47,600 − 100 = ₺47,500; yes, the two balances are equal and the difference is 0.
  3. A timing difference; it closes on its own when the cheque is presented.
  4. 270 is a multiple of 9; check whether two digits may have been transposed (e.g. 1,980 instead of 1,890).
  5. 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.

Start FreeOnline Collection

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools