How to create a report that sorts payments by payment method.

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

1. Select Reports from the sidebar menu.
2. Under the Sales and customers section, choose Deposit Detail.
3. Click the Customize button.
4. Set the appropriate reporting date and accounting method.
5. Go to the Rows/Columns section, then click Change columns.
6. Tick the Payment Method checkbox, then click Run report.
7. Select the Export icon, then choose Export to Excel.

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.