Extract Income/Expense to spreadsheet, but totals don't match

Roland Roberts roland at astrofoto.org
Sat Mar 19 23:30:58 EDT 2016


On 03/19/2016 11:11 PM, Roland Roberts wrote:
> I started out with the budget tool but the way it handles liability
> accounts was confusing me, so I decided to do a poor man's budget and
> just cut and past my income/expense report into a spreadsheet.
> 
> I unchecked "include accounts with zero total balances" and checked
> "omit zero balance figures", changed parent account balanced "do not
> show" and parent account subtotals "show subtotals".
> 
> What I expected was that I could just sum  the right most subtotal
> column for the income section and get the same number GC gives me for
> total revenue. I don't.
> 
> I already checked the account selection. All my income accounts are
> under a single parent account which I selected, then selected "select
> child accounts" and chose "all" for levels of subaccounts.
> 
> What am I doing wrong to end up with a difference here?

I've sort of found it. For some reason, my capital gains account was not
included in the income/expense report even though it is listed as an
income account and even though it is selected. When I manually add that
to my spreadsheet, everything balances out.

I still don't understand why it's not being including in the report....

roland
-- 
		       GPG2 Key ID: 267AF146
Roland B. Roberts, PhD                             RL Enterprises
roland at rlenter.com                            6818 Madeline Court
roland at astrofoto.org                           Brooklyn, NY 11220


More information about the gnucash-user mailing list