The only way I can think without a mod FIFO could be tracked in FrontAccounting is as a foreign currency account then It would have allocations. but im not sure how it would work.

I will pull the inventory tables in a bit for you if you haven't already

I was looking at a FIFO mod where when you sell you would make the effective date in the item moves(?) table the same as the purchase which will
make finding the first unsold asset easy in SQL.

We'd need to add a flag for FIFO  vs average cost

I am going to try to follow your suggestions above and see how close that gets us.
Inventory Location per wallet/exchange
Inventory GL cloned to Digital Assets GL (I assume in same GL group 15xx or mayne 16xx)
ditto for Variance

Should Sales and COGS have cloned accounts too?

I think we might need a Bank Account for each Exchange to track FIAT at that 'location'

I am not sure I get Supplier/Customer... but I need to ease into it

Tom

Note the IRS changes in inventory now is by wallet. So simplify your setup pick a standard and stick to it. Also I saw in 2026 FIFO will be required.

‘Per wallet’ method
After January 1, 2025, all US taxpayers will be required to use the ‘per wallet’ or ‘per account’ cost basis method. This means that sales of assets have to be matched with cost basis from buys or acquisitions of assets from the same account or wallet, hence ‘per wallet’.

The only way I can think without a mod FIFO could be tracked in FrontAccounting is as a foreign currency account then It would have allocations. but im not sure how it would work.

I will pull the inventory tables in a bit for you if you haven't already

Also the cost basis is also wallet (location) specific, not sure you can use one Inventory account for all...

Add supplier and track purchases
-Coinbase
-kraken
Add client to track sales
-Coinbase

It will calc your gains or losses for you
With the new US GAAP rules you can mark to market on your balance sheet. Prior it was only record impairments.

I think you adjust with the cost update or just do a general ledger
Debit - digital assets
Credit - gains / losses
Or vice versa

Do you need the import for prior transactions?
Csv? What headings?

I have found it is not hard to add a new mb_flag type and existing options to prohibit buying or selling the item and then
we can add Crypto Buy and Crypto Sell in the banking section (Like Payments and Deposits)

I started looking at the webpages to add that functionality and support edit/delete etc as FA does so well and that is a bit of a push for me!

So what I want to do is implement it as part of a new or existing extension and once I have that working find someone to do the FA pages.

*** HELP WANTED *** (Read above first)

Once I get the crypto transaction import working I need someone, either an FA core programmer or someone else who has the skills.

I might be able to put up some money for the project but first and foremost the end product will be open source and available to be merged
into the main FA source.

I have been using FA for 15 years for free (and making contributions) and feel it is important to continue doing so.

If we get a few of us to work on it together we can work on a forked version.

If some who want this can contribute $25, $50, etc that can help - I work for free because I want to use the feature.

If you have something that does a lot of what I am asking for Great, but I am not interested in closed source.

Tom