The true cost of a piece: from PO charges to QuickBooks

The vendor price for a sofa is $2,000. The cost after inbound charges is $2,811.23. The difference belongs somewhere more useful than a freight invoice sitting outside the order record.

This illustrative purchase at the invented Linden & Oak showroom follows one sofa through OrderPilot's PO charges, receipt, and QuickBooks Online purchasing records. Every amount and the assumed duty rate below is an example, not a current tariff or freight quotation. The aim is a cost record the owner can explain from the supporting documents.

General information, not tax advice.

1. Record the charges while they are still estimates

Priya records the sofa's $2,000 vendor cost and the expected purchasing charges on its PO. Freight, duty, brokerage, insurance, and handling can be identified separately, with estimated and final amounts distinguishable. That gives receiving a starting point and accounting a list of documents still expected. A charge that belongs only to this product should remain identifiable as such. A shared charge needs an allocation basis. Do not spread a line-specific duty across unrelated products simply because they traveled in the same shipment.

When a charge arrives in another currency, retain its original amount and the conversion basis used for the purchasing record. OrderPilot supports currency conversion on purchasing charges where needed; that does not make the order desk a multi-currency sales ledger. Keep the documented conversion consistent with the accounting treatment chosen for the business.

The landed-cost guide covers the wider cost inventory. Here, Priya keeps the source document and whether its amount is estimated visible before the goods arrive.

2. Record the vendor deposit as a vendor payment

The vendor deposit belongs to the purchase, separate from any customer deposit on the sale. Suppose Priya prepays 30% of the $2,000 product cost: $600. She records the vendor payment against the PO with the selected bank or card account and its reference. With QuickBooks connected and mapped, the vendor deposit is represented through the purchasing integration and applied to the bill later. Review the resulting record instead of entering the same prepayment again because the supplier's invoice arrives afterward.

The payment changes what remains owed to the vendor; it does not reduce the sofa's cost. A fully prepaid piece still has its full product cost and the inbound charges associated with obtaining it. Keep payment timing and product valuation separate.

3. Receive the goods before treating them as accepted stock

The receiving team records the date, accepted quantities, and rejected quantities with reasons. The line identity matters: “the blue sofa” is less useful than the selected fabric code, especially when the vendor has named that blue “Mist.” Rejected units do not receive a share of the accepted inventory's cost allocation. Review the charge basis over the units kept and handle vendor claims or credits through their proper records. A rejection should remain visible as an exception, rather than being hidden by entering the full purchase quantity as received.

Partial shipments create separate receipt events. Keep their dates and quantities accurate because those events support both inventory and the corresponding bills. Do not use the original PO total as a shortcut for goods that have not yet arrived.

4. Allocate the charges on a stated basis

OrderPilot supports allocation by value, quantity, or manual amounts. Weight allocation is unavailable because PO lines do not record unit weights; a weight- or cube-based calculation must be entered as manual amounts. Choose the basis for the actual charge instead of treating one method as right for every invoice.

Value can be a useful basis for a shared value-related charge. Quantity can fit a uniform per-unit charge. Freight driven by space can call for an externally calculated cube allocation. Retain that calculation so a colleague can explain why the sofa received a particular share.

The freight-allocation guide compares those decisions. Distinguish the commercial reasoning behind the allocation from the controls available in the app.

For the sample sofa, assume a 25% duty on the $2,000 base and $311.23 of shared inbound costs allocated to this unit. The duty is $500, and the resulting landed cost is $2,811.23. The assumed duty is solely part of this arithmetic exercise.

5. Replace estimates through a documented correction

A final freight invoice can change the result after the first receipt. Compare it with the estimate and apply the supported charge or receipt adjustment with a reason. Preserve the connection to the final invoice instead of silently changing a figure someone has already reconciled.

Suppose the sofa's final allocated freight is $100 higher than estimated. Its completed cost becomes $2,911.23. At an unchanged selling price, the extra cost reduces the amount remaining from the sale by $100. The customer's signed price does not change merely because the store's cost did.

Review which units remain in inventory and which have already been fulfilled. The correction and accounting records must reflect the actual stock position. Check the supported sync results so the adjustment is not recorded once through OrderPilot and again as an unrelated manual bill entry.

Treat unresolved estimates as work still open at period end. A cost is more useful when its remaining uncertainty is visible than when an estimated receipt is casually described as final.

6. Apply the business's costing policy

OrderPilot supports FIFO, LIFO, and moving weighted average costing. The method determines how recorded inventory costs are assigned as units leave; it does not tell warehouse staff which physical sofa to pick. Keep the accounting policy and physical identification understandable as separate decisions. Choose the method with your CPA, including whether it is permitted and appropriate for the business and jurisdiction. For U.S. tax treatment, 26 U.S.C. §472 includes requirements governing LIFO use and reporting consistency. The statute in force for this article's February 2025 setting is a reason to treat the choice as an accounting policy, not a way to improve a convenient report.

The FIFO, LIFO, and weighted-average guide explains the comparison. Make the decision before using the resulting margins for pricing or commission review, and document any later change through the accounting process.

OrderPilot keeps Shopify's cost-per-item value updated from its inventory costing. That field is not the full receipt and cost-layer history. Use the detailed purchasing records when tracing why one received unit differs from another.

7. Reconcile what reaches QuickBooks Online

The connection covers purchasing records: POs, a bill per receipt, vendor payments and deposits, receipt corrections, and stock-cost entries. Configure the account mappings before relying on the resulting ledger. The QuickBooks setup guide covers that preparation. Cost-of-goods entries follow supported fulfillment, including Shopify online and POS fulfillment, and restocked returns restore the related stock cost. Review the actual fulfillment or restock event when reconciling a movement. A money-only refund is not evidence that the sofa returned to inventory.

OrderPilot does not send sales invoices, reconcile the bank, or run payroll through this connection. Use the purchasing integration alongside the business's sales-accounting and reconciliation process, with ownership clear for every entry.

For Priya's purchase, the useful review is concrete: the receipt bill matches accepted goods and charges, the $600 prepayment is accounted for once, and the later cost correction is visible. Resolve failed syncs or unmatched records before treating the period as reconciled.

8. Read the margin with the correct cost

On a $5,200 selling price before sales tax, comparing only the $2,000 vendor cost leaves $3,200, or approximately 61.5% of sales. Comparing the $2,811.23 landed cost leaves $2,388.77, or approximately 45.9%. Those are different answers because they include different costs.

These figures are product-margin comparisons before other business expenses, not net profit. Delivery labor or overhead outside the included cost basis can still affect the business's final result. State the basis when comparing reports so colleagues do not mistake a different definition for an arithmetic error.

Shopify's profit-report guidance says its product profit reporting depends on cost recorded when the product was sold. Do not assume changing a current cost field rewrites every historical sales report. Reconcile the intended report against its own timing and cost basis.

Close the period with the outstanding work visible

The month-end check follows the same documents as the sofa:

1. Match received and rejected quantities to the actual shipment.
2. Identify estimated charges still awaiting final invoices.
3. Review allocation bases and documented corrections.
4. Reconcile vendor deposits, bills, and remaining amounts owed.
5. Check accounting sync results and fulfillment cost entries.
6. Compare margin using consistent revenue and cost definitions.

The result is a product cost someone can trace, from invoice through the receipt to the ledger. Continue with one sofa from showroom to living room for the surrounding sale and delivery record.

Sources

1. 26 U.S.C. §472, last-in, first-out inventories — U.S. Code, Cornell Legal Information Institute; LIFO requirements and reporting consistency.
2. Profit reports — Shopify Help Center; cost-at-sale basis and margin calculation.