Cash book and bank reconciliation statement PDF: Formats, examples, and how to prepare one

Key Takeaways

A bank reconciliation helps you explain why your records and the bank’s records show different balances. A consistent process makes those differences easier to find, document, and resolve.

• Compare the cash book with the bank statement for the same account and period.
• Record bank-originated transactions in the cash book before adjusting for timing differences.
• Separate outstanding payments and deposits in transit from errors or unrecorded transactions.
• Use a template that captures the period, balances, adjustments, and final check.
• Keep supporting records and revisit outstanding items until they clear.

What a bank reconciliation statement does

A bank reconciliation statement explains the difference between the balance in your cash book and the balance shown on your bank statement. It gives you a way to check that transactions are recorded consistently and that the difference has a clear explanation. You can use the process to identify missing entries, timing differences, and possible errors.

How it compares the cash book with the bank statement

Your cash book records the transactions you have entered for a bank account, while the bank statement records transactions processed by the bank. A reconciliation compares both records over the same period and matches items such as deposits, withdrawals, and checks. The statement then shows why the balances differ and how the difference is accounted for.

Why the two balances may differ

The balances often differ because a transaction has been recorded in one place but has not yet appeared in the other. A check you issued may still be waiting to clear, for example, or a deposit may not have reached the statement by the period-end date. Bank fees, interest, direct deposits, and recording errors can also create differences. The key is to identify the reason for each unmatched item rather than treating every difference as an error.

When to prepare a reconciliation

Prepare a reconciliation regularly, often at month-end, and use the same cutoff date for the cash book and bank statement. A timely check makes it easier to trace transactions while receipts, payment records, and other documents are still available. Monthly reconciliation checks can also give you a routine for reviewing cash records and resolving outstanding items. If account activity is high, you may choose to reconcile more often.

What to look for in a cash book and bank reconciliation statement PDF

A useful cash book and bank reconciliation statement pdf should make the transaction trail easy to follow, whether you print it or fill it in electronically. Look for clear fields for dates, descriptions, amounts, and balances, as well as enough room to explain adjustments. A well-organized format reduces the chance that a difference is listed without context.

Common cash book formats and key columns

A cash book may be a simple transaction register or a two-sided layout that separates money received from money paid. For bank reconciliation, the most useful format lets you identify each transaction and see how it affects the running balance. These common fields help you judge whether a template contains enough detail:

The exact layout can vary, but each entry should be identifiable and the balance should be traceable. If you use a separate reconciliation page, keep its references consistent with the cash book so you can move between the two without guesswork.

Essential details in a bank reconciliation statement

Include the account name or number, the statement period, and the date used for reconciliation. Record the starting balance from each source, then list adjustments with a short explanation and amount. Your final format should make clear which balance has been adjusted and whether the adjusted cash book and bank statement balances agree.

Choosing a printable or editable template

Choose a printable template if you prefer to write in adjustments by hand, or an editable PDF if you want to enter details on screen. Either way, check that the fields are legible and provide space for supporting notes. When you need transaction data from a bank statement PDF for your records, Know Your Bank Statement extracts transaction data from digital or scanned bank statement PDFs and converts it into structured Excel, CSV, or JSON files. That can give you data to review alongside your chosen reconciliation format, while the reconciliation itself still depends on your matching and checks. A reconciliation format guide can help you compare the information a practical template should capture.

How to prepare a bank reconciliation statement

Start with the records for the same account and period: your cash book and the bank statement. Work through bank-originated entries first, then match the transactions that appear in both places. Once you separate timing differences from entries that need correction, you can calculate and check the adjusted balances.

Update the cash book for bank-originated transactions

The bank may process items that you have not yet entered in the cash book, such as fees, interest, direct debits, or a customer’s direct deposit. Add these items to the cash book with the correct date and description, using the bank statement and supporting records to confirm what they are. Updating the book first helps keep genuine timing differences separate from missing entries.

Compare entries and mark matching items

Compare each cash book entry with the bank statement, checking the date, amount, and description rather than relying on a similar-looking amount alone. Mark a transaction as matched only when the details support the match. If you are working from statement PDFs, Know Your Bank Statement extracts transaction data from digital or scanned bank statement PDFs into Excel, CSV, or JSON, with fields such as dates, descriptions, debits, credits, and balances; review the extracted entries against the original statement before using them.

A simple matching routine can keep the review orderly, especially when a period contains many small transactions:

1. Sort or review both records in date order.
2. Match entries that agree in amount and transaction detail.
3. List unmatched entries separately with their source and date.
4. Investigate each unmatched item before classifying it as a timing difference or correction.

This leaves you with a focused list of items to explain, rather than a second pass through every transaction. Keep the original statement available while you review extracted or transcribed data.

Adjust the balances for timing differences

After updating the cash book for bank-originated transactions, account for items recorded on one side but not yet processed on the other. When starting from the bank statement balance, add deposits in transit and subtract outstanding checks or payments. When starting from the cash book, make the corresponding adjustments in the opposite direction to reach the same reconciled amount. Use the same approach consistently and label each adjustment.

Check that the adjusted balances agree

Recalculate the adjusted cash book and bank statement balances independently. They should agree after you have recorded book updates and accounted for timing differences. If they do not, revisit the amounts and signs, confirm that each item is included only once, and check whether an unmatched transaction has been overlooked.

How to handle common reconciliation differences

Most differences can be understood by asking where an item has been recorded and whether it has cleared by the statement date. A timing difference usually needs to be carried forward until it appears in both records; an unrecorded transaction or mistake needs investigation. Classifying each item before adjusting the balance helps you avoid correcting something that is simply still in transit.

Unpresented checks and outstanding payments

