QuickBooksHelpIntuit

# Move your stock from QuickBooks Desktop to QuickBooks Online

##### by Intuit• Updated 2 months ago

Learn how QuickBooks Online accounts for stock and why it’s different from QuickBooks Desktop.

QuickBooks Pro/Premier use average cost to calculate your stock costs. QuickBooks Online uses first-in-first out (FIFO). QuickBooks Enterprise can use either method.

For most businesses, FIFO shows the biggest gross profit and highest final stock value on the balance sheet. It also shows how stock flows through your business.

## Step 1: Set your stock start date

You’ll need to pick a FIFO stock date before you move your data. Once you set the stock start date, you can’t change it. Also, you can’t edit any transactions before this date.

Any transactions on or after this date show as FIFO. We recommend you use the first day after your company’s last tax filing period. This way you won’t have to file amended forms.

### Examples of FIFO stock calculations

Let's say you have an stock item with a cost that changes over time. You don’t resell this item directly, but use it to make your final sellable product.

 Purchase date Quantity Cost per item Cost to business 1/1/18 100 \$0.70 \$70.00 1/15/18 125 \$0.73 \$91.25 2/1/18 150 \$0.78 \$117.00 2/15/18 200 \$0.80 \$160.00 Totals 575 \$438.25

In this example, we’ll use 200 of this stock item to make your final product your customer already bought. We’ll compare the average costing method (QuickBooks Desktop) to FIFO (QuickBooks Online) for this stock item.

 Average Cost FIFO Calculate the average: (\$70.00 + 91.25 + 117.00 + 160.00) / (100 + 125 + 150 + 200) = \$0.76 per item Multiply the average cost by quantity sold to determine Cost of Goods Sold: \$0.76 x 200 items sold = \$152 Calculate Cost of Goods Sold for the first purchase date (1/1/22): \$0.70 x 100 items sold = \$70Multiply the remaining 100 items by the cost of the next purchase date (1/15/22):\$0.73 x 100 items sold = \$73Add the values of both purchase date to determine Cost of Goods Sold:\$73 + \$70 = \$143

For more info, check out the QuickBooks Blog post, Average Cost vs FIFO.

Complete this form and send it in by the due date for timely filing of your business tax return. For the current tax year, it must be filed by October 15 (the due date of your return with an automatic 6-month extension).