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.
amberkab
Level 1

How can I match a bank deposit with a combination of several sale receipts and expenses?

Hi QBO community, is there a way for me to match a bank deposit (from a check) with several sales receipts and expenses? We receive the billing statements from the distribution partner that we work with each month that show the sales amount for the items as well as the distribution fees, and the amount we receive on the check is the balance after the sales, the fees, and the partial payment we sent have taken into account.

 

Thank you!

Solved
Best answer January 06, 2023

Best Answers
MaryLandT
Moderator

How can I match a bank deposit with a combination of several sale receipts and expenses?

I appreciate you sharing complete details about matching bank deposits with several receipts and expenses, amberkab.

 

In QuickBooks Online, you can create a bank deposit and enter all items. Then, add the fees from there. This way, it'll match with what's in the real bank account entry with no invoices.

 

I'll guide you about how to do it.

 

  1. Click + New, then Bank Deposit.
  2. From the Account ▼ drop-down, choose the account you want to put the money.
  3. Scroll down to the Add funds to this deposit section.
  4. Enter all items.
  5. Enter the fee as a line item.
  6. Choose who the fee was from (for example, the bank charging you).
  7. Select Bank Charges from the Account ▼ drop-down.
  8. Enter the amount fee as a negative number. For example, if the fee was US $.50, enter –.50.
  9. Review the deposit total with the bank fee.
  10. Click Save and close or Save and new.

 

If there's an invoice, record the payment and post it to the Undeposited Funds account. Then, follow the steps above on how to add fees and post it the actual bank account.

 

Once done, match the deposit to the payment you've received through the Banking page. This links them together so you don't get duplicates.

 

Don't forget to reconcile your bank accounts every month. It'll help you compare each transaction with the ones entered into QuickBooks. Check out our complete reconciliation guide.

 

Feel at ease if you need assistance with how to match multiple transactions. I'll be here around to guide you always. Stay safe and more power to your business!

View solution in original post

1 Comment 1
MaryLandT
Moderator

How can I match a bank deposit with a combination of several sale receipts and expenses?

I appreciate you sharing complete details about matching bank deposits with several receipts and expenses, amberkab.

 

In QuickBooks Online, you can create a bank deposit and enter all items. Then, add the fees from there. This way, it'll match with what's in the real bank account entry with no invoices.

 

I'll guide you about how to do it.

 

  1. Click + New, then Bank Deposit.
  2. From the Account ▼ drop-down, choose the account you want to put the money.
  3. Scroll down to the Add funds to this deposit section.
  4. Enter all items.
  5. Enter the fee as a line item.
  6. Choose who the fee was from (for example, the bank charging you).
  7. Select Bank Charges from the Account ▼ drop-down.
  8. Enter the amount fee as a negative number. For example, if the fee was US $.50, enter –.50.
  9. Review the deposit total with the bank fee.
  10. Click Save and close or Save and new.

 

If there's an invoice, record the payment and post it to the Undeposited Funds account. Then, follow the steps above on how to add fees and post it the actual bank account.

 

Once done, match the deposit to the payment you've received through the Banking page. This links them together so you don't get duplicates.

 

Don't forget to reconcile your bank accounts every month. It'll help you compare each transaction with the ones entered into QuickBooks. Check out our complete reconciliation guide.

 

Feel at ease if you need assistance with how to match multiple transactions. I'll be here around to guide you always. Stay safe and more power to your business!

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

Need to get in touch?

Contact us