Service Titan Knowledge Base

Intacct Transaction Reconciliation Report - PaymentsLast updated on 03/22/2022

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


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:

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

    • Show Reconciled Payments— Select this option 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


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.

  2. Click the Filter icon 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.

  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.

    The Edit Columns screen opens.

  2. Select or deselect the items you want to add or remove from your report.

  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:

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

    • 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?



Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.