Cash Flow Report Changes
Carsten Rinke
carsten.rinke at gmx.de
Tue Apr 8 15:37:58 EDT 2014
Hi Robin,
My understanding is that you prefer a cashflow report that interprets
the transaction below like this:
Asset ---------------------> Electricity
^ \
| \
| ----------> Gas
Prepaid
Running the same cashflow report on the Prepaid account should then
result in
Asset ---------------> Electricity
| /
| /
V /----------> Gas
Prepaid-/
and running it on the Gas account would result in
Asset --- Electricity
\ ^
\ |
\ |
Prepaid ------------> Gas
(I hope this nice piece of art survives the mail tranport)
Isn't this a bit inconsistent?
Kind regards,
/Carsten
On 04/07/2014 01:07 AM, Robin Chattopadhyay wrote:
I skipped over this thread when it first came up, but I just noticed
the behavior described in #722140. My use case for the cash flow report
appears to match that of Tim Barber and John Halton.
In my household/personal finance (no business features) scenario, I pay
a single vendor for electricity and natural gas. Further, I pay a flat
amount (averaged monthly payment) regardless of usage. Once or twice
per year, the utility will true-up what I've paid with what I owe (or
they owe me since the difference can go either way).
I track the actual monthly expense based on usage and offset the
remainder against a "prepaid expense" asset account.
The transaction looks like this in the register:
Expenses:Utilities:Electricity.......69.18
Expenses:Utilities:Natural Gas...122.18
Assets:Checking.................................(141.00)
Assets:Prepaid Expenses......................(50.36)
In the cash flow report (selecting only Assets:Checking) however, it
looks like this:
Expenses:Utilities:Electricity........50.97
Expenses:Utilities:Natural Gas.....90.03
I understand Carsten's argument (I think) about physical flows, but I
think there is a clear use case for a cash flow report that addresses
logical flows. In other words, my combined expense for electricity and
natural gas was $191.36, but I only paid $141.00 this month and that
remaining $50.36 had to come from *somewhere*.
I tried the suggestion of using the Transaction Report with the "Other
Account Name" checked. This, however, didn't solve my problem because
the transactions with multiple splits are just reported in that report
as "Split Transaction".
On Sun, Apr 6, 2014 at 8:37 AM, Carsten Rinke <[1]carsten.rinke at gmx.de>
wrote:
hmm, no replies so far.
Does that mean there are no cashflow report users out there?
Carsten
On 04/01/2014 03:12 AM, Tim Barber wrote:
After upgrading to 2.6.2, I have come across a difference in the
Cash Flow report which I believe is not correct. The problem is that
now a transaction cannot have both an expense and income. An example
would be for a deposit, I have also have a cash expense that I would
record in the deposit. This worked well previously because the
report would show both the income and expense as well have a single
entry in the register which is what I would see in the bank
reconciliation at the end of the month (which made the
reconciliation a breeze). With 2.6 I can either do a double entry
for the Cash Flow report which made reconciling a pain, or have a
single entry in the register and the Cash Flow report not show both
the income and expense (see Bug 722140 for a complete history). To
be honest, I believe how 2.4 worked is correct and in line with
other accounting packages.
With the help of Carsten Rinke, I have tried everything I believe in
2.6 to get it to act like 2.4 but with no luck.
Any suggestions would be appreciated.
Tim Barber
_______________________________________________
gnucash-user mailing list
[2]gnucash-user at gnucash.org
[3]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.
_______________________________________________
gnucash-user mailing list
[4]gnucash-user at gnucash.org
[5]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.
References
1. mailto:carsten.rinke at gmx.de
2. mailto:gnucash-user at gnucash.org
3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
4. mailto:gnucash-user at gnucash.org
5. https://lists.gnucash.org/mailman/listinfo/gnucash-user
More information about the gnucash-user
mailing list