Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
LizzyboBizzy
November 12, 2019
Question

Transaction Detail by Account

  • November 12, 2019
  • 1 reply
  • 5 views

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?

1 reply

S
SarahannC
Level 9
November 12, 2019

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:

 

  1. Go to the Reports menu.
  2. Click Account & Taxes.
  3. Select Transaction Detail by Account
  4. Click the Customize Report button.
  5. Select the Display section.
  6. Enter Pay Meth and put a check on it.
  7. Click OK.

 

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. 

L
LizzyboBizzyAuthor
November 12, 2019
Thank you for your response.  I have done that the Pay Meth column is there  but nothing shows.  We process the credit card payments through quickbooks; the payments are there - they just don't show in any reports. 
 
S
SarahannC
Level 9
November 12, 2019

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:

 

  1. Match the credit card payment by selecting Add Payment.
  2. Then, create an invoice by clicking the Need Invoice link?.
  3. Once done, you can now apply the payment clicking the Receive Payments menu inside the Invoice page.

 

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement