Skip to main content
S
SFF1
October 18, 2022
Question

Easy way split and match bulk deposit?

  • October 18, 2022
  • 1 reply
  • 0 views

Is it possible to split up a bulk deposit of checks that includes matching invoice repayments and categorizing the rest into different sales accounts that do not have a matching component?  When we do our drop off at the bank it often includes invoice repayments, cash and checks from the store and other non-invoiced income.  I can't seem to find a straight forward way of breaking out the bulk deposit in quickbooks online.

Thanks

1 reply

R
rvrfrf
October 18, 2022

Thanks for getting in touch with the Community, SFF1.

 

You can split transactions between multiple accounts for better tracking while categorizing and matching them.

 

Here's how:

  1. In your left navigation bar, go to Banking.
  2. Access the For review tab.
  3. Find a transaction you'd like to categorize and click it to expand its view.
  4. If you see a Match option under its Action column, change Find match to Categorize.
  5. Choose Split next to your Add button.
  6. From the Category drop-down list, pick which categories (accounts) you'd like to split it into.
  7. Enter an Amount and Customer for each split.
  8. Select Apply and accept.

 

I've also included a detailed resource about categorizing and matching transactions which may come in handy moving forward: Categorize & match online bank transactions

 

I'll be here to help if there's any additional questions. Have a great Tuesday!

S
SFF1Author
October 20, 2022

I might be missing something but so let me phrase it another way.

We have accounts that we invoice which creates an accounts receivable in our wholesale account category. Let's say its 1,000.

We then take in 1500 in cash through direct cash sales. And another for non invoiced wholesale sales of $500.


They all get put together into a single deposit for the bank for a total of $3,000.   Without the invoice sales we would split them in the transaction area into their specific categories.  But with the invoices I don't understand how it gets matched to a single invoice while splitting the other transactions into their categories.  Without an extra journal entry the deposit and accounts receivable stay in the whole sale account.

J
JamesAndrewM
October 20, 2022

Hello there, @SFF1.Currently, we're unable to split a bulk deposit to a single invoice while matching it to different categories or accounts.

 

What we can do is exclude the downloaded bank deposit, and manually change the status of the transactions in the register.

 

To exclude a bank transaction:

  1. Go to Banking.
  2. Select the For Review tab
  3. Choose a Transactions
  4. Select the checkbox of the transaction(s) to exclude.
  5. Select Exclude.

 

Next, to manually clear the status:

  1. Go to Bookkeeping or Accounting, then select Chart of accounts (Take me there).
  2. Find the account that has the reconciled transaction. Then select View register.
  3. Find the account that has the reconciled transaction. Then select View register.
  4. Select the transaction to expand the view.
  5. In the checkmark column, select the box with the “R” until the box is change to "C". This removes the transaction from the reconciliation.
  6. Select Save.
  7. Close the account register

 

 For more detailed information, please refer to these articles:

 

To split the single invoice to cash, direct sales, and non-invoiced wholesale, we suggest creating a journal entry (as what you have been doing).

 

You can visit this link on how to resolve bank feed errors: What to do if you get a bank error or can't download transactions in QuickBooks Online.

 

You're always welcome to reach us again if you have more questions about your invoice transactions. Have a great day ahead!

Terms & ConditionsAccessibility statement