cancel
Showing results for 
Search instead for 
Did you mean: 
davidmatyas
Level 2

Is there a report that will show the credit card payment transaction not broken down by customer?

I use job costing, so any bill can be for multiple customers. Being as such, a $5k credit card payment to a bill will show up in the ledger as maybe 5 separate $1000 charges (if the bill was for 5 customers).

 

My accountant doesn't like this, as he says it's hard for him to match it up to the statements.

 

Is there a report that I can generate that will show it based off of the transaction (the full $5k) and not broken down by the individual customers?

 

Thank you 

3 Comments 3
MadelynC
Moderator

Is there a report that will show the credit card payment transaction not broken down by customer?

Yes, there is David. I’m here to share information on how to manage these transactions so you can generate a report for $5000.


If you set Undeposited Funds as default when receiving payments, you can easily combine those amounts to a single deposit. This can generate a report based on the transaction ($5000) and not by individual customers.


Here’s how to combine multiple transactions into a single record so QuickBooks matches your real-life bank deposits.

 

  1. Go to the Banking menu, then Make Deposits.
  2. In the Payments to Deposit window, select the payments you want to combine and then OK.
  3. From the Deposit To dropdown, select the account you want to put the deposit into.
  4. Review the amounts.
  5. Enter the date and add a memo as needed.
  6. Press Save & Close.


You can use this guide to learn more about bank deposits: Record and make bank deposits in QuickBooks Desktop.


Then you can run the Transaction Detail report. This report lists individual transactions, showing each account involved in a transaction on a separate line. Just filter it to Transaction Type so you’ll be able to see the combined deposit. I'll show you how:

 

  1. Click Reports, then Custom Reports.
  2. Choose Transaction Detail.
    Capture.PNG
  3. Select the Customize Report button, then go to the Filters tab.
  4. Enter/select Transaction Type and choose Deposit.


Capture.PNG


On the other hand, you’ll want to change your default deposit account to an account named Undeposited Fund so you’ll be able to generate the said report in QuickBooks.


Also, here’s a reference that contains detailed steps to reconcile an account: Reconciling accounts. This will ensure everything is good and accurate.


Don’t hesitate to drop a comment if you have other concerns or questions about reports. I’m always here to help. Take care and have a good one!

davidmatyas
Level 2

Is there a report that will show the credit card payment transaction not broken down by customer?

Thank you, I will try this when I'm back by the computer.

 

What about all the transactions that I did until now, is there a way to generate a report or is it too late for that?

 

Thank you 

JoesemM
Moderator

Is there a report that will show the credit card payment transaction not broken down by customer?

Thanks for getting back to us, @davidmatyas.

 

You'll want to edit the Deposit to account for the recorded payment. This removes the transaction that shows up in the bank deposit section.

 

  1. From the Lists menu, select Chart of Accounts.
  2. Choose the account you deposit the payment.
  3. From the Deposit to drop-down, select Undeposited Funds.
  4. Fill out the rest of the form.
  5. Select Save & Close or Save & New.

 

Also, it’s good to periodically check your Undeposited Funds account and clear out any payments waiting to be moved.

 

  1. From the Lists menu, select Chart of Accounts.
  2. Right-click Undeposited Funds and then select QuickReport: Undeposited Funds.
  3. From the Dates drop-down menu, select All.
  4. Select Customize Report.
  5. Select the Filters tab.
  6. Scroll down the Filter list and select Cleared.
  7. In the Cleared section, select No and then select OK.

For more information, see this article: Deposit payments into the Undeposited Funds account in QuickBooks Desktop.

 

Once done, you can follow the steps shared by my colleague MadelynC on how you pull up a report and get the data you needed. Pulling up and customizing the Transaction Detail report will show each record for your transactions. You might also want to read this article to learn more on how to customize reports: Customize Reports in QuickBooks Desktop.

 

To learn more about how QuickBooks generates the reports, you can check out this article: Understand reports.

 

I've added these articles that you can use for matching and reconciling transactions in QuickBooks:

 

 

Please know that you can always get back into this post if you have more questions. I'll keep an eye out for your response. Have a nice day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us