Home Page link  

Treasurer's Report

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Treasurer's Report Bernie Cosell 05-06-2008
Posted by Bernie Cosell on May 6, 2008, 1:28 pm
Please log in for more thread options
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 <STARTDATE>:
<income and outgo transactions during the interval>
Balance as of <ENDDATE>:

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
--
Bernie Cosell Fantasy Farm Fibers
bernie@fantasyfarm.com Pearisburg, VA
--> Too many people, too few sheep <--

Posted by John Pollard on May 6, 2008, 2:05 pm
Please log in for more thread options
Bernie Cosell wrote:
> 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 <STARTDATE>:
> <income and outgo transactions during the interval>
> Balance as of <ENDDATE>:

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

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Bernie Cosell on May 9, 2008, 7:24 am
Please log in for more thread options

} 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

--
Bernie Cosell Fantasy Farm Fibers
bernie@fantasyfarm.com Pearisburg, VA
--> Too many people, too few sheep <--

Posted by John Pollard on May 9, 2008, 9:36 am
Please log in for more thread options
Bernie Cosell wrote:

> 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].

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").

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
Report Wont Ask to Create Reconcile Report March 15, 2008, 7:42 pm
Cannot Create New Report From Existing Report December 30, 2007, 3:53 pm
Report Transfers September 4, 2006, 12:15 pm
Reconciliation Report November 2, 2006, 8:50 pm
Tax Summary Report January 5, 2007, 1:51 am
Tax Report Wrong January 13, 2007, 8:50 pm
What's best report for all transactions? January 19, 2007, 1:50 pm
Schedule D Tax Report January 26, 2007, 4:51 pm
Lost Report January 1, 2008, 1:27 am
"X" in Portfolio report January 23, 2008, 10:32 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap