Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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.
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:
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!
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
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.
Also, it’s good to periodically check your Undeposited Funds account and clear out any payments waiting to be moved.
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here