Skip to content

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