Re: command line QIF import

[Liz]

On Mon, 16 Oct 2017 06:52:17 -0700 (MST)
Nelson  wrote:

> You're getting very defensive here David and your posts are not
> contributing to this discussion at all. 
> 
> 

Gnucash is Gnucash.
It isn't a Quicken-to-Gnucash project.

Yes, we do get many queries about this, but the process once completed
is soon forgotten, and while there is much knowledge about this in the
mailing lists, Quicken-to-Gnucash is not the main focus of this project.


Nelson, you are free to try and do what you like, except start personal
attacks on other contributors.

Liz, the moderator.
(Profanity is also something I heavily discourage)
___
gnucash-user mailing list
gnucash-user@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.

Re: Vendor Bill - Invoice Entries

[DaveC49]

Hi Michael,

Point taken. I was really commenting specifically on the in package
capability of Gnucash to meet fellow_travellers's needs. It might be useful
to have a list of external software that does provide additional capability
to extend Gnucash somewhere on the wiki page.

One of the disadvantages of an external software approach is in the lack of
ability to readily exchange data between the various components. I am
thinking specifically of customer/vendor information, product listsetc.. 
While this can be done with data import/export, there is always the problem
of ensuring the data import/export is upto date in both packages. 

I do remember seeing someone mentioning a POS plugin under development
sometime ago but haven't seen any more on it. As you have pointed out a POS
system is largely useless without an integrated inventory system.  The
current plugins wiki page doesn't list anything like this though.  

The plugin capability of Gnucash would be one way of supporting integrated
inventory, payroll, POS systems in an integrated fashion but each of these
is likely to require a team of developers to support and maintain
compatability as Gnucash and each of the packages develops. I think this is
one reason such plugins haven't been developed yet. 

I have tried developing a fairly simple mod for Gnucash and I found finding
my way around the code base required a considerable effort and investment in
time to work out where to insert the relatively simple code needed. Still
working on that, but it does make me really appreciate the efforts the
current developers put in.

If Gnucash does shift towards SQL database backends in the future, separate
packages could have the required data integration through the use of a
common shared database minimising the need to interact at the code level.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Vendor Bill - Invoice Entries

[fellowtraveler]

Thanks CM, I’ll take a look. Given that this is a very small non-profit, I am 
hoping to avoid a commercial package and so far GC has (mostly) met the needs 
but now we’re looking at trying to have more data available that is not 
strictly just dollars and cents so to speak. In any case, are you (or anyone 
else here) aware of some common commercial packages?




> On Oct 16, 2017, at 6:31 PM, C M Reinehr  wrote:
> 
> I second the comments by Michael. While I use GnuCash to keep up with my 
> personal accounting, for my business I use commercial accounting software 
> which provides all of the modules described and quite a few more. You can 
> license as few or as many modules as desired -- at a cost, of course. So, if 
> you're doing only basic accounting you can license only the general ledger 
> module, which would be analogous to GnuCash. But if your needs are greater 
> than there are the accounts receivable module, the accounts payable, module, 
> payroll, inventory control, sales order entry, point of sale, etc.
> 
> The only other open source software of which I am aware that would provide 
> you these types of modules is a product called SQL-Ledger which you may wish 
> to investigate:
> 
> http://www.sql-ledger.org/cgi-bin/nav.pl?page=feature/index.html=Features
> 
> At the very least looking at what SQL Ledger has to offer will show you the 
> kinds of packages available.
> 
> Otherwise, you're looking at purchasing commercial enterprise resource 
> software.
> 
> Hope this helps!
> 
> CMR
> 
> On 10/16/2017 05:04 PM, fellowtrave...@comcast.net wrote:
>> Michael:
>> Thanks for the reply. I have to say, I was thinking this would be a natural 
>> function of business accounting software but I see your point about the 
>> bulk. This is a function I am currently looking into for a non-profit. 
>> Basically, we receive invoices for services which I’ve been inputing as 
>> bills into the AP register. The invoices of course could contain any number 
>> of services, many of which are common. What we’d like to be able to do is to 
>> create reports that might say, these are the top 5 services that were 
>> preformed in 2016 and how many of each there were. I’d prefer to only have 
>> to enter this data once, so I was hoping that GC would have the 
>> functionality but I am finding out that this might be outside the scope of 
>> any accounting type of software.
>> Would you be able to suggest an approach, a tool, that might compliment GC? 
>> Or is this just going to have to be something totally different?
>> Thanks.
>>> On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack 
>>>  wrote:
>>> 
>>> On 10/15/2017 10:08 PM, DaveC49 wrote:
 Hi,
 
 The facilities you are requesting are likely to require an inventory
 management system. At present Gnucash is an accounting package and 
 currently
 does not incorporate any features for inventory management. As far as i 
 know
 there are no plans to incorporate such features in the near future. To do 
 so
 would reuire a developer(s) interested in developing these features.
 Similarly while it can handle the accounting specific side of payroll
 management it does not handle the calculation of payrolls, deductions, 
 taxes
 etc. You may need to took at ERP software if you require these facilities.
 
 David Cousens
