Search options (Page 1 of 4)

The drag is just the bulk importing once you have it setup it will be regular use and front will give you accounting plus inventory for free compared to QuickBooks for 40 USD plus inventory 60 USD a month. There are some others as well I don't know if they have inventory

I’ve taken a look at the source code for import_items located here https://github.com/apmuthu/FA24extensions/blob/master/Extensions/import_items/import_items.php. I can see exactly why your import is failing. This specific script is very rigid about how it expects data to be structured.
Here is the breakdown of the issues and how to fix them.

Note: there could be a variation if you are using a different version of the plugin!

1. The Header and Delimiter Mismatch
You mentioned your header looks like this:
ITEM;ITEMCODE;STOCK_ID;Description;Category;units;;MB_FLAG;Currency;Price;
The key code in the file is this

list($type, $code, $id, $description, $category, $units, $qty, $mb_flag, $currency, $price) = $data;

The Issues:
The Separator: You are using semicolons ( ; ), but the PHP code defaults to a comma ( , ).
The Column Count: Your header has 11 potential slots (counting the double semicolon), but the script uses list() to assign exactly 10 variables.
The Script's Internal Map: In the code, the variables are assigned in this specific order:
type (Must be "ITEM")
code (Item Code)
id (Stock ID)
description
category
units (e.g., 'each')
qty (The script uses this column for Dimensions)
mb_flag (B, M, D, or A)
currency
price

