Cash & General Ledger · Included in Twinn Reports
General Journal for Sage 100 Contractor
Posted GL transactions with all their lines and debit/credit totals, filtered by year, periods, source, date and account.
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.
- Transaction
- Group heading: record#, date, source, transaction# and description (VOID when voided).
- Record#
- Sage's GL transaction record number.
- Trans#
- Transaction number (check#, invoice#, deposit#…).
- Date
- Transaction date.
- Period
- Posting period.
- Source
- Where it was posted from (GL Check, Journal, AP Invoice, Payroll…).
- Status
- Open, Cleared (reconciled) or Void.
- Payee
- Who was paid or who paid.
- Line#
- Line number within the transaction.
- Account
- GL account of the line.
- Account Name
- Account name.
- Subaccount
- Subaccount or department number, if any.
- Subaccount Name
- Department name for department accounts, otherwise the subaccount name.
- Description
- The line's description, or the transaction's when the line has none.
- Debit
- Debit amount (blank when zero).
- Credit
- Credit amount (blank when zero).
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Posting year
- Period from
- Period to
- Source
- Date from
- Date to
- Transactions touching account
- Sort by
- Include voided transactions
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- One group per transaction, with its debit and credit totals. Debits always equal credits within a transaction.
- The Account filter picks transactions that touch that account, and still shows all of their lines.
- Payee is the transaction's payee, or else the vendor, employee or client of the invoice or receipt it came from.
- Voided transactions are left out unless you include them. A large company can post more lines in one period than the row limit: filter by source or date if the report says it was cut off.
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 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.
Income Statement
Income and expenses by account type for the selected periods and year to date, with budget.
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