Monthly Reports

[chandrespickett]

I'm hoping for some assistance on how, if possible, to change the display on a couple of the reports. When you pull up the Income and Expense and Budget Reports, the amounts the church tithes to other missions shows under the contributions, pulling their percentage of support from the total contributions and reducing the General Fund total.

The elders would like to have the missions NOT show the amount we'll give under the income category (leaving it in the expenses, obviously). They would like to see the raw contribution total on those reports.

My first solution, which was more of a band-aid, was to also begin emailing the Monthly Contribution Totals Report (totals only) to show where our contributions went.

Is there another way to do this, or will I need to save the reports as an Excel spreadsheet and edit them to create custom reports?

Thank you so much!
Chandres

[NeilZ]

I'm hoping for some assistance on how, if possible, to change the display on a couple of the reports. When you pull up the Income and Expense and Budget Reports, the amounts the church tithes to other missions shows under the contributions, pulling their percentage of support from the total contributions and reducing the General Fund total.

The elders would like to have the missions NOT show the amount we'll give under the income category (leaving it in the expenses, obviously). They would like to see the raw contribution total on those reports.

My first solution, which was more of a band-aid, was to also begin emailing the Monthly Contribution Totals Report (totals only) to show where our contributions went.

Is there another way to do this, or will I need to save the reports as an Excel spreadsheet and edit them to create custom reports?

Thank you so much!
Chandres

Some additional questions before any advice could be given:

1. Are you debiting Income accounts when writing checks to these external missions? If not, how are these accounts being reduced?
2. Why is this being done?
3. Do you have budgeting expense accounts for these external missions?

[chandrespickett]

I'm hoping for some assistance on how, if possible, to change the display on a couple of the reports. When you pull up the Income and Expense and Budget Reports, the amounts the church tithes to other missions shows under the contributions, pulling their percentage of support from the total contributions and reducing the General Fund total.

The elders would like to have the missions NOT show the amount we'll give under the income category (leaving it in the expenses, obviously). They would like to see the raw contribution total on those reports.

My first solution, which was more of a band-aid, was to also begin emailing the Monthly Contribution Totals Report (totals only) to show where our contributions went.

Is there another way to do this, or will I need to save the reports as an Excel spreadsheet and edit them to create custom reports?

Thank you so much!
Chandres

Some additional questions before any advice could be given:

1. Are you debiting Income accounts when writing checks to these external missions? If not, how are these accounts being reduced?
2. Why is this being done?
3. Do you have budgeting expense accounts for these external missions?

1. It still falls under the general fund and reduces our general fund as checks are written.

2. I'm not sure the why you mean in asking, but the easy answer in why the budget is set up this way is because that's how it's always been done. It's how the last treasurer did it, and I've not changed it. I've modified the percentages for this budget year to each mission under Contributions -> Setup -> Maintain List of Contribution Funds. From each fund, I can click on 'Accounting' and establish a set percentage that each mission receives. The debit account is our general fund and the credit account is a sub-account for the specific mission. It all still shows up in the general fund.

It being set up this way is extremely helpful to me in writing checks. However, I am also fairly decent with a calculator, so if I have to eliminate these sub-accounts, I'll still be able to figure it out.

3. We have matching budgeting expense accounts for the missions.

I hope that helps, please let me know if I can clarify anything else!
Thank you!

[NeilZ]

1. It still falls under the general fund and reduces our general fund as checks are written.

2. I'm not sure the why you mean in asking, but the easy answer in why the budget is set up this way is because that's how it's always been done. It's how the last treasurer did it, and I've not changed it. I've modified the percentages for this budget year to each mission under Contributions -> Setup -> Maintain List of Contribution Funds. From each fund, I can click on 'Accounting' and establish a set percentage that each mission receives. The debit account is our general fund and the credit account is a sub-account for the specific mission. It all still shows up in the general fund.

It being set up this way is extremely helpful to me in writing checks. However, I am also fairly decent with a calculator, so if I have to eliminate these sub-accounts, I'll still be able to figure it out.

3. We have matching budgeting expense accounts for the missions.

I hope that helps, please let me know if I can clarify anything else!
Thank you!

OK .. now I understand what you're looking for.

Because you have the separate income accounts setup to show the tithe they will always reflect the tithe. It is a great way to keep track of each weeks tithe. But since the board wants to see the entire amount as income you may want to do the following.

1. You can keep the Contribution Funds setup to properly reflect a percentage of what comes in each week.
2. Just change the Income accounts on all such funds to reflect the MAIN contribution income account.
3. You can use the weekly Contribution FUNDS REPORT to see how much was tithed to each mission account so you can then be able to write the proper amounts on the check.

Does this help ??

[chandrespickett]

That makes total sense! The elders see what they'd like on the report, and I'm not having to manually figure out percentages.

On the same thread, since we've already had two Sundays and posted those contributions, is there a way to change how they show up this month, or should I let them know that next month's reports will be the first reports to reflect these changes?

You are always so helpful, thank you for taking time to teach!
Chandres

[NeilZ]

That makes total sense! The elders see what they'd like on the report, and I'm not having to manually figure out percentages.

On the same thread, since we've already had two Sundays and posted those contributions, is there a way to change how they show up this month, or should I let them know that next month's reports will be the first reports to reflect these changes?

You are always so helpful, thank you for taking time to teach!
Chandres

You can Merge the existing income accounts into the main income account using the Move Account button which is found when you open the account detail under Maintain Chart of Accounts.

Click on the Move Account button then select the existing Main Tithes and Offerings account (your name may be different).