cancel
Showing results for 
Search instead for 
Did you mean: 
Lizzybobizzy1
Level 1

Transaction Detail by Account

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?

7 Comments 7
SarahannC
Moderator

Transaction Detail by Account

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. 

LizzyboBizzy
Level 1

Transaction Detail by Account

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. 
 
SarahannC
Moderator

Transaction Detail by Account

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.

LizzyboBizzy
Level 1

Transaction Detail by Account

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.

LizzyboBizzy
Level 1

Transaction Detail by Account

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.

LizzyboBizzy
Level 1

Transaction Detail by Account

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.

Ryan_M
Moderator

Transaction Detail by Account

Hi @LizzyboBizzy,

 

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:

  1. Click the Customize Report button.
  2. Go to the Filters tab.
  3. On the Search Filters search box, type in "transaction", then select TransactionType.
  4. On the TransactionType drop-down menu, select Multiple Transactions Types.
  5. Tick Payment and Sales Receipt (if you record this type of transaction).
  6. When done, click OK, then hit OK again.

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us