Cash Book with Bank Reconciliation

£23.99


Free Delivery

Immediate Download

Cash Book Spreadsheet with Bank Reconciliation and Expenses Analysis

This comprehensive Cash Book Spreadsheet allows you to analyse and control your 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. 

For a complete accounting solution see our Cash Accounting Range

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.

  



 Additional information and small print 

 
Mr. Spreadsheet is a registered trading name and division of Heron Accounting Services, Poole, Dorset. This software is protected by international copyright and is sold on a single-user license agreement for the use by the licensee or licensees business only. Unlawful copying and distribution will result in prosecution.We make no warranty or representation, either express or implied, with respect to this software and documentation, their quality, performance, merchantability, or fitness for a particular purpose. This software is licensed ‘as is’, and you, the licensee, by making use thereof, are assuming the entire risk as to their quality and performance. In no circumstances will we be held liable for direct, indirect, special, incidental or consequential damages arising out of the use or inability to use the software or documentation.
 


Please Choose:

Excel Spreadsheet

Excel Download



Customers who bought this product also purchased...