Accounts Receivable · Included in Twinn Reports

Client Statement for Sage 100 Contractor

Statement of account per client: every open contract and service invoice, with aging totals per client.

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.

See it on your own data All 44 reports

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 works

What’s in the report

Every column, and what it means.

Statement For: The client the section belongs to, with billing address and phone; printed as the section heading.
Client: Client number: the job's client for contract invoices, the invoice's client for service invoices.
Client Name: Client name.
Source: Contract (AR invoice) or Service (service invoice).
Job: Job the invoice was billed on (service invoices only when they have a job).
Job Name: Job name; for a service invoice without a job, its service order number.
Invoice#: Invoice number.
Invoice Date: Invoice date.
Due Date: Due date.
Description: Invoice description.
Client PO#: The client's purchase order number on the invoice.
Days: Days past due on the statement date; zero or negative = not yet due.
Invoice Total: Original invoice amount, retention and sales tax included.
Paid: Received so far, discounts and credits included.
Retention: Retention still held (contract invoices only). Not aged.
Balance: What the client still owes on the invoice, retention included.
Current: Net due that isn't past due yet.
1-30: Net due 1 to 30 days past due.
31-60: Net due 31 to 60 days past due.
61-90: Net due 61 to 90 days past due.
Over 90: Net due more than 90 days past due.

Criteria you can set

Pick these before you run it. Twinn remembers your last run.

Statement date
Client
Client type
Include service invoices

How it’s calculated

The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.

One section per client, headed with the client's billing address and phone; the section subtotal is the client's aging.
Include service invoices = Sage's Combined Statements (contract receivables plus service receivables).
Balances are current balances. The statement date only sets the age.

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.

AR Invoice List

Receivable invoices with total, sales tax, paid, retention and balance, and each invoice's receipts (date and check number).

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