cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
JDO2
Level 1

Mapping of Invoices

We are accrual based, but our billing methods are to obtain 50% down before a project begins and then we bill for the remaining 50% upon project completion.  So the issue that I am running into is that when I go to create an invoice in QBO to get the customer to pay for the initial 50% payment, QBO automatically books revenue and a receivable for the amount invoiced, when in fact there should be no entry at date of invoice, but when the payment is received there should be a debit to cash and a credit to advance customer payments (unearned revenue).  Then as progress happens on the project revenue is credited and the unbilled account is debited proportionally until 50% of the project is reached, and then the entry should be to debit AR and credit revenue, bill the remaining 50% upon completion of the project and book a debit to cash and credit to AR upon receipt of the last 50%.  Right now I am having to do a lot of manual entries to  reverse the effects of QBO automatically making entries when I create an invoice, is there anyway around this? I know there has to be, but I can not figure out how to get there.  Thanks in advance!

3 Comments 3
Trish_T
QuickBooks Team

Mapping of Invoices

Hello JDO2,

 

Welcome to Community!  QuickBooks Online Project feature is a dynamic way to track your jobs accurately.  However, to ensure a positive outcome on your books, I recommend speaking with an accounting professional.  They'll be able to provide their expertise and best course of action to ensure your books remain balanced.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

If you have any other questions, feel free to reach back out.  We would be happy to help!

JDO2
Level 1

Mapping of Invoices

Hi Trish,

 

I am a CPA, and I know how to account for the transaction I was describing, what I would like assistance with is how to accomplish that in QBO.  Thanks!

Trish_T
QuickBooks Team

Mapping of Invoices

Hi JDO2,

 

Thanks for getting back to me here.  QuickBooks Online offers Progress invoicing, so you can send invoices over a period of time.  You can split an estimate into several invoices as needed.  This enables you to invoice customers for partial payments at the beginning of a project, then add items as you complete the work.  Click here, to learn how to add an account summary to your progress invoices.

 

I hope you find this helpful!

 

 

Need to get in touch?

Contact us