My accounts were created before GnuCash defaulted to setting the top
level accounts as placeholders. So yes, my Expenses account will allow
transactions to use it.
When I get to the "Match Transactions" step, none of the transactions
have transfer accounts. When click the Add column and then try a
The GnuCash account structure is dictated by the program and it will not
necessarily exactly match what your brokerage statement shows. As one of
the previous comments noted, there are some bug reports indicating that the
csv importer is not able to import some transactions . You may need to
fudge
As for using the Expenses account, unless you intentionally made it
*not* a placeholder account, you can't put transactions in it. I'll
hazard a guess that is why the importer is not assigning it.
Create a sub-account of Expenses for tracking the commissions/fees and
try to assign that one in
I used the parent Expense account because I don't really need to track
it separately. The fee is paid directly out of the stock account. I
don't see how adding an additional account is going to fit the
commodity problem. The second line is a purchase from a specific Asset
account and that transacti
I uploaded the spreadsheet I've been using and a python program I wrote to
https://github.com/flywire/ETF-Annual-Statement
It's basically just a lookup and pivot table saved to csv using rounding as
an error check (credit to Chris Grinton). It could easily be extended to
automatically extract the
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/
> Does the CSV importer handle floating point values for amount and price
or do I need to use integers?
Floating point works fine for me in all amounts except price:
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102535.html
> e.g you'd write $497.65 for 57 shares as 49765/5700
___
Jon,
My example that I gave earlier deliberately ignored commissions. I assumed
the simpler method, as described somewhere in the help manual, that net
prices were used instead. This will better match your broker's statements
when you review the cost basis. If your first line is supposed to ind
Unless I've confused something, purchasing or selling a stock/fund/etc.
should be between 2 asset accounts. Considering a split for a commission
or such, (like the first line of your CSV) it would be a *specific*
expense account, not the parent and placeholder "Expenses" account.
Regards,
Adr
On Sun, 2022-08-21 at 09:01 -0700, john wrote:
>
>
> > On Aug 21, 2022, at 6:37 AM, Jon Schewe wrote:
> >
> > On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote:
> > > On 8/19/2022 10:33 PM, Jon Schewe wrote:
> > > > So I didn't get the CSV import tool to work.
> > >
> > > Perhap
Finding the right source and symbol seems a challenge! For several years
I've been successfully getting quotes through fq using the single source
"Alphavantage, US" for single UK equities, and the multiple-source "U.K.
funds" for UK funds. However, I can't find anything that works for UK
Treasury g
11 matches
Mail list logo
