Using Bitcoin With Quickbooks - Part 1: Recording Sales and Accepting Payments

Jason M Tyra for BitCoin Magazine writes: This is the first part of a multi-part series that will explain how to integrate Bitcoin as a payment method using your existing small business accounting software package.  Why would you need to do this?  In short, because accounting principles generally accepted in the United States and state and federal regulatory authorities require reporting in US Dollars.  This procedure will allow you to properly account for the full extent of your Bitcoin sales and integrate those sales into your business records as if they had originally been made in your home currency.

Since the vast majority of small business owners use a version of Intuit QuickBooks, this series will refer to that product (specifically the 2014 version). The concepts will be the same regardless of what software or version you use, though the implementation may vary somewhat.  I assume as a pre-requisite that you have a basic knowledge of financial accounting, that you are familiar with your accounting software package and that the amounts that you record are determined with reference to US Dollars. 

Starting in 2009, most US desktop versions of QuickBooks featured native multi-currency support.  This function can be activated from the preferences menu and allows rates to be automatically updated from the internet.  The QuickBooks file has a default or “home” currency and then tracks as many other foreign currencies as needed, with the functional currency set by vendor, customer, or account. 

Use of the multi-currency feature comes with a few caveats- First, QuickBooks will only update currencies automatically when the home currency is US Dollars so this feature may not work well for users outside the US.  Second, add-ins like Statement Writer and Fixed Asset Manager will only work with US Dollars, meaning financial statements cannot be denominated in Bitcoin if you choose to hold them as an asset.  Finally, QuickBooks does not integrate with many of the Bitcoin intermediaries in common use at this time.  Thus, billing and collection would require an extra step even if you did use multi-currency.  For these reasons, this procedure does not make use of multi-currency support.

As of the fall of 2013, Bitpay.com supported ledger downloads in Intuit Interchange File format (.iif).  Though this may save some data entry work if your business has considerable Bitcoin transaction activity with Bitpay, you will still need to create the accounts in QuickBooks to classify your transactions.  If there is a demand for it, I will address how Bitpay and QuickBooks interact in a later article, though Bitpay’s website already does a good job of this.

To book Bitcoin sales in QuickBooks:

1.       First, record sales as normal, using the programmed workflow in QuickBooks (either “create statements” or “create invoices”) in your functional currency (USD, Euro, etc.).  If you request funds using Coinbase, Bitpay, BIPS, or another payment service provider, you may want to select the option bill with reference to your functional currency instead of directly in Bitcoin in order to reduce your exchange risk.

2.       Before recording payment, you will need to add two new accounts to your company’s chart of accounts (you only need to add these accounts once).  From the home screen, select “Chart of Accounts”, then select the “Account” tab and click “New.”  The first account will be an “Other Current Asset” account (under “Other Account Types”) called “Bitcoin” (or “Bitcoin Wallet” or whatever works for you).  The tax line mapping will be “not tax related.”  The second account will be an income account called “Bitcoin Exchange Gains.”  The tax line mapping will be “other income.”  You may also want to add an expense account called “Bitcoin Exchange Losses”, though gains and losses generally should net out and show up as a single line item on your Profit and Loss statement.  Close the chart of accounts.

3.       Add Bitcoin as a payment method.  From the home screen, select the “Receive Payments” function (also accessible from the Customers menu).  On the “Customer Payment” screen, select the “More” button adjacent to the cluster of payment method buttons.  Then select “add new payment method.”  The new payment method will be called “Bitcoin” of type “Cash.”  Select “Ok.” 

4.       To record a payment on account in Bitcoin, click the “Receive Payments” button and select the customer from the “Received From” menu.  Input the amount received in dollars.  This should be the same amount that you billed, even if the exchange rate fluctuated between billing and receipt, or else QuickBooks will show an unresolved debit or credit balance on the customer’s account.  Click the “More” payment method button (looks like a plus sign), then select “Bitcoin.”  In the “Deposit To” box, select the other current asset account you created to track your Bitcoin Wallet.  Your customer should now show payment in full for the associated invoice.

This procedure is just one of several possible ways to record Bitcoin sales in QuickBooks and less complicated that some of the others out there.  Since you are already using the regular QuickBooks workflow, you should have no problems with your Cost of Goods Sold or Accounts Receivable showing weird balances (they will be denominated in dollars, just as you recorded them).  Always remember to record sales and payments in QuickBooks using the “Create Invoices” and “Receive Payments” functions.  Not doing so may result in misclassification or underreporting of income, unapplied customer payments and other undesired results.   

The next part of the series will be “Revaluing Your Wallet and Converting to Cash.” Feel free to contact me with feedback, questions, or requests.