>>> 
>>> I am going to point something out. Gnucash is an accounting package. A 
>>> business might need a number of OTHER packages that would interact with the 
>>> accounting package, but normally are separate parts. Why separate? Because 
>>> which of these other parts a business might want/need depend on the 
>>> business. A unified business application (including ALL the different 
>>> possible pieces) would be unnecessarily bulky, with a given business never 
>>> using many of those pieces.
>>> 
>>> inventory -- only if the business HAS inventory that it sells
>>> payroll -- only if the business has employees (employees in the legal 
>>> sense of that word)
>>> billed time -- only of a business deals in "billable hours"
>>> POS --- only if a business does this kind of retail << point of sales not 
>>> only interacts with accounting but also inventory >>
>>> etc. etc. etc.
>>> 
>>> Since I do accounting just for non-profits, I am aware of OTHER "pieces" 
>>> that would apply to this specialty. Just because I may be using gnucash to 
>>> provide these pieces does NOT mean "part of gnucash" << I am simply ALSO 
>>> using gnucash to implement "virtual  books" for those specific pieces >>
>>> 
>>> Michael D Novack
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>> 

Re: Vendor Bill - Invoice Entries

[Nelson Handcock]

I think about the only way you could do it using Gnucash would be to add a
series of sub-accounts that are specific to each service that you provide,
and then post each bill for a service to the appropriate account.

Then you could use the existing reporting available in Gnucash to show the
breakdown of each service via the account structure.

I'm in a similar situation as you - using Gnucash to maintain the books for
a not-for-profit association. But in my case we have a wide variety of
products we sell and they change seasonally, so there's simply not enough
time in the day to keep up.

We use a Point-of-Sale system to record all our sales to our members called
Lettuceshare - (www.lettuceshare.org) - all sales are entered at our
"checkout" and then I summarise the data and import invoices into Gnucash
once a quarter. So can use this system for sales analysis rather than
Gnucash. It could potentially work for you too

Cheers - Nelson



On Tue, Oct 17, 2017 at 8:04 AM,  wrote:

