cancel
Showing results for 
Search instead for 
Did you mean: 
emilyhuangefc
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

When I enter the donations by Donation (Sales Receipt), what is the" item" for?

and what is that? why not the chart of account?

Solved
Best answer December 10, 2018

Best Answers
john-pero
Community Champion

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Quickbooks uses Items , or products and services, to identify individual transactions that may need tracking but can all be part of a whole. You do need to use at least one item, even if you just call it Donations and it posts to Donations in your COA. But with items you have the advantage of being able to split donations to any of several targets that are all part of general fund. IN addition you can direct, by item, any designated funds that must be held separately.

As an illustration you could have the following Items

General Fund Donation

Building Fund

Sunday School

Missions

Advent

Easter

And you could also set up any specific items for memorials or any other reason that the parishioners donate.

I presume you are using  one sales receipt per donor so that you can give them quarterly and annual reports. The destination account for the "Sales Receipt" should be Undeposited Funds and then you create the Deposit by selecting all the included payments of cash and check

View solution in original post

24 Comments 24
john-pero
Community Champion

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Quickbooks uses Items , or products and services, to identify individual transactions that may need tracking but can all be part of a whole. You do need to use at least one item, even if you just call it Donations and it posts to Donations in your COA. But with items you have the advantage of being able to split donations to any of several targets that are all part of general fund. IN addition you can direct, by item, any designated funds that must be held separately.

As an illustration you could have the following Items

General Fund Donation

Building Fund

Sunday School

Missions

Advent

Easter

And you could also set up any specific items for memorials or any other reason that the parishioners donate.

I presume you are using  one sales receipt per donor so that you can give them quarterly and annual reports. The destination account for the "Sales Receipt" should be Undeposited Funds and then you create the Deposit by selecting all the included payments of cash and check

tanyagoldy
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

I added Sales Receipt as Undeposited Funds, then made the deposit. Now , when I open  COA and click to Tithe & Offerings  I have doubled records 1 under undeposited Funds  and another  under Checking account (deposit from  online banking)
john-pero
Community Champion

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

The deposit from online banking needs to be "matched" to the deposit already entered. Everything in the feed is For Review and is not "in your bools' unless you add it. Banking is cash flow, not income. It appears you are recording the bank feed as income when it is not
qbteachmt
Level 15

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

This is your Duplicate: "then made the deposit."

You did the work twice using two different methods. You don't enter the deposit in detail. You Select From the UF entry as part of a deposit or you set your Sales Receipt to post directly to the Checking account, already.
qbteachmt
Level 15

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

"When I enter the donations by Donation (Sales Receipt), what is the" item" for? and what is that? why not the chart of account?'

Items control the flow of the data to the accounts and allow for Better tracking and reporting.

Example: You collections include Hurricane Relief Donations. That Service Item links to your regular Restricted Income account, but you use that item for the Donation receipts and for the Giving, and now you can report on Hurricane Relief specifically, as Item-based reports. The Accounting is not micro-managed for various Missions and purposes, in other words.

"how to record the deposit in QB after we deposit the cash+checks to the bank"

You do this After the following:

"how to enter the donations received every Sunday at church?"

You track the giving, and then you address the Various destinations of funds. That means you can Summarize the day on one sales receipt, like this:

Daily Sales Summary Desktop for Retailers by Long

Or you want to track it Per Donor Name, for meeting your specific requirements for reporting.

Or, some of each.








HartleyBookkeeper
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

If I am tracking individual donor's donations via sales receipt, how do I handle a returned check?  Specifically, how do I get the donation off of the donor's giving record?

qbteachmt
Level 15

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

To enter a Reversal of a Sale (Sales Receive/Donation or Invoice/Pledge), you use your donation item on a Credit Memo.

 

Then, you either apply that to the unpaid open invoice; or, you use it to Refund the money from the Credit Memo, directly. That isn't a real refund, of course, to reflect a Bounced Check. It simply is a posting to banking to reflect the lost amount from the initial deposit that is too high or reflects the return of the funds when the bank pulled back the bounce. It's your Banking Bookkeeping entry, not a check to send the funds anywhere, in reality.

HartleyBookkeeper
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

I understand that, but how do I get it off of the donor's record?  I don't want them to get credit for it at the end of the year.

qbteachmt
Level 15

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

For this: "but how do I get it off of the donor's record?"

 

