4 Bank Reconciliation Statement Problems & Solution Example

Any credit cards, PayPal accounts, or other accounts with business transactions should be reconciled. When you “reconcile” your bank statement or bank records, you compare it with your bookkeeping records for the same period, and pinpoint every discrepancy. Then, you make a record of those discrepancies, so you or your accountant can be certain there’s no money that has gone “missing” from your business. Remember that outstanding checks do not need to be recorded into the G/L since they are already there. However, anything that affects the G/L, such as unexpected deposits, interest income, or service fees, will need to be recorded. It would help if you subtracted both checks from your bank balance, as well as any other checks listed in your check register that haven’t cleared.

When the payee deposits the check at a bank, it requests the funds from the payor’s bank, which, in turn, withdraws the amount from the payor’s account and transfers it to the payee’s bank. When the bank receives the full amount requested, it deposits it into the payee’s account. Outstanding checks are checks written by a company, but the checks have not cleared the bank account. Adjust the cash balances in the business account by adding interest or deducting monthly charges and overdraft fees.

What is a Bank Reconciliation?

Check to see that the contact information is correct, as checks may go missing simply because of an incorrect mailing address. You come to know about such deductions only when you receive the statement from the bank. However, there can be situations where your business has overdrafts at the bank. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike License .

For example, a restaurant or a busy retail store both process a lot of transactions and take in a lot of cash. They might reconcile on a daily basis to make sure everything matches and all cash receipts hit the bank account. On the other hand, a small online store—one that has days when there are no new transactions at all—could reconcile on a weekly or monthly basis. Reconciling your bank statements lets you see the relationship between when money enters your business and when it enters your bank account, and plan how you collect and spend money accordingly.

Open a Huntington Checking Account

Or you could have written a NSF check (not sufficient funds) and recorded the amount normally in your books, without realizing there wasn’t insufficient balance and the check bounced. Nowadays, many companies use specialized accounting software in bank reconciliation to reduce the amount of work and adjustments required and to enable real-time updates. Your accounting software Is an entry made for outstanding checks when preparing a bank reconciliation? should automatically keep an accounts receivable ledger account for each customer. The accounts receivable ledger, which can also double as a customer statement, serves as a record of each customer’s charges and payments. Preparing a bank reconciliation when you receive your bank statement every month helps you verify the amount of cash in your checking account.

Your bank can help you find and correct errors if you need further help. Subtract the amount of the NSF check and the fees from your books. Your bank decreases your checking account by the amount of the NSF check (plus a fee).

What are the 6 steps for bank reconciliation?

Be mindful of what outstanding checks you’ve written before drawing down your bank balance. Ideally, you should reconcile your bank account each time you receive a statement from your bank. This is often done at the end of every month, weekly and even at the end of each day by businesses that have a large number of transactions.

• Consider when or why you might need to look back through your financial records for your bank reconciliation, and which method of recording will make the task easier for you based on how you keep your records.
• For some businesses, including my own, the bank statement does not close at the end of the month.
• This often happens when the checks are written in the last few days of the month.
• Compare this amount to the sum of the individual accounts payable ledgers.
• You note that a check for $1,000 that you deposited during the month was returned as the issuer didn’t have enough money in their account to cover the check amount.
• If there’s a discrepancy between your accounts and the bank’s records that you can’t explain any other way, it may be time to speak to someone at the bank.

If you use the accrual system of accounting, you might “debit” your cash account when you finish a project and the client says “the cheque is going in the mail today, I promise! Then when you do your bank reconciliation a month later, you realize that cheque never came, and the money isn’t in your books (even though your bookkeeping shows you got paid). Designed to keep your bank and your G/L in Balance, the bank reconciliation process also helps you correct possible errors, account for uncashed checks, and even locate missing deposits.

For the most part, how often you reconcile bank statements will depend on your volume of transactions. Once you’ve figured out the reasons why your bank statement and your accounting records don’t match up, you need to record them. There’s nothing harmful about outstanding checks/withdrawals or outstanding deposits/receipts, so long as you keep track of them. Bank reconciliations are like a fail-safe for making sure your accounts receivable never get out of control.

• During your reconciliation, you note that you wrote a check for $500 on May 29 that hasn’t yet cleared the bank.
• Companies may authorize a bank to automatically transfer funds into or out of their account.
• If you want a basic checking account with no monthly maintenance fee, or an interest-earning checking account, we’ve got the options that are right for you.
• As a result of such direct payments made by the bank on your behalf, the balance as per the passbook would be less than the balance as per the cash book.
• Deposits in transit are amounts that are received and recorded by the business but are not yet recorded by the bank.

Bank reconciliations are a vital part of internal control for most organizations because they can help detect fraud and prevent errors so you can issue accurate and timely financial reports. They also help you stay on top of cash flow by ensuring you know how much cash you have on hand. When you prepare your reconciliation, you adjust the balance from one source by those reconciling items to arrive at the balance of the other source.

GST/HST for digital economy businesses

She creates a bank reconciliation statement that itemizes both the $200 in unrecorded bank fees and the $13,000 in outstanding deposits. While some reconciling items necessitate an adjustment to your book balance with journal entries, deposits in transit and outstanding checks do not. Instead, record them on the bank reconciliation, as these are timing differences that should be reversed during next month’s reconciliation. 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.

• All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly.
• A reconciling item is a transaction or other entity representing a difference between your general ledger balance and the source documentation being compared.
• Designed to keep your bank and your G/L in Balance, the bank reconciliation process also helps you correct possible errors, account for uncashed checks, and even locate missing deposits.
• In the above example, if the general ledger cash account does not show a balance of $3,851.26, you must track down the cause of the difference.

Businesses that use online banking service can download the bank statements for the regular reconciliation process rather than having to manually enter the information. For companies with high transaction volumes, multiple bank accounts or multiple currencies, bank reconciliation can be a time-consuming process. NetSuite Cash Management can automate a crucial part of this process — the manual comparison of bank data with companies’ accounting system data. NetSuite users can automatically import bank data, saving time and improving accuracy. For instance, the MD Restaurant Group, a chain based in Illinois, is using NetSuite’s bank reconciliation functionality to compare financials from 19 different entities. In preparing a bank reconciliation, outstanding checks should be added back to the ending balance per the bank statement.