Workflow · Reconcile · Opening soon

Revenue reconciliation: billing vs GL

Compare invoiced revenue to revenue posted in the GL by month. Use invoice created date for the month and subtotal before tax for billing revenue.

Book a demo

Someone typed

“each month compare invoiced revenue from billing to revenue posted in the GL by month and show the gap”

The agent read it as

Each month compare invoiced revenue from Stripe invoices to revenue posted in QuickBooks general ledger by month and show the gap, using the invoice created date to define the month and using subtotal before tax for billing revenue.

What the agent built

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

File

Stripe invoices

CSV export · 18 rows

File

QuickBooks general ledger

CSV export · 19 rows

Step

Total invoiced revenue by month

Step 1

Step

Total GL revenue by month

Step 2

Join

Bring in invoiced revenue

6 of 6 paired

Step

Show monthly revenue gap

Step 4

Result

Monthly Revenue Gap

6 rows

Schedule

Runs when you say

Proposed

File
Stripe invoices
CSV export · 18 rows
File
QuickBooks general ledger
CSV export · 19 rows
Step
Total invoiced revenue by month
Step 1
Step
Total GL revenue by month
Step 2
Join
Bring in invoiced revenue
6 of 6 paired
Step
Show monthly revenue gap
Step 4
Result
Monthly Revenue Gap
6 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 6 rows came out, and the join paired 6 of 6 rows.

Download Stripe invoices sample (18 rows)Stripe: Invoicing > Invoices > Export
Download QuickBooks general ledger sample (19 rows)QuickBooks: Reports > General Ledger > Customize > Export to Excel

What you get back

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

Monthly Revenue GapSample data6 rows

Month	Invoiced revenue (USD)	GL revenue (USD)	Gap (GL minus invoiced) (USD)
2026-06-01	3,950	3,950	0
2026-07-01	6,100	6,100	0
2026-08-01	5,300	3,800	-1,500
2026-09-01	6,400	7,200	800
2026-10-01	6,700	6,200	-500
2026-11-01	6,700	6,700	0

6 rows in the result. Sample data: illustrative figures, not business results.

How do you reconcile revenue by month?

Export invoices from Stripe and the GL report from QuickBooks, then load both files into the workflow. It groups invoiced revenue by invoice created date, uses subtotal before tax, groups GL revenue by month, and shows the monthly gap. You can review where billing and the GL do not match.

How it works

How to use the Monthly Revenue Gap 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.

Monthly Revenue Gap: questions

What export should you use from each tool?

Use a file export from your billing system for invoices, and a month-based revenue export from your GL. The workflow needs the rows and columns that contain dates, amounts, and any fields used to group the data.

What happens to rows that do not match the rules?

Rows that do not match the setup are left out of the grouped result or shown separately, depending on the step. You can review them and decide whether to change the rules or clean the source file.

How do you change the matching rules?

Edit the steps in words, for example, change the date field used for month grouping, the amount field used for revenue, or the columns used to match rows. Then run the workflow again on the exported files.