Re: [GNC] Cash Flow report

[Adrien Monteleone]

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

[DaveC49]

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.

Re: [GNC] Action column in Splits table

[gerry]

Thanks John.I will search the sources as you suggest.Or I may choose to design 
my app so as to be completely independant.Gerry
Sent from Samsung tablet
 Original message From: John Ralls  Date: 
2018-06-03  7:51 PM  (GMT-08:00) To: ge...@gerrymatte.ca Cc: 
gnucash-user@gnucash.org Subject: Re: [GNC] Action column in Splits table 
https://code.gnucash.org/docs/MAINT/group__Transaction.html#gaf3159327b4bcbb9bb85aed3da9908f1b
It does get set automatically in some operations, grep the sources for 
xaccSplitSetAction to see what and then decide if you can avoid them.
A safer approach (at least for the near term) would be to create a slots entry 
on the split. Near term because at some point we’ll do away with slots, but 
that won’t be for several more years.
Regards,John Ralls
On Jun 3, 2018, at 4:31 PM, Gerry Matte  wrote:
Hi.

I use gnucash 2.6.19 on windows 10 with a mysql database data store.

I've been developing a java standalone application to allow me to store one
or more attachments for a gnucash splits record.  My attachments table is
not stored within the same database as gnucash uses.



Although it's not mandatory, it would be convenient if I could use if I
could use the action column in the gnucash splits table as part of the
linkage between my attachments table and gnucash's splits table.



The database wiki describes the columns in the splits table but does not
explain what the action column is used for (or reserved for) so I am
reluctant to use that column without knowing what it is intended for.



Can anyone tell me what the action column in splits is for or will be used
for ?

Thanks in advance

Gerry



PS: I'm aware that version 3.x of gnucash supports file attachments but
until I am satisfied that all known bugs have been resolved on Win10 I'm
unwilling to start using it.  It looked to me to not associate attachments
to a splits transaction (in a quick look).

___
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] Finance::Quote

[WasserLand]

I have just re-subscribed to the List.

I am sure this issue has been well aired so I apologise for the question:

Can no longer get quotes for my share portfolio. ASX.  It stopped some 
many months ago.  Google has been of little help.


Is there a present, definative way to get my quotes going again?

Dave W
___
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] Action column in Splits table

[John Ralls]

https://code.gnucash.org/docs/MAINT/group__Transaction.html#gaf3159327b4bcbb9bb85aed3da9908f1b
 


It does get set automatically in some operations, grep the sources for 
xaccSplitSetAction to see what and then decide if you can avoid them.

A safer approach (at least for the near term) would be to create a slots entry 
on the split. Near term because at some point we’ll do away with slots, but 
that won’t be for several more years.

Regards,
John Ralls

> On Jun 3, 2018, at 4:31 PM, Gerry Matte  wrote:
> 
> Hi.
> 
> I use gnucash 2.6.19 on windows 10 with a mysql database data store.
> 
> I've been developing a java standalone application to allow me to store one
> or more attachments for a gnucash splits record.  My attachments table is
> not stored within the same database as gnucash uses.
> 
> 
> 
> Although it's not mandatory, it would be convenient if I could use if I
> could use the action column in the gnucash splits table as part of the
> linkage between my attachments table and gnucash's splits table.
> 
> 
> 
> The database wiki describes the columns in the splits table but does not
> explain what the action column is used for (or reserved for) so I am
> reluctant to use that column without knowing what it is intended for.
> 
> 
> 
> Can anyone tell me what the action column in splits is for or will be used
> for ?
> 
> Thanks in advance
> 
> Gerry
> 
> 
> 
> PS: I'm aware that version 3.x of gnucash supports file attachments but
> until I am satisfied that all known bugs have been resolved on Win10 I'm
> unwilling to start using it.  It looked to me to not associate attachments
> to a splits transaction (in a quick look).
> 
> ___
> 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] latest gnucash release (3.1) feedback

[Adrien Monteleone]

You should file a bug report on the date issue.

Regards,
Adrien

