[GNC] Need help importing Investment transactions

[David Carlson]

I have created a test csv import file and I can replicate the single line
out-of-balance imported transactions. .  Reminder, I am still using release
3.8 in Llnux Lite [Ubuntu 20.04].

The test file is pure text, I will quote it to be sure that it gets
through.  Alas, that adds spurious carriage returns.  There should only be
five transaction lines beginning with the date and no cr's until just
before the next date.  I will try attaching it as well.
I set it to import into the brokerage account skipping the header lines,
assign import columns Date to Date, Memo to Type, Description to
Description, Deposit to Amount, Transaction Commodity to Symbol and Price
to Price. Then I make all five transactions new in the match step as there
are existing similar transactions.  The dividend transaction does get a
transfer to the correct account.

[Transactions
Account: DianeIRA (*****574)

Time Period: 07/01/2021 to 12/22/2021
Transaction type: All transactions without Cash Sweep Activity

Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
08/02/2021,Dividend,"Bristol Myers Squibb Co
Cash Div  On     475 Shs
Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
08/02/2021,Dividend,"Pimco Corporate & Income
Opportunity Fund
Cash Div  On     600 Shs",,78,PTY,,
07/26/2021,Interest,"RBC Insured Deposits
Monthly Interest 06/28-07/25
Apye#: 00.01 %",,0.02,,,
07/09/2021,Dividend,"American Tower Corporation
Reit
Cash Div  On     150 Shs",,190.5,AMT,,
07/01/2021,Dividend,"Pimco Corporate & Income
Opportunity Fund
Cash Div  On     600 Shs",,78,PTY,,]

On Thu, Dec 23, 2021 at 12:58 PM David Carlson <david.carlson.417 at gmail.com>
wrote:

> It will be a while before I can find an adequate time window to test and
> post an example csv with instructions to duplicate the single line
> transactions that I saw the other day.  I still have the csv file and the
> import configuration so I should be able to do it.  In the meantime have a
> nice holiday.
>
> On Thu, Dec 23, 2021 at 11:44 AM john <jralls at ceridwen.us> wrote:
>
>>
>>
>> On Dec 22, 2021, at 8:58 PM, David Carlson <david.carlson.417 at gmail.com>
>> wrote:
>>
>> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
>> under a different label.  I think that the CSV transaction import has not
>> been changed, between 3.8 and 4.9.  If that is not correct, then some of
>> my
>> issues may be bugs that have been fixed.
>>
>> I have read the current help manual section on importing transactions in
>> csv format <https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>
>> which
>> gave me a start, but there are some things that I cannot make work
>> correctly.
>>
>> I have come to the conclusion that my brokerage house World Equity Group
>> CSV exports probably need to be massaged, and possibly split up but there
>> are a couple of issues that I need to understand in order to determine how
>> to fix the import data and to assign the proper names to the various
>> fields.
>>
>> One issue is that in one test many transactions were imported as single
>> line unbalanced transactions with no transfer account, not even an
>> assignment to an unbalance account.  Why did GnuCash accept unbalanced
>> transactions containing amounts? Applying Check and Repair to some of
>> those
>> transactions did not balance them to an unbalance account.
>>
>> Another issue is that I have not figured out which column name should be
>> used for the number of shares in a purchase or sale transaction.
>>
>> Yet another issue would be whether I can import everything into the
>> brokerage account or do I need to do something special to get stock
>> transactions assigned to the proper security account when appropriate?
>>
>> A fourth issue would be whether I need to use the Multi-Split feature and,
>> if so, how to format the CSV file to make it assign the correct split
>> lines
>> to the correct base transaction, and save it in CSV format if I built the
>> spreadsheet in LibreOffice Calc or equivalent
>>
>>
>> Your premise might be mistaken: There have been 40 commits in
>> gnucash/import-export/csv since 3.8 including several bug-fixes. However
>> none of the summaries say anything about creating single-split
>> transactions. You're right that that shouldn't be possible. Can you post an
>> example or two of CSV rows that do that?
>>
>> There isn't a column name for amount (see
>> https://bugs.gnucash.org/show_bug.cgi?id=797368), just for price, but
>> even that apparently doesn't work well:
>> https://bugs.gnucash.org/show_bug.cgi?id=793306 and
>> https://bugs.gnucash.org/show_bug.cgi?id=796955.
>>
>> If you root the import on the brokerage cash account you should be able
>> to designate the transfer accounts to the various stock's accounts in the
>> matcher if importing stock trades worked, see previous item.
>>
>> The easiest way to learn the format for multi-split CSV files is to do
>> File>Export>Export Transactions to CSV and examine the resulting
>> spreadsheet.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>>
>>
>>
>>
>
> --
> David Carlson
>


-- 
David Carlson
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Test_Transactions_without_Cash_Sweep_Activity_2021-12-22.csv
Type: text/csv
Size: 719 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20211225/a018b28d/attachment.csv>