Skip to main content
D
Deadwood Al
September 19, 2024
Solved

Report driving me batty!!!!!

  • September 19, 2024
  • 2 replies
  • 0 views

I'm probably missing something really plain and simple, but I am spinning my wheels ....

 

I want a report to show all deposits for a month that were paid via credit cards.  Under Banking, I select the Deposit Detail. In the filter, I added Payment Method, so that then shows up on the report. I then tried to filter Payment Method of "Credit Card" and the screen goes blank. No matter what Payment Method I filter for, it shows nothing at all, even though cash, check and credit card all appeared when I wasn't filtering .

 

Am I doing something wrong? Why won't it filter or Payment Method? Help!!

Best answer by BigRedConsulting

Let me provide a little more info ....

 

There were a number of credit card entries that were entered directly into Deposits, never having been first entered as a receipts via the "Receive Payments" process in the Customer Center. I wanted to identify all of these and remove them as they were duplicates of dollar amounts entered via entries from a POS system. So yes, I understand how the system works. 

 

I printed a Deposit Detail report for the period where most of the entries occurred, and filtered Transaction Type to only show Deposits, and then filtered Payment Method to show if payment was made by credit card. It actually showed payments made by Cash, Check Money Order , and ACH. I then tried to filter so it only showed the credit cards. This resulted in the blank screen. 

 

I was eventually able to achieve my goal by just manually identifying the credit card entries and ignoring the other payment methods. We do have payments that are received directly via deposits and not "Payments Received" because we receive funding to reimburse allowable expenses, so there are a significant number of entries that bypass the Undeposited Funds type account.

 

But I do thank you for the links you provided. Perhaps some of them will help in this or other areas.                                                                                                                             


@Deadwood Al 

- The Deposit Detail report is based on a pre-fixed 'view' to the data that makes your efforts to further filter it not work. Intuit should know this.

- There is only one payment method field, though it appears both as "Payment Method" and the shortened "Pay Method" (without the 'od', because this site stupidly thinks the first 4 letters of that are a bad word) in the reporting user interface, for no good reason. Intuit should know this.

- Based on the behavior you mention, which Intuit could duplicate simply by trying it, there is nothing wrong with your data file. Intuit should know this.

 

To create a report showing all of the line items from your deposits using just a specific payment method, start with a Custom Transaction Detail report from the Reports | Custom Reports menu.

Then add the following filters:

- Transaction Type = Deposit

- Payment Method = Credit Card (or whatever method(s) you want to see).

Then add the Pay Method column to the report and delete whatever columns you won't want.

That's it!

 

Intuit should know this.

 

2 replies

JoesemM
JoesemM
September 20, 2024

You're on the right track, including the payment method when running the Deposit Detail report, Deadwood Al. Let's verify the customization of your report to ensure that it will show details when running the report.

 

You'll want to review the customization of your Deposit Detail report and ensure that you check the Detail level in the Filter column and click Summary only. That way, it displays the payment for your transactions. See the screenshot for visual reference.

If it's filtered correctly, let's utilize the verify and rebuild data tool to fix data damage on your QuickBooks Desktop company file. The verify tool finds the most common issues in a company file and the rebuild tool fixes them.

 

To verify your company file data:

 

  1. Go to Window then select Close All.
  2. Click File, then select Utilities.
  3. Select Verify Data. If you see:
    1. QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
    2. An error message—search for it on our QuickBooks Desktop support site to find out how to fix it.
    3. Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

 

To rebuild your company file data:

 

  1. Go to File, Utilities, and then select Rebuild Data.
  2. QuickBooks will ask you to make a backup before it rebuilds your company file. Select OK. A backup is required before you can rebuild.
  3. Choose where you want to save your backup, then OK. Don’t replace another backup file. Enter a new name in the File name and select Save.
  4. Click OK when you get the message Rebuild has completed.
  5. Go to File, select Utilities then select Verify Data again to check for additional damage.

 

For more details, see this link: Verify and Rebuild Data in QuickBooks Desktop.

 

