How to reconcile your bank statements (2024)

Bank reconciliations are a crucial part of any business. Small business owners should reconcile their bank statements once a month. For larger businesses, you may need to perform daily bank reconciliations.

In addition to serving as a necessary check and balance, the reconciliation process also offers you the opportunity to see your business's actual cash flow. It provides you with a better understanding of the timing of your business's collections and spending, and it helps you stay on top of your accounts receivable and accounts payable.

How to reconcile your bank statements (1)

What is a bank reconciliation?

A bank reconciliation compares the cash account from your business's general ledger to the ending balance on the bank statement for the same time period. When you perform a bank reconciliation, you are ensuring your business records have captured all cash transactions accurately. It is also an opportunity to double-check your bank's records to identify any errors in the transactions in your bank account.

Differences in the cash account balance and bank statement balance are common. Not all differences signal an error or fraudulent activity. Many are the result of timing differences or small fees directly assessed in the bank account. However, if you do find any discrepancies in the records, it is important to resolve the issue during the reconciliation process. At the end of the reconciliation, your adjusted bank balance should equal your adjusted cash account balance.

Step-by-step guide to reconciling your bank statement

You receive your bank statement from your business's financial institution on a recurring basis, typically monthly. The bank statement itemizes everything you deposited into or withdrew from your account in a certain time frame. When you receive this statement, it is time to start on your bank reconciliation.

1. Compare balances

Gather your accounting records for the time period covered by the bank statement. You should compare the deposits and withdrawals from the bank statement to the debits and credits in your cash account. Debits increase your cash account, like a deposit or income, and credits decrease your cash account, like a withdrawal or fee. You might want to try accrual accounting as one way of keeping track of your balance.

2. Identify differences

Some differences in timing are normal and expected, such as deposits in transit and outstanding checks. Deposits in transit are amounts received by your business and recorded in your books that haven't yet been recorded by the bank. Outstanding checks have been issued by your business but haven't cleared the bank yet. The same thing can happen with electronic fund transfers initiated at the end of the month.

Additionally, it is common for your bank to deduct fees and penalties and add interest income directly to your bank account. Unless you are tracking your bank account balance on a daily basis, your business may not have recorded these transactions on its books prior to the reconciliation process.

3. Resolve any issues

Other items require more effort to resolve. Here are some common issues that arise during a bank reconciliation.

  • Voided checks that cleared your bank account. A check you have previously voided on your books may be cashed by the recipient and clear your bank account. If this happens, you will need to credit the amount to your cash account.
  • Transactions processed by your bank twice. If one check erroneously clears your bank account twice, you will need to inform the bank of the error. If you've voided and reissued a check, and both checks clear your bank account, you will need to credit the amount to your cash account for the voided check. However, in this situation, you should also contact the recipient to work out a repayment for the overpayment.
  • Errors in bank records or your records. The bank may clear a transaction for an incorrect amount, or your cash account may have an error in the original entry. You can catch a number of issues during a reconciliation. For example, an "8" could appear as a "0" to someone manually recording an item, two numbers could be reversed, or a decimal point may be moved over one or more digits. If it is an error on the bank's side, contact them. If it is an error on your own records, you will need to do an adjusting journal entry.
  • Older outstanding checks that need to be voided. Recently issued checks will still be outstanding, and that is normal and expected. If you issued checks on the last day of the month, it is unlikely that all of the recipients would have already cashed them. However, if a check remains outstanding for many months, it signals an issue. You should reach out to the intended recipient and see if you need to void and reissue the check.

4. Adjust balances

First, adjust the bank balance by adding in deposits in transit, subtracting outstanding checks, and adjusting for any bank errors that you have identified during the reconciliation process.

Second, you need to adjust the cash account balance. Enter bank fees and penalties as a credit entry, and enter interest income as a debit.If any errors were made in the accounting records, they will need to be adjusted here as well.

5. Compare balances

After you have adjusted the bank balance and cash account balance, the two should match. If the adjusted balances still don't match, go back through the previous steps to identify the discrepancy.

6. Book adjusting journal entries

