Report: Payment Method is VISA

TD98250 · ‎March 30, 2021

How can I create and save a report in Quickbooks Desktop for Mac 2021, where all my received payments are from credit cards?

jamespaul · ‎March 30, 2021

Hello, TD98250.

Thanks for the screenshot and the details! After tinkering around the Deposit Detail report, I'll share the details on why it won't show the filtered payment method.

The Deposit Detail report pulls the data based on the bank accounts listed. It doesn't actually pull the data from the affected accounts (Undeposited Funds, income accounts, etc..). Rather, it will only list them since it needs to have a detailed view on all of the deposits made within a specific period.

The only time it'll show the filtered payment method is when you directly deposit any invoice or sales receipt payments (without using the Bank deposit function).

When that happens, it tags a selected payment method beside the bank account.

I took a another look at your screenshot and I see that your transactions were deposited using the Bank deposit function. This is the reason why your results show a blank page.

I'll demonstrate using a couple of screenshots below:

If you need to see which payment method would a transaction fall under, you can run another report. For example, the Transaction List by Account report.

If you need help building a specific report in QuickBooks Mac, you can check these articles:

Need to record other transactions or need to work on other areas in QuickBooks? We have other articles to guide you through the processes. Check them out if you need assistance.

I'll share some guides or information again if you have questions about the reports or in QuickBooks Mac. Happy to help.

View solution in original post

ReymondO · ‎March 30, 2021

Good day, @TD98250.

I'm here to make sure you'll able to create and save your report in QuickBooks Desktop (QBDT) for Mac.

You can create a report to find information about your banking transactions in the program. All you have to do is to use the Banking report to get these data. Here's how:

Go to Reports and select Report Center.
Double-click the type of report you want to create. Just click the Banking report to get its info.

Additionally, you can customize it to see the data and style you’d like.

You can also check this article to get a better understanding of reports in QBDT for Mac: Learn about reports in QuickBooks Desktop for Mac.

Should you have any follow-up questions or concerns about this process, don't hesitate to post again here in the Community. I'll be there to provide you answers. Take care and have a good one.

TD98250 · ‎March 30, 2021

OK, thank you that was very helpful - Now I'm looking at a Banking Report "Deposit Detail" and I was able to add some customization to it. I don't have a "CUSTOMIZE" button that I can see, but I do have "OPTIONS", "FILTERS" and "FORMAT". I was able to add "PAY METHOD" from the OPTIONS tab and now I see all of last year's deposits. Every one shows either "Check" or "VISA" under the PAY METHOD column.

When I open the FILTERS tab, and click on SHOW ALL, I see that I can add a "PAYMENT METHOD" filter, (not "PAY METHOD") and I have the option to choose to show only CHECK, only VISA or both (along with American Express, Cash and all the others, but I don't use those - only CHECK and VISA).

Problem is, as soon as I click to show anything other than "ALL PAYMENT METHODS", all the transactions disappear.

Note: I'm including a couple of screenshots.

Any help with this oddity would be greatly appreciated - Thanks!

jamespaul · ‎March 30, 2021