[GNC] Example of importing Stock transactions from CSV

[flywire]

This post is from the
https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112463.html
thread with discussion moving in a different direction.

https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112470.html Greg
Julius <greg.julius at outtacyte.com> wrote:

> FWIW, I really struggled with this to figure out what was wrong with my
> imports.  There is a Commodity field and there is a Currency field.  I had
> to repeatedly fill in fields until I found the issue was Currency.


Greg, Are you suggesting this is a  Commodity/Currency field issue? I've
added the full process from the linked bug report - see RIO near the end.
My GnuCash file has transactions from previous years that were imported
properly.

https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102562.html
>
>> The three lines below *work* using a Multi-split import - based on
>> https://bugs.gnucash.org/show_bug.cgi?id=797450
>> Save *PP-Demo_Transactions_Minimal_Priced2.csv*:
>> Date,Description,Action,Account,Deposit,Rate/Price
>> 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53
>> ,,Buy,Assets:Broker:Shares:RIO,89,8900/991253
>
>
GnuCash (brackets at end of line show changes for V5.8)
> File, New
> Cancel
>


Tools, Security Editor
> Securities: Add
> New security
> Full Name: RIO
> Symbol: RIO
> Type: ASX (Namespace)
> OK
> Close
>


File, Import, Transactions from CSV
> Next, PP-Demo_Transactions_Minimal.csv, Next
> Multi-split, DateFormat, Leading Lines to Skip 1,
> Date, Description, Action, Account, Deposit, Price (Amount instead of
> Deposit)
> Next
> Map Account ID to Account Name
>


Change GnuCash Account, New Account
>
> Manually parse the accounts at ":" Creating new accounts until they are
> done.
> RIO is Account Type: Stock, Security: RIO, OK (Note security Namespace:
> ASX)
>


Next (If New Book Options is displayed just Close), Next
>


Ignore UNBALANCED, Apply, Close
>

If it was UNBALANCED then Import was not successful.


Interestingly, this previously working file now has three field errors
(Date, Amount, Price):

> Save PP-Demo_Transactions_Minimal_Priced.csv
> Date,Description,Action,Account,Deposit,Rate/Price
> 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53
> ,,Buy,Assets:Broker:Shares:RIO,89,111 + 3353/8900


Regards