An unpresented check is a payment you have recorded, but the bank has not processed by the statement date. It reduces the cash book balance before it reduces the bank statement balance. When reconciling from the bank statement, subtract the outstanding payment, then check a later statement to confirm when it clears. If it remains outstanding for an unusually long time, investigate it rather than carrying it forward indefinitely.

Deposits in transit

A deposit in transit has been recorded in your cash book but has not yet appeared on the bank statement. When reconciling from the bank statement balance, add the deposit to account for the difference. Check the deposit receipt and the next statement to confirm that the bank processed it. If the amount or date does not match, follow up before treating it as a routine timing item.

Bank fees, interest, and direct debits

These items may first appear on the bank statement, so enter them in the cash book after confirming their nature and amount. Fees and direct debits reduce the book balance; interest or other credits increase it. Keep a short explanation and supporting record for each entry so that the change remains understandable later.

Errors in the cash book or bank statement

Compare the original transaction evidence with both records if an amount, date, or description appears wrong. Correct cash book errors in your own records, following your normal approval and documentation process. If the bank statement appears to contain an error, contact the bank and track the matter until it is resolved; do not silently alter the statement figure. A clear note lets anyone reviewing the reconciliation see what is being corrected and why.

Worked bank reconciliation example

A small worked example shows how the cash book, statement balance, and timing items fit together. Assume you are reconciling an account at month-end and have already checked that both balances refer to the same date. First record bank-originated items in the cash book; then account for payments and deposits that have not cleared.

Start with the cash book and bank statement balances

Suppose your cash book shows $4,820 and the bank statement shows $5,060 at the cutoff date. The statement includes a $35 bank fee and $20 of interest that are not yet in the cash book. The cash book also includes a $275 direct deposit that is not separately entered in the book’s transaction record. Confirm the nature and amount of each item before making an adjustment.

Identify and classify unmatched transactions

After updating the cash book for the fee, interest, and direct deposit, two timing items remain: a $520 check has not cleared, and a $540 deposit has not appeared on the statement. The check is a payment recorded in the book but not yet processed by the bank; the deposit is recorded in the book but still in transit. Keeping these categories distinct helps you apply the adjustment in the right direction.

Calculate the adjusted balance

The adjusted cash book balance is $4,820 - $35 + $20 + $275, or $5,080. Starting from the bank statement, the adjusted balance is $5,060 - $520 + $540, also $5,080. The two routes should reach the same figure when the items have been classified and recorded correctly.

Verify the final reconciliation

Confirm that the $35 fee, $20 interest, and $275 deposit are reflected in the cash book, and that the $520 check and $540 deposit are listed as timing differences. Check the supporting statement and transaction records once more, then carry forward only items that have not cleared. Know Your Bank Statement can extract transaction data from digital or scanned bank statement PDFs into structured Excel, CSV, or JSON files; review the extracted details against the statement when using them to support a reconciliation.

How to use and maintain your PDF template

A template is most useful when you complete it consistently and can trace each figure back to its source. Use the same account, period, and cutoff date across the cash book, bank statement, and reconciliation page. Then keep the explanation for each adjustment close to the amount, so a later reviewer can follow the calculation.

Fill in the statement period and opening balances

Enter the account identifier and the start and end dates before listing adjustments. Record the cash book and bank statement balances as they appear in their respective records, without changing one to make it match the other. This gives you a reliable starting point for the reconciliation and makes the period clear if you refer back to the file later.

Keep supporting documents for adjustments

Retain the statement, deposit receipts, check details, transaction notices, and other records that support your entries. If a statement PDF is converted into transaction data for review, keep the source document alongside the working file and verify the extracted figures. Clear references between a line item and its evidence make it easier to answer questions without recreating the work.

Review and resolve outstanding items

Check outstanding payments and deposits against the next bank statement. Mark an item as cleared when it appears, and investigate stale or unexpected items rather than carrying them forward automatically. If a difference remains unexplained, note what you checked and what follow-up is still needed.

Save completed reconciliations for audit and reference

Save the completed reconciliation with a clear account name and period, and retain it with the documents used to prepare it. Follow your organization’s record-retention and access practices for financial information. A consistent filing approach makes it easier to compare periods, respond to review questions, and see whether the same unresolved item is recurring.

Conclusion

A reliable bank reconciliation comes from comparing like-for-like records, recording bank-originated activity, and separating timing differences from errors. With a clear PDF format and supporting documents close at hand, you can explain how the balances agree and follow up on anything that remains unresolved.

Frequently Asked Questions

What is a bank reconciliation statement?

It is a record that explains the difference between the cash book balance and the bank statement balance for a specific account and period, and shows how the adjusted balances agree.

How often should you prepare a bank reconciliation?

Many organizations reconcile monthly, while accounts with frequent activity may benefit from more frequent checks. Choose a schedule that supports timely review and follow-up.

Why might the cash book and bank statement balances differ?

Common reasons include checks or payments that have not cleared, deposits in transit, bank fees, interest, direct debits, and errors or missing entries in either record.

What should a bank reconciliation template include?

Include the account and statement period, starting balances, transaction or adjustment descriptions, amounts, and the final adjusted balances. Space for notes and references to supporting documents is also useful.

Do you add or subtract outstanding checks?

When reconciling from the bank statement balance, subtract outstanding checks or payments because they have already reduced the cash book but have not yet reduced the statement balance.

How do you treat a deposit in transit?

When reconciling from the bank statement balance, add a deposit in transit because it has already increased the cash book balance but has not yet appeared on the statement.

What should you do if the adjusted balances do not agree?

Recheck the period and account, verify each amount and adjustment direction, and look for omitted or duplicated entries. Investigate any remaining difference before considering the reconciliation complete.