[GNC] Migrating from AceMoney

[David Cousens]

Jason

AceMoney does not list any export formats in its documentation.  GnuCash
will not be able to read AceMoneys file format unless someone has written a
translator and this is unlikely. 

GnuCash can import OFX/QFX, QIF, CSV files if Acemoney can export data in
any of these formats. OFX/QFX is generally the most reliable if the OFX/QFX
formats have been correctly implemented in the export. Another factor is
what information exists in any exported data. It is generally better to
export data for a specific period, e.g. a month or quarter and import the
data in batches in sequence. Also if you start with your major Asset and
Liability accounts, i.e.  with the largest number of transactions, first it
will make importing easier as this will import most or all of the data for
income, expense and equity account. 

GnuCash's importers have a matching algorithm, which for imports to a given
account, looks for matches in data already in the GnuCash file to existing
transactions to minimise duplication and also matches and automatically
assigns the second account in a transaction if enough information is present
to allow this. It uses a Bayesian algorithm which is trained by the data you
have already imported to match transaction.  It is generally better to
import transactions, at least initially, in small batches, as this makes it
easier to detect mismatches in imported data and "train" the automatic
matching and assignment of the second account of a transaction. Any
automatic assignment by the matcher can be overridden before importing. It
pays to check the account assignment data (displayed in a window) before
importing as importing incorrect assignments will not train the algorithm
correctly which results in less successful matching in future imports.

Another suggestion is to perhaps start using current data and then gradually
add your historical data. GnuCash can set opening balances for accounts at a
specified date. This can be edited to the opening balance at an earlier date
as you import your historical data. The opening balances are just another
transaction.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html