Skip to main content
K
KSfranklin
February 23, 2023
Solved

QBS payment methods to work with basic deposits or reports

  • February 23, 2023
  • 2 replies
  • 0 views

Apparently QBS did not set the payment methods to work with basic deposits (in constructing a report) unless it is under an invoice.  Can we create a deposit report that shows the payment method that is not associated with an invoice?

Best answer by BigRedConsulting

We do not have invoices associated with these deposits.

 

Point blank, whatever I enter into the deposit field pmt method does not transcend to any report so therefore, there is no answer to my issue because it doesn't exist.

 

I love QBs.

 

THANK YOU for your response.  

 


RE: We do not have invoices associated with these deposits.

 

It doesn't matter. And, that's a very rare thing in any case. Invoices are rarely included directly in deposits.

 

RE: Point blank, whatever I enter into the deposit field pmt method does not transcend to any report so therefore, there is no answer to my issue because it doesn't exist.

 

The payment methods entered on deposit detail lines appear on every report that displays the detail lines. You can prove this to yourself by opening one of your deposits and then picking Reports | Transaction Journal from the QB menu. Then add the Pmt Method column.

 

To test it I created this deposit by adding line items to it using an income account, no name (so you can be sure there is no invoice involved), and then running the Transaction Journal report for the deposit:

You can see that the first line of the deposit, the Checking account line, does not have a Pay Method. I expect that is the line from your report.

 

Any report that shows detailed transaction rows from the deposit will show the Pay Method.

 

For example, if I create a custom Transaction Detail report for the date of the deposit, I see this detail:

To create a similar report in your file, which will show the Pay Meth, start at Reports | Custom Reports | Transaction Detail.

2 replies

J
JamaicaA
February 23, 2023

We can only run a report that shows a deposit with the payment method, @franklin. I've got a workaround to share with you so you can still get the data you need.

 

When pulling up a report, the deposit and payment method appear together. This means we're unable to identify which ones are unassociated with your invoices. Also, there's no option that allows us to separate them when customizing it.

 

You might consider adding a memo to your deposits. This way, you can easily recognize which deposits aren't linked to invoices. See this screenshot below for your reference:

 

I do agree with you that adding more customizations to a report would make the program more flexible. This way, you’ll be able to add the necessary columns for your data. You'll want to send feedback to our Product Developer so they can review and consider adding this feature in the future.

 

Here's how:

 

1. Go to the Help icon and select Send Feedback Online.

2. Choose Product Suggestion and then enter your idea or request.

3. Click Send Feedback.

 

Please know that we’re unable to provide a specific time frame as to when this feature will be available. You can track your suggestion through this website. You can also visit our blog to keep up with all of our recent events and developments.

 

If you want to create a report that shows selected transactions as well as other transactions to which they are linked, such as an invoice and its payment, see this article: Use Check or Deposit Detail Reports to show transaction links and mimic Cash Receipt Report.

 

Feel free to visit these resources to learn more about personalizing reports and saving their current settings:

 

 

Don't hesitate to tag me in the comment section below if you have other concerns or questions about generating reports. I'm always ready to help. Enjoy using QuickBooks.

BigRedConsulting
BigRedConsulting
February 23, 2023

@JamaicaA  Re: When pulling up a report, the deposit and payment method appear together. This means we're unable to identify which ones are unassociated with your invoices. 

 

That's interesting, but it's not at all what the customer asked for, so sort of a mute point and unhelpful.

    K
    KSfranklinAuthor
    February 23, 2023

    It should be so simple.  

    BigRedConsulting
    BigRedConsulting
    February 23, 2023

    @KSfranklin 

    RE: Can we create a deposit report that shows the payment method that is not associated with an invoice?

     

    Yes.  A Journal report filtered for Deposits will show the payment method for each line item on a Deposit:

     

    It looks like the Deposit Detail report will as well, if you add the Pay Meth column, and also the generic Transaction Detail report.

    Terms & ConditionsAccessibility statement