Accounts Receivable Detail by Date ReportLast updated on 03/22/2022
Purpose of the Accounts Receivable Detail by Date Report:
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:
Click Reports > Search Accounts Receivable Detail by Date > Click the report name. Then you will be able to set filters and run the report.
Filter by business unit. This report can be run by a single business unit or all business units.
Filter by invoice status: Posted & Exported, Exported, or All.
Note: Select All to include pending invoices.
Filter by date.
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.
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)
Explanation of report columns
The report includes the following columns:
Business unit under which the job was performed.
How to configure - Business unit for a job: 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.
How to configure - Create invoice type: To create or edit an invoice type, navigate to Settings > Payment and Invoice Types.
How to configure - 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.
The Bill To customer name on the invoice.
The Bill To customer phone number.
(Report columns continued)
The Service Location customer name on the invoice (this is the name entered on the location record).
City, Street, Zip
The Service Location address.
Invoice total, including tax.
Remaining balance on the invoice, including tax.
Explanation of report totals:
Total is calculated by taking the sum of the entire column.
Total Balance is calculated by taking the sum of the entire column.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.