AR Reconciliation report template

Prev Next

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.

  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: 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.

Want to learn more?