Cashflow Report on Split Transactions in Checking Accounts

David Carlson carlson.dl at sbcglobal.net
Sun Jan 22 19:28:20 EST 2012


On 1/22/2012 12:52 PM, casi wrote:
> Hm, well, I checked out the link below. There is no difference to how I
> use it:
> 
> I have 
> - an Income:Salary 
> - an Asset:Checking
> - several expense accounts for receiving the taxes and deductions.
> 
> In the Income account I enter the complete paysheets for the previous
> year, including gross income.
> The NET transaction is one of the splits, targeting the checking
> account.
> Once that I close the split view, I see the gross value in the 'Income'
> column.
> That should all be correct.
> 
> After entering all split transactions in the income account I open the
> checking account register.
> I can see the transactions with the NET value in the 'Deposit' column.
> Once that I open the split view I see basically the same split structure
> as in the income account.
> That should all be correct.
> 
> So, basically it looks the same as in the diagrams shown in the link
> that you sent me.
> (All account totals are as expected in the ledger view.)
> 
> Now I run the cash flow report on the income account (i.e. only
> selecting the Income:Salary account) for the whole passed year 
> -> I see the the accumulated net value going to the checking account
> (OK)
> 
> Now I run the cash flow report on the checking account (i.e. only
> selecting the Asset:Checking account) for the whole passed year
>  -> I see the accumulated gross value coming from the income account
> (not OK, according to my understanding).
> 
> Is it working ok for you?
> 
> -Carsten
> 
> 
> 
> On Sun, 2012-01-22 at 07:35 -0800, Dave Niezabitowski wrote:
>> It sounds like you're classifying your split incorrectly. 
>>
>> You should have your Gross amount in your ledger too. Not just your
>> Net. You enter your NET in your transaction register but you also have
>> an entry for your Gross.
>>
>> It sounds like you should have the following Accounts
>>
>> Assets:Checking
>> Income:Salary(Net)
>> Expenses:Taxes:FICA
>> Expenses:State
>> Expenses:Federal
>> Expense:(Whatever other deductions you have coming from your check)
>>
>> You should have an entry for both your Gross and Net if you're going
>> to track your whole check. If you're only entering your NET and not
>> the gross but still entering your paycheck expenses, then your totals
>> won't match.
>>
>>
>> Check out this entry for splits showing a paycheck
>> http://svn.gnucash.org/docs/guide/txns-registers1.html#txns-register-multiaccount
>>
>>
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

Sometimes it is hard to see the forest when all those dang trees are in
the way.  Try running the report again for your checking account and for
only one (pay)day.  You will probably find that every line in your
paycheck transaction is accounted for except the net pay, because the
net pay actually stayed in the account, rather than 'flowing' in and out.

So, if you want to know the total net pay for the year, run a report for
Salary and see how much went to the checking account.

Does that make sense?

David C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0xDC7C8BF3.asc
Type: application/pgp-keys
Size: 1729 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120122/78bfec92/attachment.bin>


More information about the gnucash-user mailing list