Transactions Reconciliation Report - QBDLast updated on 02/22/2023

Before running your report, set filters to get the most relevant information for your needs:

1. Go to the navigation bar and click Reports.

2. In the side menu, click All Reports.

3. Click Transaction Reconciliation report - QBD. Tip: In the search field, enter a few letters from the report title for quick access.

4. Use the From and To calendar fields to set a range of dates to run the report on. Note: The date range can only be within 31 days so you can efficiently review your transactions.

5. Click the Transactions Type dropdown and select which transaction types you want the report to show. Note: If you don’t select specific transaction types, by default, the report shows all transaction types.

6. Click the Business Unit dropdown and select which business units you want the report to show. Note: If you don’t select specific business units, by default, the report shows all business units.

7. Click the Connection dropdown and select your online connection which is linked to your QuickBooks Desktop file. Note: The connection you choose determines the computer where the ServiceTitan Web Connector is running.

8. When you’re done setting your filter, click Run Report.

Your report results display in a table based on the filters you set. The report only displays batched transactions. By default, the Transactions Reconciliation Report - QBD includes the following columns:

• Id (ST)—Transaction record ID in ServiceTitan

• Number (ST)—Transaction number in ServiceTitan

• Transaction Date (ST)—Date the transaction is recorded in ServiceTitan

• Business Unit (ST)—Business unit (BU) the transaction is assigned to in ServiceTitan

• Batch Name (ST)—Batch the transaction is assigned to when exported Note: The batch ID and name are in the Memo field in QuickBooks Desktop.

• Name (ST)—Customer or vendor name in ServiceTitan

• Total (ST)—Net total of the transactions in ServiceTitan Tip: Compare this value with the Total value in QuickBooks Desktop to ensure transactions match.

• Job Number (ST)—If the transaction is associated with a job, the job number from the job record in ServiceTitan

• Project Number (ST)—If the transaction is associated with a project, the project number from the project record in ServiceTitan

• Transaction Type (ST)—Transaction type can be an Invoice, Payment, Bill, or Return in ServiceTitan

• Export Status (ST)— Status of the transaction can be Pending, Posted, Exported or Bypassed

• Reference Number—Transaction number in QuickBooks Desktop

• Transaction Date—Date the transaction is recorded in QuickBooks Desktop

• Class—BU the transaction is assigned to in QuickBooks Desktop

• Name—Customer or vendor name in QuickBooks Desktop

• Total—Net total of the transaction in QuickBooks Desktop

• Reconciliation Status—Identifies if the transaction matches between ServiceTitan and QuickBooks Desktop.

  • Exists: Match—Transaction exists in ServiceTitan and QuickBooks Desktop with a matching Total.

  • Exists: Variance—Transaction exists in ServiceTitan and QuickBooks Desktop but with a different Total value.

  • Missing: ST—Transaction exists in QuickBooks Desktop but no match is found in ServiceTitan.

  • Missing: QBD—Transaction exists in ServiceTitan but no match is found in QuickBooks Desktop.

  • Exception—Transaction has a match between ServiceTitan and QuickBooks Desktop Id and Reference Number but the Id and Reference Number appear on other transactions within the date range of the report.

• Message—Additional details about the reconciliation status

You can arrange and filter your results to narrow the focus of your report.

You can also schedule the report to be sent by email on a regular basis.

See Export a report