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

I have the same question (0)

All responses (8)

Answers (0)

Richard Wheeler 75,852 Moderator on at

Like (1)

Report

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

There are other ways but try this first.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No