These reports are especially useful for bookkeeping, accounting, and uploading data into tools like Google Sheets, Excel, or QuickBooks.
Where to Find the Reports
Log into Allison
Go to Reports
Scroll all the way to the bottom of the page
You’ll see two reports:
Invoices
Transactions
Each report can be run and exported independently.
Invoices Report
The Invoices Report shows every invoice that was billed in Allison during a selected time period.
Important details:
Customers billed after each clean get an invoice when the job is completed.
Customers on a billing schedule get one invoice on their billing date, covering every job completed in that period.
Cancellation fees are billed too.
Invoices not billed yet don't appear.
You cannot manually create an invoice for a job that:
Does not exist, or
Has not been completed
How Jobs Get Completed
A job is considered completed in one of two ways:
All assigned cleaners clock out, or
You manually mark the job as complete
If you believe an invoice is missing, almost every time it’s because the job itself was never completed.
How to Export Invoices
Go to Reports → Invoices
Click Run Report
Select the date range you want
Example: November 1 through November 30
Click Calculate
Review the list of generated invoices
Click Export
Click Download
This will download a CSV file that you can upload into:
Google Sheets
Excel
Accounting or bookkeeping software
What's in the Invoice CSV
One row per invoice, with these columns:
id
number
billed_date
due_date
customer_name
subtotal
tax
total
voided
subtotal_net
tax_net
total_net (after credits and voids)
The tax columns cover the invoice only. If you charge sales tax on card surcharges, use the Transactions Report for that tax, because a surcharge is part of a payment, not an invoice.
Transactions Report
The Transactions Report shows:
All payments and refunds, by payment date, within the selected date range
The associated invoice ID for each payment
Key columns in the CSV:
date_time — the payment date
amount — the full payment; refunds are negative
invoice_revenue — the part of the payment that went toward the invoice, before tax
sales_tax — all sales tax in the payment, including any tax on a card surcharge
surcharge_pre_tax — the card surcharge before tax; $0.00 if there wasn't one
tip — the tip
tip_distributed — how much of the tip went to cleaners
invoice_revenue + sales_tax + surcharge_pre_tax + tip = amount. tip_distributed is part of tip, so don't add it again.
If a surcharge is taxed, surcharge_pre_tax is lower than the surcharge on the customer's receipt. The receipt includes the tax, and here that tax is in sales_tax.
How to Export Transactions
Go to Reports → Transactions
Click Run Report
Select your desired date range
Click Calculate
Review the list of transactions and linked invoices
Click Export
Click Download
Just like the invoice report, this downloads a CSV file you can upload into:
Google Sheets
Excel
QuickBooks or other accounting tools
Common Use Cases
Most customers use these reports to:
Reconcile revenue
Send data to their bookkeeper
Upload invoices and payments into QuickBooks
Analyze monthly or quarterly performance
Quick Troubleshooting
If something looks missing:
Check whether the job was completed
Confirm the date range you selected
Remember that invoices only exist for completed jobs
If the customer is billed on a schedule, the invoice won't appear until their billing date