Creating your own templates
See the standard instructions for a general guide on how to create your own spreadsheets for entering cash book receipts.
Spreadsheet Design
Cash Book Payments Excelerator offers great flexibility in how spreadsheets can be designed for entering cash payment batches.
There are three basic structures for entering data:
- Many nominal distributions to a single invoice
- Many invoices and nominal distributions for a single supplier
- Many suppliers, invoices and nominal distributions
In all cases batch number is a header cells
In addition to this, user will need to consider how will enter your VAT