Next, you need to make a list of all the RECEIPTS IN THE BANK STATEMENTS in the table (Schedule) below. Next you will make a list of all the UNPRESENTED CHEQUES in the Table (Schedule) below. Next, Key in all the Bank Charges and Other Charges not captured in the Bank book in the Table (Schedule) Below. Next, Key in all the DIRECT PAYMENTS IN THE BANK STATEMENTS in the Table (schedule) below.
Next, Key in all the UNCREDITED CHEQUES/LODGEMENTS in the Table (Schedule) below. The pictures below shows the various steps to take.įirst, Select the Bank you want to Reconcile as shown below. You can Print or Make a Copy of this Page once you are done. As you are updating here with the Uncredited and Unpresented cheques, the application is preparing the Bank Reconciliation Statement for you. This is where the Reconciliation is prepared. Step by Step from Note 1 to 6 you need to list out the Transactions that caused the Differences between the Bank Book Balance and Bank Statement Balance. You will notice that the Company Name, Reconciliation Month and Date are already updated in this Page after you have done Number 3 above. First you need to select the Bank you want to Reconcile. Here, you need to input all the items that made the Balance in the Bank Book different from the Bank Statement.
THIS IS THE MOST IMPORTANT SHEET IN THIS APPLICATION. P REPARE THE RECONCILIATION NOTES (SCHEDULES) The Pictures below show before and after selections and keying of closing balances.
How to do a ledger in excel update#
The Initial is important if you want to update the Bank Statement Balances on the Chart on the User Interface. You can set up Abbreviations or INITIALS for each bank. For each Bank, Key in the Closing Balances as per your BANK BOOKS/LEDGERS and also key in the Closing Balances as per your BANK STATEMENTS under their respective Columns. Next, select all the Banks that you want to reconcile for the Month. The two pictures below show before and after the Set up Setting up the Month can only be done here. You need to do this anytime you want to prepare reconciliation for any month.
SET UP COMPANY DETAILS & SELECT MONTH FOR RECONCILIATIONĪlways set up the Month and Date for the Reconciliation. The two Pictures below shows before and after Staff Set Up. Second, set up the Names of the Account Personnel who will be preparing and reviewing the Bank Reconciliation Statements. List the Banks, their Account Numbers, Location, Account Officer and Contact if necessary. If you have downloading the Template, the steps below will be important to fully understand įirst you need to list all the Banks of your Organization on the Picture shown below.
How to do a ledger in excel how to#
The article below is a guide on how to Set Up and Use the Template to Reconcile the Bank Statements with the Bank Books/Ledgers.
0 kommentar(er)
