entering donation for building fund on donor record

by naking

I entered a contribution from a donor to the building fund on the donor statement to track tithes and offerings but when I enter it doesn't show the amount of the contribution in the total. Why not? Also when I enter a date on some of the tracking records it enters ###### instead because it says something about the total or numbers being negative. How do I get it to accept the date. I am totally baffled.

Comments for entering donation for building fund on donor record

Click here to add your own comments

Feb 20, 2012
Contribution Spreadsheet
by: Vickey

I am assuming you are refering to my contribution spreadsheet.

Something must have got messed up in the download. The amount of the contribution should be showing in the total column and on the front Address worksheet. The date should be showing as well.

The date is an easy fix. Just highlight that column under the Date headline (row 17 unless you have modified the spreadsheet), right click, go down to Format Cells.

In the Category box, select Date.Over in the Type box, select how you want the date to appear.

Click OK.

You will need to do the same on all worksheets where you are getting the error message.

On the problem with the total...are you recording the amount in the right column? The amount should be recorded under the offering heading (Column C if spreadsheet not modified) and then typing the word “Building” under the Fund column (Column E).

Here are the instructions for setting up the contribution spreadsheet.

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 Contributions .

If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.

Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)

Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.