QuickBooks Online for a furniture store: the setup that works

The bookkeeper’s question arrives again: what is this payment to the freight forwarder, and which furniture does it belong to? The PO identifies the pieces. The bank identifies the money. Somewhere between them, someone must establish what the goods cost.

A useful QuickBooks Online setup gives each event a defined home before it reaches the bank feed. Customer deposits, factory prepayments, receipt bills, and inventory costs should be distinguishable and reconcilable. That produces a margin the owner can explain and a deposit balance the team can trace back to open orders.

General information, not tax advice.

Decide what each system owns

Start with a posting map that identifies the source of every transaction. OrderPilot supplies purchasing and stock-cost records. Your Shopify sales-accounting process or bookkeeper supplies sales, customer deposits, and the related sales adjustments. QuickBooks holds the financial ledger and bank reconciliation.

Write down which process creates the initial entry and which one matches or reviews it. A bank-feed suggestion should not create a second expense for a payment already recorded against a vendor bill. The same principle applies when a sales connector and a separate inventory process can both create cost of goods.

Keep quantities and financial balances aligned without maintaining competing inventory counts through the connection. OrderPilot and Shopify manage the operational units; the QuickBooks purchasing connection posts their financial effects. A number shown on a purchasing document is not a second stock ledger.

Use the connection guide for the setup steps. This article concerns the accounting design: where entries go, when they arise, and what the month-end review needs to prove.

Build a chart of accounts around the order’s stages

The chart of accounts should separate money owed to customers from money advanced to vendors. It should also distinguish goods held as assets from costs recognized when those goods are sold.

Intuit’s US chart-of-accounts guide explains the account structure behind the financial statements. The following furniture-store design is a working proposal to review with your CPA, including the inventory method, capitalization policy, and tax treatment before mapping it.

The optional accounts need a defined posting method. Adding Goods in Transit does not automatically establish when the store owns a shipment. Adding Landed Cost Accrual does not make every estimated freight charge a correctly posted accrual. The bookkeeper needs the agreed recognition rules and supporting documents.

Keep account names understandable to the people using them. A short description beneath Vendor Deposits can say what belongs there and what clears it. That prevents a factory advance from becoming an expense simply because the person coding the bank transaction has not seen the PO.

Use cost-of-goods detail without duplicating costs

Cost-of-goods subaccounts can help explain product cost, inbound freight, duty and customs, brokerage, inventory adjustments, and shrink or damage. Whether to use those separate ledger accounts depends on the reporting your team will maintain consistently.

Operational landed-cost detail can supply the breakdown even when the ledger posts a combined landed amount to one mapped cost-of-goods account. OrderPilot’s purchasing-charge detail should not be mistaken for a promise that every component posts to a separate COGS subaccount automatically.

Document the difference between acquiring furniture and delivering it to the customer. A freight-forwarder bill for bringing stock into the store and an outbound white-glove delivery charge serve different purposes. An account called Shipping is too broad if it mixes both without explanation.

Also distinguish an inventory write-down from a vendor credit. Damaged furniture may produce an adjustment to its carrying value, a claim against the vendor, a repair expense, or several related entries. The supporting record should explain what happened rather than treating every damage report as an automatic credit.

Put freight and duty into the correct cost calculation

For inventory accounted for at cost, acquisition charges generally belong with the goods. The IRS’s Publication 538, Cost Method section, explains that purchased merchandise cost includes invoice price less appropriate discounts plus transportation and other acquisition charges. Tax accounting methods and exceptions still need the policy review described above.

OrderPilot capitalizes allocated landed charges into the goods’ account on new QuickBooks bills. The goods’ mapping therefore matters: the account used for stock or for a customer order determines where the receipt’s value lands.

Keep the purchasing charge records detailed even when the accounting entry is combined. Freight, duty, and brokerage should remain identifiable, with the allocation method and whether each amount is estimated or final. That is how a bookkeeper can explain the inventory value without opening every email.

Avoid entering the same forwarder invoice once through receipt charges and again as an unrelated bank-feed expense. Match the recorded financial event and reconcile any difference. The PO-charges-to-QuickBooks guide follows that cost trail.

Trace one order through the proposed accounts

Use this worked example to test the design. A sofa sells for $6,000. The customer pays a $3,000 deposit. The factory price is $3,000, with a $900 advance, and the assumed acquisition charges total $600. The example excludes sales tax and other selling expenses and uses an inventory-asset treatment until sale recognition.

