Accounting Detail Legacy Report

  • Updated on Mar 27, 2026
  • Published on Feb 19, 2026
  • 2 minute(s) read
Prev Next

Overview

This report provides summary of transaction balances on all your General Ledger Accounts.

Common uses for this report

  • Use this report to see a detailed breakdown of credit and debit transactions in your General Ledger accounts.

How to find this report

  1. Click Reports in the main navigation menu.

  2. On the Reports screen that opens, click Legacy Reports.

  3. In the Search field, search for Accounting Detail.

  4. Click the report name. Then you will be able to set filters and run the report.

Search bar for locating the Accounting Detail Report in a user interface.

Report filters

Filter options for business unit and date range in a user interface.

Business Unit

Filter by business unit. This report can be run by a single business unit or all business units.

Dropdown menu for selecting business units, currently set to 'All'.

Status

Filter by status. This report can be run by posted, exported, or all invoices.

Dropdown menu showing status options, currently set to 'Posted'.

Date range

Filter by date range. Use the From and To fields to set a custom date range.

Dropdown menu for selecting business units, currently set to 'All'.

View or download the report

Click Update to view the report.

Button labeled 'Update' for submitting changes or updates in a user interface.

The report can be downloaded in three different formats:

  • Export to Excel (.xlsx) (click the dropdown arrow next to Download PDF)

  • Export to Comma separated (.csv) (click the dropdown arrow next to Download PDF)

  • Export to Excel (Allow Long-Running) (click the dropdown arrow next to Download PDF)

Options to export data in various formats including Excel and CSV.

Explanation of report columns

The report includes the following columns:

Cash Receipts

Cash receipts summary showing payment accounts, quantities, debits, and credits for transactions.

Payment Account

There are two details you can see in this column for the Payment Account:                

  • The payment type, such as cash, credit card, or GreenSky® Financing.

  • The QuickBooks account number the transaction is tied to.

Qty  

The amount of payments made under a certain payments type. For example, in the image above there are 2 cash transactions                  

Debits

Positive payments amounts.

Credits

Negative payments amounts, such as refunds, or payment corrections.

Date

The date the transaction occurred on.

Income

Customer Type

The type of customer:

  • Residential

  • Commercial

Account

The General Ledger  account tied to the task.

Qty

The number  of payments made by a specific customer type.

Debits

Negative task amounts. Debits would reduce your income.  Negative tasks are created when an invoice total is greater than what it was supposed to be and now needs to be reduced.

Credits

Positive task amounts. Credits would increase your income. Positive tasks are created when you income accounts receive credit.

Date

The Invoiced On date of the invoice where the transaction occurred.

Net Change in A/R

Account

There are two account types:                      

  • Account Receivable Payments - Payments that exist but the invoices  are not within the report’s date range.

  • Account Receivable Invoices - Payments for invoices which  have not been made, are in a pending status, or do not fall within the report’s date range

Qty

The amount of payments made by a specific account.

Debits

Positive invoice items or payments

Credits

Negative invoice items or payments.

Date

The date the transaction occurred on.

Related articles