This forum has been archived. All content is frozen. Please use KDE Discuss instead.

I need help with a budget report

Tags: None
(comma "," separated)
gcash
Registered Member
Posts
96
Karma
0
OS

I need help with a budget report

Tue Jan 29, 2013 1:06 am
I am trying to design a budget report and could use some guidance.
The quarterly budget vs actual which shows each months budget/actual is a very close report.

The total column is somewhat helpful, but what I really need is the total budget for the year for that particular item. The total that now shows is the total of whatever columns are shown. So in my example report the total budget would $6,000 ( $500 x 12 )

As an example, the grocery budget is $ 500.00 per month.
Had I spent $200.00, $300.00, and $700.00, this is what I would want the report to show.

--------- Jan. ---------- ||||| ----------Feb----------- |||| ----------Mar. -----------|||| ------------YTD----------||||| -----------Total------------
Actual Budget. Diff.||||| Actual Budget Diff.||||| Actual. Budget. Diff.||||| Actual. Budget. Diff.||||| Actual. Budget. Diff.
....200.....500....300+ ||||| 300......500....200+||||| 700.........500.....200-||||| 1,200..6,000....4,800+|||||1,200.....1,500......300+

It's the YTD columns that I am looking for, to have them appear on any report that shows the months. I could do away with the Total on this report.
The YTD give you an accurate number for what I have left to spend.
In an extreme example, the complete budget for groceries may have been spent by the end of March, and I would want to know that in advance.

Is there any way to add this additional column to the report ? What I can do now, though I haven't tried it as of yet, is to run 2 reports and import them into Excel and manipulate them there.

Thanks again for a terrific app. I promote it every chance I get, especially now that Quicken 13 has been released.


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], ourcraft