Treasurer's Report

May 06, 2008 3 Replies

This with Q2006 Basic on XP: Is there some trickery in the 'reports' stuff for making a standard "Treasurer's Report"? The kind I'm thinking of here is the report that looks like:



Balance as of : Balance as of :



I suppose I could export a transaction report as a csv file and then try to figure out how to get Excel to format the report [I know close to nothing about Excel and even less at trying to get it to function as a report generator, with page headers, fancy formatting, etc]. Any other way to do it? [or help, templates, whatever for pounding Excel into submission..:o)]



This seems like such a simple/typical report -- does a newer/fancier version of Quicken include something like it? Thanks!!



/Bernie\


For a single Quicken non-investment account: open the account to its register, then click "Report" in the register menu bar, then "Register Report".

} Bernie Cosell wrote: } > This with Q2006 Basic on XP: Is there some trickery in the } > 'reports' } > stuff for making a standard "Treasurer's Report"?

} } For a single Quicken non-investment account: open the account to } its register, then click "Report" in the register menu bar, then } "Register Report".

Thanks! Turns out that the report is called a "Transaction Report" in Q2006 and it is a bit of an odd duck [which is, perhaps, why I didn't notice its treasurer-ness before..:o)]: If you tell it NOT to group the transactions at all, you do, in fact, get a "treasurer's report": starting balance, ending balance and the transactions listed in chronological order. BUT: if you tell it to do ANY sort of grouping, then the treasurer-ness goes away [e.g., I tried to get the transactions groups by category instead of chronological, but that doesn't just change the order of listing/grouping, it changes the entire report]. But overall, it was just what I was looking for... Thanks!!

/Bernie\

I find that in Q2008, I can "group" transactions by using any of the "Sort by" choices without losing the balance forward and ending balance.

I can also keep the balance-forward/ending-balance when I "Subtotal by" a "period" (like "Month").

Only when I use the "Subtotal by" with non-date type choices (like Category or Payee) do I lose the balance forward and ending balance.

I think balance-forward and ending-balance are not meaningful to transactions subtotalled by Category or Payee, etc.; just to transactions subtotalled by a date of some type (which includes "Don't subtotal").

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required