Skip to main content

Exporting Invoices and Transactions (Reports)

In this article, I’ll walk you through how to export Invoices and Transactions from Allison, what each report includes.

B
Written by Blake Wood

These reports are especially useful for bookkeeping, accounting, and uploading data into tools like Google Sheets, Excel, or QuickBooks.

Where to Find the Reports

  1. Log into Allison

  2. Go to Reports

  3. 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:

  1. All assigned cleaners clock out, or

  2. 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

  1. Go to Reports → Invoices

  2. Click Run Report

  3. Select the date range you want

    • Example: November 1 through November 30

  4. Click Calculate

  5. Review the list of generated invoices

  6. Click Export

  7. 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

  1. Go to Reports → Transactions

  2. Click Run Report

  3. Select your desired date range

  4. Click Calculate

  5. Review the list of transactions and linked invoices

  6. Click Export

  7. 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

Did this answer your question?