Automated Bank Reconciliation Excel Template (Help Video)

                                           BUY THE EXCEL TEMPLATE HERE

                          

#bankreconciliationstatement​ #exceltemplate​ #excellovers​

This is an automated excel spreadsheet designed to enable users to prepare a Bank Reconciliation Statement every month. 

Jump to:

1. Set up the back end: 0:15​

2. Set up Organization Bank Accounts: 01:12​

3. Select the Bank Account to reconcile: 03:03​

4. Enter data in Schedule 1: 03:26​ and 06:07​ - Unpresented Cheques

5. Enter data in Schedule 2: 03:38​ and 06:34​ - Uncredited Cheques

6. Enter data in Schedule 3: 06:49​ - Lodgements not in the cashbook

7. Enter data in Schedule 4: 07:04​ - Withdrawals not in the cashbook

8. Enter data in Schedule 5: 07:25​ - Bank Charges not in the cashbook

9. Printing: 09:04​

Features:

1. It is easy to use.

2. Users can reconcile more than one bank

3. Users can prepare supporting schedules for the Reconciliation Statement.

4. Users can customize with organization logo before printing or saving as PDF

5. Page Layout has been customized to print to fit

6. Works on Excel Versions 2010 and newer versions including 365

7. Users can clear contents of all schedules with an easy click button to enable another reconciliation

8. All calculations are automated

9. Additional features to aid compare Bank Statements Transactions and the associated Cashbook Transactions

10. Purchase cost is a one-off payment.

Using the Template

1. Set-Up:

Before you start to reconcile your bank accounts with the template you have to Set Up the back end details

1.1. Enter the name of the Organization

1.2. Select the Reconciliation Month

1.3. Select the period (This Year or Last Year)

1.4. Update the currencies 

1.5. Enter the names of the Responsible Officers

1.6. Update list of banks in your country

2. Organization Bank's Details

Next is to enter the details of all the Bank Accounts you are to reconcile. From item 2.1 to 2.5 can be set up once. Item 2.6 to 2.7 will be done on a monthly basis or anytime you want to reconcile a Bank Account.

2.1. Select the Name of the Bank

2.2. Select the currency of the Bank Account

2.3. Enter the Ledger Account of the Bank Account (This is from the Chart of Account)

2.4. Enter the Bank Account Name

2.5. Enter the Bank Account Number

2.6. Enter the closing balance in the Bank Statement

2.7. Enter the closing balance in the Cash Book

3. Unpresented Cheques:

In the schedule below, enter all the Payments that have been captured in the Cash Book but are not reflected in the Bank Statements.

4. Uncredited Cheques:

In the schedule below, enter all the Receipts that have been captured in the Cash Book but are not reflected in the Bank Statements.

5. Lodgements not in the Cashbook:

In the schedule below, enter all the Receipts that have been captured in the Bank Statements but are not reflected in the Cashbook.

6. Payments not in the cashbook:

In the schedule below, enter all the Payments that have been captured in the Bank Statements but are not reflected in the Cashbook.

7. Bank Charges:

In the schedule below, enter all the Bank Charges that have been captured in the Bank Statements but are not reflected in the Cashbook.

In the sheet named "Statement", you are to fill in only two cells. Select the Bank Account Details that you want to reconcile and select the RECONCILIATION OPTION. The Reconciliation Options means you can either begin with "Balance as per Bank Statements" and end the statement with "Balance as per Cash/Bank Book". Once you are done selecting these two cells, your reconciliation statement is ready as far as you have entered the data needed in the 5 schedules correctly.

Behold your Bank Reconciliation Statement!

For more, kindly click HERE to see the full tutorial on Bank Reconciliation Statements explained in simple terms

The Automated Excel Template is sold for $13.5 only.

Giveaway Price for clients in Nigeria only: N5,000 ongoing till 31st May 2021

1. For all currency payments Pay through Flutterwave.

2. For USD Payment only Pay through Flutterwave.

3. For Naira Payment only Pay through Flutterwave.

When making payments via Flutterwave, kindly enter "Automated BRS" in the field for "Item/Service Purchased". 

If you wish to make a direct payment to our bank account kindly send us an email to theconsultsplatformsolutions@gmail.com. 

Send us an email to theconsultsplatformsolutions@gmail.com if you are interested in this template.