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