Vendor deposits and prepayments in QuickBooks Online for builders
Windows, cabinets and appliances are often paid for before delivery. How to record the deposit so it is not a cost on the house until the goods arrive, and so it is not forgotten.
Short answer: Record a deposit to a supplier as money you are owed until the goods arrive, not as a cost on the house. In QuickBooks Online you can post it to a current asset account, or post it to Accounts Payable so it appears as a vendor credit. When the bill arrives, enter the full bill to the house and cost code and apply the deposit in Pay Bills, so you pay only the balance and the cost lands when the goods are received.
Why this matters on a house
A builder pays $18,000 up front for windows that will not ship for ten weeks. If that payment is coded to the Windows cost code immediately, the house looks $18,000 over budget on cost to date, percent complete jumps, and a WIP schedule overstates earned revenue. If it is not recorded at all, the supplier balance is wrong and the next invoice gets paid twice. A deposit is neither a cost nor nothing. It is an amount the supplier owes you in goods.
Two ways to record it
| Method 1: asset account | Method 2: Accounts Payable credit | |
|---|---|---|
| Entry | Check or expense to the supplier, category set to a current asset such as Supplier deposits | Check or expense to the supplier, category set to Accounts Payable |
| Where it sits while you wait | A positive balance in the asset account | A negative balance on the supplier in Accounts Payable |
| When the bill arrives | Enter the full bill with a negative line to the asset account for the deposit, so the asset clears and you pay the balance | Enter the full bill, then apply the credit in Pay Bills |
| Strength | Easy to see all open deposits in one place | Shows up in the vendor's balance and in Pay Bills automatically |
| Watch for | Needs a clearing step, or the asset never goes away | Negative AP balances look odd to a reader of the balance sheet. Use the same supplier name on both entries. |
Intuit's help for QuickBooks Desktop describes both methods, recording the prepayment through Accounts Payable or through an other current asset account, and clearing the asset by entering the bill with the prepayment as a negative line. Independent QuickBooks Online help sites describe the same two approaches for the online version: post the prepayment to Accounts Payable on a check or expense so it is held as a credit for that supplier, or hold it in a current asset account and apply it when the bill arrives. Pick one and use it for every supplier.
Want deposits and prepayments tracked until they are earned? Request a Relationship Assessment.
The steps for each house
- Record the deposit using your chosen method. In the memo, put the house and the item, such as "Lot 14 windows, 50 percent deposit".
- Keep a deposit schedule by house. List supplier, house, amount, expected delivery date and the invoice you are waiting on. Review it at month end.
- When the invoice arrives, enter the full amount as a bill to the correct house and cost code, using the delivery or invoice date.
- Apply the deposit in Pay Bills so the payment equals the bill minus the deposit. If the bill is smaller than the deposit, apply what you need and leave the rest for the next bill.
- Clear the remainder. If the order is cancelled, get the refund and record it against the deposit.
How deposits affect your numbers
- Job cost. Cost is recognized when the goods arrive, not when you pay. The house report stays honest between deposit and delivery.
- WIP. Many builders also exclude uninstalled materials from percent complete. See uninstalled materials and percent complete.
- Cash. Deposits tie up cash before the cost exists. Include them in your 13-week cash forecast.
- Customer deposits are the other side of this. Money you hold from an owner is a liability. See retainage and customer deposits.
Mistakes to avoid
- Coding the deposit straight to the cost code and then entering the invoice again, which counts the cost twice.
- Using a different supplier name on the deposit and the bill, so the credit cannot be found.
- Letting a deposit sit for a cancelled order and never recovering it.
- Deposits on a credit card that never reach the supplier's balance. See credit card charges to the right house.
How we help
Our team records each deposit by house, applies it when the bill arrives and reviews open deposits at every close. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.
Sources
- Intuit, Record vendor prepayments or deposits in QuickBooks Desktop
- Intuit, Enter supplier credits and refunds in QuickBooks Online (applying a credit to a bill in Pay bills)
- QBO Support (independent help site), How do you record a supplier prepayment in QuickBooks Online?
- QBO Support (independent help site), How do I record supplier prepayments in QuickBooks Online?
Common questions
How do I record a deposit to a supplier in QuickBooks Online?
Post it as a check or expense to the supplier with the category set to Accounts Payable, or to a current asset account. Then enter the full bill when it arrives and apply the deposit in Pay Bills.
Should a vendor deposit be a job cost?
Not until the goods arrive. Until then it is an amount the supplier owes you, so it sits in an asset account or as a vendor credit.
What if the bill is smaller than the deposit?
Apply the part you need and leave the rest as a credit or asset balance for the next bill, or get a refund.
Why is there a negative balance on my supplier?
If you post a prepayment to Accounts Payable, the supplier shows a negative balance until you apply the credit to a bill. That is expected.
How do deposits affect a WIP schedule?
Deposits are not cost until delivery, and uninstalled materials can inflate percent complete if included. Many builders exclude them.
Can you track my vendor deposits by house?
Yes. Our team keeps a deposit schedule by house and reviews it at each close.
Related
- Purchase orders and committed costs in QuickBooks Online
- Accounts payable workflow for home builders
- Uninstalled materials and percent complete
- 13-week cash forecast for builders
- Retainage and customer deposits
- Subcontractor pay application review checklist
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.