cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Contributor *

How do I show a partial payments applied to invoices?

So the payments/credit on invoices is terrible. I don't like that it doesn't show if there's a split payment.  I have customers who pay partial invoices using a credit memos and the balance with credit cards.  I have some who return some items on invoices which leaves the invoice looking like there was a partial payment when in fact it's a return.  As of now we depend on memos in the body of the invoice to indicate the payments. Most customers don't see the memo even though we move it clearing several lines below the items and my total form font is pretty large. I would like to either change the font color to Red so the memo is clear and visible.  Is there a way to change the color in the body of an invoice?  Or does anyone else have an ideas.  

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

When you put a Payment Item on the invoice, the date of t...

When you put a Payment Item on the invoice, the date of the invoice is the date of the payment. It also reduces what the invoice shows in the Customer Center and in transaction reports. In other words, if the two payments are the same date as the invoice, adding them to the invoice is fine, but now, if that paid the invoice in full, your Transactions Listing will always show $0. You have to Open these invoices to figure out what the Actual sale was.

Next, if the partial payments are different dates, you never put that on the invoice because that is the wrong Date.

The tool for what you are asking is Statements. Run Customer Statements to see the AR activities as a Listing of transactions. That will show Payments and Credit Memos and a running balance.

"I would like to setup a "TYPE" Account to use for information use only.   For example I would call the  item "Credit Memo Applied" and then in the Description type the amount."

You are messing with your Real Financial Data.


20 Comments
Established Community Backer ***

When you put a Payment Item on the invoice, the date of t...

When you put a Payment Item on the invoice, the date of the invoice is the date of the payment. It also reduces what the invoice shows in the Customer Center and in transaction reports. In other words, if the two payments are the same date as the invoice, adding them to the invoice is fine, but now, if that paid the invoice in full, your Transactions Listing will always show $0. You have to Open these invoices to figure out what the Actual sale was.

Next, if the partial payments are different dates, you never put that on the invoice because that is the wrong Date.

The tool for what you are asking is Statements. Run Customer Statements to see the AR activities as a Listing of transactions. That will show Payments and Credit Memos and a running balance.

"I would like to setup a "TYPE" Account to use for information use only.   For example I would call the  item "Credit Memo Applied" and then in the Description type the amount."

You are messing with your Real Financial Data.


Frequent Contributor *

I don't believe you understand what I am asking. When a c...

I don't believe you understand what I am asking. When a customer asks for a copy of a paid invoice they don't want a statement every time.  I want to be able to add a memo to the invoice in the description section explaining how payments were made.  That's all.  I don't want to put a anything in payment fields.  I thought adding a TYPE account would save us time when typing these partial payments info to the customer and in red they would see it better.  We deal with so many credit memos and partial payments that the lack of this type of field and also the fact that the MEMO field in Quickbooks is useless leaves one to improvise at times.
Established Community Backer ***

I understand. The one invoice won't show Details of other...

I understand. The one invoice won't show Details of other transactions. That is what a Statement provides.
"I thought adding a TYPE account would save us time when typing these partial payments info to the customer and in red they would see it better"
That would create Real Data.
Established Member

Hello nancyl,  We definitely want to help you create well...

Hello nancyl, 

We definitely want to help you create well-designed invoices as this helps promote your brand and present a professional image to your customer. 

At this time, the Payments/Credits field only shows the summary of all the payments and credits applied to the invoice. Another way to include the partial payments and their dates to show on the invoice is to set up a payment item. Please note that this applies to payments only; returns are an exception. 

Here's how we can set up the payment item: 

  1. Go to Lists, and then choose Item List.
  2. At the bottom click Item, and choose New. You can also use the keyboard shortcut CTRL+N
  3. Choose Payment as the Type
  4. Name this payment item. Then, choose whether you'd like to Group this payment to undeposited funds, or Deposit to an account.
  5. Click OK.

You can then use this payment item to record a partial payment on the invoice and reduce the amount owed, too. You can put the date in the description field. 

To answer your second question, yes, we can change the font color in the body of an invoice. I've got the steps for you: 

  1. Open an invoice. Then, choose the Formatting tab at the top. 
  2. Click the Customize Data Layout icon. 
  3. In the Additional Customization window, click the Layout Designer button.
  4. Double click on the data field (Memo) you'd like to customize. 
  5. In the Properties window, choose the Text tab. Then, click the color area. Pick a color, and then click OK.
  6. Click OK to save your changes. 

Just in case you need a little help finding your way around, you can check out the screenshots I've added below. 

We'd love to hear more about how we can improve the customization options for invoices. Send us your feedback or ideas by going to the Help menu (right next to Window) at the top, clicking Send Feedback Online, and then choosing Product Suggestion.

