Advanced QuickBooks Online Integration Overview
Managing Bills & Expenses in Buildertrend
Implementing Bills into your QuickBooks Online and Intuit Enterprise Suite workflow will streamline your accounting processes and enhance your financial operations by eliminating duplications and boosting reporting capabilities with detailed insights at the Project & Services level.
The workflows in this article apply to both QuickBooks Online and Intuit Enterprise Suite. If you're using Intuit Enterprise Suite, follow the same processes outlined below.
Which QuickBooks workflows will be effected when implementing Bills?
-
Match Bill to bank transaction instead of creating a new expense
-
Remove bank rules for Cost of Goods Sold accounts to prevent auto-created expenses
-
Pay Bills with checks instead of creating a type check transaction
✏️Note: If you have already created a check in QuickBooks, there are two ways to get this cost into your Buildertrend budget while avoiding duplicated costs.
1. Enable Include costs entered in QuickBooks in the budget under the Advanced Settings section of the Job Details.
2. Create a bill in Buildertrend but DO NOT push it to QuickBooks. Then mark that bill paid with an offline payment.
Bank Feed | Matching Bills & Invoices
When purchasing ad hoc materials or services for a project, matching a Buildertrend Bill to a transaction in your bank feed helps keep both your accounting records and Buildertrend budget in sync.
💡Pro Tip:
Matching Bills in the QuickBooks Bank Feed will be commonly used with the Inbox located on the Bills page.
-
For more information on uploading bills and receipts into Buildertrend, review Bills Overview.
-
For more information on how to push a bill or receipt to QuickBooks, review QuickBooks Online Integration Overview.
This ensures actual costs are accurately reflected in the Job Costing Budget, prevents duplicate entries, and gives your team real-time visibility into project spend.
By maintaining this alignment, you’ll streamline reconciliation and improve financial reporting across both platforms.
‼️ The walkthrough below uses Bills as the example. To match Invoices, follow the same steps, just substitute “Bill” with “Invoice.” ‼️
Create a Bill in Buildertrend. Be sure to push the Bill over to QuickBooks.
In QuickBooks, go to Bank transactions.
-
If there is a transaction of the exact same amount, QuickBooks will suggest a match for the unpaid Bill.
-
Click Match to create a Bill payment.
✏️Note: Results may populate multiple matches. Select the correct option and click Match.
Once the Bill payment has been created, both Bills will be marked as paid.
Having trouble finding a match?
If QuickBooks doesn’t automatically suggest matches, often due to discrepancies in the vendor, invoice date, or total, you can manually search for a match.
Go to Bank Transactions in QuickBooks. Select the transaction you want to match, then select Match.
From the Find other matches popup window, utilize the filters to locate the Bill you wish to match to the transaction.
Sending Bill Payments to QuickBooks Online
This section walks you through how to configure Buildertrend to push Bill Payments to QuickBooks Online. Once a bank account in Buildertrend is linked to the correct General Ledger account in QuickBooks, Bill Payments will automatically sync to QuickBooks, provided the associated Bill has already been pushed to QuickBooks. An additional step is required in QBO: the bank transaction that comes in through your bank feed must be matched to the Bill Payment created in Buildertrend.
✏️ Note: You must be an Organization Owner or Trusted Payment User in Buildertrend to complete the setup steps below.
Part 1: Buildertrend Setup
Complete the following steps in Buildertrend to link your bank account to the correct QuickBooks General Ledger account.
- Navigate to Company Settings → Online Payments → Bill Pay.
- Select the Bill Pay tab.
- In the Bank account section, click the Pencil icon.
- Click the Link to QuickBooks dropdown.
- Select the General Ledger account that matches your bank account in QuickBooks Desktop. *Note: The General Ledger account selected here must match the bank account in QuickBooks Online that you use to issue payments. If you are unsure which account to select, check with your accountant or QuickBooks administrator.
- Click Save.
Part 2: How Bill Payments Sync to QuickBooks Online
Requirements for Automatic Sync
- The bill in Buildertrend has already been pushed to QuickBooks Online.
- The bank account in Buildertrend is linked to the correct GL account in QuickBooks (as set up in Part 1).
- The payment is submitted through Buildertrend's Bill Pay feature.
What Gets Created in QuickBooks Online
When a Bill Payment syncs from Buildertrend, a Bill Payment record is created in QuickBooks Online and attached to the correct Bill. The bank transaction that comes in through your bank feed will then need to be matched to this Bill Payment in QuickBooks Online to fully reconcile the transaction.
Verifying the Payment Pushed to QuickBooks
To confirm a bill payment has been sent to QuickBooks Online, view the Payment Details from the Bill's Payment History in Buildertrend.
- Open the Bill in Buildertrend.
- Navigate to the payment history on the Bill.
- Click View Details on the payment entry.
- In the Payment Details panel, check the Accounting Status field.
The Accounting Status will show Sent to QuickBooks as soon as the payment is initiated.
✏️ Note: If the Accounting Status does not show Sent to QuickBooks, verify that the Bill itself was previously pushed to QuickBooks. A payment cannot sync if the parent Bill has not been sent first.
Part 3: Match the Bank Transaction
When the Bill Payment clears your bank, QuickBooks Online will receive the transaction through your bank feed. You must match that bank transaction to the Bill Payment created by Buildertrend to avoid creating a duplicate entry and to fully reconcile the payment.
- Navigate to Accounting → Bank Transactions.
- Select the bank account the payment was sent from.
- Locate the bank transaction that corresponds to the Bill Payment.
- In the Match/Categorize column, QuickBooks Online will suggest a match to the Bill Payment created by Buildertrend. Confirm the match details are correct.
- Click Match to link the bank transaction to the Bill Payment.
‼️Important:
✏️ Note: QuickBooks Online will typically auto-suggest the correct Bill Payment match based on the amount, date, and vendor. If not match is suggested, verify that the Bill Payment has synced from Buildertrend by checking the Accounting Status in the Payment Details section.
Troubleshooting
| Issue | Resolution |
| Bill Payment not appearing in QuickBooks Online | Check the Accounting Status in Buildertrend Payment Details. If it does not show Sent to QuickBooks, verify that the Bill was previously pushed to QuickBooks Online before the payment was submitted. |
| Bank transaction has no suggested match in QuickBooks Online | Confirm the Bill Payment has synced from Buildertrend (Accounting Status shows Sent to QuickBooks). Also verify that the correct bank account is linked in Buildertrend Bill Pay settings. If the sync is recent, wait a few minutes and refresh the Bank Transactions page. |
| Duplicate Bill Payment entry in QuickBooks Online | This can occur if the bank transaction was posted without being matched to the Buildertrend Bill Payment. Delete the duplicate entry and use the Match function to link the bank transaction to the existing Bill Payment. |
| GL Account not appearing in the Link to QuickBooks dropdown | Ensure QuickBooks Online is connected to Buildertrend and the integration is active. Try disconnecting and reconnecting the integration, or contact Buildertrend Support for assistance. |
| Edit pencil not visible in Bill Pay settings | You must be an Organization Owner or Trusted Payment User in Buildertrend. Contact your account administrator to update your role. |
Online Payments
When invoices and payments are sent to QuickBooks from Buildertrend, they must be matched to bank transactions to reconcile deposits. While QuickBooks may recognize some matches exactly, often a bank fee will need to be accounted for.
Choose the appropriate Invoice options in the QuickBooks integration settings, located in the Client tab of the Job Details.
-
Choose an account to send your record of payment to via the Deposit Online Payments dropdown.
- Choose an expense account to post the payment processing fees via the Expense Account for Online Transaction Fees dropdown.
✏️ Note: The fees posted to this account are Buildertrend's Client Payments processing fees. Card payments are charged 2.99% of the transaction amount. ACH payments are charged a flat $15 per transaction. Amex is not accepted.
✏️ Note: For more information on configuring your Integration Preferences in Buildertrend, go to QuickBooks Online Integration Overview!
Reconciling Payments sent from Buildertrend
Using the Undeposited Funds Account
If payments are sent to the Undeposited Funds account, both the payment and the journal entry for the payment processing fee will be available to combine into a deposit. You can then match this deposit to the bank transaction by following these steps:
Navigate to the Bank deposits in your QuickBooks.
Create the deposit by checking the payment and journal entry.
✏️Note: If there are multiple transactions, ensure that the reference numbers on both the payment and the journal entry you are merging are the same.
Ensure the deposit date and checking account are correct before selecting Save and Close.
QuickBooks will now suggest a match to the deposit. Clicking match will resolve this transaction.
Reconciling Payments sent from Buildertrend
Using the Checking Account
When reconciling payments using a Checking Account, direct your Deposit Online Payments to the desired checking account in your Accounting Settings Preferences.
Navigate to and open the transaction in the Bank Feed. Verify that the suggested match is accurate. If so, select match.
✏️Note: When Buildertrend pushes the payment and journal entry (for the bank fees), initially the payment and journal entry will be sent to your Undeposited Funds until a Bank Deposit can be created for a match in the bank feed.Buildertrend will automatically create the deposit slip once the payment settles. Client Payments settle in 3-5 business days.
Payroll
The Time Clock is used to track labor for job costing and payroll processing, making it an efficient tool the processing payroll.
When Time Clock shifts sync to QuickBooks, Buildertrend transfers employee data, including the associated cost code (P&S), dates and times worked, project/job details, and–when applicable–the Billable Rate. If Mark as billable is selected before the shift is synced, the shift is also sent to QuickBooks as billable. Buildertrend does not map to QuickBooks payroll items. These payroll items must be set up and assigned to each employee in QuickBooks through the Weekly Time Sheet.
Expand to learn more about Payroll Items
Within QuickBooks, navigate to Payroll,Employees and click Edit payroll items.
Select New Payroll Item, then create your new Pay type. 
Next, select an employee.
Click Start/Edit next to Pay Types.
Assign a Pay Rate for the default hourly rate and/or any custom Payroll Items (Pay Types) created.
Payroll Item(s) will need to be assigned to each time entry on the Weekly Timesheet.
Since Buildertrend does not map to the Payroll Item, the Pay Item field will be left blank and assume the default hourly rate for the employee.
In cases where multiple Payroll Items need to be accounted for, such as overtime, the Weekly Timesheet must be manually edited.
US Taxes
Within QuickBooks, you can set up Automatic Sales Taxes. You will have the ability to set your tax rates up by either Location (based on the customer's shipping address) or you can create Custom sales tax rates. To use the integration, ensure that tax tracking is enabled in both QuickBooks and Buildertrend.
QuickBooks Setup:
-
Navigate to Taxes → Sales Tax, click Use Automated Sales Tax and walk through the steps to set up your tax agency (state/city/country) and filing frequency.
✏️Note: There is an embedded YouTube video with instructions to assist you.
Buildertrend Setup:
-
Navigate to Company Settings → %Taxes and click Enable Tax.
✏️Note: Do not add taxes here because they will be imported from QuickBooks.
Location Based Sales Tax Rates
QuickBooks Online uses location-based sales tax to automatically calculate the correct rate based on where the sale occurs. It pulls in the appropriate state, county, and city tax rates based on the shipping or business location, helping ensure tax compliance across jurisdictions.
Import your tax rate from QuickBooks:
To import a specific tax rate from QuickBooks, ensure the Zip Code for a job in Buildertrend matches the customer shipping address in QuickBooks!
In Buildertrend, from the job who's tax rate you'd like to import, go to the Job Details → Advanced Settings tab → Taxes and set your Default Tax Rate to Import rate from Accounting.
Moving forward, the Tax Rate you have just imported will be available in the Default Tax Rate dropdown for future jobs.
Once your Default Tax Rate is set, the taxable rate will default on your invoices and be calculated appropriately.
How Tax Rates integrate with Buildertrend and QuickBooks
Create an Invoice in Buildertrend and push the Invoice to QuickBooks.
-
For more information on creating an Invoice in Buildertrend, review Invoices Overview!
-
For more information on pushing an Invoice to QuickBooks, review QuickBooks Online Integration!
What if my Tax Rates vary based on Products and Services?
If your rates vary based on products or services provided, then QuickBooks will allow you to set up variable rates.
If this is how your taxes are set up:
-
The invoice will need to be sent to QuickBooks with the default tax rate.
-
Then the invoice can be opened for editing which will allow QuickBooks to update the tax on each Product/Service code.
-
Once you edit the Invoice, after your next sync with Buildertrend, your Invoice within Buildertrend will updated to match and the tax adjustment will be noted.
Custom Sales Tax Rates
QuickBooks Online allows you to create your own sales tax rates for situations where automatic rates do not apply. These custom rates can be used for specific regions, districts, or tax scenarios that require manual setup.
Set up your custom Tax Rate
Within QuickBooks, navigate to Taxes → Sales Tax → Sales Tax Settings.
Click Add Rate and add the name, agency, and rate.
International Taxes
Within QuickBooks, you can set up Sales Taxes. You will have the ability to set your tax rates up by Country or Province requirements. In addition to setting up your tax rates by Country or Province, you can create group tax rates to allow you to use the same tax code for both sales and purchases.
Setting Up Sales Taxes for Quickbooks Online
The following steps ensure that Buildertrend and Quickbooks Online are configured correctly so taxes are tracked to the appropriate liability account.
To use taxes on Buildertrend Invoices and have them push properly to QuickBooks Online, the following settings must be completed:
- A sales tax rate must be added to each Product or Service code. This rate may be Exempt or Out of Scope but cannot be left blank.
- Tax Rate(s) must be created in Buildertrend.
- The invoice tax option must be set to Exclusive in Buildertrend Accounting settings.
- A default tax rate must be assigned to the job.
- Each invoice line must be marked taxable or non-taxable based on the tax settings assigned to the Product or Service code.
Add Sales Tax to Product or Service Codes in Quickbooks Online
To assign a tax rate to a Product or Service:
Navigate to Sales, then select Products and services.
Click Edit next to the desired Product or Service code. 
Choose the appropriate Sales tax rate (this may be Exempt or Out of Scope) and click Save and Close.
✏️Note: Even if you plan to configure Buildertrend to push invoice as inclusive, DO NOT check the "Inclusive of sales tax" box.
Create Tax Rates in Buildertrend
Navigate to Company Settings, then select Taxes.
Click + Tax Rate, enter your tax details, and select Save.
If multiple taxes need to be combined, create a Tax group:
Enter a name for the group.
Select the taxes to include, then click Save.
Set Invoice Tax Option to Exclusive
Navigate to Company Settings, then select Accounting.
Under Invoice Options, set your tax calculation to Exclusive.
✏️Note: Selecting Inclusive will deduct tax from the invoice subtotal rather than adding it to the total.
Assign a Default Tax Rate to the Job
Navigate to Job Details, then select Advanced Settings.
Under Tax Settings, select the appropriate default tax rate and click Save.
Create and Verify the Invoice in Quickbooks Online
Create your invoice and send it to Quickbooks Online.
Once synced, verify that the invoice sales tax rate matches the Product or Service tax rate in Quickbooks Online.
For example, if both systems are configured with a combined GST/QST rate of 14.975%, the invoice totals should match in both Buildertrend and Quickbooks Online.
Purchase Taxes
Purchase taxes are the taxes you pay when buying products or services from suppliers. Properly tracking these taxes allows you to accurately record your expenses and take advantage of any eligible credits or deductions.
‼️Important:
To use the taxes on Buildertrend Bills and have them pushed to QuickBooks Online properly, the following settings are necessary:
-
Purchase tax rates are applied to each product/service code. Note: This rate may be exempt or out of scope but cannot be left blank.
-
A tax option of Inclusive or Exclusive is chosen in the Buildertrend Accounting Settings.
From QuickBooks, add tax rates to the product/service codes by navigating to Gear Wheel → Products and Services, and then click Edit on the code.
Choose the appropriate Purchase tax rate (this may be Exempt) and click Save and Close.
✏️Note: Even if you plan to configure Buildertrend to push bills as inclusive, DO NOT check the Inclusive of purchase tax box.
From Buildertrend, navigate to Company Settings → Accounting to set your default QuickBooks Invoice options.
- Tax inclusive: Use this option if you want to include taxes in your Buildertrend budget as cost of goods sold. The full bill will be entered into Buildertrend and QuickBooks will deduct the tax and apply it to the liability report.
Example of Tax inclusive:
In this example, the 5% GST is included on the bill and displayed on the budget as cost of goods sold. Then it is sent to QuickBooks, and the GST is deducted and applied to the liability report.
Budget View:
Example of Tax exclusive:
In this example the bill will be created without tax, a 5% GST will be added in QuickBooks, and the Buildertrend budget will only reflect the cost of goods sold.
Budget View:
Tracking PST as Cost of Goods Sold
In some regions, Provincial Sales Tax (PST) can be tracked as part of your Cost of Goods Sold. Doing so helps you better understand your product costs and profit margins while ensuring your tax reporting aligns with local regulations.
PST paid on materials is tracked as cost of goods sold and therefore should be recorded on the Buildertrend budget. To make this possible, PST will need to be included in the cost of the materials and a special GST rate set up to ensure that it is charged correctly.
For Provinces that need to collect 5% GST on the product, while calculating on a cost that is the product plus a 7% PST:
-
You will need to set up a custom GST purchase tax rate of 4.6729%.
For Provinces that need to collect 5% GST on the product, while calculating on a cost that is the product plus a 6% PST:
-
You will need to set up a custom GST purchase tax rate of 4.717%.
Click +Add Custom Rate under the Canada Revenue Agency.
Create your custom rate by:
-
Entering a name for the Tax Rate.
-
Checking I pay this on Purchases.
-
Enter the rate of 4.6729%.
-
This rate of 4.6729% is an adjusted number allowing you to apply a 5% GST to all items that include PST WITHOUT applying the 5% GST to your PST (aka we are making sure we don't tax the PST tax).
-
-
Choose Input Tax Credits (ITCs) under Show tax amount on return line.
-
Click Add to save your new custom rate.
✏️Note: Check with your accountant to ensure that your GST should be set up as a Input Tax Credits.
Add the new purchase tax to all product/service codes that will be charged PST by navigating to the Gear Wheel → Products and Services, and then click Edit on the code.
Adjust the Purchase Tax Rate to the newly created custom rate.
✏️Note: Do NOT check the Inclusive of Purchase Tax box.
From Buildertrend, navigate to Company Settings → Accounting to set your default QuickBooks Bill option to Exclusive.
Example of a Bill utilizing PST as Cost of Good Sold tracking:
In this example I have a receipt with a mixture of cost items that do and do not include PST.
*Note: This is a real customer receipt and has been redacted to protect the customer.
Receipt Breakdown:
Total Due: $87.36 (material + PST + GST) + $89.25 (labor + GST) = $176.61
-
1 Yard Bedding Sand – This is a material cost that includes PST
-
$78.00 (material total) x 7% (PST) = $5.46
-
$83.46 (material + PST) x 4.6729% (adjusted 5% GST) = $3.90
-
$78.00 (material) + $5.46 (PST) + $3.90 (GST) = $87.36
-
-
-
-
Agg & Mulch Delivery – This is a labor cost that does NOT include PST
-
$85.00 (material total) x 5% (GST) = $4.25
-
$85.00 (material) + $4.25 (GST) = $89.25
-
-
When creating a bill in Buildertrend that needs to account for PST for some costs and GST for all costs, you have two options.
In the example provided for each option below, we will be recreating the example bill above using 2 cost codes (product & service codes):
-
7010 – Landscaping
-
In QuickBooks, this product and service will have your Purchase tax set to the custom tax rate as PST will be applied to this when purchased.
-
-
7410 – Pickup/Delivery
In QuickBooks, this product and service will have your Purchase tax set to your general GST tax rate as PST will NOT be applied to this when purchased.
Option 1
Put the PST on its own cost line but use the same cost code for the PST cost line that you used for the material cost that requires PST to be applied. This will eliminate any potential math errors. 
Option 2
Include the PST total in the cost line with the product that requires PST to be applied.
Interested in Learning More? 📚
Visit the Buildertrend Learning Academy to explore additional learning opportunities — from live group trainings and certifications to on-demand courses and more.
For questions or additional support, contact our Customer Support team via Live Chat, email support@buildertrend.com, or call 1-888-415-7149 — we’re always happy to help.
Still have questions or need our help finding a resource?
Contact our Customer Success team.
Mon - Fri
8:00am - 5:00pm
USA (CST-6)