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

Credit Memos - Tracking both invoices AND expenses against a credit memo

Hello-

 

In my interior design firm I receive large retainers/deposits for a project for which we do not know exact costs at the outset.   When I enter the deposit/retainer into QB,  I create a Credit Memo in since there is as yet no open invoices to apply against the Credit Memo.  

Problem 1: The system does not assign the credit memo a number, I have to do that manually.

 

Later, after work is performed, I create an invoice.  There can be one or several invoices applied against the Credit Memo.  QB asks me if I want to use the open Credit Memo to pay the invoice.  I  say yes.  That works fine.  Later, I can pull up the Credit Memo (payment) and see all the invoices I have applied against the open Credit Memo, until the Credit Memo is depleted and nothing more can be invoiced against it.  That works fine.

 

However, my next issue:  Also associated with this Credit Memo, on the other side of the equation, I am paying vendors for the product or service for which I am invoicing the client.   Problem 2:  There is no way in  QB that I have found where I can tie the vendor payment back to the Credit Memo. The vendor is being paid from that Credit Memo.  My goal is to see both invoices applied against the credit memo AND payments to Vendors associated with a  credit memo.  The difference between those two things is my profit.   Can this be done?

 

 

7 Comments
Anonymous
Not applicable

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Hello, @dddenise1.

 

Let me help record a retainer/deposit into QuickBooks and set a retainer item that'll be selected when creating a sales receipt for retainer payment.

 

When setting up a deposit/retainer process for your company, this is treated as a liability to show that, although your business is holding the money, it doesn't belong to you until it's used to pay for services.

 

First, you'll need to create a liability account to track retainers. Here's how:

 

  1. Go to the Lists menu and select Chart of Accounts.
  2. You can right-click anywhere and select New.
  3. Select Other Account Liability and click the Continue tab.
  4. Enter a name for the account (ex. Trust Liabilities).
  5. Once done, click Save & Close.

Next, create a retainer item:

 

  1. Go to the Lists menu and select Item List.
  2. Choose a Service item and enter a name (ex. Retainer).
  3. From the Account drop-down, select the Trust liability account you just created.
  4. Click Save & Close.

 

The retainer item can now be selected when creating an invoice or sales receipt for a deposit or retainer payment. Once you have set up the accounts and the retainer or deposit item, you can begin to create Sales Receipts for the deposits or retainers you receive.

 

Here's how to create the sales receipt for deposit/retainer payment:

 

  1. Go to Customers menu and select Enter Sales Receipts.
  2. Select the Customer.
  3. From the Deposit To drop-down list, select the bank account where the retainer was deposited.
  4. Enter the retainer service item you've set up on the Item column.
  5. Then enter the amount received for the retainer or deposit in the Amount column.
  6. Select Save & Close.

 

In addition to adding the retainer/deposit amount to your bank account, this increases the amount in your liability account to show that the money isn't truly yours yet, and to avoid treating it as income later.

 

You can now create a credit memo using the retainer item. Let me show my sample below in creating an invoice and applying the credit memo.

 

 

 

 

You'll have to manually enter a credit memo number if needed. At this time, we don't have the option to automatically assign a credit memo number. Now when paying vendors using the retainer/deposit, you don't need to link this to a credit memo. Once you're done recording your retainer/deposit in QuickBooks, you can directly pay your vendor using your account where the retainer amount was deposited.

 

The transactions will now show on your P&L report. Just in case you'll need help with the whole process, you can always reach out to our Desktop Support to assist you with the steps using their screen share tool. You can also check out our site if you need some helpful references in the future: Help articles for QuickBooks Desktop.

 

That should do it. Let me know if you have additional questions about your retainer/deposit. I'm always here to help.

Level 1

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Thank you.  I will test this and see if it works for my business.  

Level 15

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

@dddenise1 

 

You took a deposit and deposited those funds.

 

Now you pay a vendor from those funds, he is not being paid from the credit memo.

 

Make the contract a job under the customer, then use billable expenses to tag the vendor payment with the job name, do not mark it billable. that will associate the cost with the job.

on the job screen you can run a P&L by job report

 

Using a credit memo for the deposit, what item did you use and is it linked to a liability account? Or did you just deposit the funds and use the customer name as the source of the deposit?

Either way mis-states your accounts receivable on the balance sheet, since intuit holds customer credit in the A/R account, lowering actual A/R on the balance sheet

 

I prefer to create the deposit item which is linked to a liability account. Then as you create an invoice you use that same item with a qty of negative one and the amount of the deposit to apply.

 

Level 2

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Hello, It's been a while since I wrote this message and received your reply, but I am now ready to deal with this issue. I think I need a little more clarification, using my language. Basically, I already have a bank account in which all Customer Down Payments/Deposits are deposited. The account is called "Customer Deposits." From there I create a "Credit Memo" to which I have to manually assign a Credit Memo number, as you describe. Follow me for the following examplie Client Smith gives me $10,000 for a kitchen remodel. I deposit the funds into my "Customer Deposit" account, into which all customer deposits go. I create Credit Memo #123 for the $10,000 I invoice Customer Smith for individual or multiple items. For instance, I Invoice Client Smith on Invoice #xyz in the amount of $1500 for architectural plans. I deduct $1500 from the Credit Memo #123, leaving an $8500 balance. Then, I turn around and pay the architect $1000 from the credit memo. So, as far as Client Smith is concerned, he has spent $1500. As far as the Company is concerned, we have spent $1000 The $500 difference is our profit. This continues until we have invoiced Client Smith $10,000, as we continue to pay vendors for some amount that is less than the amount we have billed the client (usually 20-25%). Say,for instance, after a period of time we have billed the client $10,000 from five invoices, but have paid out only $8000 to several vendors. This leaves us $2000 in profit which comes out of our Customer Deposit account and into our profit account. I need to see the invoices and vendor payments applied to the credit memo, with the remaining balance after the customer has been fully billed. Can I do for all of this in QuickBooks desktop?
QuickBooks Team

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Hello there, @dddenise.

 

Allow me to step in and help provide some additional information about tracking the transactions you've made in QuickBooks. 

 

First, I'd like to acknowledge your effort in adding detailed information about your concern. To record the transactions correctly, you'll need to set up a deposit/retainer by following the detailed steps provided by my colleague. It will help you track your profits.

 

Then, when creating customer's invoice, you can use the job tracking feature so you can track the expenses for a job and compare those expenses to your revenue by pulling up the Job Profitability Detail report. 

 

Here's how:

  1. At the top menu bar, select Reports.
  2. Select Job, Time, & Mileage.
  3. Click Job Profitability Detail report. 

 

Also, if you'd like to view the invoices applied to the credit memo and the remaining credit, you can pull up the Customer Balance Detail report by following these steps:

  1. Go to Reports.
  2. Choose Customers & Receivables.
  3. Select Customer Balance Detail.

You may also check this article on how to customize reports in QuickBooks Desktop.

 

Please know that you're always welcome to post again if you have additional questions. Have a good one. 

Level 2

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Thank you for your quick reply. When your colleague said "choose a service item" when setting up a retainer, do I have to set up a service item for each new deposit?
QuickBooks Team

Re: Credit Memos - Tracking both invoices AND expenses against a credit memo

Thanks for getting back to me, dddenise. 

 

To answer your question, you can only create one service item and use it every deposit you made. 

 

Wishing you and your business continued success. 

Need to get in touch?

Contact us