Managing Bills & Expenses in Buildertrend
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.
Which QuickBooks workflows will be effected when implementing Bills?
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 transation or importing CSV bank statement
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 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.
Bank Feed | Matching Bills
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.
Matching Bills in the QuickBooks Bank Feed will be commonly used with the Cost Inbox.
For more information on how to scan your receipts into Buildertrend and to create a Bill from the Receipt, review this article.
For more information on how to push the Bill created from the Receipt to QuickBooks, review this article.
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.
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.
Navigate to the Bank and Credit Cards in QB. Select the account (bank or card) used for payment.
Next, navigate to the Unrecognized tab to locate the transaction. Use the search feature if necessary.
Once the correct transaction is located, use the checked actions to select the transaction, then select Match to existing transactions from the dropdown.
Online Payments
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.
For more information on configuring your Integration Preferences in Buildertrend, check out this article!
Reconciling Payments sent from Buildertrend
Expand to learn how to reconcile payments using the Undeposited Funds Account
Expand to learn 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).
Expand to learn how to reconcile payments using the Checking Account
Expand to learn how to 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.
Interested in Learning More? 📚
The Buildertrend Learning Academy is your one-stop-shop for your online education, whether you're new to Buildertrend or an experienced user looking to learn more.
If you have any questions or require additional support, feel free to chat with us, send an email: support@buildertrend.com, or give us a call at 1-888-415-7149. We’re always happy to help.