--- title: "Transactions Reconciliation Report - QBD" slug: "transactions-reconciliation-report-qbd" updated: 2026-10-15T01:19:00Z published: 2026-10-15T01:19:00Z canonical: "help.servicetitan.com/transactions-reconciliation-report-qbd" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # Transactions Reconciliation Report - QBD ## Overview ## 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. --- ### #### 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](http://go.servicetitan.com/ask) for details. ## Run report 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] > **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] > **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] > **Note:** If you don’t select specific transaction types, by default, the report shows all transaction types. ![Dropdown menu showing transaction types: Invoice, Payment, Return, and Bill options.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/transactions-reconciliation-report---qbd-image-m3m8v4dp.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A36%3A50Z&se=2026-10-31T02%3A36%3A50Z&sr=c&sp=r&sig=T9rUD2LIV1k35B4oJg1%2BdBiBtWf%2Fh%2FBDpJdIbMmAJGY%3D) 6. Click the **Business Unit** dropdown and select which business units you want the report to show. > [!NOTE] > **Note:** If you don’t select specific business units, by default, the report shows all business units. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/transactions-reconciliation-report---qbd-image-5rypsukf.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A36%3A50Z&se=2026-10-31T02%3A36%3A50Z&sr=c&sp=r&sig=T9rUD2LIV1k35B4oJg1%2BdBiBtWf%2Fh%2FBDpJdIbMmAJGY%3D) 7. Click the **Connection** dropdown and select your online connection which is linked to your QuickBooks Desktop file. > [!NOTE] > **Note:** The connection you choose determines the computer where the ServiceTitan Web Connector is running. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/transactions-reconciliation-report---qbd-image-c7wp8keo.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A36%3A50Z&se=2026-10-31T02%3A36%3A50Z&sr=c&sp=r&sig=T9rUD2LIV1k35B4oJg1%2BdBiBtWf%2Fh%2FBDpJdIbMmAJGY%3D) 8. 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] > **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] > **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](/construction/docs/edit-custom-reports) to narrow the focus of your report. You can also [schedule the report](/construction/docs/schedule-reports) to be sent by email on a regular basis. ## Want to learn more? - See [Run, filter, and export reports](/construction/docs/run-filter-and-export-reports) A batch, or invoice batch, is a set of invoices that have been audited and are ready to post. You will use the Invoice screen in ServiceTitan to create invoice batches. On the Invoice screen, you'll have access to unbatched and batched invoices. [Learn more →](https://help.servicetitan.com/docs/servicetitan-glossary) · [See the full glossary →](https://help.servicetitan.com/docs/glossary-overview)