cancel
Showing results for 
Search instead for 
Did you mean: 
bmcc1200
Level 3

Compiling Donations for Meaningful Deposits

St Vincent de Paul is a non profit.  We receive several checks each week and right now are entering them as sales receipts.  Whether they are sales receipts or receipts I don't think makes any difference to our books.  To us they are donations.  We take money in and we distribute money out.

 

Our challenge is reconciling.  When we go to the ATM and deposit 5-20 checks, we get a print out of each check on the tape, but out monthly bank statement has only the total, say $1000.  

 

Each of the donation checks is entered as a single sales receipt because it has to be coded to that individual.  That means that there are 10 check entries for this 1000 deposit which isn't bad, but we have 40-60 of these to match up in a month.  What I am hoping this very resourceful community can provide me is some sort of tool or other entry methodology that allows me to make one deposit entry in QB such that I can allocate the sum of these donations allocated to each individual donor within that deposit.  I visualize this similar to writing a check to the utility company for 1000 with 10 different individual client whose utility bills we paid 100 each.  Hope this is not too confusing.  Thanks in advance for any input on this subject.

Solved
Best answer December 09, 2020

Best Answers
JonpriL
Moderator

Compiling Donations for Meaningful Deposits

Hello @bmcc1200,

 

You can use your undeposited funds account so you can group your donations before recording deposits into your bank. Let me show you how.

  1. Go to the +New button.
  2. Under CUSTOMERS, select Sales receipt.
  3. Select a customer from the Customer menu.
  4. On the Deposit to menu, select Undeposited Funds.
  5. Enter the donation and the amount.
  6. Click Save and Close.

Once you entered all of your 10 donation transactions, you can record them as a single deposit. To do so:

  1. Go to the +New button.
  2. Under OTHER, select Bank Deposit.
  3. Select your bank account on the Account menu.
  4. On the Select the payments included in this deposit section, select all your 10 donation transactions.
  5. Click Save and close.

In addition, here's an article you can read to learn more about how you can use your undeposited funds account: Learn how to put payments into the Undeposited Funds account before you combine them into a deposit.

 

Lastly, I've also included this helpful article for the steps in reviewing a bank transaction and other functions you can use: What are account registers in QuickBooks Online?

 

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand. Stay safe and well!

View solution in original post

6 Comments 6
JonpriL
Moderator

Compiling Donations for Meaningful Deposits

Hello @bmcc1200,

 

You can use your undeposited funds account so you can group your donations before recording deposits into your bank. Let me show you how.

  1. Go to the +New button.
  2. Under CUSTOMERS, select Sales receipt.
  3. Select a customer from the Customer menu.
  4. On the Deposit to menu, select Undeposited Funds.
  5. Enter the donation and the amount.
  6. Click Save and Close.

Once you entered all of your 10 donation transactions, you can record them as a single deposit. To do so:

  1. Go to the +New button.
  2. Under OTHER, select Bank Deposit.
  3. Select your bank account on the Account menu.
  4. On the Select the payments included in this deposit section, select all your 10 donation transactions.
  5. Click Save and close.

In addition, here's an article you can read to learn more about how you can use your undeposited funds account: Learn how to put payments into the Undeposited Funds account before you combine them into a deposit.

 

Lastly, I've also included this helpful article for the steps in reviewing a bank transaction and other functions you can use: What are account registers in QuickBooks Online?

 

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand. Stay safe and well!

bmcc1200
Level 3

Compiling Donations for Meaningful Deposits

JonpriL  Very clever!!  That will works perfectly.  Thank you and thanks for the other articles.

JonpriL
Moderator

Compiling Donations for Meaningful Deposits

You're always welcome, @bmcc1200!

 

I'm happy to know that you're able to accomplish your goal for today and share the resolution you need to finish your task.

 

Tag me (@JonpriL) in the comments below if you have any other concerns. Wishing you a joyful and safe end of the year. Enjoy the rest of your day!

bmcc1200
Level 3

Compiling Donations for Meaningful Deposits

This is a great solution.  Perfect for what we need.  Thank you!!

mnh4fcs
Level 1

Compiling Donations for Meaningful Deposits

This is for QuickBooks 202X Premier Desktop...

 

So I have a follow up case of for meaningful deposits.

Is there a way to identify the donations (sales receipts) that belong to a deposit at the front end?

The way outlined is based on entering the donations that are deposited together in a coordinated way.

 

When deposits occur throughout the month, at the end of the month the deposits are recorded. Since there is a selection screen on the Payment to Deposit - is there a way to on that screen identify which donations "go" together? since gives the option to individually select the receipts.

For example - is there access to the time column - to use as the indicator of common deposits?

 

I am also using an custom app via SDK to bulk add donations - and deposit information could be included to make a deposit identifier.

 

Thanks  

 

 

 

ChristineJoieR
QuickBooks Team

Compiling Donations for Meaningful Deposits

Yes, @mnh4fcs.

 

I'll demonstrate how to view sales receipts associated with a single deposit in QuickBooks Desktop.

 

QuickBooks provides functions to track donations from cash, checks, and credit cards. These revenues should be entered as donations to ensure the appropriate tax fields use for year-end deductions.

 

Here's how:

 

  1. Select Make Deposit from the Banking Tab.
  2. When the Payment to Deposit screen appears, select Cancel.
  3. To see the most recent deposits made, click the Previous button on the Make Deposit screen.
  4. This way, you can see the list of Sales Receipts in one Deposit.

 

Check out the following articles to learn more about QuickBooks Desktop's online banking features:

 

 

Visit us if you need further assistance. I'm always here to help. Have a great day.

Need to get in touch?

Contact us