Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am new to Quickbooks Online, and trying to set it up for running a small construction business. I am using
Online Pro with cash method accounting.
When I start a project I receive a down payment from a customer, which allows me to purchase materials necessary to start a job.
I am invoicing for these, then entering the funds as deposits/down payments, type "Other current liabilities", detail type "Trust accounts-liabilities". When I make the deposit it seems to cancel out the invoice, so that on a customer statement it doesn't appear as a credit. I have included a screen grab from a customer statement below to show what I mean. If I were to look at the bottom of this statement it would show the customer owing me $1837.55, even though they gave me a deposit of $4000
What is the simplest way to easily see how much a customer has paid, spent, and the difference between? Thank you
While your grasp of the concept of treating down payments as current liabilities may be correct from a purely accrual side of looking at things the fact that you are cash basis, to my mind, complicates this even further.
Now I admit I am not an expert on money received before work is performed, however, I receive rent money prior to the rent being charged. This, in the books, is treated as a prepayment - current liability - and becomes or is applied when rent is billed. At the end of the year is when it gets more complicated than merely receiving money without an invoice, when any prepayments (cash IN hand) has to be converted to income since on a cash basis it has been my understanding (albeit possibly off-kilter) that ALL cash received is income regardless of whether you have performed the corresponding work.
That being said, your main issue, as I see it, is the inability to grasp the entire project at a glance and to know where you and the customer stand. In contracting I would start by using Estimates, adjust the estimate to match the signed contract (at least in our state contractors are not allowed to proceed without having presented a written proposal that includes their state-issued license number)
Now the key is Progress Invoicing, creating invoices as you go from the single estimate https://quickbooks.intuit.com/ca/resources/invoicing/converting-estimate-invoice/
And since you are cash basis https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/how-do-i-record-down-paymen... you will have unapplied cash income when you receive money without an invoice yet on the books. As cash basis you cannot treat the down payment as negative A/R but instead should treat it as income. You can use a different income account for prepayments and then reverse the income from that account on your correct final or progress invoice (by creating a credit or entering a negative income line on the invoice once created)
Have I lost you yet? Hope not. Let's break it down
1. create estimate (optional)
2. record down payment as income to Unearned Revenue or similar
3. create invoice (or progress invoicing) and deduct Unearned Revenue
4. collect all additional monies and apply to open invoice amounts
2. create
QB only reports on cash basis, it is accrual accounting. And since you are using invoices, it is not true cash basis, it is reporting on a modified cash basis.
Basically if a deposit is refundable, it is a liability. If a deposit is non refundable it is cash income when received. A pre-payment is income when received, basically no different than a non refundable deposit.
I create the liability account for customer deposits, and a service item which link to that liability account. Use that service item on the invoice or a sales receipt and deposit the funds.
When you invoice the customer, use the deposit service item as the last item, set the qty to negative one, and enter the amount, the customer pays the balance due.
If you do not want to use a liability account for the deposits for some reason, create a liability account and name it deferred income, basically the same thing it just looks different on the balance sheet. Same process as above.
John when I receive rent ahead of the due date, I post it to a deferred rent income account, then when the effective rent date comes around I charge the tenant on a sales receipt, and list the deferred income item as a negative, save the zero dollar transaction and all is right with the world. :-)
Food for thought
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here