> On Jun 2, 2018, at 10:15 AM, Alun Champion  wrote:
> 
> I'm using a custom date.
> And flipping back between 2.6.21 and 3.1 that date is lost (in both 
> directions).
>-A.
> 
> On 2 June 2018 at 09:36, Adrien Monteleone  
> wrote:
> Nice find.
> 
> On the report start date issue, are you using a specific custom date or one 
> of the presets?
> 
> Mine are all set to ’start of accounting period’ and my book’s accounting 
> period is set to ’start of current year’. I’m not seeing any loss of start 
> dates.
> 
> Perhaps some other date setting is where the issue lies.
> 
> Regards,
> Adrien
> 
> > On Jun 2, 2018, at 7:29 AM, Alun Champion  wrote:
> > 
> > Thank you all, this gave me enough information to track down and create
> > custom styling, having the tabs down the left side meant all the top and
> > bottom margin and padding was just wasted space.
> > 
> > Note: One minor issue I found when switching between 2.6.21 and 3.1 is that
> > any open reports seems to lose the start date, no idea why.
> > 
> > I’m on a Mac, was able to run the gtk3 inspector by running
> > GTK_DEBUG=interactive
> > /Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
> > which shows the various css nodes (and you can experiment with the
> > styling). And created a ~/Library/Application\ Support/Gnucash/gtk-3.0.css
> > for tight tabs:
> > 
> > notebook tab {
> >  min-height: 0px;
> >  margin-top: 0px;
> >  margin-bottom: 0px;
> >  padding-left: 0px;
> >  padding-right: 0px;
> > }
> > 
> > notebook tab box {
> >  padding-top: 2px;
> >  padding-bottom: 2px;
> > }
> > 
> > I was also able to change the colors in the reports by changing the
> > base_colors in
> > /Applications/Gnucash.app/Contents/Resources/share/gnucash/scm/html-utilities.scm
> > .
> > ​
> > 
> > On 30 May 2018 at 07:07, Mike Evans  wrote:
> > 
> >> On Wed, 30 May 2018 10:00:56 +0100
> >> Mike Evans  wrote:
> >> 
> >>> On Wed, 30 May 2018 00:12:00 -0500
> >>> Alun Champion  wrote:
> >>> 
>  MacOS High Sierra, Gnucash 3.1-3.
>  
>  If anyone finds a way for reducing the padding around the tabs (left),
> >> I
>  would be very interested. 3.1 uses almost twice as much space as
> >> 2.6.X. I
>  keep a number of tabs open (reports, accounts, registers, etc.) and
> >> this
>  comfortably fits on the screen now in 3.1 this forces scrolling. The
> >> arrows
>  to scroll up and down are particularly slow and with also losing the
>  ability to scroll the tabs then this becomes very awkward.
>  Also it seems the stylesheets aren't working - or at a minimum there
> >> are no
>  color changes between the stylesheets and the new colours are quite
> >> 'prime'.
>  Changing settings also seems to be very slow, with quite a lag between
>  selecting an option and for the tick to appear or disappear.
>  
>  I guess I will need to figure out how to change the styles - colours
> >> and
>  fonts - default fonts for 2.6.X worked fine for me but the new fonts
> >> are
>  too spidery.
>  
>  But still a fantastic piece of software - thank you all for such great
> >> work.
> -A.
>  
> >>> 
> >>> There's a theme here that helps a little.
> >>> https://www.gnome-look.org/p/1179399/
> >>> 
> >> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
> >> little testing.
> >> 
> >> If you want even narrower notebook tabs, edit
> >> 
> >> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
> >> 
> >> Search for "tabs" or "notebook"
> >> 
> >> Mike E
> >> 
> > ___
> > 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.
> 


___
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] gnucash freezing

[Varda Rotenberg via gnucash-user]

Upgraded to ubuntu 18.4 on laptop dell xps m150, and gnucash works erraticaly. 
Installed gnucash windows 7 version 3.1, and it did notwork at all on my 
windows dell. downgraded to 2.6.21, same problem.


Any suggestions?


Thanks, Varda


Varda Rotenberg
varda...@aol.com

___
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] Action column in Splits table

[Gerry Matte]

Hi.

I use gnucash 2.6.19 on windows 10 with a mysql database data store.

I've been developing a java standalone application to allow me to store one
or more attachments for a gnucash splits record.  My attachments table is
not stored within the same database as gnucash uses.

 

Although it's not mandatory, it would be convenient if I could use if I
could use the action column in the gnucash splits table as part of the
linkage between my attachments table and gnucash's splits table.

 

The database wiki describes the columns in the splits table but does not
explain what the action column is used for (or reserved for) so I am
reluctant to use that column without knowing what it is intended for.

 