> Michael:
>
> Thanks for the reply. I have to say, I was thinking this would be a
> natural function of business accounting software but I see your point about
> the bulk. This is a function I am currently looking into for a non-profit.
> Basically, we receive invoices for services which I’ve been inputing as
> bills into the AP register. The invoices of course could contain any number
> of services, many of which are common. What we’d like to be able to do is
> to create reports that might say, these are the top 5 services that were
> preformed in 2016 and how many of each there were. I’d prefer to only have
> to enter this data once, so I was hoping that GC would have the
> functionality but I am finding out that this might be outside the scope of
> any accounting type of software.
>
> Would you be able to suggest an approach, a tool, that might compliment
> GC? Or is this just going to have to be something totally different?
>
> Thanks.
>
>
>
> > On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack <
> stepbystepf...@dialup4less.com> wrote:
> >
> > On 10/15/2017 10:08 PM, DaveC49 wrote:
> >> Hi,
> >>
> >> The facilities you are requesting are likely to require an inventory
> >> management system. At present Gnucash is an accounting package and
> currently
> >> does not incorporate any features for inventory management. As far as i
> know
> >> there are no plans to incorporate such features in the near future. To
> do so
> >> would reuire a developer(s) interested in developing these features.
> >> Similarly while it can handle the accounting specific side of payroll
> >> management it does not handle the calculation of payrolls, deductions,
> taxes
> >> etc. You may need to took at ERP software if you require these
> facilities.
> >>
> >> David Cousens
> >
> > I am going to point something out. Gnucash is an accounting package. A
> business might need a number of OTHER packages that would interact with the
> accounting package, but normally are separate parts. Why separate? Because
> which of these other parts a business might want/need depend on the
> business. A unified business application (including ALL the different
> possible pieces) would be unnecessarily bulky, with a given business never
> using many of those pieces.
> >
> > inventory -- only if the business HAS inventory that it sells
> > payroll -- only if the business has employees (employees in the
> legal sense of that word)
> > billed time -- only of a business deals in "billable hours"
> > POS --- only if a business does this kind of retail << point of sales
> not only interacts with accounting but also inventory >>
> > etc. etc. etc.
> >
> > Since I do accounting just for non-profits, I am aware of OTHER "pieces"
> that would apply to this specialty. Just because I may be using gnucash to
> provide these pieces does NOT mean "part of gnucash" << I am simply ALSO
> using gnucash to implement "virtual  books" for those specific pieces >>
> >
> > Michael D Novack
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

MariaDB error 2003: Can't connect to MySQL server on x.x.x.x

[Joe Harrington]

Server and client are each on machines connected to different local 
networks.
gnucash version 2.6.18 (3a9fbb8) and MariaDB 10.1.26 (xampp 
v.7.1.9-0-VC14) all machines running Windows 10


trying to open db using external address of server network.

server is bound to 0.0.0.0

user has full privilege with ip address of x.x.x.x

where x.x.x.x is local ip address of client machine and
external address of client network and
local address of gateway on server network

gateway on server network is configured to forward port 3306 to ip of 
server on local network.


I tried all combinations that made any sense to me and all return same 
error.


I CAN open db running gnucash on same machine as server using 
'localhost' and on a different machine on the same local network using 
local address of server. User has privilege with local ip of 2nd machine 
and local address of server.


What do I try next?

___
gnucash-user mailing list
gnucash-user@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.

Re: Vendor Bill - Invoice Entries

[fellowtraveler]

Michael:

Thanks for the reply. I have to say, I was thinking this would be a natural 
function of business accounting software but I see your point about the bulk. 
This is a function I am currently looking into for a non-profit. Basically, we 
receive invoices for services which I’ve been inputing as bills into the AP 
register. The invoices of course could contain any number of services, many of 
which are common. What we’d like to be able to do is to create reports that 
might say, these are the top 5 services that were preformed in 2016 and how 
many of each there were. I’d prefer to only have to enter this data once, so I 
was hoping that GC would have the functionality but I am finding out that this 
might be outside the scope of any accounting type of software. 

Would you be able to suggest an approach, a tool, that might compliment GC? Or 
is this just going to have to be something totally different?

Thanks.



> On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack 
>  wrote:
> 
> On 10/15/2017 10:08 PM, DaveC49 wrote:
>> Hi,
>> 
>> The facilities you are requesting are likely to require an inventory
>> management system. At present Gnucash is an accounting package and currently
>> does not incorporate any features for inventory management. As far as i know
>> there are no plans to incorporate such features in the near future. To do so
>> would reuire a developer(s) interested in developing these features.
>> Similarly while it can handle the accounting specific side of payroll
>> management it does not handle the calculation of payrolls, deductions, taxes
>> etc. You may need to took at ERP software if you require these facilities.
>> 
>> David Cousens
> 
> I am going to point something out. Gnucash is an accounting package. A 
> business might need a number of OTHER packages that would interact with the 
> accounting package, but normally are separate parts. Why separate? Because 
> which of these other parts a business might want/need depend on the business. 
> A unified business application (including ALL the different possible pieces) 
> would be unnecessarily bulky, with a given business never using many of those 
> pieces.
> 
> inventory -- only if the business HAS inventory that it sells
> payroll -- only if the business has employees (employees in the legal 
> sense of that word)
> billed time -- only of a business deals in "billable hours"
> POS --- only if a business does this kind of retail << point of sales not 
> only interacts with accounting but also inventory >>
> etc. etc. etc.
> 
> Since I do accounting just for non-profits, I am aware of OTHER "pieces" that 
> would apply to this specialty. Just because I may be using gnucash to provide 
> these pieces does NOT mean "part of gnucash" << I am simply ALSO using 
> gnucash to implement "virtual  books" for those specific pieces >>
> 
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: Migrate from Moneydance to Gnucash

