Saturday, June 24, 2017

Blog

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.

News

Blog entries and news about Bitcoin and other cryptocurrencies.

Subcategories from this category: Bitcoin Minute

World Bitcoin Network

This Papa John's pizza might look like an ordinary delivery, but it seems likely to go down in history as the most expensive food of all time. And the date it was purchased, May 22nd 2010 could well mark the first shot fired in a major revolution in the history of economics.
This is because this pizza was bought for Bitcoins, and it is likely the first ever transaction ever made with the fledgling currency, which came to life in 2009.
Further when programmer Laszlo Hanyecz ordered the pizza in Jacksonville Florida three years ago, he purchased it with 10,000 Bitcoins. At today's exchange rate of approximately 120 dollars to one bitcoin that amounts to a current day price for the pizza of 1 million 2 hundred thousand dollars.
For historians, Laszlo's initial exchange can still be seen today on the bitcoin forum. He wrote:
"I'll pay 10,000 Bitcoins for a couple of pizzas.. like maybe 2 large ones so I have some left over for the next day. I like having left over pizza to nibble on later."
It seems impossible to imagine these days, as prices for Bitcoins have multiplied in value over 50 thousand times. This was recently highlighted by the bitcoin purchase of a Porsche in Austin Texas. The price here, just 300 Bitcoins.
Clearly, this leads us to a greater question. How far will the Bitcoins value soar. An answer that no one knows. Yet some pundits suggest that Bitcoins could swarm into the $60 trillion dollar international space for transactional currency.
Indeed if bitcoin even grabs a 1% share of this market, its value can be calculated to climb to a phenomenal 100 thousand dollars per coin. At that point, the pizza would be worth exactly 1 billion dollars. Too much? Its not clear. Laszlo ate well that night, and launched the once abstract coin into the world for the first time as a currency.

Hits: 1112
Rate this blog entry:
0

Posted on in News
Import your Bitcoin Sales into Quickbooks

Supported “home currencies”: USD, EUR, CAD

In Quickbooks, you do not need multi-currency enabled if your home currency is USD, EUR, or CAD, and you are taking 100% settlement from BitPay in that same home currency.

First, create 3 new Accounts in your Chart of Accounts. Income and Expense accounts can only be denominated in your home currency. (if your home currency is not USD, replace USD below with your home currency)

Type Income
Account Name BitPay Sales USD
Tax-line Mapping Income: Gross Receipts or Sales

 

Type Expense
Account Name BitPay Fees USD
Tax-line Mapping COGS: Other Costs

 

Type Bank
Account Name BitPay AR USD
Tax-line Mapping B/S Assets: Accts Rec


Your Bank Account should already be in Quickbooks. BitPay’s ACH/EFT transfer will be transferred to “My Bank” which you can change in the General Ledger transaction after import. Your Quickbooks Chart of Accounts should have these entries:


Here’s a test file to download:

https://www.dropbox.com/s/tj0dralgcl79u6d/USD-sales-USD-settlement.iif

In Quickbooks select: File - Utilities - Import - IIF files

If this imports and My Bank USD shows a balance of $100.00 then the file has imported correctly. Look at the G/L to verify the Sales Receipts.

Edit the transfer and replace “My Bank USD” with the Bank account in your chart of accounts that received the direct deposit from BitPay.

Your BitPay sales are now fully integrated with your financial reports in Quickbooks!

Note that if you keep any % of your sales in Bitcoin, this will not be noted in the download. It will prorate the gross sale to only the % of the gross sale which you settle in your local currency. Read the next section “Keeping Partial or All Settlement in Bitcoin” to learn more.

Income Statement derived from BitPay import


Balance Sheet derived from BitPay import


To download your BitPay transactions, login to your merchant account at https://bitpay.com. From your dashboard, click on Account Ledger and select your home currency to download.

You will need to specify the date range to download, and then choose Quickbooks IIF file.

We should note that Quickbooks does not support multi-currency very well, even in the 2013 edition. Nonetheless, we have used the capabilities of Quickbooks to their current maximum potential.

If you take 100% settlement from BitPay in your home currency, you are done!

If you keep a % of your BitPay Sales in Bitcoin, follow the next section to import those from your BitPay BTC ledger.

