Understanding FIFO and Moving Average Cost in QuickBooks Online
QuickBooks Online users ask which inventory costing method to use, how FIFO and Moving Average Cost affect reports, and why the choice cannot be changed later.
November 2, 2025. QuickBooks Online users often question which inventory costing method to select.
What is FIFO?
FIFO stands for First In First Out. Under this method QuickBooks Online assumes that the earliest purchased items are the first ones sold. When a sale is recorded the software reduces inventory by the cost of the oldest units and increases cost of sales by the same amount. This approach matches the physical flow of goods for many businesses that sell perishable or time‑sensitive stock.
What is Moving Average Cost?
Moving Average Cost recalculates the average cost of each item after every purchase. QuickBooks Online adds the cost of the new receipt to the existing inventory value and divides by the total quantity on hand. The resulting average cost is then applied to both the remaining inventory and the cost of sales for any subsequent sale. This method smooths out price fluctuations over time.
How does the choice impact financial reports?
The selected costing method directly influences the value shown on the balance sheet for inventory and the amount reported as cost of goods sold on the profit and loss statement. FIFO tends to report higher inventory values during periods of rising prices because older cheaper costs remain in stock. Moving Average Cost yields a middle ground that reflects recent purchase prices while still acknowledging older layers. Users should review sample reports in QuickBooks Online to see how each method alters gross profit and inventory turnover ratios.
What symptoms do users report when unsure about the costing method?
Common signs include confusion over why inventory values differ from expectations, surprise at the amount of cost of goods sold after a sale, and difficulty reconciling physical counts with the numbers shown in the software. Some users notice that changing the purchase price of a recent shipment does not immediately affect the reported cost of sales under FIFO, while under Moving Average Cost the impact appears more gradually. These observations often lead to questions about which method best matches their actual business practices.
How can you decide which method fits your business?
Start by examining the nature of your inventory. If you sell items in the order they are received, such as food or pharmaceuticals, FIFO may mirror your workflow. If your stock is homogeneous and you prefer a simple average that updates with each purchase, Moving Average Cost could be more appropriate. Consider also the reporting requirements of your accountant or financial advisor, as they may have a preference based on tax implications or industry standards. Running a trial with a small subset of items in a test company file can help you see the effects before committing.
Why can the method not be changed later?
QuickBooks Online locks the costing method once inventory transactions have been recorded. Changing the method retroactively would require altering the historical cost layers that underlie every past sale and purchase, which could compromise the integrity of financial records. The platform therefore prevents the switch after the first inventory entry to protect the accuracy of reports such as the balance sheet and profit and loss statement. Users are advised to make the decision during initial setup or before any inventory activity begins.
Summary
QuickBooks Online offers two inventory costing options: FIFO and Moving Average Cost. Each method calculates inventory value and cost of sales differently, influencing key financial statements. Users often notice discrepancies between expected and reported numbers when they are uncertain about which method applies. Evaluating the flow of goods, consulting with a financial professional, and testing in a safe environment can guide the selection. Remember that the choice is permanent once inventory transactions exist, so careful consideration at the outset is essential for reliable reporting.