The table describes the intended end-to-end accounting result, not a claim that one app sends every line. The receipt, payment, and sales processes have different responsibilities. The bookkeeper verifies that their combined entries produce the intended balances.

If the store receives a partial shipment, recognize and reconcile the actual receipt rather than the full PO automatically. If freight is still estimated, retain that state in the cost review and follow the posting basis selected for the connection.

The customer’s deposit should be traceable from the order to the ledger until it is applied, refunded, or otherwise resolved under the accounting policy. The customer-deposit guide develops that reconciliation.

Map the QuickBooks company and purchasing accounts

OrderPilot’s connection lives in Settings › Purchasing & accounting › QuickBooks. Connect the intended QuickBooks Online company and review the account mappings before enabling posting.

The mappings cover Accounts payable, Goods bought for stock, Goods bought for a customer order, Freight and shipping, Duty and brokerage, Tariffs, Other charges, and Purchase order tax. Give special attention to the two goods accounts. Stock and customer-committed goods may need distinct reporting while still following a consistent recognition policy. A special-order goods account mapped directly to expense has different consequences from one mapped to an asset. Cost-of-goods posting must not expense the same purchase again when the units ship. Review a complete sample transaction through the chosen mapping before allowing volume through it.

Match each vendor to the correct QuickBooks vendor. OrderPilot can find names, create a vendor, or use the vendor you select. Review similar names and existing duplicates before approving the match. A maker’s trading name and legal billing name can differ without representing two businesses. Keep a record of the approved mapping and who owns future changes. A change in account design should be reviewed with existing balances and posting history, rather than made halfway through reconciling the month.

Let receipt bills describe what arrived

A sent OrderPilot PO becomes a QuickBooks purchase order. The PO describes the commitment; it does not itself create a posting to the general ledger.

Each receipt creates a bill tied to that receipt and linked back to the PO’s lines. The bill uses the received quantities and costs, with a receipt-specific document reference. A partial receipt therefore represents the portion received, leaving the remaining purchase to its later receipt. Read the receipt’s quantities and cost basis before treating a synced bill as finished accounting. The connection can transmit the record accurately while the source still needs a missing freight invoice or a receiving correction. A synced status answers whether the document reached QuickBooks; the underlying record answers whether the amount is settled.

For shared purchasing charges, use the allocated share belonging to each PO or receipt. The same forwarder invoice should not be counted in full against every sofa shipment it covered. Keep its allocation detail available for the month-end review.

Choose how vendor payments reach the books

Vendor-payment posting stays off until it is enabled and mapped. Choose the bank account, any credit-card account used, the Vendor Deposits account, and the payment mode that fits the workflow.

The connection supports recording payments as deposits or as bill payments. Prepayments belong with the vendor and purchase until they can be applied to the bill. In bill-payment mode, a payment that precedes the bill still needs a prepayment treatment rather than disappearing from the bank record while waiting. Intuit’s QuickBooks Online supplier-prepayment article shows tracking a prepayment and later applying it to a bill. That page is for the UK edition; its VAT steps are not US sales-tax instructions.

Review unapplied vendor deposits by PO and age. An amount can remain open because goods are still coming, because a bill has not been matched, or because a cancellation needs a refund. Those situations require different actions even though they occupy the same asset account.

Use the vendor-deposit guide when establishing that review. The useful result is a balance explained by specific purchases and a named person chasing any unresolved amount.

Turn on cost-of-goods posting with a clear cutoff

Cost-of-goods posting is also off until enabled. OrderPilot can post journal entries daily or per order, using the selected costing method and the posting basis configured for current costs or final costs. The operational trigger is units shipping or being fulfilled, with supported changes and reversals adjusting the recorded cost. Your accounting close should align that trigger with the store’s revenue-recognition policy, especially when shipment and customer delivery fall in different periods.

Choose one process to create those inventory and COGS effects. If another connector is already posting inventory-item cost, enabling another cost process can duplicate the result. The sample transaction should prove that inventory is relieved once and cost is recognized once.

Shopify’s inventory migration documentation describes a single static Cost per item field. That scalar is not a historical cost-layer ledger. OrderPilot’s chosen costing method and allocations provide the basis for its cost entries.

For reconciliation, compare like with like. A current Shopify cost multiplied by units may differ from FIFO or other historical layers. Explain the difference using the relevant costing records rather than forcing the books to match a number calculated on another basis.

Handle late corrections as their own events