Can anyone tell me what the action column in splits is for or will be used
for ?

Thanks in advance

Gerry

 

PS: I'm aware that version 3.x of gnucash supports file attachments but
until I am satisfied that all known bugs have been resolved on Win10 I'm
unwilling to start using it.  It looked to me to not associate attachments
to a splits transaction (in a quick look).

___
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] GnuCash Friendly Accountant

[John Robins]

Yep. Understand that. A great help and good advice.

That definitely sounds like they way to go.

I am away from the office at the moment. This email has been sent from my 
iPhone.

> On Jun 3, 2018, at 14:24, Rich Shepard  wrote:
> 
>> On Sun, 3 Jun 2018, John Robins wrote:
>> 
>> What I am hoping to find is an accountant whereby we can share the GnuCash
>> file on Dropbox with them and then they can output the information they
>> need for our filings.
> 
> John,
> 
>  This may make more work for them than they're willing to take on.
> Especially during tax season. They'd still need to re-keyboard the data.
> 
>  Ask your accountant what information they want from you for each reporting
> period, then provide only that. You make their job easier and avoid
> unintentional errors. And, of course, increased costs from the time they
> spend extracting the information from what you send.
> 
>> From what you are saying I probably need to make contact with a number of
>> accountants in my area and see if I can convince any of them to give it a
>> try.
> 
>  Good luck with that.
> 
> Regards,
> 
> Rich
> ___
> 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] GnuCash Friendly Accountant

[Rich Shepard]

On Sun, 3 Jun 2018, John Robins wrote:


What I am hoping to find is an accountant whereby we can share the GnuCash
file on Dropbox with them and then they can output the information they
need for our filings.


John,

  This may make more work for them than they're willing to take on.
Especially during tax season. They'd still need to re-keyboard the data.

  Ask your accountant what information they want from you for each reporting
period, then provide only that. You make their job easier and avoid
unintentional errors. And, of course, increased costs from the time they
spend extracting the information from what you send.


From what you are saying I probably need to make contact with a number of
accountants in my area and see if I can convince any of them to give it a
try.


  Good luck with that.

Regards,

Rich
___
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] GnuCash Friendly Accountant

[John Robins]

Many thanks for your experience.

What I am hoping to find is an accountant whereby we can share the 
GnuCash file on Dropbox with them and then they can output the 
information they need for our filings. That of course would require the 
accountant to have GnuCash operating (on Mac or PC) and have some basic 
understanding of how it works and how to set it up so that we can set up 
the accounts together. That would leave me to enter the transactions on 
to the books day by day, month on month and for the accountant to just 
check over them and do the filing.


From what you are saying I probably need to make contact with a number 
of accountants in my area and see if I can convince any of them to give 
it a try.


Many thanks, John

---
John Robins

On 6/3/18 13:45, Rich Shepard wrote:

On Sun, 3 Jun 2018, John Robins wrote:


Are there any lists where you can locate a business/personal accountant
that is ready to work with companies using GnuCash? I'm looking for one
around Lakeland/Winter Haven, Florida


John,

  Without knowing your specific interests I'll offer my experiences. Over
the years I've had discussions with my accountant about switching to 
linux.

The problem is their tax software. Not only does that run only in Windows
(and her IT person doesn't know how to use a virtual Windows machine for
it), but requires other specifics that severely limit her choices. Worse
still, here in Oregon the state's Dept. of Revenue insists that 
accountants

use the department's software which is buggy and error prone.

  It doesn't matter what software her clients use because there's no 
direct

import into the federal or state tax software that she must use.

  I send her PDF files of the profit & loss and income statements at 
the end
of each month, along with quarterly and YTD reports. This works for 
her. I

also send PDF files for personal data when she needs it for annual tax
reporting.

  Florida may be different.

HTH,

Rich

___
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] GnuCash Friendly Accountant

[Rich Shepard]

On Sun, 3 Jun 2018, John Robins wrote:


Are there any lists where you can locate a business/personal accountant
that is ready to work with companies using GnuCash? I'm looking for one
around Lakeland/Winter Haven, Florida


John,

  Without knowing your specific interests I'll offer my experiences. Over