Everything will have their Name on it.

 

The original Donation has their name.

The Credit Memo also has their name; this is the Negative donation.

 

Donation + Negative donation = $0.

 

In QB, you see their list of Activities. The Financial reporting for that name = $0, because you Reversed it.

tcba2016
Level 3

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

In regards to the question about recording Sunday tithes, I have a similar situation. We are a Baptist Association and our budget is completely funded by contributions from the churches in our association. When recording these contributions, do I need to create an item and name it Tithes/Offerings:Church Contributions as on the COA? I post each check separately so that we have a total giving per church. Once an item is created, do I then just post it as payment received? I am using QB Desktop Pro 2019. I appreciate any clarity you can provide.

 

Thank you,

Robin

AlcaeusF
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Hello tcba2016,

 

Thank you for reaching out to the Community. I'm here to assist you with your question about recording Sunday tithes in QuickBooks Desktop.

 

If you set up the business type of your company as a Non-Profit and choose Church or Religious Organization as the Industry, the system will automatically create Tithes/Offerings in the Chart of Accounts. You can either use this account or create a new one and selecting Income as the account type.

 

Here's how:

 

  1. Click the List tab at the top menu.
  2. Select Chart of Accounts.
  3. Click the drop-down arrow next to Account.
  4. Select New.
  5. Choose Income as the Account Type.
  6. Enter a name (ex. Tithes & Offerings).
  7. Choose a tax-line mapping if necessary.
  8. Click Save & Close.

Once done, you can create a service item and use it when you record contributions through a sales receipt or an invoice. Here are the steps:

 

  1. Click the List tab at the top menu.
  2. Select Item List.
  3. Click the drop-down arrow next to Item.
  4. Below Type, select Service.
  5. Enter a name for the service.
  6. Choose the income account.
  7. Click OK.

You can record the contributions by clicking the Customers tab at the top menu and selecting Create Invoices or Enter Sales Receipts.

 

Please keep in touch with me here should you need any further assistance with the church contributions. The Community always has your back.

tcba2016
Level 3

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Thank you for replying. I did as you instructed and I entered in all the checks I have for today. I was under the impression that once I did that I would need to go to Make a Deposit. However, nothing shows up there. 

Charies_M
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Hello there, tcba2016.

 

Allow me to guide you through the whole process of making deposits in QuickBooks Desktop.

 

When you create an invoice and receive the payment, you'll need to choose Undeposited Funds as your Deposit to account. This way, you'll be able to select the right payment that you want to deposit.

 

Here's how:

  1. Open the invoice.
  2. Click Receive Payments.
  3. Choose Undeposited Funds as your Deposit To account.
  4. Enter other information needed and click Save & Close.

 

Now you're ready to make deposit. I'd be delighted to guide you through the steps on how to do it.

  1. Go to Banking.
  2. Click Make Deposit.
  3. In the Payments to Deposit window, select the correct payment.
  4. Click Ok.
  5. From the Make Deposit window, fill in the necessary information.
  6. Click Save & Close.

You may also want to check out this article for your reference: Make Deposit.

 

That should do it. Please know that you're always welcome to post your concern or follow-up questions about making deposits. I'd be happy to help.

elgin
Level 2

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

So if you have a check that is supposed to go half to building fund and half to sunday school fund, how would you record that deposit?  When I make a sales receipt with it broke out, it will only let me deposit to one fund.  It won't deposit to the two funds only one of the bank funds that you select.  Appreciate any help I can get.  The only way we see around it is make two seperate sales receipts for the one check and record the deposits separately.  

MirriamM
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Thanks for visiting the Community, elgin,

 

I'm here to provide information on how to make deposits for two accounts.

 

Upon creating sales receipt, the money will be deposited to your default account being set up.

 

To create deposit for two accounts, here's what you'll need to do:

  1. Click Banking menu at the top, then choose Make Deposits.
  2. In the Payments to Deposit window, put a check mark on the specific payment to deposit, then click OK.
  3. In the Make Deposits window, select the building fund account in the Deposit To field.
  4. Go to the Cash back goes to section at the bottom, then select the sunday school fund account.
  5. Enter Cash back memo (optional), then enter Cash back amount which is the half amount.
  6. Click Save & Close.

That's it! By following the steps above, I'm confident that you're now able to create two deposits.

 

If there's anything else I can do for you, please feel free to reach back out. I'm always here to help. Have a great day!

