Workflow · Finance close · Opening soon

Income statement by department

Turn your QuickBooks general ledger export into a departmental income statement. Group the rows by department class and account, then total each group.

Book a demo

Someone typed

“build an income statement by department from the general ledger with department classes”

The agent read it as

Build an income statement by department from the QuickBooks General Ledger with department classes.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

QuickBooks General Ledger

CSV export · 30 rows

Step

Total by department and account

Step 1

Result

Department Income Statement

17 rows

Schedule

Runs when you say

Proposed

File
QuickBooks General Ledger
CSV export · 30 rows
Step
Total by department and account
Step 1
Result
Department Income Statement
17 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 17 rows came out.

Download QuickBooks General Ledger sample (30 rows)QuickBooks: Reports > General Ledger > Customize (columns: Date, Transaction Type, Num, Name, Memo/Description, Account, Debit, Credit, Class) > Export to Excel

What you get back

The result of that run, the rows to look at first.

Department Income StatementSample data17 rows

Department	Account	Amount
admin	Advertising Expense	1,450
admin	Depreciation Expense	730
admin	Hiring Expense	2,750
admin	Meals Expense	380
admin	Office Expense	420
marketing	Advertising Expense	7,730
marketing	Contract Labor	8,600
ops	Benefits Expense	2,140
ops	Payroll Expense	17,050
ops	Shipping Expense	760
product	Service Revenue	18,000
product	Software Expense	2,100

17 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you build a departmental income statement from a QuickBooks general ledger export?

Export the QuickBooks general ledger with department classes. Then group the rows by department and account, and total each group to build the income statement by department. Rows that do not match a rule stay out of that step until you add a rule for them.

How it works

How to use the Department Income Statement workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Department Income Statement: questions

What export should you use from QuickBooks?

Use a general ledger export that includes the department class field. That gives you the rows and labels needed to group the statement by department.

What happens to rows that do not match a rule?

They do not get grouped by that step. You can leave them out, review them, or add a rule so they match the right department or account.

How do you change the rules in words?

Edit the step rules with plain words, for example, group by department and account, or total revenue and expense lines by department. Then run the file again with the updated rules.