Monthly Income/Expense Reports

Derek Atkins warlord at MIT.EDU
Mon Apr 4 10:36:50 EDT 2011


David,

"David G. Hamblen" <dhamblen at roadrunner.com> writes:

> I've ported the SQL code posted by markluser back on Jul 20 2009 (you
> should be able to find the thread in the gnucash-user archives).  His
> code was for Postgresql, I'm using mysql.  At this point I get a nice
> Income Statement (aka P&L) by year (or month/day/microsecond)  as well
> as Balance Sheets by year (or whatever increment I want).  The SQL
> creates a "view", which can be opened using an OpenOffice Calc Data
> Pilot (pivot table).

What's wrong with the Income Statement and Balance Sheet reports that
already exist within Gnucash (except for the fact that you can only run
them on a per-day basis and not on a microsecond basis)?

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list