Income & Expense Statement Help

evansnkm · Post by **evansnkm** » Wed Apr 13, 2005 10:51 am

Is there a way to print the Income & Expense Statement that will seperate the receipts and the expenses - if not, can someone guide me in setting up a custom report to do this. Thanks!

Matt · Post by **Matt** » Wed Apr 13, 2005 6:09 pm

If your chart of accounts is set up right it should already be separating these for you. Or, I'm not understanding your question correctly.

evansnkm · Post by **evansnkm** » Thu Apr 14, 2005 9:03 am

On my Income and Expense Statement, in the Current Period column, the amounts are what came in minus what went out, but not seperate. What the budget & stewardship committee wants is seperate columns. One column for what came in and one column for what went out. (They want to use this as our financial statement for the congregation.) This may already be possible, but if it is, I don't know how to make it happen. I should be set up correctly, as we paid a PowerChurch consultant to set it up for me.

Matt · Post by **Matt** » Thu Apr 14, 2005 10:23 pm

Can you show a sample of the report format you are looking for? Please include a couple of revenue and expense lines with dollar amounts for illustration purposes.

evansnkm · Post by **evansnkm** » Fri Apr 15, 2005 1:08 pm

January Year to Date January Year to Date
Receipts Receipts Expenses Expenses
MISSIONS
Coop. Program - 18% $3,639.13 $3,639.13
GCCBA - 5% $1,010.87 $1,010.87
Benevolent Fund
CARE $34.00 $34.00
DFM $100.00 $100.00 $500.00 $500.00

This is sort the format we are using now. This comes from an excel worksheet. The only other thing that is on the excel worksheet (I ran out of room) is a Year to Date Balance, that states the budgeted amount that is remaining. The main thing the committee is interested in is a receipts column and an expenses column (or Debit and Credit). (After I preview this message, I realize it looks nothing like I have typed it in. I hope you get the idea.) If I need to, I can email a copy directly.

Matt · Post by **Matt** » Sat Apr 16, 2005 9:52 pm

OK--I think I understand what you are looking for. Powerchurch can produce an Income and Expense report with the month to date and year to date information you want. However, the standard report will print in this format:

Income:

January---Year To Date

Expenses:

January---Year To Date

You would need to build a custom report to show month to date and year to date income and expenses in side by side columns. I can see where this format might be useful if you had designated accounts where both the income and expense account had the same name, such as your DFM account. In cases such as this, I would set up restricted accounts. Then, you could use the Changes in Equity report to see the income and expenses side by side for each restricted account without having to build a custom report.

evansnkm · Post by **evansnkm** » Thu Apr 21, 2005 12:28 pm

I may be missing something somewhere, but I can't find a standard report that will print the income and expenses seperately (other than the Changes in Equity report).

Also, in custom reports, there is not an option for month to date income or month to date expenses that I see.

I know you probably don't have time to guide me step by step, but as close as you can...please...

Sorry if I am being a moron...just trying to understand.

NeilZ · Post by **NeilZ** » Thu Apr 21, 2005 3:25 pm

evansnkm wrote:I may be missing something somewhere, but I can't find a standard report that will print the income and expenses seperately (other than the Changes in Equity report).

Also, in custom reports, there is not an option for month to date income or month to date expenses that I see.

I know you probably don't have time to guide me step by step, but as close as you can...please...

Sorry if I am being a moron...just trying to understand.

Here's another idea ...

If you run the standard Income & Expense report .. and save it as an Excel spreadsheet you can then copy and paste the output anyway you want .

Would that help ??