Need custom report?

Mike or Penny Novack mpnovack at mtdata.com
Mon Jul 20 08:50:41 EDT 2015


On 7/19/2015 4:57 PM, Wm... wrote:
> Thu, 16 Jul 2015 06:21:31 <1437052891321-4679494.post at n4.nabble.com>
> Oliver64 <jagjit at gmx.com> wrote...
>
>> Thanks for your quick answer!
>> Maybe I am too picky, but what I do not like about the CashFlow is that
>>
>> 1) I cannot select the ExpenseAccounts but only the BankAccounts
>
> That says you do not understand the report.  You can use any 
> combination of accounts.  It says what went in and out.
And I will double that. You do not know what a "cash flow" report is 
supposed to show. Consider the possibility that if you are wanting to 
look at how much went for this or that expense then it isn't a "cash 
flow" report but some other sort of report you should be looking at.


>
> I sometimes use it upside down, i.e. I choose an expense account (say 
> shoes from your example below) and it does what I know it should do.
>
>> 2) The report does not show subtotals of the parent accounts
>
> I don't think you understand what is being shown.
More to the point, I do not think you have yet explored "report 
options". There are all sorts of things about reports that you change 
there (like how subtotals are handled)
>
>> 3) Expense Accounts appear in the Income & Expense section: Means 
>> when my
>> wife buys 5 pairs of shoes on Amazon to select (250EUR) and later on 
>> returns
>> 4 of them (200EUR), I would like to see just one number: Expense:Shoes =
>> 50EUR, and not have to manually add 2 numbers later on...
>
> Why?  The report is showing the flow of money.  Your liabilities 
> increased when the purchase was made and decreased afterwards.
>
>> So best case I would like to combine theses reports somehow in scheme 
>> files
>> ? plus very-best case also add the starting/ending balance of the 
>> related
>> accounts...

Again, not understanding what the "cash flow" report is all about (what 
DIFFERENT thing is it trying to show you than some other report). Let us 
take this very example, yes? On date 8/02/15 the shoes are bought for 
250EUR, paid for by check, at a time where the checking account balance 
was 200EUR. On 8/12/15 some of the shoes returned, and a refund check 
for 200EUR received and deposited on 8/22/15.

In terms of starting and ending balance, everything was hunky-dory, yes? 
Bit in terms of what a cash flow report shows, there was a cash flow 
problem with that first check bouncing (or starting an "overdraft" 
situation if that kind of account)

Michael


More information about the gnucash-user mailing list