the years I've had discussions with my accountant about switching to linux.
The problem is their tax software. Not only does that run only in Windows
(and her IT person doesn't know how to use a virtual Windows machine for
it), but requires other specifics that severely limit her choices. Worse
still, here in Oregon the state's Dept. of Revenue insists that accountants
use the department's software which is buggy and error prone.

  It doesn't matter what software her clients use because there's no direct
import into the federal or state tax software that she must use.

  I send her PDF files of the profit & loss and income statements at the end
of each month, along with quarterly and YTD reports. This works for her. I
also send PDF files for personal data when she needs it for annual tax
reporting.

  Florida may be different.

HTH,

Rich

___
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] Profit and Loss Spreadsheet

[Mike or Penny Novack]

On 6/3/2018 3:01 AM, John Robins wrote:

Got it! Thank you.

One quick follow up question. Would it be possible for a gnucash 
developer to add this report into the software, could I commission a 
developer to add this report in (or would it be too expensive), or is 
it not the type of report that could be added in?


All the best, John 


Assuming a developer were willing to take this on (unlikely*) the first 
step would be thinking about the not so simple things.


When you run ONE "Income Statement" report the CoA is as it is at the 
end of that period. But when you are running for multiple months you 
have no assurance that the CoA will be the same each time. How is that 
to be handled? << I am NOT asking how implemented but what do you expect 
to see in the report >> Notice that with the manual process that has 
been described to you you might encounter this situation also, and IF 
SO, make a decision what to do at that time. But if coded, need to have 
decided that in advance.


In my working days, probably 20% or more of a project's "time charges" 
were for user meetings to decide matters like this, "what should the 
program do IF ...? As a general rule, expect 80% of the code (or more) 
to e dealing with all the rare "exception" situations.


Michael D Novack
___
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] Profit and Loss Spreadsheet

[John Robins]

Hi, Adrien.

I totally agree with your take on the reporting mechanism. And given how 
good the core application is I can't help but feel that a major upgrade 
of the reporting mechanism would have a significant influence on 
increasing usage/uptake. That aside, I have had a quick look at PieCash 
and at first glance it looks to be quite a bit beyond my computer 
capability - I'll have another look later and see if i can get my head 
around it, but thanks for the heads up.


---
John Robins

On 6/3/18 12:15, Adrien Monteleone wrote:

The reporting mechanism is a bit ‘obtuse’ to put it mildly with respect to 
custom reports. Eventually, when GnuCash is a proper database application, this 
will change. In the meantime, you also have an option, if you are using one of 
the database backends, to use something like PieCash which can parse the data 
and allow you to write your own reports using more friendly tools than the 
default reporting system. Do a web search or specifically a search here on the 
list for threads about it with links.

Regards,
Adrien


On Jun 3, 2018, at 2:01 AM, John Robins  wrote:

Got it! Thank you.

One quick follow up question. Would it be possible for a gnucash developer to 
add this report into the software, could I commission a developer to add this 
report in (or would it be too expensive), or is it not the type of report that 
could be added in?
All the best, John

---
John Robins

USA: +1 (863) 397-3646
UK: +44 (783) 788-8246
UAE: +97 (150) 651-6381
Skype: john_robins
Web: www.newzpoint.com

On 6/3/18 07:51, David T. via gnucash-user wrote:

Indeed. And once your data are in a spreadsheet, you can run all sorts of 
sophisticated functions on it. ;)

David



On Jun 3, 2018, at 10:07 AM, Adrien Monteleone 
  wrote:

John,

I’ll have to interpret a bit, but my guess is you want a report that shows multiple 
months worth of P data, consolidated with each month in it’s own column. (and 
maybe even a YTD or QTD column at the end)

There is no such report.

You can run a multi-column report and put each column as a different month’s 
P, but that will repeat the account name header column.

More than likely, you’ll need to either export and import, or copy/paste 
individual months into a spreadsheet and work from there. (a simple select-all, 
copy/paste is usually sufficient)

Regards,
Adrien



On Jun 2, 2018, at 10:51 AM, John 
  wrote:

Hi.

I have been looking through the report options and help files and I am unable 
to work out how to create a month by month profit and loss spreadsheet. Is this 
possible? and if so, do I need to download and install a plugin of some kind.

Many thanks, John

---
John Robins





___
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.


___
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.


___
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.

[GNC] GnuCash Friendly Accountant

[John Robins]

Hi,

