Bank Reconciliation Examples - BrandonGaille.com (2024)

The balance record for a company’s bank account compared to the balance recorded in the company books usually do not match for several reasons. For instance, there can be deposits in transit to the bank, bank charges, NSF checks, and outstanding checks.

Bank reconciliations are usually carried out at regular intervals to ensure that the company’s own bookkeeping is accurate and to catch any potential errors that the bank may have made. Although many companies have specialized software to help calculate complicated bank reconciliation statements, many companies perform their own bookkeeping and calculate them by hand, particularly for statements that are not as complex.

Bank Reconciliation Video Tutorial With Examples

Deposits in Transit
Deposits in transit refer to deposits that are recorded in the company’s books but have not arrived at the bank. Therefore the bank’s records will not show them. There is often a delay between the time that the company records its deposits and when the bank receives the cash, due to bank wiring delays or cash deposit delays.

Deposits in transit can be determined by looking at the deposits that have been recorded in the company’s own records compared to the deposits shown on the bank’s records.

NSF Checks
NSF or insufficient fund checks are checks from a customer that bounced because the customer did not have enough funds in their checking account. The check will have been recorded as a deposit in the company’s records, but the bank will not record a corresponding deposit. The bank will usually record the fact that the customer’s check was a NSF check, and the company’s records can be updated with this information.

Outstanding Checks
When a company writes a check, it will record a debit in its cash records, however the bank will not record a debit until the check is cashed by the customer. Outstanding checks can be determined by comparing the debits listed on the company’s cash account compared to the debits listed on the bank account.

Bank Charges
Some banks may charge a monthly fee for the use of their services, and this service charge will show up as a debit on the company’s bank account, but it will not be recorded by the company right away. The bank will clearly show on their records what the service charge was for and the amount, and this debit can be recorded on the company’s records.

Errors
Basic accounting errors can occur at the bank or at the company. The company may accidentally record a sale twice, or the bank may show two charges on a product that was only purchased one time. These errors are slightly more difficult to pinpoint, but after everything else has been eliminated they typically stand out after some careful investigation and comparing debits and credits on each statement. More often it is the company’s records that have an error, since charges and debits are often recorded manually.

Bank Reconciliation Video Example 1

Bank Reconciliation Video Example 2

Bank Reconciliation Written Example 1
XYZ Corporation shows a cash balance of $41,000 in their own books, while their bank account shows a balance of $40,000.

On the day that the balances were viewed, there was $1,500 of deposits in transit to the bank, $300 in NSF checks that were returned, $200 in bank service charges, and $2,000 in outstanding checks.

To create the reconciliation statement, the balance of the bank account should be added to the deposits in transit which are on the way to the bank, and the outstanding checks which not yet been cashed should be subtracted from the balance.

The company needs to subtract the bank’s service charges from its balance, since it has not recorded the service charge yet, and also subtract the NSF checks which bounced.

The bank reconciliation statement would be prepared as follows:

Bank Reconciliation Statement for XYC Corp.
Bank Reconciliation Examples - BrandonGaille.com (1)

The reconciled cash balance on the bottom of both sides should be identical after the statement has been prepared.

Bank Reconciliation Written Example 2
ABC Inc. has recorded a cash balance of $34,000 in their own records while their bank account shows a balance of $32,000 at the end of the year.

On the day the balances were viewed, there were $1,000 in NSF checks, $2,000 in outstanding checks, $1,000 of deposits in transit, $500 in bank service charges, and $500 was recorded erroneously as a credit in the company records.

The bank reconciliation statement would be prepared as follows:

Bank Reconciliation Statement for ABC Inc.
Bank Reconciliation Examples - BrandonGaille.com (2)

Related Posts:

  • 50 Easiest Ways to Make Money from Your Phone
  • Alibaba SWOT Analysis for 2021: 24 Key Strengths and…
  • How to Make $50k/year with Instacart: 25 Pro Tips
  • 50 Best Passive Income Ideas that Deliver

About The Author
Although millions of people visit Brandon's blog each month, his path to success was not easy. Go here to read his incredible story,

"From Disabled and $500k in Debt to a Pro Blogger with 5 Million Monthly Visitors."

If you want to send Brandon a quick message, then

visit his contact page here

.

Bank Reconciliation Examples - BrandonGaille.com (2024)

FAQs

What are examples of bank reconciliation? ›

Example of a Bank Reconciliation Statement

For example, say ABC Holding Co. recorded an ending balance of $500,000 on its records. However, its bank statement shows an ending balance of $520,000. After careful investigation, ABC Holding found that a vendor's check for $20,000 hadn't been presented to the bank.

How to do bank reconciliation for dummies? ›

Bank reconciliation steps
  1. Get bank records. You need a list of transactions from the bank. ...
  2. Get business records. Open your ledger of income and outgoings. ...
  3. Find your starting point. ...
  4. Run through bank deposits. ...
  5. Check the income on your books. ...
  6. Run through bank withdrawals. ...
  7. Check the expenses on your books. ...
  8. End balance.

