stewardship/charitable church contributions

[Sewingmom]

does anyone know of a free program that i can use for recording my church
contributions for a little church? There are some good programs out there
but right now we don't have the finances to purchase, they are so expensive.
I would love one that is somewhat close to this example.
http://www.powerchurch.com/images/captures/features_product/co.gif

we are looking to record by envelope numbers/names

 

[Fred]

Your application is very simple but very specialized.

Maybe someone knows of a template.

Do you know / are you looking to learn Access? Or, are you seeking to avoid
that? If it's the former, this might be a good one to do yourself....to
start with, post and ask for recommendation on a table structure.

 

[Sewingmom]

so does anyone know of a template?

 

[John W. Vinson]

does anyone know of a free program that i can use for recording my church
contributions for a little church? There are some good programs out there
but right now we don't have the finances to purchase, they are so expensive.
I would love one that is somewhat close to this example.
http://www.powerchurch.com/images/captures/features_product/co.gif

we are looking to record by envelope numbers/names

I've got a church membership database that I donate to those who ask... but it
doesn't presently have a contributions tracking table. It would be easy to add
one, but my time's sort of stacked up at present. If you'ld like to contact me
offline at jvinson <at> wysard of info <dot> com (edit out the blanks and fix
the punctuation) I'd be willing to discuss schedules (the price is right, $0).

 

[Sewingmom]

that does sound a bit overkill for what we need but thanks.

 

[Bob Waggoner]

I wrote a database for the Air Force chaplain service that will do what you
want.
You're welcome to it. It tracks contributions and creates reports to send to
contributors regarding their annual contributions.
It also tracks attendance and has a few other features. The person using it
was not a database expert when I wrote it.

Maybe someone can tell me how to contact sewing mom without either of us
getting inundated with junk mail.

RC W

 

[Sewingmom]

thanks for all the help i found one that will work for now. It only allows
up to 50 entries before we have to start paying though.
it is called church trac. It is very good I just hate that we will have to
pay later

 

[Bob Waggoner]

50 entries is one service - even at a little church (I know, I pastored a
little church). I wrote the database still in use at Dyess AFB, Texas. [Call
the chapel there and talk to Yvonne].

Tables include: [tblTithes&Offerings] and [tblNames]

Tithes&Offierings fields include: [LiChkID] (autonumber primarykey);
[LiCheckNo] (Long Integer for recording the number on the check or envelope);
[txtLastName] (txt field); [txtFirstName] (txt field - you can rejoin the
names in queries or reports later but keeping them separate helps sorting
issues); [CurAmount] (currency field for amount of check or cash offering);
[dteDate] (Date on the check or today's date if cash - set the default to
Date() and then just change it as needed). You can add any other fields you
want. [Also, you could create a simple code for the date field that will put
in today's date with a double-click event if you don't want it to be the
default for the record you create.

If you are not familiar with Access Queries, reports and / or VBA - I'll be
happy to walk you through (using this forum) writing queries and reports to
extract just the information you need. It's a great learning experience and
not very complicated. Plus, it's a lot cheaper doing it yourself than paying
for something off the shelf that goes overboard.

 

[Sewingmom]

that sounds great. If no one else is using it then I will be glad to take
off your hands, how much did you say?

50 entries is one service - even at a little church (I know, I pastored a
little church). I wrote the database still in use at Dyess AFB, Texas. [Call
the chapel there and talk to Yvonne].

Tables include: [tblTithes&Offerings] and [tblNames]

Tithes&Offierings fields include: [LiChkID] (autonumber primarykey);
[LiCheckNo] (Long Integer for recording the number on the check or envelope);
[txtLastName] (txt field); [txtFirstName] (txt field - you can rejoin the
names in queries or reports later but keeping them separate helps sorting
issues); [CurAmount] (currency field for amount of check or cash offering);
[dteDate] (Date on the check or today's date if cash - set the default to
Date() and then just change it as needed). You can add any other fields you
want. [Also, you could create a simple code for the date field that will put
in today's date with a double-click event if you don't want it to be the
default for the record you create.

If you are not familiar with Access Queries, reports and / or VBA - I'll be
happy to walk you through (using this forum) writing queries and reports to
extract just the information you need. It's a great learning experience and
not very complicated. Plus, it's a lot cheaper doing it yourself than paying
for something off the shelf that goes overboard.

thanks for all the help i found one that will work for now. It only allows
up to 50 entries before we have to start paying though.
it is called church trac. It is very good I just hate that we will have to
pay later

 

[Bob Waggoner]

I'm not selling. Consider it a gift. If it works for you, great. If not, no
problem. It's written in access 97 and upreved to 2003. Write to me at
bwaggoner [here's the rest of it] @aircanopy.net Send me an e-mail and I'll
get it to you. You can adapt it as needed.

that sounds great. If no one else is using it then I will be glad to take
off your hands, how much did you say?

50 entries is one service - even at a little church (I know, I pastored a
little church). I wrote the database still in use at Dyess AFB, Texas. [Call
the chapel there and talk to Yvonne].

Tables include: [tblTithes&Offerings] and [tblNames]

Tithes&Offierings fields include: [LiChkID] (autonumber primarykey);
[LiCheckNo] (Long Integer for recording the number on the check or envelope);
[txtLastName] (txt field); [txtFirstName] (txt field - you can rejoin the
names in queries or reports later but keeping them separate helps sorting
issues); [CurAmount] (currency field for amount of check or cash offering);
[dteDate] (Date on the check or today's date if cash - set the default to
Date() and then just change it as needed). You can add any other fields you
want. [Also, you could create a simple code for the date field that will put
in today's date with a double-click event if you don't want it to be the
default for the record you create.

If you are not familiar with Access Queries, reports and / or VBA - I'll be
happy to walk you through (using this forum) writing queries and reports to
extract just the information you need. It's a great learning experience and
not very complicated. Plus, it's a lot cheaper doing it yourself than paying
for something off the shelf that goes overboard.

thanks for all the help i found one that will work for now. It only allows
up to 50 entries before we have to start paying though.
it is called church trac. It is very good I just hate that we will have to
pay later


:


I wrote a database for the Air Force chaplain service that will do what you
want.
You're welcome to it. It tracks contributions and creates reports to send to
contributors regarding their annual contributions.
It also tracks attendance and has a few other features. The person using it
was not a database expert when I wrote it.

Maybe someone can tell me how to contact sewing mom without either of us
getting inundated with junk mail.

RC W
:

that does sound a bit overkill for what we need but thanks.

:

I am in the process of developing a DB for a charitable organization
(supporting children & families in Africa). It is not ready for final
release but is about to start inital user testing. It is fairly complex and
might be overkill for your needs, "manages" clients (demographics),
contributions, child or project sponsorships, events/projects (ex fund
raisers), client interests, and will have a very basic product inventory and
sales component.
Would Excel do what you need.


Sewingmom wrote:
does anyone know of a free program that i can use for recording my church
contributions for a little church? There are some good programs out there
but right now we don't have the finances to purchase, they are so expensive.
I would love one that is somewhat close to this example.
http://www.powerchurch.com/images/captures/features_product/co.gif

we are looking to record by envelope numbers/names