Splitting Deposit in Bank Feeds QB Desktop

SuperiorGCAZ · ‎May 14, 2021

I made the mistake of making a single deposit that included a refund check from a vendor & checks received from customers. How do I resolve this in bank feeds?

The refund was processed using credit in enter/pay bills. The other checks were from customers, & deposited using receive payments/record deposits. So when I downloaded transaction via bank feeds, the total deposit amount shows but doesn't match with any transaction.

KlentB · ‎May 14, 2021

I can help you with that, SuperiorGCAZ.

The downloaded deposit won't automatically match the recorded entries (checks from vendor and customer) since they've different amounts. To fix this, you'll need to split the downloaded transaction across multiple accounts and customers/vendors. I'll show you how:

Go to the Banking menu.
Choose Bank Feeds, then select Bank Feeds Center.
Select the appropriate bank account, then click Transaction List.
Locate the deposit, then choose Add more detail from the drop-down arrow in the Action column.
In the Deposit List table, enter the name, account, and amount of the checks. If you can see the checks on the table above, you can tick their checkboxes so you won't have to manually enter transaction details.
Make sure that the remaining difference is zero.
When you're done, click Add to QuickBooks.

In addition, here are some articles that you can read to help manage your online banking transactions in QuickBooks: Add and match Bank Feed transactions.

I'm still here if you need further assistance in accomplishing your other tasks. Have a great rest of the weekend.

View solution in original post

ShiellaGraceA · ‎May 14, 2021

Thanks for coming back to this thread, @SuperiorGCAZ.

I have some information about splitting the deposits with different accounts. In your case, you'll need to apply the customer payment to an open invoice. Then, add the vendor refund from the Deposit List section. Let me walk you through how.

Go to Banking, Bank Feeds, and then choose Bank Feed Center.
Tick the deposit, then select Add More Details from the Action drop-down.
From the Transaction Details window, tap the Open Invoices tab and look for the invoice that matches the check payment.
Scroll down towards the Deposit List section, select the vendor's name in the Received From column, Accounts Payable from the From Account column, and the Amount. See the attached image below.
Click Add to QuickBooks.

With the above steps, you're able to split the downloaded transactions into two separate accounts (A/R and A/P). Learn more about bank feed transactions in this guide: Add and match Bank Feed transactions in QuickBooks Desktop.

Additionally, here's a link that covers all the tasks you can do when using the banking feature. Feel free to look for responses that fit your concern.

Please know that you're always welcome to swing by if you have follow-up questions or concerns. I'll be around for you. Take care and have a good one.

View solution in original post

LieraMarie_A · ‎May 16, 2021

Thanks for the clarification, @SuperiorGCAZ.

The best way to handle this situation is to ignore the deposit from your bank feeds. This will delete the transactions from your transaction list. Then, clear them manually from the account register.

Here's how:

Go to the Banking menu.
Select Bank Feeds and choose Bank Feeds Center.
Select the bank account and click Transaction List.
Find the deposit.
From the Action column, click the dropdown and select Ignore.
Click Yes to confirm.

Once done, clear the refund transaction and the received payment from your account register.

Go to the Lists menu and select Chart of Accounts.
Look for the credit card account that needs fixing.
Locate the uncleared transactions.
Clear them by putting a checkmark.
Once done, click Record.
Click Yes to confirm.

To learn more about the online banking features in QuickBooks Desktop, you can check these articles:

Keep posted if you have any other banking concerns. I'll be always happy to help.

View solution in original post

KlentB · ‎May 14, 2021

I can help you with that, SuperiorGCAZ.

The downloaded deposit won't automatically match the recorded entries (checks from vendor and customer) since they've different amounts. To fix this, you'll need to split the downloaded transaction across multiple accounts and customers/vendors. I'll show you how:

Go to the Banking menu.
Choose Bank Feeds, then select Bank Feeds Center.
Select the appropriate bank account, then click Transaction List.
Locate the deposit, then choose Add more detail from the drop-down arrow in the Action column.
In the Deposit List table, enter the name, account, and amount of the checks. If you can see the checks on the table above, you can tick their checkboxes so you won't have to manually enter transaction details.
Make sure that the remaining difference is zero.
When you're done, click Add to QuickBooks.

In addition, here are some articles that you can read to help manage your online banking transactions in QuickBooks: Add and match Bank Feed transactions.

I'm still here if you need further assistance in accomplishing your other tasks. Have a great rest of the weekend.

SuperiorGCAZ · ‎May 14, 2021

