Skip to main content
R
R-S29
November 17, 2020
Solved

I am trying to get a report for all Credit card purchases/charges divided by customer:job

  • November 17, 2020
  • 2 replies
  • 0 views

I am trying to get a report for all Credit card purchases/charges divided by customer:job

Best answer by Candice C

Good Evening, @R-S29. 

 

It's great to see a new face here in the Community. I hope your day is going well. 

 

The best report to run and review this information from is a Transaction Detail list. From the list, you can customize it to show credit card purchases and charges divided by customer/job. No worries. I can walk you through the simple process. 

 

  1. Go to the Reports menu. 
  2. Hover over Custom. 
  3. Pick the Transaction Detail report. 

 

 

      4. Click the Customize Report button. 

      5. Cruise on over to the Filters tab. 

      6. From there, you'll choose these filters/options below to make your report include your specific requests. 

      7. After you're done, tap OK to run the list. 

 

 

It's that easy. For future reference, you can always check out this article about customizing reports. 

 

You should be able to review the needed information from this report that's been provided. If you're still running into trouble, don't hesitate to ask. The Community is always here to have your back. Wishing you and your business continued success!

2 replies

Candice C
Candice CAnswer
November 17, 2020

Good Evening, @R-S29. 

 

It's great to see a new face here in the Community. I hope your day is going well. 

 

The best report to run and review this information from is a Transaction Detail list. From the list, you can customize it to show credit card purchases and charges divided by customer/job. No worries. I can walk you through the simple process. 

 

  1. Go to the Reports menu. 
  2. Hover over Custom. 
  3. Pick the Transaction Detail report. 

 

 

      4. Click the Customize Report button. 

      5. Cruise on over to the Filters tab. 

      6. From there, you'll choose these filters/options below to make your report include your specific requests. 

      7. After you're done, tap OK to run the list. 

 

 

It's that easy. For future reference, you can always check out this article about customizing reports. 

 

You should be able to review the needed information from this report that's been provided. If you're still running into trouble, don't hesitate to ask. The Community is always here to have your back. Wishing you and your business continued success!

    A
    aanderson805
    January 3, 2023

    I have tried running this report, but it does not show any results when filtered on Credit Card.  We use the Quickbooks credit card processing service and record the credit card payment directly through quickbooks, but it is not recognizing it as a credit card transaction type.

     

    Tried to filter on payment type and selected multiple types (Visa, Mastercard, AMEX)  I must be missing something as we process about $200K per year via credit card

    S
    SirielJeaB
    January 3, 2023

    Welcome to the community @aanderson805. Let me help you with this.

     

    I understand how relevant it is for you to keep track of your credit card purchases or charges. I suggest running a batch detail report from your Merchant Service Center. Here's how:

     

    1. Sign in to the Merchant Service Center.
    2. Select Activity & Reports, then click Deposits.
    3. Find the deposit in question by date range.
    4. Click the deposit name to display each transaction within the deposit.

     

    You may want to print the report, just select the Print Details link.

     

    Moreover, you can get monthly bank statements from your QuickBooks Checking account. Here's how:

     

    1. Go to Business overview, then select Cash flow.
    2. Choose QuickBooks Checking.
    3. Select Manage.
    4. View your QuickBooks Checking account and select Monthly Statements.

     

    You can also refer to this article for references on Merchant Services frequently asked questions such as funding status and managing payments accounts: QuickBooks Payments FAQ.

     

    Please let us know if you need additional assistance with your payments or running reports. We're available 24/7. Have a wonderful day!

    R
    R-S29Author
    November 18, 2020

    HI! 

     

    Thanks for your clear answer. 

    One questions. I ran the report and it gave me all the Credit card transactions, which is good. The one thing it's missing is the totals for each job.... 

    AlcaeusF
    AlcaeusF
    November 18, 2020

    Thanks for getting back to us, @R-S29.

     

    While the option to show the totals for each job isn't available in the custom Transaction Detail report that you've pulled up, you can use the Profit and Loss by Job report instead.

     

    All you need to do is filter the Transaction Type to credit card and it will display the totals for each specific job. Here's how:

     

    1. Go back to the Reports menu at the top.
    2. In the drop-down, select Company & Financial, then Profit and Loss by Job. 
    3. Tick the Customize Report option at the upper left and proceed to the Filters tab.
    4. Locate the Transaction Type, then pick Credit Card in the drop-down.
    5. Hit OK to refresh the report.

     

    For more in-depth information about managing reports in QuickBooks Desktop (QBDT), I suggest checking out these articles:

     

     

    Reach out to me in the comment section below if you have any additional concerns. I'll be here to help. Have a good one!

    Terms & ConditionsAccessibility statement