Excel Bank Rec

<< Click to Display Table of Contents >>

Navigation:  Procedures > Bank Reconciliation >

Excel Bank Rec

Previous pageReturn to chapter overviewNext page

PROCESS FOR BANK RECONCILIATION DAILY

 

METHOD USING

1.Print daily bank statement.
2.Ask management to print off daily bank statement.
3.Go to z drive. (Accounts person) and click on bank rec for the current month.
4.Add on the cash receipts by using +  eg 1841.10+100+200 etc
5.Type in balance as per bank statement using a negative if this is the case.
6.Add any cheques that were written yesterday.
7.Present cheques from bank statement.
8.Add any eft’s.  These are shown on the reconciliation as b/s.  This means bank statement entries.
9.Ensure that the variance at the bottom of the bank reconciliation is zero.
10.Email a copy to management.

 

PROCESS FOR BANK RECONCILIATION MONTHLY

 

1.Print out Exel spreadsheet for daily bank reconciliation
2.Print out monthly statement from westpac online
3.Print out account card from pbc.  Double click on general ledger.  Double click on reports.  Double click on account card
4.Enter 99000 as the general ledger from and to
5.Enter in the period you are reconciling
6.Click on consolidated and summary
7.Run report
8.Go to z drive.  (Accounts person).  Monthly bank reconciliation and save as new month
9.Fill in the values
10.If this does not reconcile you need to tick off both sides of the exel spreadsheet against the account card
11.Once the differences are corrected reprint the reports and file in the green folder as per prior month