User Roles AdminStaff contributor ✗External contributor ✗Pulse user 

The Creditors schedule template lets you build up a supporting schedule of individual suppliers, or of individual invoices where you need more detail, that reconciles back to the value of a creditors account in the trial balance. It also gives you a section to record and evidence any difference that does not reconcile. It is a generalised reconciliation working paper, with nothing accounting-standard-specific about it.

Table of contents 

When should I use this template?

Use it whenever you need to evidence a trade creditors balance, or a similar creditor-type balance, with supporting supplier or invoice detail, rather than just accepting the trial balance figure.

The template is fixed to creditor wording, so it refers to Supplier and not Customer. If you need the equivalent for a debtor-type balance, use the separate Debtors schedule template, which works identically but with debtor wording.

Before you start

  • Apply the template to the relevant creditor account or accounts in the trial balance. It reconciles to whatever value that account carries, and adjusts the sign automatically depending on whether the account naturally sits in debit or credit, so there is nothing to configure for that.
  • Decide upfront whether you want a supplier-level total or an invoice-level breakdown (see Step 1). You can switch later without losing any data you have already entered.

Steps

Step 1: Choose Supplier or Invoice mode

At the top of the template, a Template type dropdown lets you choose between:

  • Supplier (the default): a simple table with one row per supplier.
  • Invoice: a more detailed table with one row per invoice.

Switching between the two only changes which columns are shown below. Any supplier number, name, attachment or amount you have entered stays saved either way, and any invoice number, date or description you have added under Invoice mode stays saved (just hidden) if you switch back to Supplier mode.

Step 2: Enter your supplier or invoice detail

  • Supplier mode columns: Supplier number, Supplier name, an attachment column (for evidence such as a statement), and the amount.
  • Invoice mode columns: Supplier number, Supplier name, Invoice number, Invoice date, Invoice description (a free-text box), an attachment column, and the invoice amount.

Add as many rows as you need with the + button. The Total row calculates automatically as you go.

Step 3: Reconcile and explain any difference

The schedule's total is compared against the trial balance value of the account it is applied to. If they agree, a green reconciled indicator appears next to the total.

If they do not agree, an Explanation of differences section appears below it, with rows for a note, an attachment, and an amount. Add as many as you need to account for the gap. A Total after explanation row then shows the residual difference, with a reconciliation indicator giving a breakdown of the trial balance value, the schedule's total, and the difference, updating live as you add explanations.

What flows through to the rest of the accounts/workflow?

Nothing beyond the reconciled account itself. This is a standalone supporting schedule, not a source of figures for any accounts-production note or other template.

What rolls forward next year?

Nothing carries forward automatically. The supplier and invoice rows, the Template type selection, and any explanation notes are all entered fresh each period against that period's trial balance. Last year's entries stay on last year's period.

Where the data comes from

  • Trial balance: the account's value is what the schedule reconciles to.
  • Everything else, meaning the supplier or invoice detail, amounts, notes and attachments, is entered manually row by row. There is no automatic import from bookkeeping or the ledger.

Frequently asked questions

Can I use this template for debtors instead of creditors?

No. This template's wording is fixed to suppliers and creditors. Use the separate Debtors schedule template for a debtor-type balance; it works the same way, with customer wording instead.

I switched from Supplier to Invoice mode (or back). Have I lost my rows?

No. Both modes read from the same underlying list of rows, so switching only changes which columns are displayed. Supplier number, name, attachment and amount carry over either way, and invoice number, date and description stay saved even when Supplier mode is hiding them.

I'm still waiting on detail from a supplier. What should I do?

Enter what you have and add a note, with an estimated amount if you know it, in the Explanation of differences section, so the schedule clearly shows why it is not fully reconciled yet.