Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowApparently 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! Go to Solution.
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.
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.
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.
@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.
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.
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.
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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here