Transactions Reconciliation Report - QBDLast updated on 02/22/2023
Run the Transactions Reconciliation Report - QBD to match transactions and compare totals between ServiceTitan and QuickBooks Desktop. Review the transactions in the report to ensure that they are accurately recorded in both systems.
Run report
Before running your report, set filters to get the most relevant information for your needs:
Go to the navigation bar and click Reports.
In the side menu, click All Reports.
Click Transaction Reconciliation report - QBD. Tip: In the search field, enter a few letters from the report title for quick access.
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.
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.
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.
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.
When you’re done setting your filter, click Run Report.
Read report results
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
Customize and schedule your report
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.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.
Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.