Bank Reconciliation [Bookkeeping 101] | Lendio (2024)

The keys to good bookkeeping are organization and attention to detail. Bookkeepers and small business owners managing their own books need to accurately record each expense and source of income to understand their true financial situation.

Bank reconciliation is one of the key processes of effective bookkeeping that requires attention to detail. This step aligns the bank’s records with your internal ledger to make sure they reflect the same amount.

This process can be tedious if you fall behind on your records or have a lot of transactions. However, this guide will help you understand its importance and—hopefully—make the process easier.

What is bank reconciliation?

Bank reconciliation is the process of ensuring the information in your business accounting software matches exactly with the information in your bank account statement. In other words, all money in and all money out should be identical in both.

What is a bank reconciliation statement?

A bank reconciliation statement is a financial document that compares an account’s balance on your company’s books to the balance in that account according to your bank statement.

A bank reconciliation statement typically has two parts. The first part starts with your bank account balance and then adds or subtracts any transactions recorded in the company’s cash account on its books that haven’t yet cleared the bank. The result is your company’s adjusted cash balance.

The second part starts with your company’s cash account on its books and then adds or subtracts any transactions recorded by the bank that have not yet been input into your company’s bookkeeping software. The result of this calculation should be the same adjusted cash balance you calculated in the first part.

Why is bank reconciliation important?

Bank reconciliation is important because it is the first step in ensuring that your company’s books are accurate.

Bookkeeping errors are not uncommon, and they can easily be caught by reconciling your cash accounts to their statements at least every month, if not more often.

Bank errors are rarer than bookkeeping errors, but they do occur. And frequently reconciling your bank account balance to your statement can help you uncover these errors when they do arise so you can bring them up with your bank for correction.

How do you reconcile a bank statement?

The first step in reconciling your bank statement is to obtain your latest bank statement and note the period it covers.

Then, open up your bookkeeping software and pull up the register of all entries to your cash account balance for the period covered by your bank statement.

Now, compare the transactions in your software with the transactions indicated on your bank statement and note any transactions that are recorded in one record—either your software or your statement—but not in the other.

For example, let’s say that your business checking account has a balance of $10,000 according to its statement, but a balance of $11,000 according to your books. In comparing the transactions between the two records, you notice these three differences:

  • A $900 check to your company that you deposited and recorded in your books, but that has not yet cleared the bank
  • A $120 service fee indicated on your bank statement that you have not yet recorded in your books
  • A $20 interest payment from your bank that you have not yet recorded in your books

Once you’ve done this work, prepare the first part of your bank reconciliation statement, which starts with your bank statement balance and adds or subtracts the transactions recorded only in your bookkeeping software. Using the example above, this part of your bank reconciliation statement would look like this:

$10,000Balance per bank
+ $900Uncleared check
$10,900Adjusted Balance

Now, you would create the second part of your bank reconciliation statement. This part starts with your cash balance on your books, to which you add or subtract the transactions found on your bank statement, but not currently on your books. Following the previous example, this part would look like this:

$11,000Balance per books
– $120Service fee
+ $20Interest earned
$10,900Adjusted balance

Since your adjusted balance in both parts matches each other, you can be confident that you’ve prepared your bank reconciliation statement correctly.

Finally, you record the necessary journal entries to adjust your current balance on your books to match the adjusted balance from your bank reconciliation statement. In this case, your entries would look like this:

Debit Service Fee Expense$120
Credit Interest Income$20
Credit Cash$100

If you haven’t reconciled your cash balance to your bank statement before, you will have to go back to the month in which you opened your bank account and perform this exercise for every month thereafter.

How often should you reconcile your accounts?


Historically, businesses would reconcile their accounts monthly when the bank sent a physical statement. However, the digital era has made it easier for businesses to pull data from a banking period and reconcile accounts as they go.

At the very least, you should reconcile your accounts monthly. However, you may decide to set up a weekly reconcile meeting to download the statements and review your ledgers. Some companies even reconcile their accounts daily if they have a high number of transactions.

By reconciling your accounts regularly, you won’t have a huge build-up of statements and ledgers that need adjusting. This proactiveness will prevent you from logging long hours each quarter (or even at the end of the year) as you try to match up what your bank says compared to your ledger.

Bank reconciliation is one of the least glamorous parts of running a business. However, this practice is essential if you want a reliable view of your finances.

Bank Reconciliation [Bookkeeping 101] | Lendio (2024)

FAQs

What are the 7 steps to bank reconciliation? ›

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.

How do you solve a bank reconciliation question? ›

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

What is the formula for bank to book reconciliation? ›

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).

How can I make reconciliation easier? ›

Here, we offer you some tips and tricks to help you save time on this process, and make it more efficient.
  1. Information and documentation. ...
  2. Don't forget the till. ...
  3. Reconcile in sections. ...
  4. Analyse discrepancies. ...
  5. Banks also make mistakes. ...
  6. Reconciling items, the last resort. ...
  7. Automate the process.

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

