cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
DustinWernerBCPA
Level 1

Sales Receipt/Mass Payment Question

Hi!  We sell inventory items and offer Paypal as a payment option.

Hypothetically, we sold 6 shirts to 6 different people, and it came in one payment.  Split deposits doesn't link up with our established inventory and split sales receipts only allow one customer per transaction.  Any suggestions?

Solved
Best answer 3 weeks ago

Best Answers
CamelleT
QuickBooks Team

Sales Receipt/Mass Payment Question

Thank you for rejoining this thread, Dustin. Let me clarify how QuickBooks Online (QBO) handles the relationship between split payments and inventory items.

 

First off, each sales receipt is created for a specific customer and their purchase, directly linking each customer's purchase to the inventory items sold. When sales receipts are created in QBO, the inventory is automatically updated.

 

Then, by combining multiple sales receipts into a single bank deposit, you ensure that your financial records in QBO match the total lump sum amount received from PayPal.

 

Moreover, the same process applies when handling multiple customers purchasing multiple inventory items.

 

Additionally, you can refer to this resource for further details about managing PayPal app transactions in QBO: Use the Connect to PayPal app with QuickBooks Online.

 

Furthermore, I'll share this resource to help you create automatic categorization rules and streamline your PayPal transaction management in QBO: Set up bank rules.

If you have other questions about handling sales receipts or bank deposits in QBO, feel free to add a reply below. The Community team is readily available to offer guidance.

View solution in original post

6 Comments 6
IrishA
QuickBooks Team

Sales Receipt/Mass Payment Question

You can record a single PayPal payment that covers multiple sales to different customers by creating individual sales receipts for each transaction, Dustin. Let me walk you through the steps involved in this process to ensure everything is accurately recorded.

 

Once you have documented each sale, you can then consolidate these receipts into a single deposit entry that reflects the total payment received.  This method links the actual bank deposit entry with all the individual customer sales receipts.  

 

Here are the steps below:

 

  1. Navigate to + New menu.
  2. Under the Other column, select Bank Deposit.

    image (1).png

  3. Choose the correct Account that is used for the sales receipt.
  4. Manually choose all the individual sales receipts that sum up to the total amount of the single payment received.


You can check this article for more comprehensive guidance in combining multiple transactions into a single record in QuickBooks: Record and make bank deposits in QuickBooks Online.

You can also match to existing sales receipts if they have already been entered into your QuickBooks Online account.

 

Also, please know that item details will not be included in a Deposit transaction and will be categorized into one account. You can check out this article for further information: Use the Connect to PayPal app with QuickBooks Online.

 

Moreover, you can set up bank rules to automatically categorize online banking transactions in QuickBooks Online.

 

I highly encourage you to take advantage of our QuickBooks Live Expert service. They provide tailored assistance and expert advice to help you effectively manage your financial records, optimize your bookkeeping practices, and ensure accurate accounts.

 

I am delighted for the opportunity to assist you with recording sales receipts and ensuring they are aligned with the correct accounts, helping you maintain accurate financial records. If you have any further questions or inquiries, please feel free to leave a comment below. Have a great day ahead!

DustinWernerBCPA
Level 1

Sales Receipt/Mass Payment Question

But how, in that transaction, can I link the split payments to inventory items?

DustinWernerBCPA
Level 1

Sales Receipt/Mass Payment Question

How do I do this if I have multiple customers buying multiple inventory items?

CamelleT
QuickBooks Team

Sales Receipt/Mass Payment Question

Thank you for rejoining this thread, Dustin. Let me clarify how QuickBooks Online (QBO) handles the relationship between split payments and inventory items.

 

First off, each sales receipt is created for a specific customer and their purchase, directly linking each customer's purchase to the inventory items sold. When sales receipts are created in QBO, the inventory is automatically updated.

 

Then, by combining multiple sales receipts into a single bank deposit, you ensure that your financial records in QBO match the total lump sum amount received from PayPal.

 

Moreover, the same process applies when handling multiple customers purchasing multiple inventory items.

 

Additionally, you can refer to this resource for further details about managing PayPal app transactions in QBO: Use the Connect to PayPal app with QuickBooks Online.

 

Furthermore, I'll share this resource to help you create automatic categorization rules and streamline your PayPal transaction management in QBO: Set up bank rules.

If you have other questions about handling sales receipts or bank deposits in QBO, feel free to add a reply below. The Community team is readily available to offer guidance.

DustinWernerBCPA
Level 1

Sales Receipt/Mass Payment Question

Ok.  I'm seeing the light now.

Last piece of the puzzle....

I make all of these sales receipts....How do I link them to the transaction?

BabyB
QuickBooks Team

Sales Receipt/Mass Payment Question

After creating the individual sales receipts posted to the Undeposited Funds account, let's ensure to combine them into a single bank deposit, Dustin.

 

I'll also lay down the detailed steps to successfully link the downloaded lump sum payment to the deposit you've created. Here's how:

 

  1. Go to Transactions, then choose Bank transactions.
  2. Find a transaction with a suggested match found under the Assign to column.
  3. Select the transaction to expand the view. Review the Suggested matches for any possible matching transactions already entered in QuickBooks.
  4. Select a match if it's correct, then click Match.
     


 

Once you're ready, let's reconcile your accounts to ensure they're balanced and accurate.

 

Need more assistance with linking your other income and expense transactions in QuickBooks Online? Drop me a reply here. I’m ready to help you out.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up