Also, you can run another report to display the payment methods such as credit cards. Click the Custom report, select Transaction Detail, and filter the columns by payment method.

 

Refer to this article to learn more about how QuickBooks generates reports, and to see the complete list of available reports in QBDT: Understand reports.

 

If you have any concerns or questions about running reports in QBDT, feel free to leave a comment below. I'm always here to help.

D
Deadwood AlAuthor
September 20, 2024

This is my second attempt to respond, but the QuickBooks Design Team scores again ... I used the same word that QB uses to describe the field for the Payment Method and what I was trying to filter on. Think the first four letters of the Payment xxxxod. Once I got the notice that I used a "bad word. Please correct it and try again." No matter how many changes I made I was unable to get the message to send. So now I need to spend MORE TIME doing something over that is absolutely STUPID!!!!

 

The response by the Moderator is another example of a QB employee either not reading the original message OR not understanding the message. I obviously know how to filter the report to show only Deposits, and than in the next field for Payment Method, to display the way in which the payment was made. What the respondent completely missed was that I wanted to know WHY I was unable to add an additional filter underneath Payrment Method to show only Credit Cards! If I try to add ANY unique method in this filter, I get a beautiful, expansive white screen with the report headings. No data. WHY? Did the crack design team not assume users may want to use multiple filters?

 

I am still looking for someone to either tell me HOW to get the report I am looking for (Deposits only, display Payment Method for ONLY one of the payment methods), OR to tell me that QuickBooks doesn't have the ability to do an additional filter on that field. I'm guessing that it is either a software bug OR that QuickBooks never assumed users would want to filter on that field.

 

If a bug, I will, of course, submit Feedback. So please, don't take the time to tell me how to do that - I DO know. I'll also mention that the option to filter SHOULD include the option for NOT. Sometimes it is easier (less time) to identify a particular type  you DON'T want to see in a filtered display or report than it is to identify all the items you do want to see. Maybe sometime the crack design team at QB will become aware of that as an option in filtering and find a way to implement that. I'll likely be worm-food before that happens, but still...

    D
    Deadwood AlAuthor
    September 20, 2024

    Oh, and Verify and Rebuild? It happens that I did both the day before I tried to run the report, and it isn't necessary to tell me HOW to do those.

     

    I would strongly suggest that ALL QB Team Members become aware of how condescending it sounds when you explain things as a routine to people who may have heard it many many many times. You could soften the blow by simply beginning the explanation by adding something.

     

    "I obviously don't know if you have experience in Verify and/or Rebuild, but those may help. If you know how to run a Verify and a Rebuild, you can skip the next part. If you are not familiar with them, here are the ways to run those functions."  THEN give the instructions.

     

     

      JenoP
      JenoP
      September 20, 2024

      I want to start by saying we've heard your feedback about how the responses and steps are presented, Deadwood Al. I would like to take this chance to clarify how the program makes use of the payment method fields.

       

      The PAYMENT METHOD and PMT METH fields are two distinct fields in QuickBooks Desktop.

       

      The PAYMENT METHOD field is used in sales transactions, such as sales receipts and customer payments.

       

       

      On the other hand, PMT METH is used in bank deposit transactions.

       

       

      Therefore, if a filter is added for PAYMENT METHOD to the Deposit Detail report, no data will be displayed if you're basing the report from bank deposits. However, it will show data if you have sales receipt or customer payment that are directly posted into the bank, without first being held in the Undeposited Funds account. 

       

      To learn more about how the program displays data when running reports, I recommend checking out this article: Understand Reports.

       

      You also mentioned about sending feedback to our engineers. Please do share that feedback, as it will help our engineering team identify ways to improve the reporting functionality.

       

      Just in case you need more guidance when running reports, feel free to check out these articles:

       

       

      As always, feel free to continue posting questions in the Community if you have any questions or need further assistance when analyzing data or performing any bookkeeping tasks in the program. The QuickBooks team and other users are always here to help and provide guidance."

      Terms & ConditionsAccessibility statement