Creating your own Templates

See getting started 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, you will need to consider how you will enter your VAT.