Accounts Payable · Included in Twinn Reports
AP Invoice Aging for Sage 100 Contractor
What you owe each vendor and subcontractor, invoice by invoice, aged into current, 1–30, 31–60, 61–90 and over 90 days, with retention held. The list you look at before a check run, and the one your bank asks for alongside the AR aging.
It runs in your browser against your live Sage 100 Contractor data, through the Twinn service on your own network, and exports to Excel, PDF or CSV.
Who uses it
- AP clerks planning the check run
- Controllers managing cash
- Owners checking vendor relationships
The questions it answers
- What do we owe that is more than 30 days old?
- Which vendors are we furthest behind with?
- How much is due this week?
Ask Twinn · Early access
“What do we owe vendors that is over 30 days?”
Ask Twinn, the assistant inside Twinn, runs this same report to answer questions in plain English. It tells you which report it ran, with which criteria, as of when, so the answer always matches the report.
How Ask Twinn worksWhat’s in the report
Every column, and what it means.
- Vendor
- Vendor number.
- Vendor Name
- Vendor name; the report is grouped by it.
- Record#
- Sage's internal invoice record number (what you type in AP Invoices to open it).
- Invoice#
- The vendor's invoice number.
- Invoice Date
- Invoice date.
- Due Date
- Due date.
- Job
- Job number the invoice was charged to (blank for overhead).
- Job Name
- Job name.
- Status
- Open, Review or Dispute.
- Days
- Days past due on the as-of date; zero or negative means not yet due. As-of date − Due date (or Invoice date).
- Invoice Total
- Original invoice amount.
- Balance
- What's still owed, retention included: Invoice Total − Paid − Discount/Credit taken (kept up to date by Sage).
- Retention
- Retention still held on the invoice. Not aged: it's due when the job releases it.
- Current
- Net due that isn't past due yet: Net Due when Days ≤ 0.
- 1-30
- Net due 1 to 30 days past due: Net Due when 1 ≤ Days ≤ 30.
- 31-60
- Net due 31 to 60 days past due: Net Due when 31 ≤ Days ≤ 60.
- 61-90
- Net due 61 to 90 days past due: Net Due when 61 ≤ Days ≤ 90.
- Over 90
- Net due more than 90 days past due: Net Due when Days > 90.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Age as of
- Age by
- Vendor
- Job
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Open = status Open, Review or Dispute with a balance. Balance = Retention + the five aging columns.
- Balances are current balances. The as-of date only sets the age, so this is not a historical aging for a past date.
- Aging by invoice date matches Sage's '~Aged By Invoice Date' variant (04010351).
More Accounts Payable reports
Lien Waiver Tracking
AP payments by job and vendor for a check date range: which lien waivers to collect, for how much, and what's still unpaid.
Subcontractor Compliance
Vendor certificates (insurance, workers' comp, license) with expiry dates, flagged expired or expiring, plus owner, federal ID and 1099 type.
1099 Vendor Payments
Payments to 1099 vendors in a calendar year, by check date, with federal ID, 1099 type and form box, checked against Sage's 1099 amounts.
AP Invoice List
Payable invoices with totals, payments, retention and balance.
Payment Invoice Details
AP payments and the invoices they paid, by vendor.
Set to Pay
Payment approval list: open invoices with the amount set to pay, by job or vendor, with balance, retention, discount and warnings.
See your own WIP in Twinn
Book a demo and we’ll set Twinn up on a test copy of your Sage 100 Contractor company, then walk you through your own WIP and over/under billings, and this report.
Book a demo