Community Discussion: Report to compare two budgets?

Report to compare two budgets?

Found at:

formatting link
The original poster first says, "I usually create a new budget each year by duplicating last years ..."

Quicken will do that for the user; either automatically when the current system date is in a later year than the most current budget displayed in Quicken, or automatically when the user clicks the right-pointing Budget year arrow when the budget for the current year is displayed.

" ... and then going through and tweaking most of the values."

Once Quicken has automatically created the new year budget, the user can "tweak" any of those automatically created budget values.

But the op's real interest is " ... to run a report or do a comparison of the difference between the new budget and the previous one."

There is no Quicken report that will do that.

But it is possible to export a budget (a budget year) to a tab-delimited text file that can be opened (or imported) into Excel. The user can create a separate tab-delimited text file for each budget, then import those two files into Excel (importing the second one below the first, so their monthly columns are aligned).

At that point it is a fairly trivial matter to visually compare the two budgets.

If the user wants the differences computed, they should be able to utilize Excel features to accomplish that.

Reply to
John Pollard
Loading thread data ...

Allow me to correct that last sentence.

In my testing, I used a budget for only a couple of categories, which allowed Excel to display both budget years fully visible on the screen at the same time.

For those who have budgets with many categories, it will be anywhere from unlikely to impossible to see all the entries for both budget years (or sometimes, for even one budget year) at the same time.

My Excel skills are fairly limited, but I think Excel can still be employed for the original poster's purpose. I will leave it to those with more refined Excel skills to address the details to achieve the desired end.

Reply to
John Pollard

Sure there is.

Current Budget Custom Dates - pick a span of several years Interval - year

Reply to
Taxed and Spent

Well, it's true, you can see multiple budgets in Quicken budget reports.

But the Quicken budget reports don't compare budgets to one another; they compare actuals to budgets. And I believe it's likely a user would want to see their budget comparisons by month (which is the common period used for budgeting); budget reports with an interval of "Month" would have one year's values totally off screen, making even visual comparisons difficult.

In Excel, one can see and compare only budget amounts (with no actual amounts to distract and waste space), and the two budgets can appear one below the other (with the same months aligned in the same column), rather than one appended horizontally to the other as in the Quicken budget reports.

I believe that a user could utilize Excel's capabilities to compute the $amount differences between two budgets imported from Quicken.

Reply to
John Pollard

Yes, but dumping what I have suggested is a much better starting point.

Reply to
Taxed and Spent

I'm not convinced of that.

And I'm basing my opinion significantly on how the process would impact the desire in original post the Quicken Community.

Further: A case can be made that a Quicken user taking the, apparent, starting approach of the original poster in the Quicken Community could not use your approach at all. As I noted in my original post in this discussion, it appears the op in the Community is creating a "new" budget for the new year (that used to be the only way to budget for a new year - there was no way to extend a budget to subsequent years)... NOT extending an existing budget to the new year. Quicken has no ability to utilize two different budgets in the same report.

But it will be those who feel they have a need for the process who will ultimately be the judge of the best approach (I'm not one of those people).

What would really be beneficial to this issue would be someone taking the Excel ball and running with it - then posting here how to have Excel do more/most of the work.

Reply to
John Pollard

I don't use Q budgets, but it looks like a user can create a budget for every year, then run a report as I suggested.

I did dump the report to excel, deleted columns for actual and difference numbers, and then did y/y comparison calculations easy peasy.

If he is creating a NEW budget for each year, he is already doing things the hard way. But I do not interpret his comment to really mean what you are suggesting he has said. But it is anybody's guess.

Just use the same budget, but update it each year. That budget will then have each year to look at.

Either way, you can dump to excel and manipulate it easy enough (unless you change your budget around every month!). But if one really creates NEW budgets, they will have to make sure the categories match, or there will be hell to pay during the excel phase.

I don't use budgets - I just make sure I spend less than I take in. LOL.

Reply to
Taxed and Spent

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.