Aged payables and retention on progress claims
Two finance reports for contract and project work, each off until you turn it on: what you owe suppliers by age, and retention held back on progress claims until the defects period ends.
Where it is
Settings for this
- Settings → Purchasing — Aged payables report
- Settings → Orders — Retention on progress claims
Both are off until you turn them on (that needs Edit settings).
Aged payables
Turn on Aged payables report under Settings → Purchasing. Reporting → Aged payables then lists what you owe suppliers on purchase orders whose supplier invoice is in: the total, less payments and supplier credits. It's grouped by supplier, in buckets of days past the bill's due date (or 30 days after it arrived when it has none): not yet due, 1–30, 31–60, 61–90 and 90+. Foreign-currency bills count at the PO's AUD value. Click a supplier to see each bill. Pick another As at date to see the position on that day. It needs the cost permission.
Retention on progress claims
Turn on Retention on progress claims under Settings → Orders. Then, on a sales order (with a payment schedule), set the Retention % and when it's due back, before the first progress claim.
- Each progress claim gets a "Retention held" line taking that % off the claim. GST is on what's billed.
- The final invoice takes the % off the whole order. Over the claims and the final invoice, exactly that % of the order is held, however the order was staged.
- Once the final invoice is approved, Release retention (on the order, or on Reporting → Retentions) raises one invoice for everything held, as a draft. Approve and send it when the defects period is over.
Reporting → Retentions lists every order with retention, what's held, when it's due back (red once that date has passed) and whether it's been released. Every invoice involved is an ordinary invoice: payments, reminders, pay links and Xero work as usual.