We are a subcontractor company and sometimes customers will send us a payment before the job is completed. We were creating an invoice, receiving the payment and then once the job was completed, updating the invoice date and sending the invoice to the customer. Doing that, it was creating a negative accounts receivable balance and because we are cash-based we cannot have that. What can I do about this?.
I included a screenshot of one of my invoices: Received down payment on 1/2/18, then was asked to invoice the job on 1/4/18 when job was done. Updated the invoice dates, one month later customer didn't pay so added a late fee and on my Jan financials, there is a negative $1000 in Accounts Receivable. What do I need to change so this isn't there?
Solved! Go to Solution.
You make an Other Charge type item for prepayments. Link it to income, for a Cash basis entity; link it to Liability, if you are allowed to carry liability.
Use this on a Sales Receipt when you get the prepayment.
Use it later on a Credit Memo for the date you are ready to apply it to the actual invoice, to refund it, or to meet Both Needs. Use the icons at the top of the credit memo.
You make an Other Charge type item for prepayments. Link it to income, for a Cash basis entity; link it to Liability, if you are allowed to carry liability.
Use this on a Sales Receipt when you get the prepayment.
Use it later on a Credit Memo for the date you are ready to apply it to the actual invoice, to refund it, or to meet Both Needs. Use the icons at the top of the credit memo.
"Won't creating the credit memo decrease my income account?"
It changes whatever you need it to affect.
You make an Other Charge type item for prepayments. Link it to income, for a Cash basis entity; link it to Liability, if you are allowed to carry liability.
Use this on a Sales Receipt when you get the prepayment.
Use it later on a Credit Memo for the date you are ready to apply it to the actual invoice, to refund it, or to meet Both Needs. Use the icons at the top of the credit memo.Nothing if you keep recording income after receiving payments for it. That's backwards.
Since you're on a cash basis, recording the invoice for the job at the point of the sale (or contract signing) will have no impact on your books. Then later when you receive payment for the invoice you'll see the income on your financial statements.
Oh:
"one month later customer didn't pay so added a late fee"
Never do that on the Existing invoice; you just revised your Prior year Sales and Financial data.
You assess a late fee using the function, which creates a New Invoice. This is a New Charge, dated Now, and increases their total AR Owed to you.
If you turned in your financial data for reporting, you might need to edit and Remove all those late fees you added after the fact to old, existing, invoices.
My question is how I handle the deposit after I enter the Credit Memo for the prepayment/deposit from my customer. I see the credit memo reduced accounts receivable, but shouldn't the money be landing in undeposited funds account? I'm missing a step (or 2). The day I get the check, the money will go into my one bank account, so I am not sure how to take it from the credit memo to the deposit and link them all together, without counting the deposit as a sale, until the final payment is made.
I looked at a statement and the one that applies to us is listed below. We are on accrual method. IF, if the deposit is refundable, it is a liability until the job/sale is invoiced. Problem is, once the customer first paid based on the estimate, I moved it to an invoice. I don’t want to pay for taxes until the final payment is made, since I do not work on it until then. Sometimes, customers will take 6-8 months to pay on an item.
Hi @S-Ponder,
Let me take care of your query about recording partial payments as a liability instead of a sale.
When recording a deposit, select Accounts Receivable as the From Account. This increases the customer's balance without recording a sale and creating a credit memo. Here's how:
Once the invoice amount gets paid in full, create an invoice for the customer. Ensure the correct dates are entered, along with other information in it. Follow these steps:
You also have the option to split a single estimate into multiple invoices (also known as progress invoices). Check out this article on how to enable and use this feature: Set up and send progress invoices in QuickBooks Desktop.
Do you have any other questions in mind? Please post them below, and I'll get back to you.
That works for me! However, the estimates reporting leaves a lot to be desired. Now I am trying to use the estimates reports, under customer center, and have updated the estimates to reflect active and inactive according to the status of the customer and the job. Changing this status does nothing that I can see with the exception of the leaving a little check mark. It will not change the Open Balance column. I like the "amount" column to reflect the amount of work that was quoted, but I need to reflect the actual potential income in the "Open Balance". Since I do not want to create an invoice for any work until it is delivered to the customer, I have to work in estimates, unless there is another option.
Hello, @S-Ponder.
An estimate is a non-posting type of transaction. You'll need to enter an invoice and apply the prepayment (credit memo) you've recorded. I can walk you through on how to do it.
You can convert the estimates that you have into an invoice. By doing so, your billing proceeds directly from the line items and pricing that your customer approved, and simplifies both your costing and your billing procedures.
Here's how:
Once the invoice is saved, you can now apply the credit memo you've created.
Once you've completed the process, here's how your report will look like:
To learn more about different workflows in recording your transactions in QuickBooks, you can check these articles:
Let me know if you have other questions. I'm just a few clicks away.
From what I understand from previous responses, the prepayments should be considered a liability, and not a sale. We are using the accrual method, therefore, the sale is not recorded until the final payment is made. The prepayments are all refundable until the final payment. When I had the partially paid invoices entered, QB calculated sales tax on all, counting the prepayments as income. I have backed out all the invoices that were partially paid and entered them as estimates. I am looking for the best way to report for prepayments in "estimates", active estimates, inactive estimates and invoices (paid in full). The inactive and active estimates baffles me - the designation does nothing. I would like it to zero out in the open balance.
I appreciate hearing again from you, @S-Ponder.
When depositing prepayments, it should be associated to a liability account. Let me show the workflow to you.
To create a liability account, here's how:
Once completed, you can now deposit the prepayment. Now, let's create a prepayment service item and use it in recording the credit memo.
Also, we have to make sure to associate the service item to the liability account. By doing so, the “Prepaid Customer” account will show a 0 balance.
From here, you'll see your Open Accounts Receivable will have a credit balance on it. Also, the entire process ensures that when you convert the estimate to invoice it will be considered a liability, not a sale.
Feel free to click the Reply button if you have other questions. I'm always here to help.