2. The Correct CSV Structure
To get "joy" from this import, your CSV file must follow the logic in line 169 of the code. Do not use semicolons unless you manually change the "Field separator" box in the FA interface to a semicolon before hitting import.
Recommended Header (Standard Comma Separated):
TYPE,ITEM_CODE,STOCK_ID,DESCRIPTION,CATEGORY,UNITS,DIMENSION,MB_FLAG,CURRENCY,PRICE
(Note the script skips the first line so header isn't important for import)
Example Data Row:
ITEM,101,101,Widget Pro,Components,each,,B,USD,15.00
Note on MB_FLAG:
B: Bought (Purchased items)
M: Manufactured (Produced in-house)
D: Service (No stock tracking)

3. Why Export "Is anything but CSV"
The code handles exports in a very "raw" way (Lines 112–134). It tries to force a download by echoing strings directly.
If the export looks like gibberish or a messy webpage, it’s usually because the server is appending HTML or notices to the file. When you export, ensure your browser isn't blocking the download and try opening the file in a plain text editor (like Notepad++ or TextEdit) rather than Excel first to see the raw structure.

Troubleshooting Checklist
Column 7 (The "Dummy" or Dimension): In your header, you had two semicolons together (;;). The script interprets that empty slot as the Dimension. If you don't use dimensions, leave it empty but keep the comma there.
Category Name: The CATEGORY in your CSV must match the "Description" of a category already in FA, or the script will try to create a new one using the default GL accounts you selected on the import screen.
Case Sensitivity: The script runs strtoupper($type). Ensure your first column always says ITEM in all caps.

I know you stated you didn't want to use SQL and that is why I mentioned phpmysql it has a graphical user interface to access the database tables like any spreadsheet editor and supports importing and exporting tables of various formats including CSV. It is a very useful tool since you can import and export from any SQL table not just one specific table through a script and do not have to import any SQL statement to do so.

One final note remember that the data must be compatable format that front and the db expects

Example
stock_id varchar(20) Primary Key. This is the unique identifier (e.g., "WIDGET-01"). No spaces are best. Max 20 characters
category_id int Foreign Key. Note that the CSV script asks for a Name, but the table stores an ID. The script does the lookup for you. But it must exist
mb_flag char(1) 1 character: B (Bought), M (Manufactured), D (Service/Dummy), or A (Assembly).
units varchar(20) 20 character max again and Must match an entry in the item_units table (e.g., "each", "hr", "box")..

Yeah I was looking over and noticed the 3rd example

Line 195 in sales/manage/recurrent_invoices.php

customer_list_row(_("Customer:"), 'debtor_no', null, " ", true);

I was wondering why the space for 3rd arg. It should become true since it has a space but strange.

I'm going to look it over tomorrow there has to be something I'm missing, maybe I'll try another browser. So strange that the generated source has the correct id as selected. Maybe it's a time / buffer issue.

This would be weighted average.  There are 3 that I know of FIFO, LIFO, and HIFO. The Cost Basis is your average of all purchases.

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

Sure, you can handle this by importing a CSV file. I would think the CSV import transactions module should be able to do this with little or no changes.

The main challenge is tracking the transactions. When using Bitcoin as a payment method with services like LNbits or BTCPayServer, they can send a webhook to your server with the fiat value and the number of inventory units you received. This makes it easy to track the cost basis. It sits in your books as the value you received it for, and then when you sell, you capture the gain or loss.

A typical method is FIFO (First In, First Out), where the gain is applied to the oldest inventory first. You would need to manually enter the sale transaction, and the system (FA, for example) should calculate the gain for you. I know it does this when Bitcoin is treated as a foreign currency.

If you're just monitoring a wallet address, you need something like Electrum Server. For example, I have one set up on a small home server running Debian with Umbrel (Umbrel). You can configure it to monitor wallet(s), record transactions in and out, and calculate gains or losses based on the spot price at the time of the transaction.

There are also many online tax tools for crypto that allow you to import CSV files, and they will handle the calculations for you and prepare the necessary tax forms.

In the united states it should be treated as inventory Cost basis

a basic sale
credit -> sales, service, or accounts receivable
debit -> inventory

then Adjust inventory units

a basic purchase
credit -> appropriate expense account
debit -> inventory

then Adjust inventory units

every company could be a bit different. depends if bitcoin is an important part of the business like COGS etc

OK just putting this out there
XRP, Ripple, & Brad Garlinghouse are a scam. They hold a premade share of the tokens (like securities) and sell to fund the scam that is, possibly even funding you.

Bitcoin is the only relevant true open digital asset with no company just code.

Also the FrontAccounting payment module already exists only lacking in polish. StrikeOut extension supports
Traditional Fiat payments ( through PayPal or Stripe)
Bitcoin exchange ie. (BTC payment but Fiat received) through Strike
Bitcoin (std and lightning) Through lnbits and btc payserver

Now if anyone would want to add a scam coin they are free to download plugins for btcpayserver to support scam coins. The only useful ones I can think of is  Stable coins (digital securities issued, fiat backed)  Like USDC or UST. But this should only be used where banking does not exist or is difficult. It is just trading a digital IOU for fiat in a bank that can be frozen or blocked at anytime or possibly the issuer might not meet reserves for redemtion just like a bank.

FrontAccounting Invoices in the clients currency of choice and if they chose to pay another way strikeout will present them with a qr invoice valued at that fiat amount in the digital asset.

I think mail should be the way to go normally but sometimes servers don't have their mail server setup, have deliverability issues, or people just want to send email from a Google account or something will use phpmailer.

you could use my strikeout plugin
It will automatically make payment links in the invoice email, PDF, and make a scanable QR on bottom right of the invoice.
This brings the client to a payment page with their balance and when they pay it will be entered in your front accounting automatic.

It supports
Stripe (credit cards, Cash App, EFT, and other payment methods)
PayPal (credit cards, Venmo, and PayPal)
Strike (Bitcoin as USD no strange accounting 0 merchant fee and fraction of percent to client)
lnBits (bitcoin the asset 0 fee self custody)

You can mix and match payments methods

https://strikeoutpay.com/new-payment-integration-module-for-frontaccounting-strikeout/

you can find it on my git
https://github.com/trafficpest/FA24extensions/tree/strikeout/Extensions/strikeout

this post has the core changes to add the link
https://frontaccounting.com/punbb/viewtopic.php?pid=43088#p43088