Graphs

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

AmandaTarter
Posts: 10
Joined: Tue Sep 01, 2009 12:22 pm

Graphs

Post by AmandaTarter »

The Finance Committee would like to see a "graph" done for the 2010 budget, I cant get this to print b/c there are no expenses yet for 2010....can you do a graph for a Budget?

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Graphs

Post by JohnDMeyers »

I never tried this before, but it did work.

I went to Fund Accounting, Copy Budget to Next Year. (I have a budget set up in 2009).

Then I ran a graph from January 2010 through December 2010. It didn't matter if I selected the box to include accounts with zero amounts or not. It worked either way.

I didn't select the option to compare to budget.

I saw the budget amounts per month and per account, whichever I selected.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

tborgal
Posts: 863
Joined: Thu Jun 03, 2004 4:55 pm
Location: New England Bible Church, Andover, MA
Contact:

Re: Graphs

Post by tborgal »

I tried this but did not have the option to select a year after 2009. How did you accomplish that?
Tom

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Graphs

Post by JohnDMeyers »

Hmmm. It should.

Are you using version 10?

Are you currently in 2009?

When I go to Fund Accounting, Graphs, I have the choice of months (I'm in August), and the choice of 2008, 2009, 2010 for years.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

tborgal
Posts: 863
Joined: Thu Jun 03, 2004 4:55 pm
Location: New England Bible Church, Andover, MA
Contact:

Re: Graphs

Post by tborgal »

I ma using v10 but my year choices are from 2004 to 2009. There is no choice for 2010.
Tom

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Graphs

Post by JohnDMeyers »

I did a restart accounting move at the beginning of 2009, which is why I am limited in history.

I did the "copy budget to next year" move before looking at the GRAPH options. Did you already do that? Maybe that is giving me the ability to look forward.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

AmandaTarter
Posts: 10
Joined: Tue Sep 01, 2009 12:22 pm

Re: Graphs

Post by AmandaTarter »

I tried this by selecting jan-dec 2010 and also only changing to see the "expense" and the "account" it told me " no accout was found to graph" ??? I do have my budget set up for 2010??????

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Graphs

Post by JohnDMeyers »

It told me that "no account was found to graph" when I tried to compare the budget figures to actual. But without that selected, it showed me the graph.

You can check in Fund Accounting - Maintain Chart of Accounts - Budget tab on an account that you think you have a budget set up, to see if there are any budget numbers set up for 2010.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

tborgal
Posts: 863
Joined: Thu Jun 03, 2004 4:55 pm
Location: New England Bible Church, Andover, MA
Contact:

Re: Graphs

Post by tborgal »

There are budget numbers set for 2010 but the choice does not show up in the list.
Tom

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

Re: Graphs

Post by Zorak »

John, Amanda, and Tom, how many months do you have set to be open at a time?

File > Preferences > Accounting Setup > Fund Accounting tab > Number of months that can be open at one time.

I guess your last closed month would be important to know as well.

There is some code in the program that calculates what range of months are "open" when running reports and doing other things. John may have a wider range of months open that ranges into 2010 where Amanda and Tom's range of "open" months do not reach into 2010.

I would have to do more research into the behavior, but that's my guess.

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Graphs

Post by JohnDMeyers »

I am set to 6 months open at a time, and I am closed through July 2010, and my fiscal year is set to start in January.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

tborgal
Posts: 863
Joined: Thu Jun 03, 2004 4:55 pm
Location: New England Bible Church, Andover, MA
Contact:

Re: Graphs

Post by tborgal »

I have max number of months open, so I am currently open from June 2008 thru Sept 2009.
Tom

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

Re: Graphs

Post by Zorak »

OK, I have verified that if your range of open months spans into 2010, you will see 2010 on the graphs page.

I had 6 months open, from Jan 2009 to June 2009. Opened graphs, 2008 and 2009 only.

I changed to 18 months open, from Jan 2009 to June 2010. Opened graphs, 2008, 2009, and 2010.

AmandaTarter
Posts: 10
Joined: Tue Sep 01, 2009 12:22 pm

Re: Graphs

Post by AmandaTarter »

I also have the max amount of months open on mine, but what would that have to do with your "Budget" showing up for 2010?
Also I tried the other suggestion and picked Jan - Dec. 2010 and had "month" selected and "expense" selected, a BLANK graph would come up???? :wall:

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

Re: Graphs

Post by NeilZ »

AmandaTarter wrote:I also have the max amount of months open on mine, but what would that have to do with your "Budget" showing up for 2010?
Also I tried the other suggestion and picked Jan - Dec. 2010 and had "month" selected and "expense" selected, a BLANK graph would come up???? :wall:
The issue is if you have 18 months open, but those months only go through Nov 2009, anything past that would not be available for access by the program. In other words, you should close those earlier months, probably most of 2008.
Neil Zampella

Using PC+ since 1999.

Post Reply