Accounts Receivable · Included in Twinn Reports
AR Invoice List for Sage 100 Contractor
Receivable invoices with total, sales tax, paid, retention and balance, and each invoice's receipts (date and check number).
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.
- Record#
- Sage's internal invoice record number.
- Invoice#
- Invoice number.
- Client
- Client number of the invoice's job.
- Client Name
- Client name.
- Job
- Job number.
- Job Name
- Job name.
- Salesperson
- The job's salesperson (last name, first name).
- Invoice Date
- Invoice date.
- Due Date
- Due date.
- Description
- Invoice description.
- Status
- Invoice status.
- Year
- Posting year.
- Period
- Posting period.
- Invoice Total
- Invoice amount, retention and sales tax included. First row of the invoice only.
- Sales Tax
- Sales tax billed on the invoice.
- Paid
- Cash received on the invoice.
- Disc/Credit
- Discounts and credits taken on the invoice.
- Retention
- Retention still held on the invoice (0 once paid).
- Balance
- Still owed, retention included. A void invoice keeps its balance in Sage; exclude Void (the default) when totalling.
- Net Due
- Still owed, not counting retention.
- Receipt Date
- Summary: the last receipt's date. One row per receipt: that receipt's date.
- Trans#
- The receipt's Trans# (normally the client's check number). Summary: every receipt's Trans#, oldest first.
- Receipt Amount
- Summary: total of the receipts shown. One row per receipt: that receipt's amount (discounts and credits are in Disc/Credit).
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Client
- Job
- Salesperson (job)
- Status
- Invoice date from
- Invoice date to
- Due date from
- Due date to
- Posting year
- Period from
- Period to
- Receipts
- Receipt date from
- Receipt date to
- Receipt Trans# (check#)
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Receipts = One row per receipt lists every receipt with its date and check (Trans#) number; the invoice amounts print on its first row only, so totals don't double.
- Receipt date and Trans# criteria keep only invoices with a matching receipt (Sage's 'AR Paid With Check Number').
- Group by: client (default), client then job, job, status, posting year then period, or the job's salesperson.
More Accounts Receivable reports
AR Invoice Aging
Open receivables by client and job, aged into Current / 1-30 / 31-60 / 61-90 / Over 90 days.
AR Aging by Job
Open receivables aged into Current / 1-30 / 31-60 / 61-90 / Over 90, by job and optionally by phase, as invoices or job totals.
AR Collection Call Sheet
Past-due receivables by client and job, with the client's contact and phone, the invoice detail and the job notes, for collection calls.
Client Statement
Statement of account per client: every open contract and service invoice, with aging totals per client.
Retention Receivable and Payable by Job
Per job: retention still held by the client on open AR invoices, retention we still hold on open AP (subcontractor) invoices, and the net.
Taxable and Non-taxable Billings by Tax District
AR billings for a period split into taxable, non-taxable and sales tax, by tax district, job city or the job's User Def1 (municipality).
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