There are couple of steps and queries
1.
Create the account structure in GNC. you can import your existing structure if
you have a file for the same
2.
The account balance you mentioned does it come with a sign (negative or
positive) depending on the account type or does it give debit , credit balance
in seperate columns? This is critical for GNU to identify the correct entry
On the column mapping it is straight forward, the import window will allow you
to map the columns in GNU.
After the mapping of columns on the next screen you will have the option to
select the counter account, in your case of opening balance you can choose
equity account
Saludos Cordiales
Murugan
________________________________
From: gnucash-user
<gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org> on behalf of
Chris Miller via gnucash-user <gnucash-user@gnucash.org>
Sent: 21 September 2024 22:02
To: gnucash-user <gnucash-user@gnucash.org>
Subject: [GNC] Importing Data
Hi Folks,
QuickBooks does not give up its data graciously, but it will export many things
as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except
with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to
go. Almost. The first line is a header to identify the fields of the subsequent
lines in the file. GNC does not understand IIF, but does understand CSV, and
IIF is just a specialized CSV. Since one of the things I can get from
QuickBooks is a chart of accounts with current balance, I have a place to
start, but I need to understand more than I do.
How do I map the existing "column" headers in the erstwhile IIF to columns that
GNC understands? How do I know what that mapping is? I can't just assert an
account balance; there has to be a complimentary entry to "Equity:Opening
Balance", so how does that happen?
I'm almost ready to light this candle.
Thanks for the help,
--
Chris.
V:916.799.9461
F:916.974.0428
A: Because we read from top to bottom, left to right.
Q: > Why should I start my reply below the quoted text?
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C9d4baeb7df2248c4213208dcdaa25d69%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638625638107859208%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=pLs54GU0mPv6DqLG8bXWKCG8BLlaNIvxKipHBufrkAE%3D&reserved=0<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
To update your subscription preferences or to unsubscribe:
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.
