[GNC] CSV Import

[Stephen M. Butler]

I presume that you will not have 100s of expense accounts.  You would 
have to do the mapping once per code word.  Just once.

On 8/24/23 16:21, jackielou wong wrote:
> You mean ill do it manual for 100s transaction. Is that correct? How 
> can i transfer in fastest way
>
> On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler <kg7je at arrl.net> wrote:
>
>     I have used the CSV importer several times to great advantage.  At a
>     minimum you need the following columns:
>
>     1.  Date -- be sure that you set the importer to the date format you
>     used.  I use MM/DD/YYYY.
>     2.  Description -- What you want in the transaction description.
>     3.  Account Code -- Something that will uniquely identify the "other
>     account".  I tend to use 3-4 character (sometime just 2) codes
>     easy for
>     me to remember.  These will get mapped (by you) to the real GnC
>     account
>     during the import process.
>     4.  Amount -- I sometimes have to specify that this is a negative
>     amount
>     (even though the file has positive values).
>
>     During the import you will have to specify the base account. This
>     will
>     be the checking account.  This is a field on the import screen --
>     not in
>     your file.
>     At some point you will map the above fields to tell the imported
>     which
>     one is the date, which one is the Other Account, which one is the
>     description and which one is the amount (or negative amount).
>
>     Test this out in a test environment first.
>
>     Save all your mapping to a file name so you can pull it back up
>     for real
>     (or for future use).  It is there on the setup screen.
>
>     At some point you will have the setup all done and will go NEXT.  At
>     this point it will list all the codes you used and ask you to map
>     those
>     to the real accounts (I presume expenses).
>
>     Good luck.
>
>     On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
>     > On 2023-08-24 14:15, jackielou wong wrote:
>     >> I have 500 transactions under checking account for importing
>     files... how
>     >> can i put this all in linked accounts...
>     >>
>     >> Everytime i do that they fall to imbalance usd.. can you help
>     to fix it. So
>     > Jackielou,
>     >
>     > This suggestion may seem inefficient, but I think you might get
>     the job
>     > done faster by just entering the 500 transactions manually, which I
>     > imagine you know how to do.
>     >
>     > I've never done an import myself, but as I understand it you have to
>     > teach GnuCash to recognize transactions the way you want. That takes
>     > time, which you could be using to enter transactions right into
>     GC, a
>     > process I assume you are comfortable with. And 500 is really not
>     many.
>     >
>     > That's what I did in early 2018 when I converted my 2011-2017
>     data to
>     > GC. It was over 15,000 transactions, but once I got going it
>     went very
>     > quickly. Sure, I had to deal with each transaction individually,
>     but I
>     > would have had to check each one anyway if I had tried an
>     import. And
>     > along the way, I noticed inconsistencies in how I had treated
>     similar
>     > events, and fixed them. For me, at least, the process was less
>     painful
>     > than spending a lot of time learning and tinkering with a batch
>     import
>     > process that I would probably never need to use again.
>     >
>     > If you still want to pursue importing, I think it would be
>     helpful if
>     > you could be a lot more specific about what process you are
>     following,
>     > what results you see in GC, and what error message you get (if any).
>     > Maybe import _one_ transaction, and provide that information?
>     >
>     > Stan Brown
>     > Tehachapi, CA, USA
>     > https://BrownMath.com/ <https://BrownMath.com/>
>     >
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at 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.
>