Feel free to let us know if you ever need help with invoices or QuickBooks Desktop in the future─we'll be here.

Frequent Contributor *

Wow...this is exactly what I was hoping for. Can't wait t...

Wow...this is exactly what I was hoping for. Can't wait to test it.  Thank you!
Frequent Contributor *

I'm a little confused on "Name this payment item. Then, c...

I'm a little confused on "Name this payment item. Then, choose whether you'd like to Group this payment to undeposited funds, or Deposit to an account." Will this affect the Deposits or any of my reports?
Established Member

You're welcome, @nancy, and thanks for getting back to me...

You're welcome, @Nancy, and thanks for getting back to me, too.

Let me get those questions cleared up.

In step 4 of setting up the payment item, enter the name for this payment in the Item Name/Number field. (See the first photo above) For example, "Partial Payment". The name that you type in here would also show on your invoices.

Since this is a payment type, we'll need to track these amounts to an account. You would want to choose "Group this payment to undeposited funds" if you want them to post to the Undeposited funds account by default. Just as the amounts you track in the Undeposited funds account, you'll need to deposit the payments to clear them (Banking > Make Deposits). On the other hand, if you want to deposit it to a bank account, income account, or a specific account, you would choose "Deposit to". Yes, this part of the steps will affect your reports.

Let me know if you have any additional questions, and I'll be glad to answer them for you.
Frequent Contributor *

Ok...since we already have all of our accounting methods...

Ok...since we already have all of our accounting methods set up and in place I don't want to shake it up. So what do you think about this?  I would like to setup a "TYPE" Account to use for information use only.   For example I would call the  item "Credit Memo Applied" and then in the Description type the amount.  This way the customer can see what we applied while it doesn't interact with with reports.  Can I create my own "TYPE"?
Established Member

Hi there, @nancyl. Right now, there isn't a way to creat...

Hi there, @nancyl.

Right now, there isn't a way to create your own item type. You can only choose from the ones available in QuickBooks.

If you only want to show payments/credits on the invoices without affecting the transaction and any reports, you can put them in the Message field. You can rename the section header to Memo (Customize Data Layout > Footer). (See the 5th photo in my original answer above) However, you would need to manually type in the information every time.

I'd be glad to hear back from you if you have any follow-up questions.
Frequent Contributor *

Thank you for answer my question about the "TYPE".  That'...

Thank you for answer my question about the "TYPE".  That's exactly what I needed to know.
Established Community Backer ***

I recommend Not Using "Customer Message" because that is...

I recommend Not Using "Customer Message" because that is a List. Every Entry you make will be Saved forever, until you filled that List. That is not a Freeform Text function. Memo is a freeform Text function.
Active Member

Trouble with this is that in Quickbooks we can see the pa...

Trouble with this is that in Quickbooks we can see the payments applied at the bottom of the invoice so if we make a line item then the balance due will be off.  I tried it.  I guess you could 1st make the line item send the invoice go back delete the line item and then take the payment out but that is very cumbersome.  I just had this happen.  I had a client who had an outstanding credit and I took it off her next invoice but it does not show on her invoice only on mine.  It seems like if we can see the true balance due then the clients should be able to as well.
Established Community Backer ***

You don't use a Line item, because putting this on the in...

You don't use a Line item, because putting this on the invoice is the same as "this is paid for the date of the invoice" and not Paid on a different date. Factually, the Payment is its own transaction and has its own date.

You should show it on the Footer; not adding it as a line item. You also can run a Statement for them.

"but it does not show on her invoice only on mine"

You need to Customize your template(s).
Established Community Backer ***

Here is another Option: Open that invoice and use History...

Here is another Option:

Open that invoice and use History icon, or Ctl H. Here is the Report you can Print.

Active Member

That is nice.  I can not find the history icon but the Ct...

That is nice.  I can not find the history icon but the Ctl H worked it would be nice if you could email that report.
Established Member

Re: Hello nancyl, We definitely want to help you create well...

I need help with my desktop Quickbooks. I have a saved invoice which I was going to email to the customer with the payment link. However, he wants to pay partially in person with cash or debit. How do I get that invoice to give me the option to collect partial payment in person instead of emailing it??

QuickBooks Team

Re: Hello nancyl, We definitely want to help you create well...

Hello Desktop2019,

 

It's good to know that your customer will pay you in person. This means you won't wait for the payment to process in your bank account.

 

When they pay you, you can open the invoice and enter the amount you receive in the PAYMENT AMOUNT field. If they want, you can print them a copy of the partially paid invoice. Then, they can just ignore the emailed invoice.

 

If you need anything else, feel free to comment below.

Active Member

Re: How do I show a partial payments applied to invoices?