Thank you I think that will work, but I can't 'Add to QB' without selecting a From Account. I tried Accounts Rec for the customer checks & Accounts Pay. for the vendor refund but I can't save from 2 different accounts.

SuperiorGCAZ · ‎May 14, 2021

Thank you I think it will work, but I can't "add to QB" without a From Account. And it won't let me use 2 accounts, Acct.Rec for customer payments, & Acct. Pay for the vendor refund.

ShiellaGraceA · ‎May 14, 2021

Thanks for coming back to this thread, @SuperiorGCAZ.

I have some information about splitting the deposits with different accounts. In your case, you'll need to apply the customer payment to an open invoice. Then, add the vendor refund from the Deposit List section. Let me walk you through how.

Go to Banking, Bank Feeds, and then choose Bank Feed Center.
Tick the deposit, then select Add More Details from the Action drop-down.
From the Transaction Details window, tap the Open Invoices tab and look for the invoice that matches the check payment.
Scroll down towards the Deposit List section, select the vendor's name in the Received From column, Accounts Payable from the From Account column, and the Amount. See the attached image below.
Click Add to QuickBooks.

With the above steps, you're able to split the downloaded transactions into two separate accounts (A/R and A/P). Learn more about bank feed transactions in this guide: Add and match Bank Feed transactions in QuickBooks Desktop.

Additionally, here's a link that covers all the tasks you can do when using the banking feature. Feel free to look for responses that fit your concern.

Please know that you're always welcome to swing by if you have follow-up questions or concerns. I'll be around for you. Take care and have a good one.

SuperiorGCAZ · ‎May 16, 2021

Thank you.

As I originally stated: The refund was processed using credit in enter/pay bills. The other checks were from customers, & deposited using receive payments/record deposits.

So the invoices aren't open on the transaction list to select & the refund is in my check register already too. Should I delete those transactions from the checking account register to do what you suggest? Then I'd have to delete the credit under pay bills also?

LieraMarie_A · ‎May 16, 2021

Thanks for the clarification, @SuperiorGCAZ.

The best way to handle this situation is to ignore the deposit from your bank feeds. This will delete the transactions from your transaction list. Then, clear them manually from the account register.

Here's how:

Go to the Banking menu.
Select Bank Feeds and choose Bank Feeds Center.
Select the bank account and click Transaction List.
Find the deposit.
From the Action column, click the dropdown and select Ignore.
Click Yes to confirm.

Once done, clear the refund transaction and the received payment from your account register.

Go to the Lists menu and select Chart of Accounts.
Look for the credit card account that needs fixing.
Locate the uncleared transactions.
Clear them by putting a checkmark.
Once done, click Record.
Click Yes to confirm.

To learn more about the online banking features in QuickBooks Desktop, you can check these articles:

Keep posted if you have any other banking concerns. I'll be always happy to help.

SuperiorGCAZ · ‎May 17, 2021

It was in the Account Business checking, but Thank you! That worked.

fmfrance · ‎September 14, 2022

This is not the problem. When I write checks, the payments may include amounts for more than one expense account. In the past (and not too long ago) there was an option to split the expenses between the accounts that resulted in the amounts showing up on the check stub as well as charging the amount to the expense account. There was a menu option at the bottom of check form that allowed you to split the amount of the check to more than one account. That appears to have vanished and I would like to get it back.

LeizylM · ‎September 14, 2022

Hi there, fmfrance.

Glad you've come to reach out to us here in the Community. I'll help you with splitting the amounts with different accounts in QuickBooks Desktop.

Beforehand, can you send me a screenshot showing the menu option at the bottom of the check? Additional information is much appreciated.

In the meantime, you can use the expense tab to split the amounts for different accounts in the write checks screen.

If the issue persists, you'll want to ensure your QBDT software is updated to the latest release. This way, we can guarantee the program is running with the newest fixes and patches.

After that, you can follow the steps below to verify and rebuild your data.

To Verify Data:

Click Window at the top menu bar, then Close All.
From the File menu, choose Utilities.
Tap Verify Data.

To Rebuild Data:

Click Window at the top menu bar, then Close All.
From the File menu, choose Utilities.
Hit Rebuild Data.
You will receive a warning message to back up your company file, press OK.
Click OK when you get the message "Rebuild has completed".
Close and re-open QuickBooks Desktop.

Additionally, I've added this article to learn more about the online banking features in QuickBooks Desktop:

Please let me know if there's anything else you need or concerns about splitting the amount in QBDT. You can drop a comment below, and I'll gladly help.

Topics

Training

Community

Resources

Splitting Deposit in Bank Feeds QB Desktop