Intacct Transaction Reconciliation Report - Payments

  • Updated on Apr 25, 2026
  • Published on Feb 27, 2026
  • 2 minute(s) read
Prev Next

Overview

Run the Intacct Transaction Reconciliation Report - Payments report to see a detailed list of your payment reconciliation results.

Who uses this feature

  • Administrators, office employees, managers, accountants, and bookkeepers

  • Applies to all business types

  • Applies to all trades

Feature configuration

  • Account configuration is required to use this feature. Please contact Technical Support for details.

Run report

  1. Go to the navigation bar and click Reports.

  2. From the side menu, click All Reports.

  3. Search for Intacct Transaction Reconciliation Report - Payments.

  4. Click Intacct Transaction Reconciliation Report - Payments.

  5. Set the filters and click Run to view the report:

    1. Use the From and To calendar fields to set a date range for invoice transactions that show on the report.

    2. Select Show Reconciled Payments to run the report with both payment transactions that match and do not match with the corresponding record in Intacct.

Read report results

Your report results display in an easy-to-read table based on the filters you set. By default, the Intacct Transaction Reconciliation Report - Payments report includes the following columns:

  • Payment ID: Unique payment ID in ServiceTitan

  • Paid On Date: Date payment is made on in ServiceTitan

  • Amount (ST): Payment amount in ServiceTitan

  • Document Number: The remote key number of the record in Intacct. This ID is unique to Intacct and not visible through the Intacct interface.

  • Payment Date (Intacct): Date payment is made on in Intacct

  • Amount (Intacct): Payment amount in Intacct

  • State: Result of the reconciliation:

    • Exception: No match found

    • No Exception: Match found

Payment records showing amounts, dates, and exceptions for invoices in ServiceTitan and Intacct.

Sort and filter report results

  1. Click a column name to sort your report by that column. For example, clicking the Amount (ST) column sorts the report from least to the greatest amount. An arrow displays next to the sorted column name.
     Table displaying payment IDs, dates, and amounts with sorting arrow on the amount column.

  2. Click Filter next to a column name to apply a filter to that column.Tip: Use the And/Or dropdown to apply multiple filters to a column.
     A filter menu for payment data with options for date and amount selection.

  3. When you’re done, click Filter.

  4. To save your sorting preferences and filters, click Save Changes.

For more on filtering, see Filter a report.

Customize report columns

If you want to report on other Intacct Transaction Reconciliation - Payments data, add columns to your report. You can also remove columns and change how they are arranged.

Add and remove columns

  1. Above the report results, click Edit Columns.


    User interface showing options to save changes and edit columns in a table.

  2. On the Edit Columns screen that opens, select or deselect the items you want to add or remove from your report.
     User selects columns to include in a report, highlighting 'Paid On Date'.

  3. When you’re done selecting columns, click Apply. Click Run Report to view the revised report.

Change column arrangement

  1. You can arrange columns with just a few clicks:

    1. Drag a column header to change its order in your report.


      GIF of columns being rearranged in a table

    2. Drag the right edge of a column header to change the column width.

  2. When you’re done, click Save Changes.

  3. Click Run Report to view the report with your column changes.

Want to learn more?

Related articles