Are there any lists where you can locate a business/personal accountant 
that is ready to work with companies using GnuCash? I'm looking for one 
around Lakeland/Winter Haven, Florida


Thanks,  John

---
John Robins

___
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] Profit and Loss Spreadsheet

[Adrien Monteleone]

The reporting mechanism is a bit ‘obtuse’ to put it mildly with respect to 
custom reports. Eventually, when GnuCash is a proper database application, this 
will change. In the meantime, you also have an option, if you are using one of 
the database backends, to use something like PieCash which can parse the data 
and allow you to write your own reports using more friendly tools than the 
default reporting system. Do a web search or specifically a search here on the 
list for threads about it with links.

Regards,
Adrien

> On Jun 3, 2018, at 2:01 AM, John Robins  wrote:
> 
> Got it! Thank you.
> 
> One quick follow up question. Would it be possible for a gnucash developer to 
> add this report into the software, could I commission a developer to add this 
> report in (or would it be too expensive), or is it not the type of report 
> that could be added in?
> All the best, John
> 
> ---
> John Robins
> 
> USA: +1 (863) 397-3646 
> UK: +44 (783) 788-8246 
> UAE: +97 (150) 651-6381
> Skype: john_robins
> Web: www.newzpoint.com
> 
> On 6/3/18 07:51, David T. via gnucash-user wrote:
>> Indeed. And once your data are in a spreadsheet, you can run all sorts of 
>> sophisticated functions on it. ;)
>> 
>> David
>> 
>> 
>>> On Jun 3, 2018, at 10:07 AM, Adrien Monteleone 
>>> 
>>>  wrote:
>>> 
>>> John,
>>> 
>>> I’ll have to interpret a bit, but my guess is you want a report that shows 
>>> multiple months worth of P data, consolidated with each month in it’s own 
>>> column. (and maybe even a YTD or QTD column at the end)
>>> 
>>> There is no such report.
>>> 
>>> You can run a multi-column report and put each column as a different 
>>> month’s P, but that will repeat the account name header column.
>>> 
>>> More than likely, you’ll need to either export and import, or copy/paste 
>>> individual months into a spreadsheet and work from there. (a simple 
>>> select-all, copy/paste is usually sufficient)
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> 
 On Jun 2, 2018, at 10:51 AM, John 
  wrote:
 
 Hi.
 
 I have been looking through the report options and help files and I am 
 unable to work out how to create a month by month profit and loss 
 spreadsheet. Is this possible? and if so, do I need to download and 
 install a plugin of some kind.
 
 Many thanks, John
 
 ---
 John Robins
 
 
 
 
 
 ___
 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.
>>> 
>> ___
>> 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] Currency problem

[SHUAIB MECHERY]

I saved one file in my laptop to Dropbox
It's common currency was QAR
But I open from Dropbox from my mobile
All currency chaged to None means it's Shows like before and after the
amount
Anybody here how can resolve this idsur
___
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] Closing and reopening Gnucash

[D via gnucash-user]

In my experience, Gnucash always opens the last file I had open. How are you 
calling Gnucash such that it doesn't open the last file? 

David

P.s. What version, what OS?

On June 3, 2018, at 2:19 PM, Richard Barmann  wrote:

When I boot up and want to go to Gnucash I have to hunt through the 
files to find the newest file. The files in the bottom when I click on 
open do not work. I believe I am closing the program wrong. It goes to 
BusinessGnucash but that is log files as well as the Gnucash file. Can I 
delete the old Log Files

Richard E. Barmann

___
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] Profit and Loss Spreadsheet

[D via gnucash-user]

Possible? Anything is possible. However, knowing the community, I doubt you'll 
get much traction. The developer pool is shallow, unfortunately.

Given the fact that a spreadsheet is a much better tool for the kind of 
manipulations I imagine you're seeking, the devs are going to focus on bigger 
core issues.

Of course, this is just my opinion.

David

On June 3, 2018, at 12:01 PM, John Robins  wrote:

Got it! Thank you.

One quick follow up question. Would it be possible for a gnucash developer to 
add this report into the software, could I commission a developer to add this 
report in (or would it be too expensive), or is it not the type of report that 
could be added in?

All the best, John

---
John Robins

USA: +1 (863) 397-3646 
UK: +44 (783) 788-8246 
UAE: +97 (150) 651-6381
Skype: john_robins
Web: www.newzpoint.com

