--- title: "Accounts Receivable Detail by Date Legacy Report" slug: "accounts-receivable-detail-by-date-report-1" updated: 2026-03-27T20:54:04Z published: 2026-03-27T20:54:04Z --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # Accounts Receivable Detail by Date Legacy Report ## Overview This report provides a detailed list of invoices that have an outstanding balance. This report includes all invoices with an outstanding balance (completed jobs only), up to a specific date Common uses for this report - Use this report to view invoice number, service location details, invoice total, and remaining balance. Data is based on invoice dates. ## 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 Accounts Receivable Detail by Date. 4. Click the report name. Then you will be able to set filters and run the report. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-l1xcxfzv.png) ## Report filters ![User interface displaying filters for business unit, status, and date selection options.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-rq52hy8g.png) ### Business Unit Filter by business unit. This report can be run by a single business unit or all business units. ### Status Filter by invoice status: Posted & Exported, Exported, or All. > [!NOTE] > **Note:** Select **All** to include pending invoices. ### Date Filter by date. ### Ignore Deposits Select to filter out deposits from the report results. ### Include pinned customer notes Select to include any notes that are pinned to the top of a customer record. ## View or download the report Click **Update** to view the report. ![Button labeled 'Update' for submitting changes or updates in a user interface.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-huxazqxg.jpg) 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.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-q57f02eb.png) ## Explanation of report columns ![Invoice details for plumbing and electrical services, including customer information and balances.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-3rd6pvsi.png) The report includes the following columns: | **Column** | **Description** | | --- | --- | | Invoice | Invoice number. This report displays invoices for completed jobs only. If you choose to view customer deposits, you will see deposits for jobs in progress at the bottom of the report. | | Date | Invoice date. This report includes all invoices with an outstanding balance (completed jobs only) whose Invoiced On date is on or before this date. | | Business Unit | Business unit under which the job was performed. When you book a job from the *Calls* screen, you will select a business unit for the job. You may change the business unit by navigating to the job (from the invoice, click on the job number in the upper left corner). Once you are on the job page, click the Edit Pencil next to the job action button, set *Business Unit*, then click Save. | | Type | Invoice type. To create or edit an invoice type, navigate to Settings > Payment and Invoice Types. To set the invoice type on an invoice, click **Update invoice details** from the left menu on the invoice page. Set *Invoice Type*, then click Save. | | Customer | The *Bill To* customer name on the invoice. | | Customer # | The *Bill T*o customer phone number. | | Location | The *Service Location* customer name on the invoice (this is the name entered on the location record). | | City, Street, Zip | The *Service Location* address. | | Total | Invoice total, including tax. If adjustment invoices have been created, invoice total will not include adjustment invoice amounts. The adjustment invoices are listed separately, if they have an outstanding balance and if their Invoiced On date is on or before the date selected in the report | | Balance | Remaining balance on the invoice, including tax. - If adjustment invoices have been created, the balance will include adjustment invoice amounts. - If the balance is a positive amount: The balance is an unpaid amount. - If the balance is a negative amount: The customer has made a deposit, or has a customer credit. | ## Explanation of report totals ![Summary of financial transactions showing total and balance amounts for services rendered.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/accounts-receivable-detail-by-date-report-image-tl1k15am.png) | Total | Total is calculated by taking the sum of the entire column. | | --- | --- | | Total Balance | Total Balance is calculated by taking the sum of the entire column. |