Credit and rebill matcher

A replacement bill should be reviewed together with the credits and payments allocated to the same supply and period. Looking at the newest invoice on its own can leave earlier entries unexplained. This matcher groups the records you provide and calculates the balance of charges less credits and payments, giving you a period-by-period reconciliation to compare with the supplier ledger.

Credit and rebill matcher

Reconcile charges, credits and payments for the same supply and billing period.

Enter positive amounts with type charge, credit or payment. Only group items for the same account, supply and period. Verify allocation with the supplier ledger.

What the result shows

Records are grouped by supply or account and billing period. Within each group, the tool adds positive charges, subtracts positive credits and subtracts positive payments. A repeated reference with the same supply, period and type is rejected for review. Keep allocation consistent: a payment that belongs to a different period can change the apparent balance even when the underlying payment amount is correct.

Prepare the information for this review

Use the example CSV available in the tool to check the structure before preparing a larger file. Keep its header row, use one record per row and use plain numbers without currency symbols or thousands separators. Dates should follow the stated format. Quoted values can contain commas, but every row must have the same number of columns as the header.

  • reference: Keep the reference stable enough to match the record back to the invoice, statement or source entry.
  • supply: Use a consistent supply or account identifier so unrelated balances are kept in separate groups.
  • period: Use a consistent delivery or billing period label and compare it only with the matching period.
  • type: Use charge, credit or payment, with a positive amount; the type determines the direction of the entry.
  • amount: Enter a plain numeric amount and use the separate type or frequency field to explain how it should be treated.

The file is read in the browser when you select it or paste its contents. Check a small set of records first and compare the output with a manual example. Up to 20,000 data rows and 2 MB are supported. The result table displays records in pages where needed, while downloads include the full result rather than only the rows visible on screen.

Check the result against the source records

Enter positive amounts with type charge, credit or payment. Only group items for the same account, supply and period. Verify allocation with the supplier ledger.

Start with one case whose inputs you can trace back to the original records. Run the tool and compare its labels, units and dates with that example before preparing a wider review. If a value is uncertain, record the uncertainty in your working notes and resolve it with the person who holds the source information. A neatly presented result is useful only when the assumptions behind it are also clear.

Keep a copy and agree the next action

Use Download report to keep the written result and Download results CSV when you want to work with its records in a spreadsheet. Save inputs keeps a JSON file that can be restored into this same tool later. Editing an input hides the old result until you run the tool again, which helps avoid sharing an output that belongs to an earlier set of assumptions.

Where report emailing has been configured, Email my results lets you request a copy and send the same inputs and result to this site for follow-up about your request. The form explains who receives the copy and requires a completed security check. Check the recipient address carefully before sending. The email request uses the current result, so review the entered information before choosing that option.

For help with the next step, Explore specialist support.

If the figures still do not reconcile after you have checked the credits and replacement bills, see how Costmaster investigates business energy billing errors.

Scroll to Top