Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowA customer asked me to invoice them 100% of their purchase order amount near the start of the year. The invoice was for a certain number of hours of my consulting services. They paid that invoice earlier this year. It is now near the end of the year and they have not used up the hours that they purchased, so, in an Excel spreadsheet, I have been tracking the credit they really have with my company.
To report an accurate year end revenue value, how do I account for the fact that they really have a credit with me? Or, should I tell them that they lose the credit after December 31. Since they will be issuing a 1099-MISC for the full amount paid, do I claim all of the revenue in 2018 or do I somehow adjust this revenue to subtract the credit they have since the remaining work has yet to be performed?
first your contract with them should have stated that the deposit was forfeited if not used by 12/31
You received the money, you should have posted that to an unearned revenue liability account when received, then during the year you apply some portion of those funds to the invoice for your work each month.
if you will be getting a 1099 for the full amount, then obviously they think the money is spent, so yes the balance not used is income.
Now the question really is, how did you enter the funds received back at the start?
At the start, I entered an invoice for the full amount into QuickBooks and sent the invoice to the customer. Then, when they paid the invoice, I entered the payment by clicking on "Receive Payments" from the main screen in QuickBooks (desktop edition 2016).
if you file taxes on an accrual basis, the full amount was entered as income as of that date
If you file taxes on a cash basis then income is posted when you receive the funds
We received payment from a customer in July for 6 months of payments in advance, how do I show those prepayments and how would I apply them monthly in Quickbooks?
Hello @Mriddick,
Let me help share information about how you can enter prepayment or advance payment from your customers.
To start with, you'll have to create a liability account and an item to be used to track the advance payment you received. Let me show you how.
Creating a liability account:
Creating a new item:
Once done, proceed with the remaining steps you need to take which are outlined in this article: Manage upfront deposits or retainers.
Additionally, I've also included this helpful article for the references you can use to help organize your customer transactions: Learn the different ways you can track customer transactions.
If you have any other questions, you can always leave them in the comments below. I'll be here to help. Stay safe!
Jonpril,
Do you have an article like the one referenced in your reply that applies to QBO? This article is for desktop.
thank you
I’m here to guide you through how to manage upfront deposits in QuickBooks Online, @GSCI1644.
If you accept upfront deposits or retainers for products or services, there are several steps you need to take to account for that money. This is to make sure the company revenue will not be doubled.
You’ll want to ensure you’ve set up an account, item, and trust liability account. So when you charge a customer for the services you perform for them, you can turn the retainer or deposit you previously received into credit on an invoice and accept it as payment. You can follow these processes to handle this fund in QuickBooks Online:
For detailed instructions and to be more familiar with managing retainers in QuickBooks Online (QBO): How to record a retainer or deposit.
I've also included an article that'll help combine multiple transactions into a single record so QuickBooks matches real-life bank deposits:
Additionally, I encourage you to pull up the Customer Balance Detail report. This makes sure you're able to monitor the payments you receive and the remaining balance that your customer has. Go to the Who owes you a section from the Reports menu's Standard tab.
In case you have other inquiries or concerns, let me know in the comments below. I’ll be around to back you up. Have a good one and keep safe, @GSCI1644.
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.