PATools Auto Bank Rec

Use this workbook for your cash book
and let PATools prepare your bank reconciliation
at the press of a button!

Scroll down for more

The workbook comprises the following:

» One sheet containing the Bank Reconciliation.

» 12 receipts and 12 payments sheets - one of each for each month. Note These are called Rec01, Pay01 etc so that it does not matter

which month starts your fiscal year.

» One sheet called "BFwd" - enter in here your opening cash book balance for the fiscal year, plus the details of previous year uncleared items. The format required will allow you in future years easily to copy and paste in such items.

» One sheet called "Setup" where you enter (once only each year)

the name of first month in your fiscal year

your fiscal year eg 2001, or 2000/01

your company / division / bank account name

Having set up the details on these two sheets you are then ready to start entering your cash book detail into the 12 receipts and 12 payments sheets. Any sheet that already contains a total line can either have lines inserted above that line, or better still, you should delete the totals line. At any time you can automatically have a totals line added just by clicking on the button at the top of the sheet - the software will insert the formulae for however many columns you have used (which can vary from sheet to sheet).

On these 12 sheets you must not change the format of columns A - E.

Column A contains the date.

Column B is for a reference eg cheque number, paying-in number, direct debit, etc.

Column C is for marking when each item clears the bank. Uncleared items are the ones used to reconcile the bank. We recommend you enter the name or number of the month when each item clears. NOTE: This also applies to the brought forward items. Don't forget to mark these once cleared.

Column D is for some text eg payee for payments.

Column E is a formula that will automatically be inserted when you use the "Total this page" button. You do not need to enter anything in column E.

Column F onwards can be used as you wish, and it is here that you enter the amount(s).

At any time you can create the bank reconciliation simply by pressing the button on the first worksheet, and entering the current bank balance.

You MUST observe these limitations:
1. Do not change the worksheet tab names as supplied in the file by PATools. You can add your own new worksheets though this is not recommended. You can move the sheets around eg put all the 12 receipts sheets together, and similarly the payments sheets.
2. Do not alter the format of the worksheets set up by PATools EXCEPT you may use columns F onwards on the 12 receipt and 12 payments sheets as you wish.

follow us