Online Accounting

Bank reconciliation exercises and answers: 4 Bank Reconciliation Statement Problems & Solution Example

In this simple process of tallying the cash book and bank statement, there could be multiple errors. These errors or bank reconciliation problems might differ based on the size of the organization. Businesses can gain a variety of advantages from effective reconciliation processes. Without good reconciliation, it is difficult determining which expected payments haven’t been made. In addition to detecting fraud, cash book and bank reconciliation statements allow you to quickly identify any potential disruptions in your cash flow.

Effective bank reconciliation process offers various advantages to businesses. It allows businesses to identify any expected payments that haven’t been made, and detect fraud. Bank reconciliation can also help businesses quickly identify any disruptions in their cash flow.

Challenges Faced While Preparing Bank Reconciliation Statements

A bank reconciliation statement is a financial statement that compares the balance of a company’s bank account with its own accounting records. The purpose of a bank reconciliation statement is to identify any discrepancies between the two balances and to reconcile them. Markson’s & co. has a difference in balance as per cash book and bank statement as on 31st March 2021. A check for Rs. 182 drawn for the payment of telephone bill had been entered in the cash book as Rs. 281 but was shown correctly in the bank statement.

The debit side of the cash book had been undercast by Rs. 300. From the following particulars prepare a Bank Reconciliation Statement to find out the causes of difference in two balances as on August 31st, 2016 for Four Star (Pvt.) Ltd. Get help with your Bank reconciliation homework. Access the answers to hundreds of Bank reconciliation questions that are explained in a way that’s easy for you to understand. Can’t find the question you’re looking for?

Solution #2: Bank Reconciliation Statement (BRS) Format

Apart from the major benefits that it has, there are some key features which can not be missed out, some of them are Email Remittance capture, Discounts and Deductions Handling, Check Remittance Capture, Web Remittance Capture, Invoice Matching, and RDC & Mobile Payments. Powered by technologies, such as AI/ML, advanced bank reconciliation software make anomaly detection, variance analysis, and financial close task management easier for analysts. A check for Rs. 210 by the customer having been deposited into bank was dishonored by the bankA check was credited twice in Cash Book for worth Rs. 3,000. Balance as per bank statement overdraft of Rs. 2,118. Harold Averkamp (CPA, MBA) has worked as a university accounting instructor, accountant, and consultant for more than 25 years. He is the sole author of all the materials on AccountingCoach.com.

Go ahead and submit it to our experts to be answered. Want more practice questions? Receive instant access to our graded Quick Tests (more than 1,800 unique test questions) when you join AccountingCoach PRO. JPN & Co, has a balance of $20,000 as per passbook as on 31st march 2021. Charged commission on collection of outstation check by bank of worth Rs. 800.

Example #1: Cash Book Balance More Than Bank

Read more about the author. The review of 100% balance sheet reconciliations before ledger close. Driven by artificial intelligence, the software transforms reconciliations from a reactive to proactive process by detecting anomalies, making it faster and accurate. A check for Rs. 10,500 issued to Salman & Co. for purchase of Equipment was not encashed.

A check for Rs. 2,077 was issued by the company for purchase of merchandise and was paid by the bank but not recorded in company’s book. V. A Dividend of worth Rs. 90 had been collected by the bank but not recorded in the cash book. ABC Corp, has a balance of $2000 as per passbook as on 31st march 2021. However, the balance as per cash book as on 31st march 2021 is  $2210. Check received from the following customers were returned unpaid by the bank. Interest amounting 228 had been debited by the bank but not entered in the cash book.

Bank Reconciliation Exercise (Answer Key)

Check received from customers amounting to Rs. 75,850 deposited and properly accounted for in the cash book was not credited by bank. Check issued totaling Rs. 115,250 recorded in cash book but not appeared in the bank statement. Rutherford Inc. has  a difference in the balance as on 31st March 2021 between the bank statement and cash book. Prepare the bank reconciliation statement as on 30 June 2013 to arrive the balance as per pass book. In this blog, we will introduce you to some real-life bank reconciliation examples as well as the major roadblocks faced by organizations while reconciling their bank statements. Viii.