Doing a treasurer's report

I don't think you can do this sort of report in Quicken. Probably the best thing to do is to export your activity report to Excel then edit the spreadsheet to include your beginning and ending balances, that you type in manually. Modify the spreadsheet to actually do the math (i.e., beginning balance + net activity = ending balance) just to make sure you've accounted for everything properly.

Tom Young

} On Sep 27, 10:44 am, Bernie Cosell wrote: } > Q2009Deluxe/XP-pro: I'm treasurer of a small club and need to make } > occasional "treasurer's report".... } >

} > What I'm talking about is a report that looks like } >    Balance at beginning of period            $xxxxx } >       [activity, in my case grouped by categories] } >    Balance at end of period                  $xxxxx

} I don't think you can do this sort of report in Quicken. Probably the } best thing to do is to export your activity report to Excel then edit } the spreadsheet to include your beginning and ending balances, that } you type in manually. Modify the spreadsheet to actually do the math } (i.e., beginning balance + net activity = ending balance) just to make } sure you've accounted for everything properly.

Thanks... but I'm an Excel novice... it is easy/possible to get nicely formatted "reports" out of excel. [Dunno what Q exports, but I'd also need title/date info and junk like that]. It is easy/possible to write little "excel programs" that'll fix data like this? I assume I'll get a lot of columns some of which'll have to be moved around, proper column-formats applied [and as I said, I haven't a clue how to get a nicely-formatted report, similar to what Q produces], but it'd be nice to be able to do that with some kind of 'prebuilt' macro or program that I could just load the quicken data into and have it get magically "reportified". THANKS!

/Bernie\

Bernie Cosell wrote in news: snipped-for-privacy@library.airnews.net:

I've done those things. Everytime it was a hassle. Just like it was a hassle to reconcile the bank's balance as reported on the statement with Quicken's balance at the end of the reporting period (totally different time frames of course). And especially because there always seemed to be checks outstanding that hadn't been cashed, and bills that were anticipated but hadn't come in.

I'm treasurer off now, but indeed I'd like to see a nice and easy way to do this ...

This project takes very little Excel knowledge.

You export the report ("Export Data" drop-down menu in the upper left- hand corner of the report) which produces a text file with the name you provide. You start up Excel and do File > Open and then navigate to the text file that Quicken places in the Quicken folder. Excel's "Text Import Wizard" starts up and you click "Next", "Next", "Finish". The report shows up in Excel looking pretty much like it looks if you printed it to paper, though you probably will have to adjust column widths (a drag and drop operation) to get income and expense titles fully readable and too-large numbers to stop showing as "######". At this point there are no formulas within the Excel file, just titles and numbers placed into cells.

By default the numbers appear in Excel's "General" format, meaning non- significant zeros are dropped (e.g., 12.50 will show up as 12.5) so formatting the numbers (select range, right click, select "Format cells") will probably be necessary be necessary. There's a few more formatting tweaks you can do (e.g., put in underscores for subtotals, etc.) but at this point the report is fully readable and understandable. The final steps would be to insert the beginning and ending balances you'd copy off a Quicken Net Worth report along with their titles and then ensuring that the math (Beginning Balance + Overall Total = Ending Balance) is correct. If you've done things properly this math should be correct but you should always check anyway. You can do this checking either within the Excel file itself or by simply pounding the numbers into a calculator.

You could attempt to have all this happen with an Excel macro but, frankly, I think that would be more trouble than it's worth as the basic formatting is pretty quick and easy to do manually, once you get the hang of it.

Tom Young

} This project takes very little Excel knowledge. } } You export the report ("Export Data" drop-down menu in the upper left- } hand corner of the report) which produces a text file with the name } you provide. You start up Excel and do File > Open and then navigate } to the text file that Quicken places in the Quicken folder. Excel's } "Text Import Wizard" starts up and you click "Next", "Next", } "Finish". The report shows up in Excel looking pretty much like it } looks if you printed it to paper, though you probably will have to } adjust column widths (a drag and drop operation) to get income and } expense titles fully readable and too-large numbers to stop showing as } "######".

VERY NICE. Now I can go to the other report to get the opening/closing balances and with a few insert-rows I'll be good to go. One thing: doing the export as tab-separated helped. Doing it as a simple text file lost all the indentation from titles->categories->subcategories, but importing the tab-sep got me just the right thing.

THANKS!!

/Bernie\