[David Carlson]

I think it is about the same as from Quicken,  but perhaps easier because
Moneydance is closer to being double entry.

If they still have QIF exports ...


David C

On Oct 16, 2017 8:51 AM, "Roger Miskowicz"  wrote:

> Is there a recommended procedure for migrating Moneydance to GnuCash?
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

[Joerg Diederich]

Hi Maf,

thank you very much for this hint. I guess it points into the right direction. 
I've just checked my xml file and indeed, there is an entry with such a strange 
date. I will try to fix it as suggested and look, if I can save the data into 
my mysql database.

Joerg


On Mon, 16 Oct 2017 20:46:14 +0100
"Maf. King"  wrote:

> On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote:
> 
> > 
> > A date in 1898 (as reported) looks more like a data error.  
> 
> I know the OP mentioned Linux - but isn't that date something to with a 
> (fixed/
> resolved) windows bug creating transactions from "before time existed"  Just 
> rings a distant bell with me...
> 
> Maybe a grep of the xml file for something like the problem timestamp and 
> fixing 
> the data manually?  A postdate won't be visible in the registers anywhere 
> AFAIK.
> 
>  Back up the data file first then back it up again...
> 
> 0.02
> Maf.
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.
> 
___
gnucash-user mailing list
gnucash-user@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.

Importing Data

[Rick Strupkus]

I have just purchased a new laptop with Windows 10 and am trying to import
the data from my old laptop onto it.  Which files do I look for and how can
I put them on my new machine?

Rick
___
gnucash-user mailing list
gnucash-user@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.

Re: Ordering Transactions on same date

[Maf. King]

On Monday, 16 October 2017 16:18:49 BST baneeishaque wrote:
> Solved the problem in aneasier way...
> 

OK. I'll bite.

What is the easier way?Others in the future might benefit from your method?


BTW, happy to hear that you found a solution.
Cheers,
Maf.

___
gnucash-user mailing list
gnucash-user@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.

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

[Maf. King]

On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote:

> 
> A date in 1898 (as reported) looks more like a data error.

I know the OP mentioned Linux - but isn't that date something to with a (fixed/
resolved) windows bug creating transactions from "before time existed"  Just 
rings a distant bell with me...

Maybe a grep of the xml file for something like the problem timestamp and 
fixing 
the data manually?  A postdate won't be visible in the registers anywhere 
AFAIK.

 Back up the data file first then back it up again...

0.02
Maf.



___
gnucash-user mailing list
gnucash-user@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.

RE: Ordering Transactions on same date

[baneeishaque]

Solved the problem in aneasier way...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

[Joerg Diederich]

Hi Colin,

thank you very much for the quick response to my post. I dropped the database 
and let gnucash create it. But I get the same error message again.

Joerg


On Mon, 16 Oct 2017 14:46:31 +0100
Colin Law  wrote:

