Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
shubert
Level 1

How to create a credit card sales report with total amount for the year?

I ran the deposit detail report and added the payment methods of credit card, debit etc. The problem is it is not giving me a total of how much we did in Credit Card sales. The numbers are completely off. I feel like this should be a simple task, what am  doing wrong?

1 Comment 1
JamesAndrewM
Moderator

How to create a credit card sales report with total amount for the year?

Thanks for dropping by the Community and posting the details of your concern, Shubert. I've got you! I'll share information and steps you can follow to pull this kind of report through.

 

Creating a credit card sales report with total amounts for the year in QuickBooks Desktop involves a few steps. It's crucial to ensure you correctly categorized transactions and used the correct filters for your report. Here's a step-by-step guide:

 

  1. Open QuickBooks Desktop.
  2. Go to the Reports menu.
  3. Choose Accountant & Taxes and then select Transaction Detail by Account.
  4. Set the report date range to cover the entire year. You can customize the date range by selecting the exact dates in the Dates field.
  5. Click on the Customize Report button.
  6. In the Modify Report window, go to the Filters tab.
  7. Look for the Payment Method filter.
  8. Select Credit Card as the payment method. You may need to look for the specific payment method field depending on your version of QuickBooks.
  9. Click OK to run the report.
  10. Review the report to ensure that only credit card transactions are included.

 

I'm adding these articles you can use in the future:

 

 

By following these steps, you should be able to generate a credit card sales report with accurate total amounts for the year in QuickBooks Desktop. If you have more questions about reports, post them here in the forum. I'll be around to answer them. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us