Accounts Payable · Included in Twinn Reports
Use Tax Accrual for Sage 100 Contractor
AP invoices with use tax, by use tax district and posting period, with the taxable base, rate and tax to remit.
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.
- District
- Use tax district number and name; the report is grouped by it.
- Year
- Posting year of the invoice.
- Period
- Posting period (1-12) of the invoice.
- Record#
- Sage's invoice record number.
- Invoice#
- Vendor's invoice number.
- Invoice Date
- Invoice date.
- Vendor
- Vendor number.
- Vendor Name
- Vendor name.
- Job
- Job the invoice is charged to.
- Description
- Invoice description.
- Status
- Invoice status (void invoices are excluded).
- Invoice Total
- Invoice total (use tax isn't part of it: the vendor didn't charge it).
- Freight
- Freight on the invoice (not taxed).
- Taxable Base
- Amount the use tax is calculated on.
- Rate %
- Use tax rate applied.
- District Rate %
- The district's total rate today (it may have changed since the invoice).
- Use Tax
- Use tax owed on the invoice.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Posting year
- Period from
- Period to
- Use tax district
- Vendor
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Grouped by use tax district: each district's Use Tax subtotal is what to remit for the period.
- Period = the invoice's posting year and period. Void invoices are left out.
- The Use Tax total equals the credits to the 'Use Tax' AP account from AP invoices for the same periods.
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