Customer statement showing invoices and payments applied to each.

Customer Balance Detail Report

Will

Thanks for your response, but the Customer Balance Report shows the Invoices we created and the Customers Check Number, but does not provide information showing which invoices were paid by each check.

Some of my customers have 7-10 invoices per week.  They want to be able to see which invoices we applied each of their checks to.  The only way I can find is to go to 4ach "Payment", view transaction history and print that.  However, the customer may pay a portion of an invoice with more than one check, which makes them have to look at multiple reports and figure it our, or, usually, I have to do that for them.

I worked on one customer yesterday and today.  It took between 3 and 4 hours to reconcile their account; printing 45 sheets of paper and creating an Excel spreadsheet to try to explain it to them.

Please help me figure out an easier way to do this.

You are right that the Customer Balance Detail Report does not show this information and I don't know of a report that does. However, this report may well exist or someone else may have created one.
I am curious about why the Customer who is issuing these checks is not "applying" them to the Invoices in their accounting sustem  and on their check stub? For instance, when I pay mutiple bills from a Vendor the Voucher Check Stub shows each bill being paid. Since I have a copy of that Check Stub then there is no need for a report from the Vendor. Does this make sense?

Will

I agree the customer should know which invoices are being paid, but some of our customers have a lot of turnover, partly because people do not follow directions, and their records are not properly maintained.  Of course, the customers with the greatest volume of transactions with us are the ones that need help figuring out what they truly owe.

A report that shows a link between the Invoice and Payment document numbers would help my people to help our customers.

I agree, but you know how customers are.

I am looking for the same report.  I have tried to create it, but there are no data fields available in the customization.

I send my vendor payments and the ck stub indicates what the payment is to be applied to.  BUT, it doesn't always get applied the way I have designated. 

We really need a report like this as well.  I haven't found anything that includes what seems like very simple information.  Our clients are individuals and we often have to demonstrate to them which check was applied to which invoice.  Since they sometimes pay multiple invoices with one check, it is not obvious as to how payments were applied.   QB definitely needs to create a report that shows which invoice a payment is applied to.  We shouldn't have to go through multiple windows and reports to collect this basic information.   It turns a very simple, basic request into a task that will take me at least an hour or more.  Very annoying.

There may have only been three users that al posted responses in agreement on this subject, but there are countless others that just didn't respond, or that don't use this forum.  Those of us that use an "Open Item" accounts receivable system need this simple/basic report.  I can't even download a set of reports that have information that would allow me to use VLOOKUP or write a Macro to match the payments and invoices together so I could prepare a report in Excel.  It is a manual process.

I just spent over an hour on a conference call with a customer and her credit card company reconciling her payments for the last couple of months.  We allow a 20% down payment with an order with the balance due in 14 days.  Many customers pay with a credit card and they place their orders at different times, often placing a new order before the previous order was paid.  The customer know the date they requested the item, but do not know the date we actually batched the transaction (usually the same day, but sometimes the next day), then there is the date their credit card company processed the transaction, and the date we received reimbursement.  Their credit card transaction does not show our invoice number making reconciliation hard for them as well as us.

This reply is about 8 months after the original post, but I have been working with QB for over 6 years and this report has caused me many hours of explanation to customers.  It doesn't really matter if my customer should keep these records their selves, I should be able to provide any report they ask for within reason. 

My credit card statements show my payments and purchases.  I am totally amazed that QB can't provide this report.  My customers may have a balance due on 15 invoices of 40,000.00, but they might only pay 16,500.00.  I, me, myself and I and the customer should be able to see where I applied their payment.  They also may come in and purchase product and pay for it.  I apply their payment to their oldest bill.  Again I should be able to show them where and how I applied their payments, not a list of invoices and payments or printing 50 pages of paper. 

I am getting ready to go to court for a small claims collection and I need this information, but instead of printing out a report that would take less than 30 seconds, I am going to have to spend at least 6 hours researching and compiling this information and making an excel spread sheet.

Someone must have come up with something by now.  Hopefully my post will que somewhere and someone will have the answer for us all.

I needed this information as well for reports and i just want to say THANK YOU for taking the time to describe it.  I haven't done it yet, so I hope it does work and will be trying it Monday.  I felt so STUPID when a customer asked me for this report and i coudln't figure out how to do it.  The report is something that a lot of my customers need and again THANK YOU!

I can't believe this question is marked SOLVED.  REALLY

It isn't solved, it's still a convoluted mess.  BUT, BurtonCPA, Thank you for at least getting me to a report, as convoluted as it is, does show the payment applications. 

I wish I could get it to show only the invoice totals and the payment applied and then the balance of that invoice, either paid of balance still due.  Right now it show EVERY item purchased on that invoice, including tax as a line item.  Each invoice is about 30 lines long!  OMGoodness.  What a train wreck.

I just wonder does anyone from QB look at this forum and try to resolve the issues, or is it just for the users left to their own demise?  HAHA.  MMMMM

try going to the customer center select the customer    then where you see the 3 filter selections select all then the date range you want right click and select view as report.  you can print from there.   at least you can with pro 2011

Also, if you only need to show this for one customer and there are not a lot of payments - you can add a memo in the payment window that will appear on a statement. I just wrote in the memo field "Paid on Invoice 4603". You could always start to do this when you are entering payments.