After the adjusted balances match or are "reconciled," you should record any necessary adjusting journal entries to modify the cash account in your general ledger. You should make an adjusting journal entry for any transaction recorded in your adjusted cash account balance in Step 4. Items you may need to adjust include:

  • Bank fees or penalties recorded by your bank. You should credit these to decrease your cash account.
  • Interest income recorded by your bank. You should debit these to increase your cash account.

If you found a discrepancy due to an error on your books, this would be the time to make those adjustments as well.

Find out more about Business Accounting

Learn more about LZ Books

How to reconcile your bank statements (2024)

FAQs

How to reconcile your bank statements? ›

To prepare a bank reconciliation statement, compare the bank statement balance to the balance in the company's accounting records, identify any discrepancies, and make adjustments for any outstanding checks, deposits in transit, bank errors, or other items that may not be in the company's records.

What is the easiest way to reconcile a bank statement? ›

Bank Reconciliation Process Flow
  1. Compare Statements. Begin with a side-by-side comparison of your bank account statement and your company's accounting records. ...
  2. Identify Discrepancies. Go through both statements and highlight any transactions that appear on only one side. ...
  3. Make Adjustments. ...
  4. Reconcile Balances.

What 3 items do you need to reconcile your bank statement? ›

To prepare a bank reconciliation statement, compare the bank statement balance to the balance in the company's accounting records, identify any discrepancies, and make adjustments for any outstanding checks, deposits in transit, bank errors, or other items that may not be in the company's records.

What should a person do to reconcile a bank statement? ›

How To Reconcile a Bank Statement
  1. Gather Resources. ...
  2. Match Deposits and Withdrawals With Debits and Credits in the Cash Account. ...
  3. Find Differences. ...
  4. Pass Adjusting Journal Entries. ...
  5. Maintain Detailed Documentation. ...
  6. Segregate Duties. ...
  7. Investigate Discrepancies. ...
  8. Automate Your Reconciliation Process.

What are the 5 steps to reconcile your account? ›

Bank reconciliation steps
  • Get bank records. You need a list of transactions from the bank. ...
  • Get business records. Open your ledger of income and outgoings. ...
  • Find your starting point. ...
  • Run through bank deposits. ...
  • Check the income on your books. ...
  • Run through bank withdrawals. ...
  • Check the expenses on your books. ...
  • End balance.

Who is the best person to reconcile a bank statement? ›

Therefore, the bank reconciliation should be performed by an employee who does not have record-keeping responsibilities, such as recording cash receipts, handling disbursem*nts, or regularly making journal entries.

What is an example of a bank reconciliation? ›

A bank reconciliation statement compares a company's records of its financial transactions with those of its bank statement. For example, if a company's records show it has $5,000 in its account, but bank statement shows $4,800, the reconciliation statement helps identify and resolve discrepancies.

What is the formula for bank reconciliation statement? ›

The formula is (Cash account balance per your records) plus or minus (reconciling items) = (Bank statement balance). When you have this formula in balance, your bank reconciliation is complete. Your cash account balance defined as your book balance (or balance per book).

What is bank reconciliation template? ›

Download the Free Bank Reconciliation Statement Template

A bank reconciliation statement is a document that matches the cash balance on a company's balance sheet to the corresponding amount on its bank statement. Reconciling the two accounts helps determine if accounting changes are needed.

What is an example of reconciliation? ›

A common example of account reconciliation 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 2 documents are used to conduct a bank reconciliation? ›

The bank reconciliation requires the follow information: ► General ledger account balance for the bank account being reconciled. ► Bank statement, which is a document sent by the bank or financial institution showing the transactions posted to a bank account during a specific period (usually 30 days).

What are the three 3 methods used in preparing bank reconciliation? ›

There are three steps: comparing your statements, adjusting your balances, and recording the reconciliation.
  • Step one: Comparing your statements. ...
  • Step two: Adjusting your balances. ...
  • Step three: Recording the reconciliation.
Aug 10, 2021

How to manually reconcile a bank statement? ›

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.
Jun 28, 2024

When reconciling a bank statement What should you do first? ›

