Re: [GNC] Cash Flow Report has incorrect values
I can't say that I understand the circle thing, but the P Report looks correct. I also keep an Excel spread sheet just for Sales by year, and it's total for this year is slightly different from the P Report. I've probably made an error somewhere. Many thanks, Howard On 5/17/21 12:49 PM, Derek Atkins wrote: The "Cash Flow" report probably is not what you really want. What that report does is allows you to draw a circle around a set of accounts and it will summarize all the transactions that cross that boundary. Any transaction fully inside the circle or fully outside the circle is ignored. Most likely, *THAT* is why it's giving you 10X, because -9X probably is fully inside the circle and not being included in the counting. Have you tried a P report? -derek On Mon, May 17, 2021 12:39 pm, Howard M. Fried wrote: Hello, My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) shows wildly incorrect values, specifically the "Money In" and "Accounts Receivable" amounts. For example, in the complete Account display, Accounts Receivable shows X (which is correct). But in the Report, it shows a value larger than 10X. I've been using the same Account for several years and never noticed such a problem. I played with the Options, to no avail. Any feedback greatly appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow Report has incorrect values
The "Cash Flow" report probably is not what you really want. What that report does is allows you to draw a circle around a set of accounts and it will summarize all the transactions that cross that boundary. Any transaction fully inside the circle or fully outside the circle is ignored. Most likely, *THAT* is why it's giving you 10X, because -9X probably is fully inside the circle and not being included in the counting. Have you tried a P report? -derek On Mon, May 17, 2021 12:39 pm, Howard M. Fried wrote: > Hello, > > My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) > shows wildly incorrect values, specifically the "Money In" and "Accounts > Receivable" amounts. For example, in the complete Account display, > Accounts Receivable shows X (which is correct). But in the Report, it > shows a value larger than 10X. > > I've been using the same Account for several years and never noticed > such a problem. I played with the Options, to no avail. > > Any feedback greatly appreciated. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Cash Flow Report has incorrect values
Hello, My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) shows wildly incorrect values, specifically the "Money In" and "Accounts Receivable" amounts. For example, in the complete Account display, Accounts Receivable shows X (which is correct). But in the Report, it shows a value larger than 10X. I've been using the same Account for several years and never noticed such a problem. I played with the Options, to no avail. Any feedback greatly appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow Report Question
Hi, Adrien Monteleone writes: > Honestly, I’ve yet to make heads or tails of that report and have it > even remotely look useful to tell me anything about my financial > activity. Certainly, the default account selections produce some odd > results as you noticed. Perhaps I have to play with the account > selection to get something useful. The best way to think of the Cash Flow report is this: Draw a circle around a set of accounts that you want to report on. This separates your accounts into two groups, the Inside group and the Outside group. The Cash Flow report then analyzes all the transactions and will report on any transaction that crosses the line between Inside and Outside. Specifically it will tell you the direction, and into (or from) which Outside Account. Any transactions that are solely between "Inside" accounts are ignored. Similarly, any transactions that are solely between "Outside" accounts are also ignored. Only transactions that cross the line will be reported. > Specifically, there might be reasons money goes ’to’ A/R. Possibly a > refund situation, maybe something with a credit note is involved. I > don’t think an unlinked payment would be the issue because that would > be a credit to A/R not a debit. Payments are credits to A/R and debits > to the payment method—checking, cash, etc. The fact that it gets > unlinked to clear an invoice doesn’t change the transaction itself. Agreed. > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow Report Question
Honestly, I’ve yet to make heads or tails of that report and have it even remotely look useful to tell me anything about my financial activity. Certainly, the default account selections produce some odd results as you noticed. Perhaps I have to play with the account selection to get something useful. Specifically, there might be reasons money goes ’to’ A/R. Possibly a refund situation, maybe something with a credit note is involved. I don’t think an unlinked payment would be the issue because that would be a credit to A/R not a debit. Payments are credits to A/R and debits to the payment method—checking, cash, etc. The fact that it gets unlinked to clear an invoice doesn’t change the transaction itself. Regards, Adrien > On Aug 1, 2018, at 9:55 AM, Martijn Heuts wrote: > > Hello, > On the Cash Flow report:"Money out of selected accounts goes to"I have a > listing of "Assets:Accounts Receivable" > Am I incorrect that this should not be there? > Is it possible an invoice got un-posted, a change was made, > the invoice was posted again, but the money did not got re-applied? > If not, why would it show here, and is there any way I can tracewhere this > amount comes from? It looks like it might be a sum of differentamounts > together. > Any help/insight is appreciated. Thanks and have a blessed day! > Martijn > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Cash Flow Report Question
Hello, On the Cash Flow report:"Money out of selected accounts goes to"I have a listing of "Assets:Accounts Receivable" Am I incorrect that this should not be there? Is it possible an invoice got un-posted, a change was made, the invoice was posted again, but the money did not got re-applied? If not, why would it show here, and is there any way I can tracewhere this amount comes from? It looks like it might be a sum of differentamounts together. Any help/insight is appreciated. Thanks and have a blessed day! Martijn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow report
Adrien, I think with the default account selection, the Cash Flow report seems to do the right thing. The double selection of accounts seems a bit strange, I haven't really got a proper set of business accounts to check it out on anymore and the dummy set I have put together have been for testing a few specific features so are not general enough. I'll try running it on my personal accounts to see how it handles them as I run a couple of small business ventures through them, but don't really use the business features with them. It should really only need to access Asset and Equity accounts to construct a cash flow report. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow report
I too am not clear on what the GnuCash version of the Cash Flow report is supposed to be. It is nothing like any such report I’ve seen from my accounting texts or any resource on the subject online. I get that it generally tells you where money is coming from and where it is going, but the presentation is quite odd. Regards, Adrien > On Jun 3, 2018, at 7:02 PM, DaveC49 wrote: > > Martijn, > > I can't really comment on the Cash Flow reportas implemented in GnuCash and > it's options but the doubling of accounts in the selected list when the show > subaccounts is selected does appear to be strange and may be a bug. My > understanding of a Cash Flow Report is that it includes: > > cash receipt and cash payments from the operating activities of the business > cash collections from customers > cash receipts of interest ( on accounts receivable) > cash receipts of dividends (current assets- short term trades) > payments to suppliers (including via A/P > payments to employees > payments for interest expens and income tax expenses ( on current > assets) > depreciation and amortization expenses > > cash flows from investing activities ( i.e interest and dividends received > on non-current assest and cash from sale of assets, investments and > collection of loans) > > Cash flows from Financing activities > proceeds of share issues and bills payable > payments of bills payable and share buybacks > payments of cash dividends > > Even though Accounts Receivable (and Accounts Payable) are in the income > statement for the period, only payments received against A/R and payments > made should be included in the Cash Flow statement. A/R and (A/P) are not > included in the set of default selections in the GnuCash CashFlow report > which is correct. Similarly neither are Credit Cards accounts and other > Liability accounts are not included as payments to them will be captured as > payments from the current asset accounts. > > David Cousens > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow report
Martijn, I can't really comment on the Cash Flow reportas implemented in GnuCash and it's options but the doubling of accounts in the selected list when the show subaccounts is selected does appear to be strange and may be a bug. My understanding of a Cash Flow Report is that it includes: cash receipt and cash payments from the operating activities of the business cash collections from customers cash receipts of interest ( on accounts receivable) cash receipts of dividends (current assets- short term trades) payments to suppliers (including via A/P payments to employees payments for interest expens and income tax expenses ( on current assets) depreciation and amortization expenses cash flows from investing activities ( i.e interest and dividends received on non-current assest and cash from sale of assets, investments and collection of loans) Cash flows from Financing activities proceeds of share issues and bills payable payments of bills payable and share buybacks payments of cash dividends Even though Accounts Receivable (and Accounts Payable) are in the income statement for the period, only payments received against A/R and payments made should be included in the Cash Flow statement. A/R and (A/P) are not included in the set of default selections in the GnuCash CashFlow report which is correct. Similarly neither are Credit Cards accounts and other Liability accounts are not included as payments to them will be captured as payments from the current asset accounts. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Cash Flow report
Hello, I have the new version of GNU. When I look at the options for the build-in 'cash flow' report,there is the option to turn "Always show sub-accounts" on and off. When I turn the option off, the total 'money in' amount is differentas when it's on, even though the same accounts are checked. When the option is checked, the report automatically includes these accounts:Assets Assets:Accounts ReceivableAssets:Checking AccountAssets:Checking AccountAssets:Current Assets and subaccountsAssets:Current Assets and subaccountsImbalance-USDOrphan-USD When it's not checked, the report automatically includes these accounts:Assets Assets:Checking AccountAssets:Current Assets and selected subaccountsImbalance-USDOrphan-USD I am not sure why it shows 'Assets:checking account' and 'Assets and sub accounts' twice I made sure I didn't have Accounts Receivable highlighted/selected before generating the report, yet it shows up in the report when I turn "always show sub-accounts". So leaves me with two questions:1. Is this a bug/error in the software? 2. Should accounts receivable be included if i want to know how much money my business brought in? Thanks and have a great day and weekend! Martijn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
