--- title: "AR Reconciliation report template" slug: "ar-reconciliation-report-template-1" tags: ["Area - Accounting", "Area - Reports", "Role - Accountant", "Role - Admin", "Role - Owner Admin", "Focus - Construction", "Focus - Service Replacement", "Type - Commercial", "Type - Residential"] updated: 2026-11-20T17:04:36Z published: 2026-11-20T17:04:36Z canonical: "help.servicetitan.com/ar-reconciliation-report-template-1" --- > ## 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. # AR Reconciliation report template ## 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](http://go.servicetitan.com/ask) for details. - The ability to create custom reports is dependent on your [ServiceTitan Package](https://www.servicetitan.com/pricing). 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](/roofing/docs/use-accounting-periods). ## Things to know - If you’re unsure which columns you want to include in your report, use the [Reporting Dictionary](/v1/docs/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](http://go.servicetitan.com/ask) 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](/roofing/docs/create-custom-reports#create-a-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] > **Tip:** Hover over the name of a column to see a short description. For detailed descriptions of the data fields, see the [Reporting Dictionary](/roofing/docs/learn-about-report-data-fields-in-the-reporting-dictionary-1). ## Report filters Both filters are required before you run the report. 1. 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. 2. 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 3. When you're finished setting filters, click **Run Report**. > [!TIP] > **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](/roofing/docs/run-filter-and-export-reports). ## Want to learn more? - See [Create custom reports](/roofing/docs/create-custom-reports) - See [Edit custom reports](/roofing/docs/edit-custom-reports) - See [Use Accounting Periods](/roofing/docs/use-accounting-periods) - See [Run, filter, and export reports](/roofing/docs/run-filter-and-export-reports) - See [Schedule reports](/roofing/docs/schedule-reports)