There is still a difference in the Cashbook of $350 which is due to the unpresented check/cheque from Query No. 7. Rose dates them all at April 30th (except for No 6. Cash withdrawal) but indicates in the Details column the date of the original transaction entry in the Cashbook. Use these exercises to practice working on bank reconciliation problems and solutions.

bank reconciliation exercises

When you compare the balance of your cash book with the balance showcased by your bank passbook, there is often a difference. Therefore, an overdraft balance is treated as a negative figure on the bank reconciliation statement. As mentioned above, bank overdraft is a condition where a bank account becomes negative as a result of excess withdrawals over deposits. Prepare the bank reconciliation statement as on 30 June 2013 to arrive the balance as per pass book.

Answer to this Exercise

Outstanding checks are those that have been written and recorded in cash account of the business but have not yet cleared the bank account. This often happens when the checks are written in the last few days of the month. Taking the time to perform a bank reconciliation can help you manage your finances and keep accurate records. This relatively straightforward and quick process provides a clear picture of your financial health. Consider reconciling your bank account monthly, whether you set aside a specific day each month or do it as your statements arrive. How you choose to perform a bank reconciliation depends on how you track your money.

bank reconciliation exercises

If not, add the missing deposits to your records and your total account balance. However, the depositor/customer/company credits its Cash account to https://personal-accounting.org/what-is-work-in-process-wip-inventory-how-to/ decrease its checking account balance. However, the depositor/customer/company debits its Cash account to increase its checking account balance.

Bank Reconciliation Problems

When you prepare the bank reconciliation statement for the month of November as on November 30, 2019, the cheque issued on November 30 is unlikely to be cashed by the bank. This is done by taking into account all the transactions bank reconciliation exercises that have occurred until the date preceding the day on which the bank reconciliation statement is prepared. To reconcile your bank statement with your cash book, you need to ensure that the cash book is complete.

As mentioned above, the process of comparing your cash book details with the records of your business’ bank transactions as recorded by the bank is known as bank reconciliation. The purpose behind preparing the bank reconciliation statement is to reconcile the difference between the balance as per the cash book and the balance as per the passbook. An outstanding cheque refers to a cheque payment that has been recorded in the books of accounts of the issuing company. But, the cheque has not yet been cleared by the bank as a deduction from the company’s cash balance. NSF cheques are an item to be reconciled while preparing the bank reconciliation statement. This is because when you deposit a cheque in your bank account, you consider that the cheque has been cleared by the bank.

Bank Reconciliation (Explanation)

There is a difference in the balance as on 31st March 2019 between the bank statement and Cash Book. You are required to prepare a Bank Reconciliation Statement as on 31st March 2019. Below is the extract for the Cash Book and Bank statement for the month of March 2019. As a result, the bank debits the amount against such dishonored cheques or bills of exchange to your bank account. When your business issues a cheque to its suppliers or creditors, such amounts are immediately recorded on the credit side of your cash book.

In order to prepare a bank reconciliation statement, you need to obtain the current as well as the previous month’s bank statements and the cash book. Such deposits are not showcased in the bank statement on the reconciliation date. This happens due to the time lag between when your business deposits cash or a cheque into its bank account and when your bank credits the same. Before the reconciliation process, business should ensure that they have recorded all transactions up to the end of your bank statement. Businesses that use online banking service can download the bank statements for the regular reconciliation process rather than having to manually enter the information.