Cash & General Ledger · Included in Twinn Reports
Audit Books for Sage 100 Contractor
Recomputes every stored ledger balance from the live journal lines and lists each one that disagrees, as the accounting system's own audit does.
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.
- check
- Which check found it: account-period-balance, account-ending-balance, subaccount-period-balance, subaccount-ending-balance, subledger-vs-ledger, subaccount-totals, subledger-vs-open-invoices, control-account-totals, trial-balance, or out-of-range-note (a note, not counted).
- account
- GL account number.
- subaccount
- Subaccount (or department) number, on subaccount checks.
- subledger
- job, client or vendor, on checks of a subledger record or its totals; empty on the equipment totals.
- recordNumber
- The job, client or vendor number; on an out-of-range note, the journal's record number.
- fiscalYear
- Posting year, on period checks.
- period
- Posting period, on period checks.
- balanceKind
- starting, beginning or ending: which balance the line compares, when it is not a period's.
- recorded
- The balance the books hold: the line's first amount.
- recomputed
- What it should be, recomputed from the live journal lines (or the open invoices, or the control account): the line's second amount.
- reportLine
- The line as Sage's own audit prints it, numbers only. On the total row, the summary: Audit successful, or N errors detected.
- formatInferred
- True when Sage has never been seen printing that kind of line, so its layout is ours.
- possiblyConcurrent
- True when journals were posted to this account while the audit ran: the finding may be theirs, not a fault in the books.
- concurrentPosts
- On the total row: how many journals were posted while the audit ran (0 when the books held still).
- journalAtStart
- On the total row: the highest journal record number when the audit started.
- journalAtEnd
- On the total row: the highest journal record number when the audit finished.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Internal: run by staff and by the write checks, never listed to customers.
- An empty result with 'Audit successful' means the books are whole. Each other line is one balance that disagrees, in the accounting system's own order and line format.
- Out-of-range notes list live journals outside the audited years; they are not counted as errors.
- When journals are posted during the run, the total row says how many, and each finding on an account they touched is marked possiblyConcurrent.
More Cash & General Ledger reports
Balance Sheet
Assets, liabilities and equity by account type as of a posting year and period, with an optional comparison column.
Cash Receipts
Money received into cash accounts (AR and service receipts, other deposits), by account and date, with who it came from.
Check Register
Checks written from cash accounts, by account and date.
General Journal
Posted GL transactions with all their lines and debit/credit totals, filtered by year, periods, source, date and account.
General Ledger
Beginning balance, every posted line with a running balance, and ending balance per account.
GL Transaction Detail
Every posted line on one account for a posting year and period range, with an optional current-year net profit line.
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