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

Creating receipts

Is 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
Best answer July 14, 2020

Best Answers
AileneA
QuickBooks Team

Creating receipts

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.

 

  1. Click the Reports from the top menu bar.
  2. Select Customers & Receivables, then choose Transaction List by Customer.
  3. Press the Customize Report button.
  4. In the Display tab, set the appropriate reporting date under the REPORT DATE RANGE section.
  5. In the Filters tab, choose Transaction Type from the FILTER menu.
  6. Choose Multiple Transaction Types from the Transaction Type drop-down menu.
  7. From the pop-up window, choose Deposit and Payment then click OK.
  8. Tap OK again to complete the process.

 

reps.T.PNG

 reps.T1.PNG

 

reps.T2.PNG

 

 

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!

View solution in original post

4 Comments 4
AileneA
QuickBooks Team

Creating receipts

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.

 

  1. Click the Reports from the top menu bar.
  2. Select Customers & Receivables, then choose Transaction List by Customer.
  3. Press the Customize Report button.
  4. In the Display tab, set the appropriate reporting date under the REPORT DATE RANGE section.
  5. In the Filters tab, choose Transaction Type from the FILTER menu.
  6. Choose Multiple Transaction Types from the Transaction Type drop-down menu.
  7. From the pop-up window, choose Deposit and Payment then click OK.
  8. Tap OK again to complete the process.

 

reps.T.PNG

 reps.T1.PNG

 

reps.T2.PNG

 

 

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!

ReneeT
Level 2

Creating receipts

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.

ReneeT
Level 2

Creating receipts

I did have to make sure the customer/job filter was off also.

JasroV
QuickBooks Team

Creating receipts

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!

Need to get in touch?

Contact us