Overview
The AR Reconciliation report template is used to create custom reports that reconcile accounts receivable (AR) transactions between ServiceTitan and your accounting system. You run the report as of a specific date and filter it by transaction status, then compare the results to your accounting system's AR aging report. If your account uses Accounting Periods, you can also add the Post Date column to see which accounting period each transaction posted to.
Who uses this feature
Administrators and accountants
Applies to all business types
Applies to all trades
Feature configuration
The ability to create custom reports depends on the ServiceTitan package your company is subscribed to. If you don't have the option to create a custom report, it may not be included in your package. Contact Technical Support for details.
The ability to create custom reports is dependent on your ServiceTitan Package. For custom reports access, please contact your Customer Success Manager.
The Post Date column is available only if your account uses Accounting Periods. For more, see Use Accounting Periods.
Things to know
If you’re unsure which columns you want to include in your report, use the Reporting Dictionary to search for appropriate data fields.
You can use this template to create as many custom reports as you need. Each report created from the template is independent and can be run or scheduled without needing to recreate it from the original template.
The AR Reconciliation report template isn't the same as the AR Balance Reconciliation report.
Transactions entered directly in your accounting system don't appear on this report. When you compare the report to your accounting system, use the same date in both.
Export the report to reconcile it with your accounting system.
Post Date is the date a transaction posted to its accounting period. It isn't the same as the Transaction Date or the Invoice Date.
If Accounting Periods is turned off for your account, the Post Date column doesn't appear in the report or in the column list.
If your company uses a version of the AR Reconciliation report built specifically for your account, the Post Date column isn't added to it automatically. Contact Technical Support to have it added.
Top report use cases and best practices
Role | Use case | Best practice | Data fields involved |
|---|---|---|---|
Accountant | Tie out AR at month-end against your accounting system, by posting period. | Compare by post date: Run the report as of month-end and compare it to your accounting system's AR aging report, matching transactions by post date. | Post Date · Transaction Date · Balance |
Accountant | Find transactions that posted to a different period than their transaction date. | Sort by Post Date: Add the Post Date column, then sort by it to spot transactions whose post date and transaction date fall in different periods. | Post Date · Transaction Date · Invoice Date |
Accountant | Keep the reconciliation in one spreadsheet. | Export with Post Date: Export the report with the Post Date column included, so you don't need to run a second report. | Post Date · Balance · Reference Number |
Create an AR Reconciliation report
Follow the steps to create a custom report based on the AR Reconciliation template and select the columns to include in your report. To find the template, click All or Others on the Report Builder screen. You only need to create the report once. After it's created, you can share it with others who may need to access the information in the report, edit report columns, and more.
Report data fields
This template groups its columns into the AR Basics and Additional Fields sections.
The template has the following columns selected by default:
Filter Status
Customer Name
Customer Type
Transaction Type
Invoice Or Payment Type
Transaction Date
Reference Number
Balance
Invoice Date
Invoice Due Date
You can customize the report by selecting additional columns:
CustomerId
InvoiceId
TransactionId
Invoice Number
Invoice Business Unit
JobId
Job Number
Job Business Unit
Is Membership
Number Of Days Outstanding
Post Date: The date the transaction posted to its accounting period. Available only if your account uses Accounting Periods. This column is not selected by default. It appears next to the Transaction Date column, and you can show, hide, reorder, and sort it like the other date columns.
Tip: Hover over the name of a column to see a short description. For detailed descriptions of the data fields, see the Reporting Dictionary.
Report filters
Both filters are required before you run the report.
Click the As Of Date field and select the date you want to report on. To match your accounting system, use the same date there.
Click the Status dropdown to filter the report by transaction status. By default, Exported is selected. You can select:
Exported: Exported transactions only
Posted and Exported: Posted and exported transactions
Pending, Posted and Exported: All pending, posted, and exported transactions
When you're finished setting filters, click Run Report.
Tip: Click Edit Report to add and remove columns from the report. For further customization, you can also arrange report columns and apply filters to columns.