Hello,

Currently our software can only import transactions from on-chain transactions. However, with the rise of off-chain transactions (Lightning Network), we are investigating allowing importing of an excel sheet of transactions into QuickBooks.

The transaction types we use are Sales Receipt OR Invoice+Payment for incoming transactions, and Journal Entry for outgoing payments (since we automatically calculate capital gains within QuickBooks for you!).

When developing the service we looked into using Bitcoin as an inventory stock item, but there were many issues with it that I don't recall now. We use Bitcoin as a foreign currency using the multicurrency abilities of QuickBooks.