Reports- Income and Expense Statement

[Church Secretary]

Howdy

Here's what's up...
I currently pull an Income and Expense Statement report to give to our deacons. I do this monthly.
Not all the men understand the report and it seems no matter how much I explain it they just can't get it.
The reason I pull the Income and Expense Statement is because they just want to go through and see the percentage in the " Annual Budget Percent" column to make sure the percent is where it should be.
They really do look at more than the percent but that is the biggie.
So because there is income for some of the line items and they have to figure it out in their heads they grown...LOL

So what I'm looking for is a report or a way to maybe put Income and Expense side-by-side OOOOOOOOr in their perfect world the percent would accurately reflect the true percent which includes the income and expense.

Is there a report that can accomplish what their looking for?

Thx for your help

[NeilZ]

Howdy

Here's what's up...
I currently pull an Income and Expense Statement report to give to our deacons. I do this monthly.
Not all the men understand the report and it seems no matter how much I explain it they just can't get it.
The reason I pull the Income and Expense Statement is because they just want to go through and see the percentage in the " Annual Budget Percent" column to make sure the percent is where it should be.
They really do look at more than the percent but that is the biggie.
So because there is income for some of the line items and they have to figure it out in their heads they grown...LOL

So what I'm looking for is a report or a way to maybe put Income and Expense side-by-side OOOOOOOOr in their perfect world the percent would accurately reflect the true percent which includes the income and expense.

Is there a report that can accomplish what their looking for?

Thx for your help

Not in the standard reports.

Do they realize that the Annual Budget Percent on the expense side just shows how much has been spent so far this year?

On the income side it the Annual Budget Percent will reflect what has been budgeted as income.

It doesn't reflect anything else.

So if they budgeted 100 for the year as an expense, and they have only spent 200 since the beginning of the year, all they will see is that they've spent 20% of the budgeted amount.

On the income side, if they estimated an annual income of 1,000, and they have received 400 since the beginning of the year, all they will see is that they've received 40% of the estimated income to date.

There really isn't any relationship between the expense and the income except you subtract expenses from income to see if there is too much spending or an excess of income to date.

What exactly are they expecting to see ??

[Church Secretary]

LOL, we all know how the report works BUT there are some that don't like to "do the math".

The income in question is NOT budgeted income.
Here's the layout...
Church Repair (B&G) Exp. 01-5321-138. Budget at 20,000
Church Repair (B&G) Inc. 01-4321-138. Nothing budgeted so the percent doesn't change.

NOW...It's this statement that you made,
"you subtract expenses from income to see if there is too much spending or an excess of income to date"
that causes the average joe who's looking at the reports to question, question, question.
Don't get me wrong we like questions but this comes up EV-ERY-TIME.

So I'm asking if Power Church has a stock report that merges the Income and Expense to give that accurate "Annual Budget Percentage" so I don't have to do all the math and create a report that helps our members understand the spending better.

Thx Again

[NeilZ]

LOL, we all know how the report works BUT there are some that don't like to "do the math".

The income in question is NOT budgeted income.
Here's the layout...
Church Repair (B&G) Exp. 01-5321-138. Budget at 20,000
Church Repair (B&G) Inc. 01-4321-138. Nothing budgeted so the percent doesn't change.

NOW...It's this statement that you made,
"you subtract expenses from income to see if there is too much spending or an excess of income to date"
that causes the average joe who's looking at the reports to question, question, question.
Don't get me wrong we like questions but this comes up EV-ERY-TIME.

So I'm asking if Power Church has a stock report that merges the Income and Expense to give that accurate "Annual Budget Percentage" so I don't have to do all the math and create a report that helps our members understand the spending better.

Thx Again

Nope ... because they are not tied together in any way. If you kept the church repair stuff in a different accounting fund, yes it would show up at the bottom line, but there is nothing that will show what you're asking for in each account budget percentage.

Now ... if you added sub-account numbers to the income and expense accounts that they have questions about, then you could run a sub-account report for each sub-account number and get them something that looks like this:

Code: Select all

                                                  Connellsville Presbyterian Church
04/26/2016 08:56 PM                                 Sub-account Report                              Page:       1
                                                                  December 2015
                                                                                                      Budget
Account    Account Name                      Category          Beg.        Period      Curr.        Annual  Difference
                                                             Balance                  Balance
Sub-account 001 
MS-4105-001Johnstown Presbyterian Ho       Income            10.00         0.00       10.00         0.00       10.00
MS-4106-001Redstone Highlands Home          Income            10.00         0.00       10.00         0.00       10.00
           Sub-account 001 Income                             20.00         0.00       20.00         0.00       20.00

MS-6641-001Johnstown Presbyterian            Expense            0.00       100.00      100.00         0.00      100.00
MS-6642-001Redstone Highlands Home         Expense            0.00       100.00      100.00         0.00      100.00
           Sub-account 001 Expense                             0.00       200.00      200.00         0.00      200.00
  
           Sub-account 001 Income/Expense               20.00      -200.00     -180.00         0.00     -180.00

it would take a bit of time for you to setup, then you'd have to run each set of accounts separately, but you could eliminate some of their questions, possibly ..

[NeilZ]

Drat .. that never seems to format right .. you get the idea however.