Cash Book Spreadsheet - with Bank Reconciliation
This comprehensive Cash Book Spreadsheet allows you to maintain complete control over you business Receipts and Payments
and is easily reconciled to your Bank Statements.
The program is ideal for small businesses who wish to automate this process and to take control of Cash Flows.
The system is flexible and easy to use and comes with a comprehensive guide and free 14 day email support.
Please view the screen shots below:
Cash Book - PAYMENTS
Every Bank Payment is recorded on a separate line. You enter the date; the details; a folio or other reference; then the analysis of the transaction followed by the Gross amount. If VAT applies to the transaction, then you can select the appropriate VAT Rate and the software automatically computes your VAT and Net values.
The total value of your Payments is recorded both in Summary and Detail on this worksheet. You can also make use of Excels filtering facility to further analyse your data.
To facilitate easy reconciliation to your Bank Statements, the worksheet includes a ‘Matching‘ routine which automatically updates the Bank Reconciliation.
Cash Book – RECEIPTS
Like the Payments worksheet above every Bank Receipt is recorded on a separate line. You enter the date; the details; a folio or other reference; then the analysis of the transaction followed by the Gross amount. If VAT applies to the transaction, then you can select the appropriate VAT Rate and the software automatically computes your VAT and Net values.
The total value of your Receipts is recorded both in Summary and Detail on this worksheet. You can also make use of Excels filtering facility to further analyse your data.
To facilitate easy reconciliation to your Bank Statements, the worksheet includes a ‘Matching‘ routine which automatically updates the Bank Reconciliation.
Cash Book – Analysis
This worksheet records the Analysis headings suitable for your business. The descriptions you enter here are then made available for selection via the Drop Down boxes on both the Payments and the Receipts worksheets.
Similarly the Totals relating to each Analysis type are automatically updated from the Payments and Receipt worksheets.
Cash Book – Reconciliation to Bank Statements
To maintain the integrity of your Cash Books you should reconcile your balances with those shown on your Bank Statements.
The Bank Reconciliation routine automates this function. It extracts details of ALL un-cleared transactions from the Payments and Receipts worksheets and brings these totals onto the reconciliation.
You simply enter the Bank Statement balance (together with details of any items un-cleared form prior periods) and the software does the rest.
