Skip to main content
D
Deadwood Al
March 3, 2025
Question

How do I ....?

  • March 3, 2025
  • 2 replies
  • 0 views

I started with Deposit Detail report.  In the column selection options, I included "Pay Math" (QB moral values police won't let me enter the name of the option that THEY use in the QB system ... sort of the QB "double standard" at work!).  This options shows if the customer paid with a check, credit card, ACH, etc.

 

What I am trying to get is a report that shows the payments deposited ONLY from credit cards during a range of dates. Unfortunately, Pay "Math" isn't an option in Filtering. (Another minor fubar from the crack design team!) 

 

**** Does anyone know how to generate a report that would show ONLY credit card deposits within a variable range of dates? ****

 

Thanks in advance.

2 replies

D
Deadwood AlAuthor
March 3, 2025

I forgot to mention ... Payment Method is NOT the same as Pay "Math" .... another wonderful example of the crack design team naming convention for report options. I know that Payment Method does not work.

S
ShangY
March 3, 2025

I appreciate your detailed concern, @Deadwood Al. I’m happy to share some insight about generating a report that shows credit card deposits and filters specific date range by making sure the account used is not Undeposited Fund. Then, I'll guide you on the Filters tab and modify it to credit card-only transactions. 

 

Before anything else, please know that Undeposited Funds account is used for tracking funds that are not to be deposited to the bank account yet. This is why transactions tied to this account won't show in the Deposit Detail report. I'll outline the steps below:

  1. Navigate to Checking Preferences and untick the Undeposited Funds as default deposit to account.
     

     

  2. Next, change the DEPOSIT TO account from the transactions (receive payments, sales receipts) to the right account.

     

  3. Then, proceed to the Deposit Detail report and select the Filters tab.
  4. Type Payment Method in the CHOOSE FILTER section to filter based on how customers paid.
  5. From the Payment Method drop-down, select Multiple payment methods.
  6. Check the box for Credit card to include only those transactions.
  7. Once finished, click OK.

     

  8. Lastly, filter the date and run the report once more.

     

In addition to this, you can create, edit, or delete memorized transactions in the future. This capability allows for greater flexibility and ensures that your transaction history remains up-to-date and relevant to your current needs.

 

Let me know if you have any additional questions or clarifications about the solution I provided. Feel free to tag me in the comments below. I'll respond to you as soon as I can. Your concern is important to me and I'm always available to help. Have a good one.

D
Deadwood AlAuthor
March 3, 2025

It seems that this is another example of how Team Members don't really read the post from users, OR they don't fully understand.

 

"Pay Method" and "Pay M(e)th" are not the same and not interchangeable. I tried following these instructions exactly (again!!) and ended up with a report that is completely blank. Someone needs to explain to ShangY the difference between those two options/fields/whatever. It would be helpful if someone in QB/Intuit with some authority would tell the design group that their naming convention needs improvement and if they allow the option "Pay M(e)th" in the display option, they SHOULD ALSO ALLOW IT IN THE FILTER OPTION!

 

I have no idea how your example ends up with data ... mine does not, following your instructions exactly. Perhaps you are using QBO instead of Enterprise, and perhaps that was fixed before Enterprise. I have tried this repeatedly, and I am hoping that someone has found a way around the limitations in Enterprise.

 

ShangY ... please contact someone in QB to explain to you the difference between the two fields that sound very similar but aren't, 

J
JoanaC
March 3, 2025

Hi there, Deadwood. The Payment Method and Pay Meth in the report are the same, and they reference the method of payment made. Allow me to clarify this information with you.

 

The payment method displayed in the report is based on how it was initially listed at the time of creation. For instance, if a payment transaction is recorded as a check, we have to include the check option in the filter field to ensure it appears in the report.

 

To address this, we can clear the current filter, add the check payment method again, run the report, and set the desired date. Here’s how:

 

  1. Go to the Reports menu.
  2. Hover over Banking and select Deposit Detail.
  3. Click on the Customize Reports tab.
  4. In the Filters tab.
  5. Type Payment Method, then click Remove Selected Filter.
  6. Recreate the filter again. Set the date you want to show.

 

If you still encounter the same error after adding the check in the filter field, I recommend contacting our support for further assistance with this error in QuickBooks Desktop.

 

You can check out this article on setting your preferences when running a report: Set report preferences.

 

Let me know if you still have more concerns about your report. We'll attend to it as soon as possible. Have a good day.

Terms & ConditionsAccessibility statement