How to reconcile multiple donations to a single bank deposit

Interesting, I hadn't thought about it that way.  I don't recall if I processed the checks in a batch when I recorded them in QB or if I did them one at a time.  Are you thinking that recording the checks in a batch in QB to match the way the bank deposited them would help?  I'll have to try it the next time I have multiple checks to deposit.

In the meantime, if there's no way to match the existing $200 bank feed entry with the two individual $100 deposits I have in QB, is it safe to simply ignore the bank feed entry?

Or another thought, is it possible to reverse these two deposits in QB and re-enter them as a group to match the bank feed?  QB gives me the option to "delete" or "void" the deposit; will either of these put the two donations back into "Undeposited Funds" account so I can record them together?

Thanks.

Hello, wplee.

I'll share a way to match multiple donations to a single deposit in QuickBooks Desktop.

The downloaded deposit won't automatically match the recorded entries since their different amounts. To fix this, you'll need to split the downloaded transaction. I'll show you how.

1. Go to the Banking menu, then Bank Feeds.
2. Select Bank Feeds Center.
3. Tick the $200 bank deposit, then choose Add More Details from the Action dropdown.
4. Locate for those individual $100 donations and ensure that the remaining difference is zero.
5. Once done, hit Add to QuickBooks.

Alternatively, you can ignore the downloaded bank transaction. Then, clear them manually from the account register.

Here's how:

1. Go to the Lists menu and select Chart of Accounts.
2. Look for the account that needs fixing.
3. Locate the uncleared transactions (two individual $100 donations).
4. Clear them by putting a checkmark.
5. Once done, click Record.
6. Click Yes to confirm.

To learn more about the online banking features in QuickBooks Desktop, check out the following articles: 

• Get started with Bank Feeds for QuickBooks Desktop.
• Add and match Bank Feed transactions in QuickBooks Desktop

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

No good - the Add More Details screen only shows shows items in the Undeposited Funds account.  Since the two $100 deposits have already been recorded in the Record Deposits screen, they don't appear in the transaction details list.  Is there a way to reverse the recording of the two deposits and put the checks back into the Undeposited Funds account?

Thank you for sharing more details and confirming that the two deposits have been recorded in the Record Deposits screen, @wplee.

To get the checks back in the Undeposited Funds account, let's go to your bank register to locate and delete the deposits.

Here's how:

1. Go to the Accountant menu.
2. Select Chart of Accounts.
3. Find the account in question and then double-click to open the bank register.
4. Locate the DEP (deposit) and then right-click to select Delete Deposit.
5. Click Yes to confirm.

Once finished, you can decide and go to the Banking menu to create a deposit for the two checks so you can match it with the $200 entry from your bank feeds.

1. Click Banking and then select Make Deposits.
2. Find the two $100 checks and put a checkmark.
3. Select OK.
4. Hit Save & Close.

You can then match the $200 deposit to your $200 bank feed transaction and reconcile the account.

Should you have additional questions or clarifications, please let me know. We're always here to help you out. Take care and have a good day!

This worked.  Once I deleted the deposits, I was able to see them in the "Record Deposits" screen once again.  I processed both donation checks in the same transaction as suggested by @Rustler and saved everything.  When I went back to the account in the Bank Feeds Center, the outstanding $200 item had been auto-matched to the two $100 deposits.  Thank you to everyone who replied.

Hi. How did you do this? I'm trying to bring my donation record keeping system into Quickbooks and do not know how to enter batch donations. 

Hello there. I can walk you through entering batch donations in QuickBooks Desktop.

Simply record the money donated to our organization by creating a bank deposit. A batch donation can be added as multiple line items on the deposit.

Make sure to choose the donor and the revenue account you set up for donations. Here's how to make a deposit:

1. Open the Banking menu and select Make Deposits.
2. Fill out all the information needed.
3. Add one donation detail per line item.
4. Once done, click on Save & Close.

For more information, check this guide: How to record donations or charitable contributions.

I'll also add this link to find out some fixes if you're account balances don't match: Reconcile an account in QuickBooks Desktop.

Keep us updated so we can help you further with donations, banking, or QuickBooks. We're here to back you and your business. Stay safe.