Keeping Partial or All Settlement in Bitcoin


The Gross, Net, and Fees are % prorated from the total amount of the sale. Meaning if you keep 10% bitcoin and settle 90% in EUR, your EUR ledger will have an entry representing 90% of the total gross sale, and your BTC ledger will have an entry representing 10% of the total gross sale, with the same Order Number so you can match them up in Quickbooks.

Create 2 more accounts in your Quickbooks Chart of Accounts:

Type Bank
Account Name BitPay AR BTCUSD
Tax-line Mapping B/S Assets: Accts Rec

 

Type Bank
Account Name My Wallet BTCUSD
Tax-line Mapping B/S Assets: Cash


These accounts represent the USD value of your Bitcoins, at BitPay and also when pushed to your Bitcoin Wallet.

How to Reconcile your Company’s Bitcoin holdings in Quickbooks


While Intuit’s support for multi-currency doesn’t give all the income/expense reporting needed for bitcoin transactions, it is possible to add your Bitcoin Wallet into Quickbooks, and mark your digital assets to market price every day or every month.

As of the 2013 edition, Quickbooks cannot:

  1. have an income account in any currency other than your home currency
  2. have an expense account in any currency other than your home currency
  3. allow you to set your home currency to a currency you add (e.g. Bitcoin)
  4. resolve any currency balance to more than 2 decimal place precision
  5. allow you to specify an exchange rate for each sale
  6. allow you to specify a data source for exchange rates for a currency
  7. allow you to upload a history of exchange rates for a currency
  8. allow an exchange rate with a date & time (only 1 rate per calendar day permitted)

We encourage Quickbooks users to contact Intuit directly and encourage development in the above 8 areas to improve their multicurrency support.

You cannot enter Income or Expenses in BTC, mBTC. But you can setup a Bank account in bitcoin to declare and value your bitcoin holdings. You will first need to enable multicurrency support in your Quickbooks. Then, you can add a new currency:

Company - Manage Currency - Currency (New)

Name millibitcoin (mBTC)
Symbol mBTC


Next, create a new account in your chart of accounts for each bitcoin wallet you want to account for in Quickbooks.

Type Bank
Account Name My Wallet mBTC
Currency millibitcoin (mBTC)
Tax-line Mapping B/S Assets: Cash


Because Quickbooks precision cannot go past 2 decimal places for the quantity, if you want to account for your bitcoin holdings you will need to use millibitcoins (mBTC). The exchange rate for mBTC is the rate for BTC divided by 1,000. Quickbooks does have 8 decimal precision when calculating the rate, but only 2 decimal precision on the quantity.

USD for 1 bitcoin (BTC) $ 123.4567
USD for 1 millilbitcoin (mBTC) $0.1234567


To transfer the balance from the USD representation of your bitcoin wallet to the mBTC account for your bitcoin wallet:

Every day, you will manually need to enter the exchange rate under Company - Manage Currency. The exchange rate is the USD amount pushed to My Wallet BTCUSD divided by the actual number of Bitcoins delivered to your wallet, as viewed directly on your BitPay BTC account ledger page.

Then, manually enter a TRANSFER every day to clear out the deposit from the My Wallet BTCUSD and transfer into My Wallet mBTC. Your Wallet should now show the latest deposit in the correct number of mBTC, and on your balance sheet the entire wallet balance will be marked to the current market price.

Original Article Link

Tagged in: BitPay
Hits: 1635
Rate this blog entry:
0

World Bitcoin Network

