Accounts Payable · Included in Twinn Reports
Lien Waiver Tracking for Sage 100 Contractor
Before the owner releases payment, the waivers have to be in. This lists what you paid each vendor and subcontractor on each job over a check-date range, with the paid-to-date figure for final waivers, so you know exactly which waivers to collect and for how much.
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 chasing paperwork
- Project managers preparing a pay application
- Controllers protecting the company from liens
The questions it answers
- Which waivers do we need for last month’s checks, and for how much?
- What have we paid this subcontractor on the job to date?
- Which invoices on the job are still unpaid?
Ask Twinn · Early access
“Which lien waivers do we need to collect for checks written last month?”
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 = no job).
- Job Name
- Job name; the outer level of the default grouping.
- Vendor
- Vendor number.
- Vendor Name
- Vendor name; the inner level of the default grouping (one waiver per job and vendor).
- Record#
- Sage's invoice record number.
- Invoice#
- The vendor's invoice number.
- Invoice Date
- Invoice date.
- PO / Subcontract#
- Subcontract the invoice was billed against, else its purchase order. Hidden when 'Show PO / subcontract#' is off.
- Description
- Invoice description.
- Status
- The invoice's current status.
- Invoice Total
- Original invoice amount (repeated on each payment line of the invoice, so it isn't totaled).
- Retention
- Retention still held on the invoice today.
- Balance
- What's still owed on the invoice today.
- Check#
- Check, ACH or transaction number of the payment (blank on unpaid rows).
- Check Date
- Date of the payment.
- Amount Paid
- Cash paid on the invoice by this check: the amount the waiver covers.
- Disc/Credit
- Discount and vendor credit applied with the payment (not cash).
- Job Paid to Date
- Total paid to the vendor on this job with check dates through the end of the range (the same on every row of that job and vendor).
- 2nd Payee
- Joint-check payee on the invoice; that payee may need to sign the waiver too. Hidden when empty on every row.
- Prelien#
- Prelien number from the job's lien tracking for this vendor. Hidden when empty on every row.
- Final Waiver
- Final waiver date (or Yes) when the job's lien tracking says the final waiver was received. Hidden when empty on every row.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Check date from
- Check date to
- Job
- Vendor
- Show PO / subcontract#
- Show unpaid invoices
- Job invoices only
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Grouped by job, then vendor: each vendor subtotal of Amount Paid is the amount that vendor's waiver for the period should cover.
- Job Paid to Date is everything paid to the vendor on the job through the end of the range, for final or cumulative waivers.
- Turn on 'Show unpaid invoices' to add open invoices with no payment in the range.
More Accounts Payable reports
AP Invoice Aging
Open payables by vendor, aged into Current / 1-30 / 31-60 / 61-90 / Over 90 days.
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