On 6/3/18 07:51, David T. via gnucash-user wrote:

Indeed. And once your data are in a spreadsheet, you can run all sorts of 
sophisticated functions on it. ;) David 

On Jun 3, 2018, at 10:07 AM, Adrien Monteleone  
wrote: John, I’ll have to interpret a bit, but my guess is you want a report 
that shows multiple months worth of P data, consolidated with each month in 
it’s own column. (and maybe even a YTD or QTD column at the end) There is no 
such report. You can run a multi-column report and put each column as a 
different month’s P, but that will repeat the account name header column. 
More than likely, you’ll need to either export and import, or copy/paste 
individual months into a spreadsheet and work from there. (a simple select-all, 
copy/paste is usually sufficient) Regards, Adrien 

On Jun 2, 2018, at 10:51 AM, John  wrote: Hi. I have been 
looking through the report options and help files and I am unable to work out 
how to create a month by month profit and loss spreadsheet. Is this possible? 
and if so, do I need to download and install a plugin of some kind. Many 
thanks, John --- John Robins 
 ___ 
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. 

___ 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] Closing and reopening Gnucash

[Richard Barmann]

When I boot up and want to go to Gnucash I have to hunt through the 
files to find the newest file. The files in the bottom when I click on 
open do not work. I believe I am closing the program wrong. It goes to 
BusinessGnucash but that is log files as well as the Gnucash file. Can I 
delete the old Log Files


Richard E. Barmann

___
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] Profit and Loss Spreadsheet

[John Robins]

Got it! Thank you.

One quick follow up question. Would it be possible for a gnucash 
developer to add this report into the software, could I commission a 
developer to add this report in (or would it be too expensive), or is it 
not the type of report that could be added in?


All the best, John

---
John Robins

*USA:* +1 (863) 397-3646
*UK:* +44 (783) 788-8246
*UAE:* +97 (150) 651-6381
*Skype:* john_robins
*Web:* www.newzpoint.com

On 6/3/18 07:51, David T. via gnucash-user wrote:

Indeed. And once your data are in a spreadsheet, you can run all sorts of 
sophisticated functions on it. ;)

David


On Jun 3, 2018, at 10:07 AM, Adrien Monteleone  
wrote:

John,

I’ll have to interpret a bit, but my guess is you want a report that shows multiple 
months worth of P data, consolidated with each month in it’s own column. (and 
maybe even a YTD or QTD column at the end)

There is no such report.

You can run a multi-column report and put each column as a different month’s 
P, but that will repeat the account name header column.

More than likely, you’ll need to either export and import, or copy/paste 
individual months into a spreadsheet and work from there. (a simple select-all, 
copy/paste is usually sufficient)

Regards,
Adrien


On Jun 2, 2018, at 10:51 AM, John  wrote:

Hi.

I have been looking through the report options and help files and I am unable 
to work out how to create a month by month profit and loss spreadsheet. Is this 
possible? and if so, do I need to download and install a plugin of some kind.

Many thanks, John

---
John Robins



___
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.

___
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] Profit and Loss Spreadsheet

[David T. via gnucash-user]

Indeed. And once your data are in a spreadsheet, you can run all sorts of 
sophisticated functions on it. ;)

David

> On Jun 3, 2018, at 10:07 AM, Adrien Monteleone 
>  wrote:
> 
> John,
> 
> I’ll have to interpret a bit, but my guess is you want a report that shows 
> multiple months worth of P data, consolidated with each month in it’s own 
> column. (and maybe even a YTD or QTD column at the end)
> 
> There is no such report.
> 
> You can run a multi-column report and put each column as a different month’s 
> P, but that will repeat the account name header column.
> 
> More than likely, you’ll need to either export and import, or copy/paste 
> individual months into a spreadsheet and work from there. (a simple 
> select-all, copy/paste is usually sufficient)
> 
> Regards,
> Adrien
> 
>> On Jun 2, 2018, at 10:51 AM, John  wrote:
>> 
>> Hi.
>> 
>> I have been looking through the report options and help files and I am 
>> unable to work out how to create a month by month profit and loss 
>> spreadsheet. Is this possible? and if so, do I need to download and install 
>> a plugin of some kind.
>> 
>> Many thanks, John
>> 
>> ---
>> John Robins
>> 
>> 
>> 
>> ___
>> 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.

___
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.