With a tiny addition at the bottom of an obscure page on their website this week, eBay sent a swirl of excitement through the bitcoin community. By adding a section for virtual currencies, it seemed clear that eBay is making moves to embrace bitcoin. Immediately the bitcoin community went wild with activity, with many applauding eBay's move. But then, as quietly as the line was added it was removed.
Had eBay changed its mind? Was it a hack?
Its likely we will never know. But digging further reveals something even more elaborate. Around the same time, another page on eBay called DEALS released a well produced introductory bitcoin video. However, the 2 minute animation, is peculiar in its own right, almost like a two minute blurb of indecision, and it makes no comment whether eBay intends to go forward with bitcoins.
Still, eBay is no newcomer to the bitcoin world. This past May, CEO, John Donahoe made numerous comments hinting that Ebay might even begin to accept bitcoin as a form of payment, a move that many bitcoiners view as a potential windfall. Yet just by selling bitcoins on its site, eBay becomes a massive free-market exchange, and as such, an easy entry point for many into the bitcoin world. With the legal framework in place to avoid the pitfalls of startups like TradeHill and Mt. Gox, Ebay's entry into bitcoin would likely be smooth.
But, for eBay, the adoption of bitcoins presents one glaring problem. Ebay owns paypal. And bitcoin's acceptance could likely signal paypal's demise. So, if Ebay were to move forward with bitcoin, the auction giant would be sacrificing billions of dollars of paypal profits, a move they are likely not going to make any time soon.
And though, you can still buy and sell bitcoins on the site today, at enormous markups with some obvious risks, its not clear that eBay is doing anything more than just flirting with the enemy.

Hits: 886
Rate this blog entry:
0

World Bitcoin Network

In an overly sensationalistic piece yesterday, the New York Times reveled more about the level of NSAs commitment to prying into the lives of Americans.
This time, though the Times news agency, long suspect on technical matters, fell for NSA's own leaked bragadoccio.
In an internal document leaked by Snowden, the NSA claims to have cracked a number of forms of cryptography.
But this is where anyone familiar with cryptography takes issue. Cryptographers, a very small population indeed, took to the airwaves to note the ridiculous errors of the Times piece.
One wrote:
"Nobody, not even the NSA can arbitrarily crack anything.
Even if the NSA set every computer on the planet to work on brute-forcing an encrypted message, it would take millions of years."
He goes further.
"Instead, the NSA breaks in through less magical means, like demanding that data be handed over, stealing a key from a user, even having agents who physically pilfer data"
This is confirmed in a much more nuanced piece by Wired.
Wired states that the NSA cannot crack the algorithms that protect data, instead the Government organization relies on mobster-type tactics.
They pressure vendors, steal passwords and bully.
In fact both Wired and the Guardian covered the story without the confusion and fear mongering of the New York Times, with neither one suggesting that any modern cryptographic algorithms have been cracked.
For Bitcoin users this news will come as a relief.
Indeed, Bitcoin uses one of the most famous bits of cryptography, SHA. And SHA stands for Secure Hash Algorithm.
It is not only still secure today, it seems likely to be secure for a few million more years.
Still, ignoring the New York Times poor journalism, these new NSA revelations do matter.
We now know that Big Brother is doing doing much more than just watching.
As a result, we'll offer two words of advice for your bitcoins.
Cold Storage.

Hits: 918
Rate this blog entry:
0
Video shared on in Bitcoin Minute

World Bitcoin Network

In an unannounced change to HTML5, the engine that powers most major websites, there is now a tiny nod to bitcoin.
For website developers "bitcoin" like "mailto" or basic http linking, is now accepted protocol.
But this small step for bitcoin could be a major step for mankind.
This is because bitcoin, and no other current system, can handle micropayments.
So difficult has it been to send a couple pennies or less via the internet that is has often been called the holy grail of web finance.
Sending such low amounts, seems petty, but when applied to something like a hit song, news article, blog comment or a video, it could add up to big money indeed.
Micropayments not only provide content creators with important feedback but game-changing finance.
But this move by the developers of HTML will also push the near-zero transaction costs of bitcoin even deeper into PayPal's home turf.
Which could prove to be a nightmare for the financial giant, because bitcoin is adept not just at small payments, but at large.
Further bitcoin can be received freely across borders even from those without bank accounts.
And its not clear that PayPal has an answer.
So as bitcoin explodes, riding an exponential adoption curve, there are rumors that PayPal might adopt the cybercurrency.
But that's not happening any time soon.
PayPal makes billions each year off their current price scheme, grabbing 2-5 percent off of every transaction.
Bitcoin, on the other hand, offers to do a better job without charging anything.
Indeed at bitcoin there are no CEOs or shareholders to gobble up profits and bonuses.
While consumers save billions, PayPal is biting its nails and perhaps even lobbying congress.
Wouldn't you?

Hits: 1740
Rate this blog entry:
0