Cash & General Ledger · Included in Twinn Reports

Income Statement by Department for Sage 100 Contractor

Income statement with a column for each department next to the consolidated total, over a period range that can span years.

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.

Account: GL account number (blank on headers and totals).
Description: Account name, or the section / total name.

Criteria you can set

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

From year
From period
To year
To period
Department (blank = compare all)
Skip $0 accounts

How it’s calculated

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

Consolidated comes from every posted line on the income and expense accounts. Department columns come from the posted lines' departments, for accounts set up with departments.
No Department = Consolidated minus the department columns, i.e. accounts not set up for departments. It's only shown when non-zero.
Pick a department to get the 'Department Specific' view: that department only, with each line as a % of the department's operating income.
Department numbers used in the ledger but missing from the department list are still shown, labelled '(not in department list)'.
Sections follow Sage's standard account types. Tie out Consolidated to Sage's Income Statement.

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