Skip to main content
S
SuperiorGCAZ
May 14, 2021
Solved

Splitting Deposit in Bank Feeds QB Desktop

  • May 14, 2021
  • 2 replies
  • 0 views

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.

Best answer by KlentB

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:

 

  1. Go to the Banking menu.
  2. Choose Bank Feeds, then select Bank Feeds Center.
  3. Select the appropriate bank account, then click Transaction List.
  4. Locate the deposit, then choose Add more detail from the drop-down arrow in the Action column.
  5. 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.
  6. Make sure that the remaining difference is zero.
  7. 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.

2 replies

KlentB
KlentBAnswer
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:

 

  1. Go to the Banking menu.
  2. Choose Bank Feeds, then select Bank Feeds Center.
  3. Select the appropriate bank account, then click Transaction List.
  4. Locate the deposit, then choose Add more detail from the drop-down arrow in the Action column.
  5. 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.
  6. Make sure that the remaining difference is zero.
  7. 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.

S
SuperiorGCAZAuthor
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.

F
fmfrance
September 15, 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.

L
LeizylM
September 15, 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:

 

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

 

To Rebuild Data:

 

  1. Click Window at the top menu bar, then Close All.
  2. From the File menu, choose Utilities.
  3. Hit Rebuild Data.
  4. You will receive a warning message to back up your company file, press OK.
  5. Click OK when you get the message "Rebuild has completed".
  6. 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. 

Terms & ConditionsAccessibility statement