Receivables & payables

What you are owed, and what you owe.

Aged against each document’s own due date, with the withholding that applies, the credit standing that blocks an order, and a collection run that is a plan rather than a list.

Aging · as at today₱14.2M outstanding
Currentnot yet due₱6,840,20048%
1–30 days₱4,112,90029%
31–60 days₱1,984,40014%
61–90 dayschasing₱842,6606%
Over 90 dayson credit hold₱428,5003%
Cebu Hardware Supplyover limit₱214,800held
STATEMENT OF ACCOUNTCebu Hardware Supply · 17/09
DR-04418 17 Aug32,563.20
DR-04502 24 Aug48,110.00
DR-04588 02 Sep61,240.40
Less payment 09 Sep(72,900.00)
Credit limit200,000.00
BALANCE DUE214,800.00
Next orderblocked
Terms: 30 days
What it is

Receivables and payables on one ledger, with aging, credit control, withholding and statements of account.

How it works

What it actually does.

01

Credit enforced at the order, not discovered at the invoice

A customer over their limit is stopped while the order is still an order. Finding out at invoicing is finding out after the goods have gone.

  • Limits and terms per customer, with who can release an exception.
  • Profit per customer after every discount, rebate and delivery.
  • Statements of account produced from the ledger, not assembled by hand.
Owed to you today₱4,182,908
Not yet due31 customers₱2,418,220
1 to 30 days14 customers₱884,410
31 to 60 days6 customers₱462,058
Over 60 days1 customer, still buying₱418,220

The last line is the one that matters, and it is the one a spreadsheet hides in a total.

02

The payable is built from the order

Not from whatever was written on the delivery receipt. A delivery receipt with no price on it does not change what you agreed to pay, and treating it as if it did is how payables come out short and nobody notices.

  • Three-way match between order, receipt and invoice.
  • Withholding applied at the rate that belongs to that supplier.
  • Certificates produced in both directions — what you owe and what is owed to you.
LimitOwedOver by
Santiago Meat Supply₱500,000₱918,220₱418,220
Tirso Trading₱300,000₱284,110
Bukidnon Provisions₱250,000₱261,400₱11,400
Tisa Distributors₱400,000₱212,908

The system knows before the delivery leaves, not after the statement goes out.

Questions

The ones people ask about this.

Can we age by a date other than the invoice date?

Yes — aging runs against each document’s own due date, which is what the terms actually say rather than a flat thirty days from issue.

Does it handle post-dated checks?

Yes, as a register that is a plan: by date, by bank and by customer, so you know what clears this week and what will not.

What if a supplier invoice disagrees with the order?

It is held, and the difference is shown against the line. Posting it anyway would make the payable right and the stock wrong.

Can we see profit per customer?

Yes, after discount, rebate and delivery — which is usually a very different ranking from profit on gross margin.

See it on your own figures.

Bring one ordinary day from your business and we will run it through in front of you, on your own items and your own prices.