cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Deadwood Al
Level 6

How do I ....?

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.

5 Comments 5
Deadwood Al
Level 6

How do I ....?

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.

ShangY
QuickBooks Team

How do I ....?

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.

     
    image (5).png

     

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

    image (6).png

  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.

    image (7).png

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

    image (8).png

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.

Deadwood Al
Level 6

How do I ....?

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, 

JoanaC
QuickBooks Team

How do I ....?

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.

Deadwood Al
Level 6

How do I ....?

to Joana C (QuickBooks Team) ...

You say "The Payment Method and Pay M(e)th in the report are the same, and they reference the method of payment made. "

AdonL (QuickBooks Team) says "Please know that the PAYMENT METHOD field is designated for sales transactions like receipts and customer payments, recording the method used to process these transactions. While on the other hand, the PMT M(E)TH field is utilized for categorizing bank deposit transactions, indicating through which funds are deposited into your bank account.

 

These two fields are distinct within QuickBooks and serve different purposes in recording transactions. Thus, the program doesn't match the filter with bank deposit entries, showing an empty Deposit Detail report. For detailed insight into how these fields are used and how this affects report data, check out this article: Reports in QBDT."

 

So this is an example of what I have been saying that QuickBooks Team members give inconsistent answers, likely because they are following a script instead of responding from personal knowledge of using the system in the same way that real-world users do. My post looking for some alternate workaround solution to printing a report showing only credit card deposits started from the premise that the two fields were separate and distinct and did NOT reference the same thing ... which is likely why my report is coming up blank. 

 

Now I don't really know whether AdonL or Joana C is correct ... I would guess AdonL because my report is blank, but I don't know that for sure. I was hoping that some USER had found a way to accomplish this, but 99% of the responses to general "help me" questions are from Team Members, and frankly, I don't trust most of them ... as you probably can gather based on the two completely different answers I've received to the same question as shown above. 

 

You know, if I was a senior management person at Intuit / QuickBooks and had any idea of the responses coming out of the community, I would really be embarrassed. Of course, I don't believe that top management even knows about the community and how wildly inconsistent the answers given tend to be.

 

Still waiting to see if any USER might have an idea that would work.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us