Help with report

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
FBCVandalia
Posts: 34
Joined: Wed Mar 14, 2012 2:35 pm

Help with report

Post by FBCVandalia »

Version using 11.5
Our church would like to see the temporarily restricted income and the expense account together in the income & expense statement. An example would be we have a food pantry & members give a designated offering to this, plus the church budgets for this expense. How can I show the net results for this account?
(income minus expense= total costs to budget)

I'm also wondering how other churches handle camp fees, event registrations, ect. Is this ran through the counting committee, or is it just collected & deposited in to bank by treasurer. Also if someone makes a donation for camp fees - do you considered this a pass through or a temporary restricted income?

Our church published a cook book and members could buy them. Cookbook was paid for before they were sold and extends through 2 budget years - any suggestions on how to show this. I've expenses it under literature and show income as designated to literature.

Hope someone can help me with these questions. I would appreciate other opinions. Thanks
Pam Shaw

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Help with report

Post by JohnDMeyers »

Pam:

There are the "usual" ways to show restricted information. The Income and Expense Statement (you can add columns for budget, etc.).

Take a look at the "Changes in Equity" report. That may show what you are looking for.

Other than that, you are looking at making a "custom report".

Money going for camp registration is "pass-through" as opposed to restricted. Simply create a liability account like this:

Money comes in:
DB 01-1110-000 checking
CR 01-2101-000 camp registration liability

Money goes out:
CR 01-1110-000 checking
DB 01-2101-000 camp registration liability

------------
Cookbooks. How did you pay for the cookbooks? Out of General Tithes and Offerings? Did you take up a special collection?

Either way, you've already recorded the income once. That's all you can do.

Here's what I see happening.
1) money was given to the church
2) you recorded it as income
3) you used the income to purchase cookbooks
4) you sell the cookbooks

The sale of the cookbooks (step 4) is not income, as you can see. It was already recorded as income in step 2).

Therefore, here's what I would do.

Purchase cookbooks:
CR 01-1110-000 checking
DB 01-1210-000 cookbook asset

Sell cookbook:
DB 01-1110-000 checking
CR 01-1210-000 cookbook asset
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

Post Reply