Is there a way to print out a customer payment that lists all the invoices applied to that payment as well as the amounts that were applied? (I can't find a way to edit the payment history report to show what I need)
I am trying to track down some payment errors and I want to print the last 10 payments for a particular customer. I need it to show what invoices each payment/check applies, the original invoice amount and the amount(s) deducted for each invoice from that payment.
There is no report available, however drilling down on the receipt will give you the information you seek.
The payment history for each of the last 10 payments should have what you need. If not then you'll need to print the invoice history for each of the invoices mentioned on the payment history.
Like I said there is no report that you can print out with all the information the OP wants to see on the report itself.
OP?
I take it I'm just going to have to either do screen dumps or copy everything I need into a spread sheet program and work with the data that way. Another A+ to Intuit. I've noticed other people requesting this very thing dating back to 2003 and still nothing available in the program. Not a big QB fan.
Allan Mart> >>> Is there a way to print out a customer payment that lists all the
We sell a program that may give you the data you need. See screenshot number 5 at
OP - Original Poster. The term is used often when you are replying in the middle of the thread.
In any case, you won't get what you want as a canned report in QB. I would not expect it at any time soon.
Why screenshots and spreadsheets? For a single customer, won't the payment history report do? As has been pointed out, you can 'drill down' from the report to specific information.
You might also try creating a statement for your customer. Perhaps you can see the 'payment errors' that way.
I'm with you Lisa. On a single customer there isn't need for all that detail. Just get the list of what payment should have paid what invoice (and how much) from the customer and set the payments that way. Then print a statement and any invoices that now show open balances. Problem solved, except for the A/R clerk who can't apply payments correctly.
I could see somebody with maybe hundreds of payments mis-applied wanting to try this on paper rather than on screen, but they are still going to have to go on screen to set things right.
Tip, use that memo field on the payment screen when you have those oddball payments and you make choices as to what gets paid. That way when you come back later to fix it, you'll know what you did.
Agreed, the ability to print customer transactions with the option to show applied details is what you get as you move up the software food chain.
I've seen this feature requested many times, going back years now.
The reason *I* would need, find benificial, find useful, desire, this information is because we have some clients that send us checks that often do not reference the invoices they are paying. So we play the game where we spend up to an hour sometimes trying to select the correct invoices until they match the check amount. It's really a fun game. :(
When we do receive a check that has the the invoices listed, we, more often than not, reliaze that their are invoices listed on this check that we have already applied payment from previous checks. By having the ability to print the last couple of checks and which invoices they applied to and the amount applied to that invoice, we can quickly see where the problem lies and adjust for it.
I don't think I need a $3k+ accounting package. I'm not asking much here. It seems that I get the features QB (Intuit) tells me I want but not what what the user really wants and requests.
Allan Mart> >>
If it will take up to an hour then it behooves you to call the customer and ask which invoices they want the payment applied to.
I agree. Intuit has an almost 90% market share because users find the word QuickBooks warm a fuzzy, not because of the features they offer.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.