Create Custom Transaction Detail Reports in QuickBooks® Desktop

Background

Compare QuickBooks Desktop job costs with Procore budget values to isolate and resolve accounting discrepancies across platforms. Running this report provides detailed item-level visibility into costs and invoiced commitments. Use this data to ensure cost synchronization between both systems.

Things to Consider

  • Required User Permissions:

    • You must have the appropriate access permissions in QuickBooks® Desktop to run custom financial reports.

  • Additional Information:

    • Selecting improper transaction types or service items will result in mismatched budget figures. Ensure you select All Services and include all relevant transaction types when matching invoiced commitments.

Steps

  1. Navigate to Reports in QuickBooks® Desktop.

  2. Click Custom Reports.

  3. Select Transaction Detail.

  4. Change Dates dropdown option to ‘All’.

  5. Click the Display tab to modify the report columns, and select the following options:

    • Type

    • Item

    • Date

    • Source Name

    • Memo (Optional)

    • Amount

      QuickBooks Modify Report screen showing Display tab with date range, report basis, and columns settings highlighted.

  6. Select Item Detail from the Total by drop-down menu to sort and summarize costs by item.

  7. Click the Filters tab and configure the following filters:

    1. a. Select Name and choose the job name you want to report on.

    2. Select Item and choose All Services.

    3. Select Account and choose the account(s) used for your service items (Optional).

  8. Review the Amount total to ensure it matches the Job to Date Costs on the synced Procore Budget.

    Procore Sample Company Custom Transaction Detail Report showing all transactions with columns for Type, Date, Source Name, Memo, and Amount.

  9. To filter the above report to show Commitments Invoiced amounts, return to the Filters tab and add the following filters:

    Modify Report dialog showing Filters tab with Account filter selected and Current Filter Choices panel highlighted on the right.

    1. Select Received and set the value to Yes.

    2. Select Name and choose the relevant job name.

    3. Select Transaction Type.

    4. Click Multiple Transaction Types, and mark the checkboxes for the following items:

      • Check

      • Credit Card

      • Bill

      • CCard Credit

      • Bill Credit

      • Bill CCard

      • Paycheck

    5. Verify the Amount column to confirm the total matches your Commitments Invoiced amount in Procore.

See Also

Loading related articles...