cancel
Showing results for 
Search instead for 
Did you mean: 
KSfranklin
Level 2

QBS payment methods to work with basic deposits or reports

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?

Solved
Best answer February 23, 2023

Best Answers
BigRedConsulting
Community Champion

QBS payment methods to work with basic deposits or reports

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:

Capture.JPG

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:

Capture1.JPG

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

View solution in original post

10 Comments 10
JamaicaA
QuickBooks Team

QBS payment methods to work with basic deposits or reports

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
Community Champion

QBS payment methods to work with basic deposits or reports

@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:

Capture.JPG

 

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

BigRedConsulting
Community Champion

QBS payment methods to work with basic deposits or reports

@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.

KSfranklin
Level 2

QBS payment methods to work with basic deposits or reports

It should be so simple.  

BigRedConsulting
Community Champion

QBS payment methods to work with basic deposits or reports

It's hard to tell what your screenshots are of, but it looks like the first one is of the deposit form when you entered Credit Card, and the other is a report.

 

Given that the Amount is positive on the report, I suspect that you're looking at the deposit total row that uses the bank account. That row doesn't have a payment method. Instead the detail rows of the deposit each have a payment method, as shown in the image on my first answer on this thread.

 

To see the payment method(s) recorded on each deposit, create or use a report that includes the details, such as a Journal report or a Deposit Detail report.

KSfranklin
Level 2

QBS payment methods to work with basic deposits or reports

Tried all the detail reports suggested by others and QBs report center.  It works if there is an invoice associated otherwise it gives and empty cell.

KSfranklin
Level 2

QBS payment methods to work with basic deposits or reports

The first snip is the deposit entry where I provided the payment method, and the second is the report.  The payment method does not transcend to the report I printed.

BigRedConsulting
Community Champion

QBS payment methods to work with basic deposits or reports

RE: It works if there is an invoice associated otherwise it gives and empty cell.

 

Generally Invoices don't have payment methods. Customer Payment transactions applied to the invoices do have payment methods. Is that what you're referring to?

 

The only exception is if you use a Payment type item on the face of the Invoice, and that item has a payment method, and the item uses your bank account directly. All of that is somewhat rare.

KSfranklin
Level 2

QBS payment methods to work with basic deposits or reports

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.  

 

BigRedConsulting
Community Champion

QBS payment methods to work with basic deposits or reports

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:

Capture.JPG

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:

Capture1.JPG

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

Need to get in touch?

Contact us