Accounts Payable · Included in Twinn Reports
Subcontractor Pay by Job for Sage 100 Contractor
Per job and subcontractor: subcontract amount with approved changes, billed to date, paid, retention held and remaining.
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.
Ask Twinn · Early access
Or just ask for it.
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.
- Job
- Job number (0 = no job).
- Job Name
- Job name; the outer level of the default grouping.
- Vendor
- Subcontractor's vendor number.
- Vendor Name
- Subcontractor's name; the inner level of the default grouping.
- Type
- Subcontract or PO.
- Subcontract#
- Subcontract number (or PO number for POs).
- Description
- Subcontract or PO description.
- Status
- Commitment status.
- Original
- Original subcontract amount (PO total for POs).
- Approved Changes
- Approved subcontract changes (0 for POs).
- Subcontract
- Current subcontract amount.
- Billed to Date
- Total of the AP invoices entered against the subcontract.
- Paid
- Cash paid on those invoices.
- Disc/Credit
- Discounts and credits taken on those invoices.
- Retention Held
- Retention still held on those invoices (not yet released or paid).
- Balance Owed
- What's still owed on those invoices, retention included.
- Remaining
- Subcontract amount not yet billed (negative = billed over the subcontract).
- % Billed
- Share of the subcontract billed so far.
- Invoices
- Number of AP invoices entered against the subcontract.
- Last Invoice
- Date of the latest invoice.
- Retention %
- Retention rate on the subcontract (blank for POs).
- Hold
- 'Hold pay' when the subcontract's Hold Pay box is checked.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Commitments
- Status
- Job
- Vendor
- Vendor type
- Only with invoices
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Subcontract = Original + Approved Changes, from the subcontract record. Billed, Paid, Retention and Balance add up the AP invoices entered against the subcontract.
- Billed to Date = Paid + Disc/Credit + Balance Owed; Remaining = Subcontract − Billed to Date.
- Companies that track subs with purchase orders can pick Commitments = Purchase orders (and filter by vendor type).
More Accounts Payable reports
AP Invoice Aging
Open payables by vendor, aged into Current / 1-30 / 31-60 / 61-90 / Over 90 days.
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.
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