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.
Go to the navigation bar and click Reports.
From the side menu, click All Reports.
Search for Intacct Transaction Reconciliation Report - Payments.
Click Intacct Transaction Reconciliation Report - Payments.
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
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.
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.
When you’re done, click Filter.
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
Above the report results, click Edit Columns.
The Edit Columns screen opens.
Select or deselect the items you want to add or remove from your report.
When you’re done selecting columns, click Apply. Click Run Report to view the revised report.
Change column arrangement
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.
When you’re done, click Save Changes.
Click Run Report to view the report with your column changes.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.