> On 16 October 2017 at 10:50,   wrote:
> > Hello,
> >
> > I'm trying to convert my existing gnucash account from xml to mysql. I 
> > created a new mysql database, but when I try to save my data into this 
> > database with gnucash I get the following error message:  
> 
> Don't manually create the database first. Just use File > Save As and
> give it a database name. You can overwrite an existing gnucash
> database in this way but don't try to overwrite an existing db unless
> it was created by gnucash. I am not guaranteeing that this is the
> problem, but try that first.
> 
> >
> > Operating System: Linux opensuse LEAP 42.2
> > gnucash:   gnucash-2.6.16-3.3.1.x86_64
> > mysql:  mariadb-10.0.31-20.7.1.x86_64  
> 
> I don't know whether anyone has tried it with mariadb, but it should
> be ok as maria is supposed to be a dropin replacement for mysql.
> 
> Colin
> 
___
gnucash-user mailing list
gnucash-user@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.

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

[John Ralls]

> On Oct 16, 2017, at 2:50 AM, joerg_dieder...@freenet.de wrote:
> 
> Hello,
> 
> I'm trying to convert my existing gnucash account from xml to mysql. I 
> created a new mysql database, but when I try to save my data into this 
> database with gnucash I get the following error message:
> 
> <--- cut here --->
> mysql error: Incorrect datetime value: '18981201105900' for column 
> 'post_date' at row 1
> <--- cut here --->
> 
> In another thread I found the recommendation to adjust the sql_mode using
> 
> sql_mode = 
> ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
> 
> Unfortunately, this doesn't change the behaviour for me.
> 
> 
> Here are some version information:
> 
> Operating System: Linux opensuse LEAP 42.2
> gnucash:   gnucash-2.6.16-3.3.1.x86_64
> mysql:  mariadb-10.0.31-20.7.1.x86_64
> 
> 
> Any hint how to get rid off this error is really appreciated.

We need to change the schema for MySQL/MariaDB to use DATETIME instead of 
TIMESTAMP; the latter’s date range is only 1 Jan 1970-15 Jun 2038. It’s on my 
to-do list for 2.8.

For 2.6 you’ll need to use Postgresql instead if you need your books to run 
before 1970.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[Aaron Laws]

On Mon, Oct 16, 2017 at 8:55 AM, Nelson  wrote:

>
> That's why I am saying that having some flags to tuneup the import process
> and detailed logging would help a lot.
>

It sounds like you've identified some areas for improvement. This is a
volunteer project, so the more you can do to make this happen, the more
likely it will happen. Creating a detailed bug report would be the first
step. If you have some quite specific ways to improve the process, that
would be very helpful. If you're comfortable with C++, feel free to
contribute a patch (it doesn't need to be perfect; we can work with you,
too).
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[Nelson]

You're getting very defensive here David and your posts are not contributing
to this discussion at all. 





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

[Colin Law]

On 16 October 2017 at 10:50,   wrote:
> Hello,
>
> I'm trying to convert my existing gnucash account from xml to mysql. I 
> created a new mysql database, but when I try to save my data into this 
> database with gnucash I get the following error message:

Don't manually create the database first. Just use File > Save As and
give it a database name. You can overwrite an existing gnucash
database in this way but don't try to overwrite an existing db unless
it was created by gnucash. I am not guaranteeing that this is the
problem, but try that first.

>
> Operating System: Linux opensuse LEAP 42.2
> gnucash:   gnucash-2.6.16-3.3.1.x86_64
> mysql:  mariadb-10.0.31-20.7.1.x86_64

I don't know whether anyone has tried it with mariadb, but it should
be ok as maria is supposed to be a dropin replacement for mysql.

Colin
___
gnucash-user mailing list
gnucash-user@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.

Migrate from Moneydance to Gnucash

[Roger Miskowicz]

Is there a recommended procedure for migrating Moneydance to GnuCash?
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[David Carlson]

Nelson,

It sounds to me like you are unwilling make the effort to "shepherd" your
data through the import process.  Many of us, including David T are trying
to tell you that we have succeeded in completing massive imports from
Quicken into GnuCash, but we needed to take several steps to plan our
procedure, prepare the data, preprocess data and postprocess data to do
it.

Each case will vary because each of us took different shortcuts and entered
data from different financial institutions, etc. when using Quicken.  We
also have different ideas about what details are most important to preserve
vs what is "noise"

David C

On Mon, Oct 16, 2017 at 7:55 AM, Nelson  wrote:

> There are multiple classes of failures and most of them seems to be
> transfers
> related. There are the ones a which show up more often:
>
> - missing transactions
> - duplicate transactions
> - voided transactions (transaction exist but flagged as "void" and has zero
> amount)
> - transactions in wrong account (transfer from account.A to account.B
> recorded as debit account.A and credit account.C)
>
> I totally understand QIF format limitations. When I do a transfer from
> account.A to account.B, and I download the transactions from the bank in
> Quicken, account.B trx. will show up in one day while account.B will show
> up
> couple days later, maybe 2 to 5 days. While Quicken will match these
> properly, GnuCash will create duplicates most-likely, because in the
> exported QIF file  there are two different transactions,  one for account.A
> and one for account.B.
>
> That's why I am saying that having some flags to tuneup the import process
> and detailed logging would help a lot.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: Vendor Bill - Invoice Entries

[Mike or Penny Novack]

On 10/15/2017 10:08 PM, DaveC49 wrote:

Hi,

The facilities you are requesting are likely to require an inventory
management system. At present Gnucash is an accounting package and currently
does not incorporate any features for inventory management. As far as i know
there are no plans to incorporate such features in the near future. To do so
would reuire a developer(s) interested in developing these features.
Similarly while it can handle the accounting specific side of payroll
management it does not handle the calculation of payrolls, deductions, taxes
etc. You may need to took at ERP software if you require these facilities.

David Cousens


I am going to point something out. Gnucash is an accounting package. A 
business might need a number of OTHER packages that would interact with 
the accounting package, but normally are separate parts. Why separate? 
Because which of these other parts a business might want/need depend on 
the business. A unified business application (including ALL the 
different possible pieces) would be unnecessarily bulky, with a given 
business never using many of those pieces.


inventory -- only if the business HAS inventory that it sells
payroll -- only if the business has employees (employees in the 
legal sense of that word)

billed time -- only of a business deals in "billable hours"
POS --- only if a business does this kind of retail << point of sales 
not only interacts with accounting but also inventory >>

etc. etc. etc.

Since I do accounting just for non-profits, I am aware of OTHER "pieces" 
that would apply to this specialty. Just because I may be using gnucash 
to provide these pieces does NOT mean "part of gnucash" << I am simply 
ALSO using gnucash to implement "virtual  books" for those specific 
pieces >>


Michael D Novack
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[Nelson]

There are multiple classes of failures and most of them seems to be transfers
related. There are the ones a which show up more often:

- missing transactions
- duplicate transactions
- voided transactions (transaction exist but flagged as "void" and has zero
amount)
- transactions in wrong account (transfer from account.A to account.B
recorded as debit account.A and credit account.C)

I totally understand QIF format limitations. When I do a transfer from
account.A to account.B, and I download the transactions from the bank in
Quicken, account.B trx. will show up in one day while account.B will show up
couple days later, maybe 2 to 5 days. While Quicken will match these
properly, GnuCash will create duplicates most-likely, because in the
exported QIF file  there are two different transactions,  one for account.A
and one for account.B.

That's why I am saying that having some flags to tuneup the import process
and detailed logging would help a lot.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[David T. via gnucash-user]

What do you mean "failed"? They aren't in the gnucash file at all? Or, they 
import incorrectly? 
If the latter, take a look at some of the transactions that failed; is there 
something in common?  In my Quicken data, it was transactions that had no 
categories that caused the most problems. Fill things in, try again and see 
what happens. Rinse and repeat until your data is clean enough, and pick up the 
rest afterwards. 
If they didn't import at all, I don't know what to say. 
David

 
 
  On Sun, Oct 15, 2017 at 22:50, Nelson wrote:   
Thank you for your answer David.

I am aware that QIF is a text file and I can open it in text editor. 

I have a 235000 lines QIF file created by quicken. Most of the transactions
are being imported properly but there are thousands failing as well. I have
no way to identify those failed transactions other than going line by line
in each account. What shall I "edit in quicken first" to insure a successful
import?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.
  
___
gnucash-user mailing list
gnucash-user@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.