Step-by-Step Guide for Reconciling Bank Statements
  1. Compare Your Current Available Balance. ...
  2. Compare Transactions. ...
  3. Account for Bank Adjustments. ...
  4. Include Pending or Unaccounted Transactions in Your Bank Balance. ...
  5. Investigate Discrepancies. ...
  6. Compare Both Balances.
Feb 28, 2024

Do people reconcile bank statements anymore? ›

Bank reconciliations are a crucial part of any business. Small business owners should reconcile their bank statements once a month. For larger businesses, you may need to perform daily bank reconciliations.

What are the three methods of a bank reconciliation? ›

Bank reconciliation involves comparing a company's records with the bank statement to identify discrepancies. The three methods include verifying and adjusting outstanding checks and deposits, reconciling bank errors, and addressing timing differences in recording transactions.

How to do bank reconciliation in Excel faster? ›

Steps To Create An Bank Reconciliation Statement Format In Excel
  1. Step 1: Set Up The Necessary Column And Header. ...
  2. Step 2: Enter Company Records Information. ...
  3. Step 3: Perform Additions And Deductions. ...
  4. Step 4: Calculate The Reconciled Balance. ...
  5. Step 5: Format And Finalise The Reconciliation Statement.

Which software is used for bank reconciliation? ›

Best bank reconciliation software quick comparison
PricingAutomation workflows
Xero$15 to $78 per monthYes
NCH Express AccountsFree or starts at $139 per licenseNo
ReconArt$1,700 per monthYes
BlackLineCustom-pricedYes
3 more rows
Mar 26, 2024

What are the four steps in the bank reconciliation? ›

The four steps in bank reconciliation are (1) accessing and comparing deposits between a company's bank statement and its internal systems of record, (2) normalizing the bank statement as needed, (3) formatting of data from internal systems of record, and (4) comparing the bank statement and internal records to confirm ...

Top Articles
Call Options: Learn The Basics Of Buying And Selling | Bankrate
LBank Exchange Will List BEE Token on January 28, 2022 | Bitcoinist.com
Frederick County Craigslist
Cottonwood Vet Ottawa Ks
Pinellas County Jail Mugshots 2023
Jefferey Dahmer Autopsy Photos
Lenscrafters Westchester Mall
Tugboat Information
Pwc Transparency Report
Darksteel Plate Deepwoken
978-0137606801
Alejos Hut Henderson Tx
Craiglist Galveston
Parent Resources - Padua Franciscan High School
Marvon McCray Update: Did He Pass Away Or Is He Still Alive?
Byui Calendar Fall 2023
Amih Stocktwits
Crawlers List Chicago
Robeson County Mugshots 2022
Euro Style Scrub Caps
Parc Soleil Drowning
How to Make Ghee - How We Flourish
Drift Hunters - Play Unblocked Game Online
Move Relearner Infinite Fusion
Kqelwaob
Calvin Coolidge: Life in Brief | Miller Center
Grove City Craigslist Pets
Math Minor Umn
Max 80 Orl
Tendermeetup Login
Seymour Johnson AFB | MilitaryINSTALLATIONS
Oreillys Federal And Evans
Solemn Behavior Antonym
Msnl Seeds
Puffco Peak 3 Red Flashes
Trivago Myrtle Beach Hotels
The TBM 930 Is Another Daher Masterpiece
Husker Football
The best specialist spirits store | Spirituosengalerie Stuttgart
Who Is Responsible for Writing Obituaries After Death? | Pottstown Funeral Home & Crematory
California Craigslist Cars For Sale By Owner
If You're Getting Your Nails Done, You Absolutely Need to Tip—Here's How Much
Arcane Bloodline Pathfinder
Charli D'amelio Bj
Divinity: Original Sin II - How to Use the Conjurer Class
Chase Bank Zip Code
What is 'Breaking Bad' star Aaron Paul's Net Worth?
15 Best Places to Visit in the Northeast During Summer
Bridgeport Police Blotter Today
Mejores páginas para ver deportes gratis y online - VidaBytes
Elizabethtown Mesothelioma Legal Question
login.microsoftonline.com Reviews | scam or legit check
Latest Posts
Article information

Author: Trent Wehner

Last Updated:

Views: 6594

Rating: 4.6 / 5 (76 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.