Creating your own templates

See getting started for a general guide on how to create your own spreadsheets for entering purchase invoices.

Spreadsheet Design

Purchase Ledger Invoice Excelerator offers great flexibility in how spreadsheets can be designed for entering invoice 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

1. Multiple Nominal Distributions to a Single Invoice

The template should have single Excel cell supplier, invoice number and invoice amount, and other header/detail ranges ranges, in the header of the sheet.

Posting codes and amounts are columns.

Multiple Nominal Distributions to a Single Invoice

2. Multiple Invoices and Nominal Distributions to a Single Suppliers

The template should have a single Excel cell supplier code range in the header of the sheet.

Invoice number and invoice amounts, posting codes and amounts are columns.

Multiple Invoices and Nominal Distributions to a Single Suppliers

3. Multiple Suppliers and Invoices

Suppliers, invoice numbers and invoices amount, posting codes and amounts are columns.

Multiple Suppliers and Invoices