What are the 5 R's of reconciliation? ›

Intro to 5 R's: Respect, Relevance, Reciprocity , Responsibility , and Relationships. Kirkness and Bernardt's First Nations in Higher Education: The Four R's (1991) is a foundational form for Indigenizing education.

What is the journal entry for bank reconciliation? ›

Definition of Journal Entries in a Bank Reconciliation

Journal entries are required in a bank reconciliation when there are adjustments to the balance per books. These adjustments result from items appearing on the bank statement that have not been recorded in the company's general ledger accounts.

What is the most important step to reconcile accounts? ›

Accuracy and completeness are the two most important things when reconciling accounts, and these are what accounts for effective and proper account reconciliation. Additionally, reconciling accounts on time consistently is also essential to maintaining financial integrity.

What are the mistakes in bank reconciliation statement? ›

Unrecorded transactions can indicate that the transactions were not entered into the accounting system or that a check or deposit lost or stolen. This error occurs when a transaction is recorded by the company, but the amount or date does not match the corresponding transaction on the bank statement.

What is the formula for reconciliation? ›

The equation used to calculate this value is: (Last Statement Balance - Checks + Deposits + Interest Income - Bank Charges +/- Other Items) - Current Statement Balance.

What is the shortcut key used for bank reconciliation? ›

Press Alt+R (Reconcile) to view the Bank Reconciliation Statement. The display goes to the Reconciliation mode, which can be edited. You can see the column for Bank Date to enter the date when the transactions are cleared in the bank.

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

What two items do you need to reconcile your checking account? You need your bank statement and your record of transactions (like a check register or accounting software).

How do you reconcile a petty cash book? ›

How to do petty cash reconciliation
  1. Gather documentation. Collect all receipts, vouchers, and petty cash logs to reconcile transactions accurately. ...
  2. Prepare reconciliation form. ...
  3. Count remaining cash. ...
  4. Record transactions. ...
  5. Total expenses. ...
  6. Reconcile cash and expenses. ...
  7. Identify discrepancies. ...
  8. Make adjustments.
Apr 5, 2024

How to do a simple bank reconciliation in Excel? ›

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.

How do you understand bank reconciliation? ›

Bank reconciliation is the process of matching entries in accounting records with information on a bank statement. Bank reconciliation is critical to get detailed visibility into cash availability, achieve accurate reporting, and faster financial close.

What is best practice for bank reconciliation? ›

Ensure all transactions are recorded promptly to the general ledger. How and when transactions are posted to the general ledger affect the reconciliation process. Transactions should be recorded as they occur, based on source records, not from bank statement activity at month's end.

Is bank reconciliation statement 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.

Is bank reconciliation easy? ›

Bank reconciliation statements are tools companies and accountants use to detect errors, omissions, and fraud in a financial account. Bank reconciliation is a simple and invaluable process to help manage cash flows.

Top Articles
Pygmy Necklace
7 Reasons Behind Dogs Licking Their Paws?
English Bulldog Puppies For Sale Under 1000 In Florida
Katie Pavlich Bikini Photos
Gamevault Agent
Pieology Nutrition Calculator Mobile
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Compare the Samsung Galaxy S24 - 256GB - Cobalt Violet vs Apple iPhone 16 Pro - 128GB - Desert Titanium | AT&T
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Craigslist Dog Kennels For Sale
Things To Do In Atlanta Tomorrow Night
Non Sequitur
Crossword Nexus Solver
How To Cut Eelgrass Grounded
Pac Man Deviantart
Alexander Funeral Home Gallatin Obituaries
Energy Healing Conference Utah
Geometry Review Quiz 5 Answer Key
Hobby Stores Near Me Now
Icivics The Electoral Process Answer Key
Allybearloves
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
Marquette Gas Prices
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Vera Bradley Factory Outlet Sunbury Products
Pixel Combat Unblocked
Movies - EPIC Theatres
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Mia Malkova Bio, Net Worth, Age & More - Magzica
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Where Can I Cash A Huntington National Bank Check
Topos De Bolos Engraçados
Sand Castle Parents Guide
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Holzer Athena Portal
Hello – Cornerstone Chapel
Stoughton Commuter Rail Schedule
Nfsd Web Portal
Selly Medaline
Latest Posts
Article information

Author: Dong Thiel

Last Updated:

Views: 5993

Rating: 4.9 / 5 (59 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Dong Thiel

Birthday: 2001-07-14

Address: 2865 Kasha Unions, West Corrinne, AK 05708-1071

Phone: +3512198379449

Job: Design Planner

Hobby: Graffiti, Foreign language learning, Gambling, Metalworking, Rowing, Sculling, Sewing

Introduction: My name is Dong Thiel, I am a brainy, happy, tasty, lively, splendid, talented, cooperative person who loves writing and wants to share my knowledge and understanding with you.