Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We add "previous balance" to invoices but it's including the CURRENT invoice. So if they owe $100 from last month and today's invoice is $50, it shows a previous balance of $150. How can we show only $100 as a prior balance on a current invoice? Is it possible?
Solved! Go to Solution.
Changing the Balance Total column to show the previous balance only is unavailable, TTI.
You'll want to use the Transactions tab in the Customer Information window. Then, filter the date to see the previous balance.
I've added a screenshot for you.
You can always swing by if you need help with anything else.
@Anonymous
Please Learn from this input. The function for this is Customer Total Balance, from template customization on the Footer Tab. You also see Job Total Balance.
Total = this sale on this invoice.
Payments/Credits applied = applied to this invoice.
Balance Due = this invoice.
Job Total Balance = this invoice + other open balances for this one job.
Customer Total Balance = this invoice and all open invoices for all jobs for this same one customer.
What you seem to describe is you Added an actual Charge item to this invoice, which means you Added a charge to this Sale; that isn't notational but functional. You just billed them for the same amount twice: Old invoice balance and this Amount here.
The Create Statement is meant to be used for showing AR Activity, and make sure to enable the Aging table for the customer to see.
Changing the Balance Total column to show the previous balance only is unavailable, TTI.
You'll want to use the Transactions tab in the Customer Information window. Then, filter the date to see the previous balance.
I've added a screenshot for you.
You can always swing by if you need help with anything else.
So you're saying that I'd have to look up (per customer) the prior balance and type it in? If that's the only solution, (and I really appreciate your input), that's hardly a solution that we could implement when generating invoices. Our only solution seems to be to delete it from the invoice altogether which has been a really useful feature BUT takes too much explaining to clients who have been overpaying: the current invoice + prior balance). Wow. (Been using QB since 1998 and am still stunned by what it doesn't do.)
Hello TTI,
We'd like to help. However, we'd need to get more details. Is it okay with you to attach a screenshot of this invoice?
Thanks in advance!
I appreciate your help. I attached the print preview (where the issue is, in the red box). I whited-out client information. The print preview shows that we re-worded it to say "Previous balance including this invoice," which is what we want to change so it's JUST any previous balance (in this case, it should be zero). If you can help, it will solve a recurring problem whenever we send invoices! Many thanks!
Pleased to hear again from you, @TTI.
I appreciate you for sending us a screenshot and for elaborating your concern.Let me share additional information on how you can send send an invoice with the previous balance to your customer.
Currently, the ability to show the breakdown of your Total Invoice Balance on the current invoice is currently not available. Although you have the ability to modify the names of the boxes or item label on the invoice, it will only show: Current Invoice Total, Sales Tax (if applicable), Total, Payments/Credits and the Total Account Balance (includes the previous ones).
You need not to worry, you have two options to show your customers previous invoice balance.
On the other hand, I can see how showing your previous invoice balance would be helpful for you and your business. I’d be glad to forward these suggestions to our Product Engineers for consideration in future updates. You can also submit any suggestions, feedback and requests for product improvements.
Here’s how:
If you need further assistance with the steps, I'd recommend reaching out to our Technical Support Team. A specialist will be able to access your account and walk you through via secured remote access session.
Here's how to contact us:
Please don't hesitate to click the Reply button if you have other questions about creating an invoice in QuickBooks Desktop. I'm always here to lend a hand.
@Anonymous
Please Learn from this input. The function for this is Customer Total Balance, from template customization on the Footer Tab. You also see Job Total Balance.
Total = this sale on this invoice.
Payments/Credits applied = applied to this invoice.
Balance Due = this invoice.
Job Total Balance = this invoice + other open balances for this one job.
Customer Total Balance = this invoice and all open invoices for all jobs for this same one customer.
What you seem to describe is you Added an actual Charge item to this invoice, which means you Added a charge to this Sale; that isn't notational but functional. You just billed them for the same amount twice: Old invoice balance and this Amount here.
The Create Statement is meant to be used for showing AR Activity, and make sure to enable the Aging table for the customer to see.
I guess I can't have what I want or need in an automated fashion. Thanks for clarifying.
Thanks for getting back to us, @TTI.
I appreciate you for following the information provided by my colleagues and our Established Community Backer above. Since the option you're looking for is unavailable, I encourage you to send a feedback directly to our product developer for future updates.
Here's how you can send a feedback:
Please know that you're always welcome to post if you have any other concerns. We're always here to help you out.
"I guess I can't have what I want or need in an automated fashion."
Yes, you enable the Customer Total Balance and/or Job Total Balance from the Footer tab of Additional Customization for the template, and Yes, the program will fill in that value for you. As I noted, I use this for monthly invoicing for a template for customers that are not paid in full by that next month's invoice. That's is how you Can Have what you want.
We have the same problem. We want to show the exact amount due from previous invoice on the line above "Total balance due". Some clients end up overpaying because it is confusing. Only thing we came up with to do is send a statement along with the current invoice but that's extra work.
I believe this was answered in an earlier reply (and I should have marked it as solved). That is "Changing the Balance Total column to show the previous balance only is unavailable, TTI."
In other words, we can't show the previous balance owed without including the new invoice charge (in Desktop). I'll mark this as solved, but I still think that feature needs to be included. Thanks for your explanations, they helped.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here