Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs it possible to create multiple receipts with a split deposit from a payment processing center? The deposits have already been added to the QB register via Bank Feeds. I do not send out invoices, as the payments reach my office after they have been invoiced/paid. I would like a way to individually track/report on each customer's ongoing payments. They come in batched and I create the split deposit with customer information.
ie: deposit of $95 from processing center comes through bank feed.
Deposit is split: company A pd $10, company B pd $70, company C paid $20, and processing company fee of $5 is listed in the split as a negative. This way the initial amounts paid are ready for the invoice or receipt and the deposit is reconciled by taking out the fee.
I need to track/report on each customer separately. Is this possible thorough invoicing/receipts/ or some other way?
Thanks for your time.
Solved! Go to Solution.
We can pull up the Transaction List by Customer Report, @ReneeT.
This report presents all the transactions and the list of deposit and payments per customer. Also, this report customization options permit you to easily filter for only the transactions you'd like. I'll be glad to guide you in modifying it.
Here's how using the Transaction List by Customer report.
You can also export this report to Excel, edit the columns there, and then add the information you'd needed. To do this, click the Excel button at the top of the report and select Create New Worksheet.
To save it for future use, I recommend memorizing this report.
I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.
Visit the Community again if you need anything else with running reports in QuickBooks. I'm here to help. Have a great day!
We can pull up the Transaction List by Customer Report, @ReneeT.
This report presents all the transactions and the list of deposit and payments per customer. Also, this report customization options permit you to easily filter for only the transactions you'd like. I'll be glad to guide you in modifying it.
Here's how using the Transaction List by Customer report.
You can also export this report to Excel, edit the columns there, and then add the information you'd needed. To do this, click the Excel button at the top of the report and select Create New Worksheet.
To save it for future use, I recommend memorizing this report.
I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.
Visit the Community again if you need anything else with running reports in QuickBooks. I'm here to help. Have a great day!
This is EXACTLY what I needed, I was goofing up the filter process. Thank you for the help, you just made my self-audit process easier and effective!!! Thank you.
I did have to make sure the customer/job filter was off also.
I'm glad the steps shared by my colleague above help resolved your issue, @ReneeT.
You might also want to check this link for future reference in reconciling your accounts. This way, we'll ensure we match your accounts accurately by the time you're ready.
Please know that you're always welcome to post on the Community page anytime you have other questions or concerns. Our door is always open to help you. Have a great day and take care!
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.