Home
Prayer for Husband
Support
Accounting Packages Church Accounting
Accounting  eBook
Contribution eBook
Help & Be Helped What's New
Questions/Comments
Free Stuff Free Newsletter
Free Spreadsheets
Spreadsheet Reviews
Customize Sheets
Freebies
Accounting Definitions
Basic Accounting
Fund Accounting
Petty Cash Account
Financial Statements
Church Software
Contributions Contributions
Annual Statement
Non-Cash Receipt
Love Offerings
Gift to Individual
Membership Software Shepherdbase
Churchtrac
Administration  Church Budget
Audits
Internal Controls
Staff
Reimb Expenses
Tax Exempt Status
Records Retention
Track Receipts
Healthcare Refund
Clergy/Minister Clergy Tax
Housing Allowance
Fringe Benefits
Percentage Pay
Employee or Not
Ministers W-2
Estimated Taxes
Opt Out SS
Payroll Payroll Set Up
Payroll Taxes
W-2/W-3
1099-MISC
Form 941
Annual To-Do List
Misc. QuickBooks
Cut Back Tips
Office Supplies
Budget Tips
Fundraiser Tips
Pastor Appreciation
Resources Church Web Site
Resources/Links
SiteSearch
Information About Me
Contact Me
Terms of Use
FAQ
[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Tracking Pledges

by Kathy
(Massachusetts)

We use QuickBooks Online for the Operating Account in my church of about 100 members.

I am the treasurer, and have a question about tracking pledges.

Our next church fiscal year goes from July 1, 2011 to June 30, 2012.

Our Stewardship Campaign for this next fiscal year starts later this month. Many people pledge and make out a check right then, which is deposited into the bank THIS fiscal year.

For example, their pledge is for $1,000. They write out a check for $500, which is deposited this FY, and start paying down the next $500 after July of 2011.

My question is: how do I track payments of a pledge during two fiscal years?

We do not have any financial oriented members to help me with this, nor do we have funds to seek the advice of a CPA, so I am on my own with this. Any suggestions as to how to track this in QuickBooks would be much appreciated.

Thank you!

Kathy




Comments for
Tracking Pledges

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 03, 2011
Rating
starstarstarstarstar
Pledges within QuickBooks
by: Bill OConnell

I have a lot of experience with churches and with QB - but no experience with QB online.

Having said that - your problem is an accounting problem and not a QB problem.

If QB online supports the concept of sub-accounts in the GL, then create a master [current asset] account named Pledges. Manage it through the use of sub-accounts. For each pledge debit a new sub-account with the name [Smith] [$100]. Offset it with a credit to the sub-account named Uncollected Pledges.

Done this way your debit sub-accounts become a trial balance of uncollected pledges, and will equal the Uncollected pledges [credit balance] - and not distort your other accounting.

With each check that arrives, debit cash in your deposit and relieve [credit] the [Smith] sub account. At the end of the month make a journal entry equal to all such relief and debit the Uncollected Pledges and credit Building Fund Revenue.

Call me with questions at 877-823-3101. Find me at www.wisdomoverwealth.com.

Mar 09, 2011
Rating
starstarstarstarstar
Response to Tracking Pledges
by: Kathy

Thank you very much for your suggestions. QB Online does have the option of sub-accounts. I will set up a parallel "company" (to try this out until I really understand what I am doing!) with a Current Asset Account for Pledges, and sub-accounts for each pledging member. The Uncollected Pledge account will also be a sub-account of Pledges. I will follow your suggestions for debits and credits when member payments come in, and make a monthly journal entry with a debit to Uncollected Pledges and a credit to Pledge Income, rather than Building Fund Revenue.
I appreciate your help - this is the first time anyone has understood my questions about how to deal with this!
Kathy

Click here to add your own comments

Join in and write your own page! It's easy to do. How?
Simply click here to return to Church Accounting Software






 

Custom Search

Church Accounting Package

Church Accounting Package

  • Want to learn some basic church accounting basics?
  • Need to know how to fill out a noncash donation receipt?
  • How about some tips on setting up a fund accounting system?

Click here for details


Testimonies

Would Highly Recommend. Took the mystery out of Church Accounting for me ...more...

Excellent Book! I highly recommend these books. They are a necessity, WRITTEN IN PLAIN ENGLISH!
Errol James

Real Eye Opener. Not knowing a thing about church finances, this was a real eye opener and a great way to get us started ...more...

Very Helpful and Detailed I would recommend these books to everyone, I am from Canada and would also recommend it to all of the Canadian people involved in the Finance part of the church. Very helpful and detailed. A must get!! ...more...

more testimonies on bottom of this page...


Small business accounting software




Free Accounting Spreadsheets

when you...

Subcribe to my free newsletter: Stewardship


Testimonies

Your spreadsheets work wonderful-I have Pastored for 17 years in 3 different churches, and this is the best and easiest finance program for the Church that I have seen yet!
Pastor Tim

Thank you so much for sharing your spreadsheets! I expect the Lord will reward you in heaven for helping those of us that needed some quick help...more...
Darla

Free Spreadsheets I've downloaded several of your spreadsheets and I had no problem with them. They have helped me to keep better records, also they are well structured professionally... more...
Mary

The free accounting spreadsheets were a life saver. I was able to immediately start using them and they saved me more time than I could ever imagine being able to save! I'm now organized!... more...

more testimonies...


Recommended Products





Shoeboxed Works Great With Evernote


Bookkeeper 2011