If you edit the invoice template, there are data fields available for 'Payments/Credits' and 'Balance Due'.  These fields reflect any payments or credits that are applied to the invoice.

 

If you don't want these fields to show up on all invoices then copy your existing template and modify the new one. Then select the new template only for invoices with partial payments or credits applied.

Active Member

Re: Hello nancyl, We definitely want to help you create well... Is this option available in Quickbooks online? I don't see the "item list" where do i find it?


@IntuitJill wrote:

Hello nancyl, 

We definitely want to help you create well-designed invoices as this helps promote your brand and present a professional image to your customer. 

At this time, the Payments/Credits field only shows the summary of all the payments and credits applied to the invoice. Another way to include the partial payments and their dates to show on the invoice is to set up a payment item. Please note that this applies to payments only; returns are an exception. 

Here's how we can set up the payment item: 

  1. Go to Lists, and then choose Item List.
  2. At the bottom click Item, and choose New. You can also use the keyboard shortcut CTRL+N
  3. Choose Payment as the Type
  4. Name this payment item. Then, choose whether you'd like to Group this payment to undeposited funds, or Deposit to an account.
  5. Click OK.

You can then use this payment item to record a partial payment on the invoice and reduce the amount owed, too. You can put the date in the description field. 

To answer your second question, yes, we can change the font color in the body of an invoice. I've got the steps for you: 

  1. Open an invoice. Then, choose the Formatting tab at the top. 
  2. Click the Customize Data Layout icon. 
  3. In the Additional Customization window, click the Layout Designer button.
  4. Double click on the data field (Memo) you'd like to customize. 
  5. In the Properties window, choose the Text tab. Then, click the color area. Pick a color, and then click OK.
  6. Click OK to save your changes. 

Just in case you need a little help finding your way around, you can check out the screenshots I've added below. 

We'd love to hear more about how we can improve the customization options for invoices. Send us your feedback or ideas by going to the Help menu (right next to Window) at the top, clicking Send Feedback Online, and then choosing Product Suggestion.

Feel free to let us know if you ever need help with invoices or QuickBooks Desktop in the future─we'll be here.



@IntuitJill wrote:

Hello nancyl, 

We definitely want to help you create well-designed invoices as this helps promote your brand and present a professional image to your customer. 

At this time, the Payments/Credits field only shows the summary of all the payments and credits applied to the invoice. Another way to include the partial payments and their dates to show on the invoice is to set up a payment item. Please note that this applies to payments only; returns are an exception. 

Here's how we can set up the payment item: 

  1. Go to Lists, and then choose Item List.
  2. At the bottom click Item, and choose New. You can also use the keyboard shortcut CTRL+N
  3. Choose Payment as the Type
  4. Name this payment item. Then, choose whether you'd like to Group this payment to undeposited funds, or Deposit to an account.
  5. Click OK.

You can then use this payment item to record a partial payment on the invoice and reduce the amount owed, too. You can put the date in the description field. 

To answer your second question, yes, we can change the font color in the body of an invoice. I've got the steps for you: 

  1. Open an invoice. Then, choose the Formatting tab at the top. 
  2. Click the Customize Data Layout icon. 
  3. In the Additional Customization window, click the Layout Designer button.
  4. Double click on the data field (Memo) you'd like to customize. 
  5. In the Properties window, choose the Text tab. Then, click the color area. Pick a color, and then click OK.
  6. Click OK to save your changes. 

Just in case you need a little help finding your way around, you can check out the screenshots I've added below. 

We'd love to hear more about how we can improve the customization options for invoices. Send us your feedback or ideas by going to the Help menu (right next to Window) at the top, clicking Send Feedback Online, and then choosing Product Suggestion.

Feel free to let us know if you ever need help with invoices or QuickBooks Desktop in the future─we'll be here.


 

QuickBooks Team

Re: Hello nancyl, We definitely want to help you create well... Is this option available in Quick...

Hello Jairo,

 

Thank you for joining the thread here in the Community. I'm here to help provide clarification about the information provided by my colleague above.

 

The steps on how to create a payment item are only applicable for QuickBooks Desktop users. For those who are using QBO, you can directly make partial payments by only receiving the only part of what the customer owes on the invoice.

 

Here's how:

 

  1. On the left panel, click Sales.
  2. Go to the Customers tab.
  3. Click the customer name.
  4. Search for the open invoice.
  5. Click Receive payment.
  6. Below Amount received, enter the partial amount.
  7. Click Save and close.

Check out these screenshots:

 

1.PNG

 

2.PNG

 

For more insights into recording customer payments, check out the article I recommend on this:

 

Record a customer payment.

 

Feel free to let me know if you need further assistance with the payment process in the Online version. The Community is always up to lend a hand.