FileFiddler
FILEFIDDLER GUIDE

FIFO Ledger Aging Explained with a Worked Example

Customer and supplier ledgers use opposite debit-credit conventions. FileFiddler’s Ledger Aging Calculator therefore separates account type and opening balance entry, then applies receipts or supplier payments to the opening amount and oldest outstanding invoices using FIFO.

Start with the transaction sequence

For a customer ledger, debit sales invoices increase receivables and credit receipts reduce them. For a supplier ledger, credit purchase invoices increase payables and debit payments reduce them. The same debit or credit column cannot be treated as an invoice or payment without first identifying the ledger type.

Enter the verified opening amount separately in the Opening Balance field. Choose Outstanding for an opening receivable or payable, or Advance / Credit Balance when the account starts with an advance. The calculator does not derive opening from the first running-balance row.

Example: a supplier opening payable of PKR 15,000 followed by a purchase invoice credit of PKR 42,500 and a supplier payment debit of PKR 25,000 leaves PKR 32,500 payable. The customer-side equivalent uses a debit invoice and credit receipt.

Add credit days

If the invoice date is 5 January and the agreed credit period is 45 days, its due date is calculated from those inputs. Aging should be measured against the remaining unpaid amount, not against the original invoice value after receipts have already been allocated.

Later receipts continue to clear the oldest outstanding eligible balances first. This produces a sequence of partially or fully settled invoices.

Why opening balances and adjustments need review

Opening balances may represent several older invoices rather than one transaction. Credit notes, returns and manual adjustments can also change how a business expects payments to be matched.

FileFiddler provides a practical FIFO result based on the ledger rows it can read. If your accounting policy allocates payments by reference number, contract, branch or another rule, the FIFO result may differ from your books.

What to verify before relying on an aging result

Aging is useful for collection follow-up and reconciliation, but unusual ledgers should be reviewed before the result is treated as an accounting record.

  • Transaction dates are interpreted correctly.
  • Debit and credit signs match the customer or supplier mode.
  • Opening balances are understood.
  • Credit notes and reversals are represented correctly.
  • Credit days match the commercial agreement.

Worked example: one payment clears the oldest invoice first

With no opening balance, invoice A dated 1 January is 100 and invoice B dated 10 January is 200. A payment of 150 dated 15 January clears A in full and pays 50 against B. B has 150 outstanding; A has zero outstanding.

With 30 credit days and an as-of date of 31 January in the same year, A was settled 14 elapsed days after its invoice date. B is due on 9 February, so its outstanding 150 is not yet overdue. Do not confuse total outstanding with payment already due. A different opening balance or payment allocation changes this result.

Related FileFiddler tools

About this guide

This guide documents how FileFiddler approaches the underlying file problem, including limitations that matter when you review the output. It is maintained alongside the tools rather than written as generic promotional content.

Advertisement