What are the two most common causes for people not being able to reconcile their bank statements accurately? ›

One of the most common causes of bank reconciliation errors is missing or duplicate transactions. This can happen when you forget to record a payment, deposit, or transfer in your accounting system, or when you enter the same transaction twice by mistake.

What happens if bank reconciliation doesn't balance? ›

For unreconciled transactions, it may be necessary to revisit each step of the reconciliation process. A company may have to pull data again and compare each transaction. If their systems allow it, a business may choose to manually adjust a transaction (or multiple transactions) to rectify the situation.

How do you correct a bank reconciliation error? ›

How do I fix it? Open Reconciliation > Reconcile Bank Accounts to review the outstanding checks and deposits. If the outstanding checks and deposits are correct, run Recalculate to calculate the outstanding check and deposit totals again.

How to do a proper bank reconciliation? ›

Here are the steps for completing a bank reconciliation:
  1. Get bank records.
  2. Gather your business records.
  3. Find a place to start.
  4. Go over your bank deposits and withdrawals.
  5. Check the income and expenses in your books.
  6. Adjust the bank statements.
  7. Adjust the cash balance.
  8. Compare the end balances.
Mar 10, 2023

How to properly reconcile an account? ›

What are the Steps in Account Reconciliation?
  1. Enter the ending cash balance per the bank statement.
  2. Subtract outstanding checks (not yet cleared)
  3. Add deposits in transit (not yet deposited)
  4. Add bank service fees and other bank transactions not yet recorded.
  5. Enter the ending cash balance per the general ledger.

What two items do you need to reconcile your checking account? ›

To start your reconciliation, you need 2 main things:
  • Your bank statement for December.
  • Your business ledger, check register, or accounting software where you record all transactions.
Jan 16, 2024

What is the starting point of a bank reconciliation? ›

After you've checked all the deposits and withdrawals, your business bank balance should match the totals in your business accounts. This will be the starting point for your next reconciliation.

What is the journal entry for bank reconciliation? ›

Purpose of Journal Entries in Bank Reconciliation

Journal entries facilitate adjustments to the company's books to reflect transactions that have been recorded by the bank but not yet by the company, or vice versa.

How to do bank reconciliation on Excel? ›

VLOOKUP, SUMIF and COUNTIF are the three reconciliation Excel formulas. First, VLOOKUP can locate values in a table and return the value based on the number of columns. It is useful if you reconcile an amount recorded in two financial registers. Then SUMIF adds the amount from found values in a range.

Why is bank reconciliation hard? ›

Yes, bank reconciliation can be difficult, especially at scale. Primary difficulties stem from bank payment delays, the challenge of normalizing payments and bank data, and the need to match a high volume of transactions quickly.

What is an example of a bank reconciliation error? ›

(a) Deposited Check Not Recorded in Cash Book

Sometimes after receiving a check from debtors, it is deposited at the bank but not recorded in the cash book (on the debit side of the bank column). Due to this error, the cash book shows a lower bank balance compared to the bank statement.

What do R and C mean in QuickBooks? ›

The C and R under the ✓ column on your Chart of Accounts are reconciliation status. C means cleared through the bank and checked off but not reconciled. On the other hand, R means reconciled. Transactions with R status will no longer show up on the next reconciliation screen at all.

What are simple examples of reconciliation? ›

An example of reconciliation in accounting is comparing the general ledger to sub-ledgers, such as accounts payable or accounts receivable. This ensures that all transactions are recorded accurately and any discrepancies are identified and corrected.

What are the three 3 forms of bank reconciliation? ›

The three methods of a bank reconciliation are:
  • Comparing the statements.
  • Adjusting the balances.
  • Recording the reconciliation.

What are the two most common types of a bank reconciliation? ›

Internal Reconciliation: This type of reconciliation compares entries between departments within the same company or organization. External Reconciliation: This type of reconciliation involves comparing accounts between different entities, such as a business and its bank, or between two different businesses.

What are the 3 bank reconciling items? ›

Deposits in transit, outstanding checks, and bank service charges usually account for the difference between the company's Cash account balance and the bank balance.

Top Articles
Latest Posts
Article information

Author: Catherine Tremblay

Last Updated:

Views: 6461

Rating: 4.7 / 5 (47 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Catherine Tremblay

Birthday: 1999-09-23

Address: Suite 461 73643 Sherril Loaf, Dickinsonland, AZ 47941-2379

Phone: +2678139151039

Job: International Administration Supervisor

Hobby: Dowsing, Snowboarding, Rowing, Beekeeping, Calligraphy, Shooting, Air sports

Introduction: My name is Catherine Tremblay, I am a precious, perfect, tasty, enthusiastic, inexpensive, vast, kind person who loves writing and wants to share my knowledge and understanding with you.