Custom Date Ranges

Moderators: Moderators, Tech Support

Post Reply
DBS_CBC
Posts: 18
Joined: Tue Jan 20, 2015 11:53 pm

Custom Date Ranges

Post by DBS_CBC »

Is there a way to produce reports with custom date ranges such as income and expenses from March 18 to August 10 rather than by month to month?

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Custom Date Ranges

Post by NeilZ »

DBS_CBC wrote:Is there a way to produce reports with custom date ranges such as income and expenses from March 18 to August 10 rather than by month to month?
It would have to be a locally created custom report. The standard reports reflect how most churches do their financial reporting which is monthly.
Neil Zampella

Using PC+ since 1999.

DBS_CBC
Posts: 18
Joined: Tue Jan 20, 2015 11:53 pm

Re: Custom Date Ranges

Post by DBS_CBC »

NeilZ wrote:
DBS_CBC wrote:Is there a way to produce reports with custom date ranges such as income and expenses from March 18 to August 10 rather than by month to month?
It would have to be a locally created custom report. The standard reports reflect how most churches do their financial reporting which is monthly.
Do you mean by using Excel or MS Access, etc.

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Custom Date Ranges

Post by Zorak »

Custom Reports in Fund Accounting only give access to month/year balances and budgets. It doesn't report on individual transactions and therefore doesn't allow you to query against transaction dates.

DBS_CBC
Posts: 18
Joined: Tue Jan 20, 2015 11:53 pm

Re: Custom Date Ranges

Post by DBS_CBC »

Zorak wrote:Custom Reports in Fund Accounting only give access to month/year balances and budgets. It doesn't report on individual transactions and therefore doesn't allow you to query against transaction dates.
What is the rationale for limiting reports this way? We routinely have requirements to provide financial reports based on other than month/year balances. We have been running PC alongside our current software hoping to possibly convert over, but this is a significant limitation to our doing that.

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Custom Date Ranges

Post by NeilZ »

DBS_CBC wrote:
Zorak wrote:Custom Reports in Fund Accounting only give access to month/year balances and budgets. It doesn't report on individual transactions and therefore doesn't allow you to query against transaction dates.
What is the rationale for limiting reports this way? We routinely have requirements to provide financial reports based on other than month/year balances. We have been running PC alongside our current software hoping to possibly convert over, but this is a significant limitation to our doing that.
Churches operate on a cash basis. Most churches have budgets based on a 12 month period, and have budgets setup to reflect a monthly spending budget. They need to see a monthly report of income and whether their expenses exceed that income.

In 20 years, and 5 different churches, I've not seen any requirement other than a monthly period report.
Neil Zampella

Using PC+ since 1999.

TAG185
Posts: 5
Joined: Wed May 09, 2018 2:39 pm

Re: Custom Date Ranges

Post by TAG185 »

My question too. I get asked by the pastor for previous ytd to compare with current ytd, for eg. jan-jun 12 2018 to compare jan-jun 2019. For example in the summer months, maybe income is dropping off and the trend is needed to anticipate where it is heading before the month's up, maybe to put a plug for reminding to give etc.

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Custom Date Ranges

Post by NeilZ »

TAG185 wrote:My question too. I get asked by the pastor for previous ytd to compare with current ytd, for eg. jan-jun 12 2018 to compare jan-jun 2019. For example in the summer months, maybe income is dropping off and the trend is needed to anticipate where it is heading before the month's up, maybe to put a plug for reminding to give etc.
Doing a cutoff by day doesn't reflect anything differently than from the 1st of Jan to the 30th of June. Any trend will still be there.
Neil Zampella

Using PC+ since 1999.

DBS_CBC
Posts: 18
Joined: Tue Jan 20, 2015 11:53 pm

Re: Custom Date Ranges

Post by DBS_CBC »

NeilZ wrote:
TAG185 wrote:My question too. I get asked by the pastor for previous ytd to compare with current ytd, for eg. jan-jun 12 2018 to compare jan-jun 2019. For example in the summer months, maybe income is dropping off and the trend is needed to anticipate where it is heading before the month's up, maybe to put a plug for reminding to give etc.
Doing a cutoff by day doesn't reflect anything differently than from the 1st of Jan to the 30th of June. Any trend will still be there.

I have to respectfully differ with you on this. Our current software breaks the budget down by day. We have income at least weekly, and expenses posted throughout the week. We can print reports and analyze financial data over any date range we wish and find this extremely beneficial for much more that just developing trends. Is it that difficult provide date range flexibility in report generation?

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Custom Date Ranges

Post by NeilZ »

DBS_CBC wrote:
NeilZ wrote:
TAG185 wrote:My question too. I get asked by the pastor for previous ytd to compare with current ytd, for eg. jan-jun 12 2018 to compare jan-jun 2019. For example in the summer months, maybe income is dropping off and the trend is needed to anticipate where it is heading before the month's up, maybe to put a plug for reminding to give etc.
Doing a cutoff by day doesn't reflect anything differently than from the 1st of Jan to the 30th of June. Any trend will still be there.

I have to respectfully differ with you on this. Our current software breaks the budget down by day. We have income at least weekly, and expenses posted throughout the week. We can print reports and analyze financial data over any date range we wish and find this extremely beneficial for much more that just developing trends. Is it that difficult provide date range flexibility in report generation?
Most churches have income weekly, as well was daily expenses. You run the report for the current month, and you get month to date reports.

Changes to reports for what you want could involve database changes, along with report changes. If you believe that this capability would enhance the workflow of the majority of churches using Powerchurch, send an email to wishlist@powerchurch.com listing the request, and showing how the request would enhance the reporting capability for churches, along with any other benefits you may see.
Neil Zampella

Using PC+ since 1999.

Post Reply