We have a catering company where I need a report that shows not the date of an invoice but the Event Date, transaction by account and the Payment Method. I have run a Transaction Detail by Accofiltered for all the other results except that the Payment Method does not show. Any ideas what I need to do to get that column showing in the report?
I'd be glad to help you with this, Lizzybobizzy1.
Let's customize this report to add the Payment Method column. I'll guide you how:
Also, you can visit this article to learn more on how you can customize this report.
If you need more help with the QuickBooks reports, just post them right away. I'm just here to help you out.
Thanks for getting back to me with additional info, LizzyboBizzy.
QuickBooks reports can't pull up the payment method that was processed through QuickBooks Payments. Though the payment method column was being added to the report, it’ll only show data that was done inside your QuickBooks account.
You'll have to manually apply the payment to the invoice by going to the Customers menu then receive the payments there. This way, your credit card payments will be able to show on the report.
Let me guide you how:
Once done working these steps, you can now run the Transaction Detail by Account and add the Pay Meth column. This helps you see the credit card payments. Also, you'll want to read this article in your free time. It's all about customizing QuickBooks reports.
Get back to me anytime if you have further questions. I'm always here to help you.
Thank you for your response. I have done that; the Pay Meth column shows in the report - but nothing is there. We process through QB; the info is there - it's just not showing in any reports.
Thank you again for your response. That is how we post the payment to the invoice. But, still, nothing shows in the Pay Meth column. I'm at a loss as to why it's not showing.
Thank you once again for your response. We do post our payments as you described and the invoice shows as paid. Still, though, nothing shows in the Pay Meth column.
Thank you for your prompt reply, as well as providing more details on your situation.
You mentioned in your initial post that you've already tried to filter the Transaction Detail report. Now, let's customize it a bit further to show the data you're looking for.
Assuming you already have the Transaction Detail report open:
Knowing that you've already ticked the Pay Meth column, selecting payments and sales receipts will show up on your reports, along with their recorded payment methods. As stated on the steps above, payment method applies to payments and sales receipts. This doesn't include invoices, as well as transactions processed through our QuickBooks Payments.
Other options on how you can customize reports in QuickBooks Desktop are listed in this article: Customize reports in QuickBooks Desktop.
Post a comment below, in case you have other questions in mind. I'll get back to you.