Accounts Payable · Included in Twinn Reports
Set to Pay for Sage 100 Contractor
Payment approval list: open invoices with the amount set to pay, by job or vendor, with balance, retention, discount and warnings.
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 the invoice is charged to (0 = overhead).
- Job Name
- Job name; the default grouping's outer level (blank = overhead, shown as (none)).
- Vendor
- Vendor number.
- Vendor Name
- Vendor name; the default grouping's inner level.
- Record#
- Sage's invoice record number.
- Invoice#
- The vendor's invoice number.
- Invoice Date
- Invoice date.
- Due Date
- Due date.
- Status
- Open, Review or Dispute.
- Description
- Invoice description.
- Invoice Total
- Original invoice amount.
- Balance
- What's still owed, retention included.
- Retention
- Retention still held on the invoice.
- Net Due
- Balance not held as retention.
- Discount Available
- Early-payment discount still available on the invoice.
- Discount Date
- Last day to take the discount.
- Set to Pay
- Amount approved to pay in the next check run (it may include released retention).
- Balance After
- What will still be owed after the set-to-pay amount is paid.
- 2nd Payee
- Joint-check payee: the invoice's 2nd Payee, else the first second-payee line.
- 2nd Payee To Pay
- Amount set to pay to the second payees (joint check).
- Warning
- Reasons to hold the payment; blank when none.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Show all open invoices
- Job
- Vendor
- Certificates expired by
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Only invoices with an amount set to pay, unless 'Show all open invoices' is on.
- Warnings flag disputed invoices, expired stop-pay certificates and subcontracts on hold before the checks are printed.
- With 'Show all open invoices' on, the Balance total equals the AP Invoice Aging balance.
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