A received cost can change after the first bill reaches QuickBooks. The correction route depends on the bill and purchase state.

While the PO remains open and its bill unpaid, a later cost or receipt adjustment can update the bill. Once the PO is finalized, the bill is paid, or a correction already exists, the difference is posted as a vendor credit for a reduction or a supplemental bill for an increase.

Suppose the example’s acquisition charges rise from $600 to $700 after the bill is paid. The extra $100 needs a supported additional accounting event. It should not be hidden by overwriting a paid document or entered independently in two places.

Keep the reason and source invoice with the correction. Review whether the units are still held or have already shipped, because the inventory and cost-of-goods consequences depend on their state and the posting settings. The connection’s correction history gives the bookkeeper a trail to reconcile.

A vendor credit is also different from a refund reaching the bank. The credit reduces what the vendor owes or what the store must pay; the cash event needs its own record when it occurs.

Choose showroom reporting dimensions deliberately

A class or location can help compare showrooms when the team will assign it consistently. You do not need both simply because both controls exist.

Intuit describes classes as a way to report by business segment and points businesses with multiple sites toward location tracking. Class tracking is available in QuickBooks Online Plus and Advanced. Choose the dimension that matches the owner’s reporting question and the company’s QuickBooks subscription.

Define whether a purchase belongs to the selling showroom, the receiving warehouse, or a central operation. A shared delivery warehouse should not accidentally inherit every sale simply because the goods passed through it.

The OrderPilot account mappings described here are not a promise of automatic class or location assignment on every QuickBooks document. Include dimension completeness in the bookkeeper’s review and establish how shared costs will be allocated.

A simple structure that is used consistently is easier to trust than a detailed one with missing tags. The showroom already has enough competing interpretations of “warm white.”

Close the month by reconciling the handoffs

The monthly close should prove the balances across systems, not merely confirm that sync jobs completed. Use a fixed checklist with an owner for each unresolved difference.

1. Customer deposits: reconcile the sales-process ledger balance to the remaining deposits on open customer orders. Investigate refunds, applied deposits, and uncompleted orders.
2. Vendor deposits: match unapplied balances to POs, expected receipts, credits, and refunds. Separate genuine prepayments from unmatched bills.
3. Receipt bills: compare accepted quantities and costs with the purchasing records and vendor statements. Review failed or incomplete syncs.
4. Landed costs: replace or reconcile estimates with final bills under the accounting policy. Review the cost-accrual account where the store uses one.
5. Cost of goods: trace posted entries to the units shipped or fulfilled, supported reversals, and the chosen period cutoff.
6. Inventory: reconcile the asset balance to owned units and their cost records, including goods in transit or customer-committed units in the defined scope.
7. Bank and cards: match payments already recorded, then investigate unmatched transactions before creating anything additional.
8. Corrections: explain vendor credits, supplemental bills, adjustments, and unresolved claims.

Keep the exceptions visible after the close. “Waiting for forwarder invoice” should include the shipment and responsible colleague. An unexplained balance is easier to resolve while the receiving team still remembers the container.

Avoid the entries that obscure the order

Do not treat a customer deposit as a completed sale merely because the cash arrived. Do not treat a factory advance as furniture already consumed. Do not code every inbound charge to a generic shipping expense without considering the adopted inventory policy.

Avoid manually recreating a synced receipt bill because it is taking time to appear. Check the PO’s QuickBooks status and resolve the recorded error or retry through the supported flow. A duplicate can make the supplier statement look wrong even when both systems are working as instructed.

OrderPilot supports QuickBooks Online, rather than QuickBooks Desktop. Its connection covers purchasing, vendor payments, corrections, and stock costs; sales invoices, customer deposits, payroll, and bank reconciliation stay with their assigned accounting processes. With that division clear, the connected PO and receipt records give the bookkeeper a useful explanation for the numbers.

Bring the reconciled results into the owner’s dashboard. The owner should be able to move from a margin or deposit balance to the orders behind it, without asking the bookkeeper to reconstruct the sale each month.

Sources

1. Publication 538: Accounting Periods and Methods, Cost Method — Internal Revenue Service, January 2022 edition; US inventory-cost guidance.
2. Chart of accounts in QuickBooks Online — Intuit, US QuickBooks Online.
3. Record supplier prepayments for products or services — Intuit, UK QuickBooks Online; prepayment method only.
4. Migrating from Stocky to Shopify inventory management — Shopify Help Center.
5. Get started with class tracking — Intuit, US QuickBooks Online.