reports crossing fiscal years

(0) Share

Report

Posted on by Community Member

I am new to GP - we are a not-for-profit and need to run a lot of reports that cross fiscal years. We are still on GP 2010 - hoping to get a grant to upgrade. How do I run a simple report for one account or a range of accounts that can ignore closing entries and print the data range I want. Or in the case it is an asset or liability running over a range crossing fiscal years. Our organization has limited resources so anyone who can help me would be a great Christmas present. We serve under-privileged inner city youth.

*This post is locked for comments

All responses (8)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: reports crossing fiscal years

I have several not-for-profits for which I donate plenty of time. Please drop me an email at info@rbsolutions.com and we can take this conversation off line.
Community Member on at

Like (0)

Report

RE: reports crossing fiscal years

Well I would but as a not-for-profit we can not afford it. Willing to donate any of your time as a tax write-off?
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: reports crossing fiscal years

In the interim, you may want to look into getting someone to write some SSRS reports that group by account and year.
Community Member on at

Like (0)

Report

RE: reports crossing fiscal years

Thanks I will take a look. I sure hope we get grant money to upgrade the system. My staff spend an awful lot of time rekeying stuff into excel to get the reports on the time periods they need.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: reports crossing fiscal years

Grant Management will require the installation of Analytical Accounting. Please make sure you read over both manuals before going down that route. You may also want to read about Multi-Dimensional Analysis. This may be all you need. There is a separate manual for this.
Community Member on at

Like (0)

Report

RE: reports crossing fiscal years

your ideas are great - do either of know anyone who uses the grant module for not-for-profit accounting - that might help?
Bill Campbell 12 on at

Like (0)

Report

RE: reports crossing fiscal years

Richard has given you good suggestion on this - the biggest issue with GP and the fiscal year is that you can not get the Opening Balance to appear on the new year, with out closing the current year.

Just do the elimation entry to 'fake the close' is what we have been asked. While easy to say, harder and complex to do.

As Richard notes there are other options, but require a bunch of work in FRX.

Repost after you have looked at the Smartlist option noted and see what that provides.
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: reports crossing fiscal years

Try using Smartlist and see if that gives you want you want. Smartlist->Financial->Account Transactions.

There are other ways but try this first.