Doing a treasurer's report

} 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 } "######".

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\