Implementing Bills into your QuickBooks Desktop 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.

• Match Bill to bank transaction instead of creating a new expense.

  • For more information on how to match Bills pushed from Buildertrend to the bank transaction, check out this section!

• Pay Bills with credit cards to populate register in Chart of Accounts, rather than creating a type credit card transaction or importing CSV bank statement

• Pay Bills with checks instead of creating a type check transaction

‼️Important:

---

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 the Include costs entered in QuickBooks in the Budget option from the Buildertrend Job's Accounting Settings.

 

2. Create a Bill in Buildertrend, but DO NOT push it to QuickBooks. Then mark that Bill paid with an offline payment.

When buying ad hoc items for your project, matching a Bill from Buildertrend to the bank feed will ensure both program budgets are up to date.

Create a Bill in Buildertrend. Be sure to push the Bill over to QuickBooks.

In QuickBooks, navigate to Bank and Credit Cards.

• If there is a transaction of the exact same amount, QuickBooks will suggest a match for the unpaid bill within the Recognized tab.

• Check the bill and click Confirm to create a bill payment.

  ✏️Note: Results may populate multiple matches. Select the correct option and click Confirm.

   

Once the Bill payment has been created, both Bills will be marked as paid.

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.

1. Navigate to the Bank and Credit Cards in QB. Select the account (bank or card) used for payment.

2. Next, navigate to the Unrecognized tab to locate the transaction. Use the search feature if necessary.

3. Once the correct transaction is located, use the checked actions to select the transaction, then select Match to existing transactions from the dropdown.

Payments sent to Quickbooks from Buildertrend can be sent in multiple methods, dependent upon your workflow and preference for the Check Register.

Choose the appropriate Owner Invoice options in the QuickBooks integration settings, located in the Homeowner 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.

Reconciling Payments sent from Buildertrend
​

How to Reconcile Payments using the Undeposited Funds Account

If payments are sent to Undeposited Funds, the amount of the bank deposit will be displayed on your Check Register.

Buildertrend posts the payment to Undeposited Funds and creates a journal entry to account for the payment processing fee. You will see both records in the customer transaction record.

 

---

Navigate to Banking dropdown, select Make Deposits.

Locate and select both the payment and the journal entry, then click OK.

Verify that the account and date are correct, then click Save & Close.

• This will create an entry on the Checking Account Register, showcasing the deposit amount (Undeposited Funds amount – the bank fees).

Reconcile Payments using the Checking Account 

If payments are sent to a Checking Account, the amount of the bank deposit and journal entry will be displayed on your Check Register.

Buildertrend posts the payment to your Checking Account and creates a journal entry to account for the payment processing fee. You will see both records in the customer transaction record as well as your check register.