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

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 "B Fwd" - 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 "Data Sheet" 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 the last 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.

Click to see full size screenshot

LIMITATIONS FOR USING THE SOFTWARE

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.

3. The 12 receipts and 12 payments sheets are limited to 32,750 usable rows. If you use more then the auto bank rec will not work properly.

For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but it will not prepare the bank reconciliation beyond month 3.

You can purchase a license 24/7 using our secure automated service from this webpage below.

Cash book with automatic bank reconciliation Zip file

To install:

1. Unzip the file you have downloaded from above.

2. Open the Excel file.

No need to uninstall your current version - simply download as above.

Contact us if you have problems.

Licenses cost GBP15.00 each per workbook and have no time restriction or expiry 
 

• For orders of 10 or more licenses please contact us for a special price

BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies

SAVE MONEY by buying several PATools Excel products - see here