Connect with and learn from others in the QuickBooks Community.
Join nowI would like to check on past payments made with credit cards to corroborate when and how those payments are being credited on my bank account
Solved! Go to Solution.
Hi Carranza_nelson, great to see you sharing your query here.
I believe that the payments you're referring to are from your customers and if so, here's a simple way to retrieve a report to sort the payments by payment method
1.) Click on Reports from the left hand panel
2.) In the search field, type Transaction List by Customer to generate this report
3.) Click on Customize at the top right
4.) Under the Filter section, click on it to reveal additional options.
5.) Simply select the payment method you wish to view under the Payment Method drop down menu
Hi Carranza_nelson, great to see you sharing your query here.
I believe that the payments you're referring to are from your customers and if so, here's a simple way to retrieve a report to sort the payments by payment method
1.) Click on Reports from the left hand panel
2.) In the search field, type Transaction List by Customer to generate this report
3.) Click on Customize at the top right
4.) Under the Filter section, click on it to reveal additional options.
5.) Simply select the payment method you wish to view under the Payment Method drop down menu
@ carranza
Run the Sales by customer detail report by customer
click the customize button, and then click the row/columns section and set the group by to payment method
then click the rows/columns and add payment method column
set the date range
run report
play with customize if you need more than what is shown
This worked perfectly. Saved me from asking the same question. Thank you!!!
I ran the report and while a payment method column appears it does not contain any information. I have entered payment method in many deposits, so it should show on at least some records.
When I filter for a payment method that I have used and entered the report comes up with no deposits/payments listed.
Hi Lake Coro 2,
You can actually see the payment method in the Deposit Detail report. So far, this is the only report that has payment method data. I will submit feedback for other reports that do not show the payment method details of a transaction.
I created 3 deposits. One from a sales receipt that is directly deposited to checking, and two from Bank Deposits.
You can click on Save Customizations to add it to your list of Custom Reports. That way, you won't have to customize it again.
Please try this report, and feel free to post back if you have additional questions.
I followed the instructions and was able to bring up the report. How do you get a grand total and not just a per customer total?
I can share some ideas on how you get the grand total, eburgchikadee1979.
The Deposit Detail report will only the total per customer. If you need to view the grand total, you may need to export the report to an Excel file. Then, compute the total amount from there. I'll show you how:
Additionally, here's an article that you can read to help speed up the reporting process in QuickBooks Online: Customize reports.
Should you have any follow-up questions or concerns, don't hesitate to post again here in the Community. I'll be more than happy to help you again.
Thank you for asking this question. I am also looking for a way to get a grand total for each month to check against the 1099 from the processing company.