elgin
Level 2

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Thank you.  that explains for two.  But we have one donor that usually has the donation broke into at least three if not four separate funds.  How would you handle that?  Not trying to be a problem just wanting to figure out the easiest way.

Kristine Mae
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Good day, Elgin.

 

You can create an invoice, make partial payments, and deposit it directly to different funds/bank accounts.

 

But first, you'll have to turn off the Use Undeposited Funds as a default deposit to account feature so you can manually choose what bank account the payment will go to. Here's how:

  1. Click Edit, then choose Preferences.
  2. Go to the Payments tab, then click Company Preferences.
  3. Uncheck the Use Undeposited Funds as a default deposit to account box, then click OK

Once done, create an invoice. Here's how:

  1. Click Customers, then choose Create Invoices.
  2. Fill in the necessary fields, then click Save & Close.

Then, make partial payments. Here's how:

  1. Open the invoice, then click Receive Payments.
  2. Click the DEPOSIT TO drop-down arrow, then choose the bank account.
  3. Edit the payment amount, then click Save & Close.

Follow the steps in making partial payments until you've deposited all amounts to the correct bank accounts. 

 

After depositing it, you can turn on the Use Undeposited Funds as a default deposit to account feature back. Just follow the same steps above on how to turn it off, and just put a check mark in the box. 

 

Feel free to let us know if you need more help. We're just around. 

Sandra461
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

This is exactly what I'm doing, but apparently I'm not doing the deposits correctly. What is the correct way to do it? Also, I've been doing it wrong for a while so all my deposits are incorrect.

Rose-A
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

I appreciate you joining in this thread, Sandra461. I'm here to help and ensure that your questions are addressed accordingly.

 

For me to be able to provide you with the right issue resolution, can I ask for the specific issues you're facing in QuickBooks Desktop? What are the steps you've taken so far?

 

It would be best if you can send me a screenshot as well. Any information that will elaborate on the problem will help me sort things out.

 

To know more about how deposit works in QuickBooks Desktop, you can scan through this write-up: Record and make bank deposits in QuickBooks Desktop. This will provide you details on how to manage your deposits.

 

I hope you can respond to me on this thread so we can work with your concern together. Please know I'm ready to assist further. Have a good one.

stpaulmbcf2-gmai
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Thank you.. Now my question is, how do or can  I keep track of individual donations using chart of accounts to set them up or do I put this elsewhere?

stpaulmbcf2-gmai
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

We have auxiliaries, and each auxiliary has dues. Would I Do a separate  chart of accounts for each auxiliary? Indo need to keep track of it.

MaryLandT
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Let me help you keep track of individual donations, stpaulmbcf2-gmai.

 

You can add a new account to track donations or use the existing one on your Chart of Accounts. 

 

Here's how to create an account.

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. From the Account ▼drop-down, select New.
  3. Select an account type, then select Continue.
  4. Complete the account details.
  5. Click Save & Close.

 

Once done, assign it to the donation item. Then, use the item when you create a sales receipt.

 

You can also consult your accountant to make sure your books have accurate accounting records. If you don't have one, please visit this link: https://quickbooks.intuit.com/find-an-accountant/.

 

Scroll-down at the bottom of the page, you can see there the Select a Country which you can change if necessary.

 

Don't hesitate to leave a comment below if you have follow-up questions about this. Just leave a comment below, and I'll get back to you.

bbretton61
Level 1

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

My question regards the loose money in the offering plate.  So, there's no one to tie that to for a Sales Receipt.  Do I simply create a "dummy customer"?   Cuz...  that's what I did.

DivinaMercy_N
Moderator

How to enter the donations received every Sunday at church? and how to record the deposit in QB after we deposit the cash+checks to the bank?

Thanks for getting back here, @bbretton61. I can share additional information about your concern.

 

Yes, you can create a dummy customer since you've mentioned that there's no specific name tied for that sales receipt. For instance, if you received donations from an event, you can use that event’s name as the customer name. For your reference in creating sales receipts in QuickBooks Desktop (QBDT), feel free to visit this article: Create sales receipts. This also provides links about the accounts receivable workflow in QBDT.

 

In case you want to personalized and modify the preference of your sales forms in QBDT, you can easily customize your form templates.

 

Don't hesitate to post again here if you have any other QuickBooks concerns. I'll be around the corner to help you further. Take care always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us