How to Check a Bank Reconciliation Statement - Top Tips (2024)

This Top Tip gives advice on how to check a bank reconciliation statement.

A bank reconciliation is a very powerful control tool that enables the organisation to identify omissions and errors in its own records, as well as being the only way to spot cheque fraud, bank errors and even bank fraud.

It is therefore very important for managers to carefully check bank reconciliation statements every month.

What is a Bank Reconciliation?

The bank reconciliation process involves checking the entries and the closing balance in the Cashbook (also called the Bank Book) with the entries and closing balance on the bank statement for the same period, to make sure the closing balances agree and to explain any differences.

This helps to pick up any missing items and incorrect entries in the records and to ensure that our accounts are accurate and complete.

For most NGOs, bank reconciliation is a monthly routine. For bank accounts that have a high volume of transactions, weekly or even daily reconciliation is advised. Even for bank accounts that are not very active, a monthly bank reconciliation is recommended due to the risk of bank fraud.

A bank reconciliation statement should be prepared every month end for every bank account held and then reviewed and signed by another responsible person such as the manager or Treasurer. The signed statements should then be carefully filed in date order for each account.

To complete the review of a bank reconciliation statement, you will need access to:

  • Previous bank reconciliation statements
  • The cashbook
  • Bank statements
  • Supporting documents, if a closer inspection is required.

What should you look for on the Bank Reconciliation Statement?

1. Check the dates

Is the date of the closing balance on the bank statement the same as the closing balance date in the cashbook? For example, if the bank statement is dated 29 January and the cashbook date is 31 January, the bank reconciliation will not be comparing like with like.

2. Check the cashbook balance

Does the stated cashbook closing balance actually agree to the cashbook?

3. Check the bank statement balance

Does the stated bank statement closing balance actually agree to the bank statement?

4. Check the structure of the reconciliation statement

Does the reconciliation statement provide details of the differences between the bank statement and cashbook balances at the month end? Do the figures add up correctly?

5. Check the outstanding items listed on the reconciliation statement

Does each of the outstanding items seem to be reasonable? These will include un-cleared cheques or cash deposits, bank interest or charges, and direct debits or bank transfers. Anything very old, very large or peculiar should be checked out. For example, a cheque that keeps appearing as un-cleared month after month could mean it is lost. Cheques do eventually become “stale” (usually after 6 months) so these must be followed up.

Check to see if missing items such as bank charges and deposits (ie appearing on the bank statement) have now been entered in the cashbook.

6. Check some cashbook entries

From time to time, it is a good idea to do a ‘spot check’ on some cashbook entries (eg for unusual or large purchases and cash receipts) to ensure the entries are valid.

For example, check the cash paying-in book to see how long it took between the cash being received and the actual banking date. It is reasonable to expect that cash is paid into the bank within 3 to 5 days for cashflow and security reasons (but check your NGO’s own policy on this). If it regularly takes 3 to 4 weeks, the money could be being ‘borrowed’ or put at risk of theft.

7. Check for ‘transposed’ numbers with the ‘magic number 9’

Sometimes the reconciliation statement will show an unexplained difference. In such cases, divide the difference figure by 9 (or add up the digits and see if it comes to 9). If it divides out evenly, then there’s a good chance that the difference is caused by a transposed number (ie where two numbers are reversed when entered).

For example, if $2,196 is entered incorrectly as $2,916 this would result in an unexplained difference of $720. We can see that 720 is divisible by 9 because 7 + 2 + 0 = 9. Magic! [If the difference figures add up to more than 9, eg 18, add together those digits too, so 1 + 8 = 9].

8. Show you’ve been here!

It can be helpful to put ticks against what you have checked, and then sign and date the reconciliation statement as evidence for the auditors that the reconciliation has been reviewed by a manager. The person preparing the reconciliation statement should also sign the form, of course.

How to Check a Bank Reconciliation Statement - Top Tips (2024)
Top Articles
Export Certificates and Private Key from a PKCS#12 File with OpenSSL - SSL.com
What is Cyber Threat Intelligence? - Check Point Software
Nco Leadership Center Of Excellence
Linkvertise Bypass 2023
Top 10: Die besten italienischen Restaurants in Wien - Falstaff
Flights to Miami (MIA)
Ogeechee Tech Blackboard
Declan Mining Co Coupon
Craigslist/Phx
Lqse-2Hdc-D
ATV Blue Book - Values & Used Prices
Mlb Ballpark Pal
Michaels W2 Online
Samsung Galaxy S24 Ultra Negru dual-sim, 256 GB, 12 GB RAM - Telefon mobil la pret avantajos - Abonament - In rate | Digi Romania S.A.
Bowlero (BOWL) Earnings Date and Reports 2024
Mineral Wells Independent School District
Char-Em Isd
Mzinchaleft
Overton Funeral Home Waterloo Iowa
Gem City Surgeons Miami Valley South
Jinx Chapter 24: Release Date, Spoilers & Where To Read - OtakuKart
The Menu Showtimes Near Regal Edwards Ontario Mountain Village
Wausau Marketplace
Zack Fairhurst Snapchat
Cbssports Rankings
Menus - Sea Level Oyster Bar - NBPT
25 Best Things to Do in Palermo, Sicily (Italy)
4 Times Rihanna Showed Solidarity for Social Movements Around the World
Tamil Movies - Ogomovies
Best Restaurants Ventnor
Craigslist Scottsdale Arizona Cars
Utexas Baseball Schedule 2023
Average weekly earnings in Great Britain
Mgm Virtual Roster Login
Greencastle Railcam
Tas Restaurant Fall River Ma
Hair Love Salon Bradley Beach
All Things Algebra Unit 3 Homework 2 Answer Key
2008 Chevrolet Corvette for sale - Houston, TX - craigslist
Scanning the Airwaves
877-292-0545
Restored Republic May 14 2023
11526 Lake Ave Cleveland Oh 44102
Kenner And Stevens Funeral Home
Citroen | Skąd pobrać program do lexia diagbox?
Walmart Careers Stocker
Crigslist Tucson
Julies Freebies Instant Win
The Hardest Quests in Old School RuneScape (Ranked) – FandomSpot
Zalog Forum
Karen Kripas Obituary
Used Curio Cabinets For Sale Near Me
Latest Posts
Article information

Author: Geoffrey Lueilwitz

Last Updated:

Views: 5801

Rating: 5 / 5 (80 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Geoffrey Lueilwitz

Birthday: 1997-03-23

Address: 74183 Thomas Course, Port Micheal, OK 55446-1529

Phone: +13408645881558

Job: Global Representative

Hobby: Sailing, Vehicle restoration, Rowing, Ghost hunting, Scrapbooking, Rugby, Board sports

Introduction: My name is Geoffrey Lueilwitz, I am a zealous, encouraging, sparkling, enchanting, graceful, faithful, nice person who loves writing and wants to share my knowledge and understanding with you.