Connecting QuickBooks Online for purchasing and stock costs

Picture the morning after month-end: vendor invoices on the desk, freight for the container that just landed, and a factory prepayment nobody has matched. A note beside the sofa cost ends with a question mark. The furniture has arrived more confidently than its paperwork.

OrderPilot's QuickBooks Online connection covers the purchasing and stock-cost side of that work. Connect the right company, agree the mappings, and follow a small set of transactions through both records before relying on the flow. The connection carries information; the accounting team still owns its classification and reconciliation.

General information, not accounting or tax advice. Review the setup and costing choice with your accountant.

Know which transactions cross the connection

The connection is organized around purchases, receipts, vendor money, and the cost of goods. Keep that scope visible while planning the rest of the store's bookkeeping.

Sales invoices, customer payments and deposits, sales-tax reporting, bank reconciliation, and payroll stay in the store's separate bookkeeping arrangements. This is a purchasing connection, so plan those responsibilities alongside it. OrderPilot carries the vendor and stock-cost events through the supported flows.

Intuit explains that a bill records accounts payable. That helps explain the important distinction between receiving goods, recording the amount owed, and recording payment. Those are related events with different jobs in the books.

Connect the company before mapping the detail

Settings › Purchasing & accounting › QuickBooks is the starting point for the connection. Have the person responsible for the QuickBooks company present, and confirm the company identity before mapping accounts. Intuit lists purchase orders as a QuickBooks Online Plus or Advanced feature, so include the QuickBooks subscription in that setup check. Use an agreed set of sample transactions for the first review. A connection to the wrong company can look successful on screen, so the meaningful check is where the resulting record appears. Keep the sample purpose clear to everyone involved, especially if the exercise touches live accounting records.

Next, map the vendor identities. Similar trading names and older duplicate supplier records deserve attention before a PO is sent through the connection. The person reconciling the payable should be able to match the vendor on the acknowledgment, receipt, and bill without guessing which version of the name is current. Include this in the first-week setup plan as a separate accounting workstream. A showroom team can rehearse a quote while the accounting owner settles mappings; nobody needs to improvise account choices to keep the demonstration moving.

Use an account plan the accountant can maintain

A starting chart of accounts is a discussion aid, not an automatic mapping recipe. The following names describe useful distinctions to consider; they do not claim that OrderPilot creates every account or sends every cost to a separate line.

Map only the accounts supported by the actual setup controls, using the classification the accountant has chosen. A useful reporting distinction does not necessarily need another ledger account, and a suggested account name is not proof that a particular journal will post there.

The QuickBooks setup guide for furniture stores covers the broader structure. Keep the account list readable enough that the person handling a freight invoice can choose the agreed treatment without reverse-engineering the setup.

Choose the costing method before the first receipt

OrderPilot supports FIFO, LIFO, and moving weighted average for its stock-cost layers. Decide which method fits the business's accounting policy before receipts and fulfillments build a history around it. FIFO draws from the oldest cost layers first. LIFO draws from the latest layers first. Moving weighted average blends the cost of the units held as receipts change the pool. The choice affects how costs move out of stock and into cost of goods; it does not require the warehouse to move the physical furniture in that same sequence.

Tax and reporting treatment can constrain the choice, so treat the selection as an accounting decision. The costing-method comparison explains the trade-offs. In this setup exercise, the important outcome is an agreed method and a sample entry that the accounting team can explain.

Do not change methods merely to make one month's margin look more familiar. First trace the received costs, the fulfillment, and the mapping. A discrepancy can come from missing freight or a duplicate transaction without the costing method being the cause.

Follow a shipment that arrives in parts

A partial receipt creates its own bill through the connection. That lets the accounting records follow what was received instead of treating the whole PO as though it arrived together.

For a worked example, suppose a PO contains four chairs at an illustrative cost of $300 each, before freight and tax. Two arrive in the first shipment and two later. The receipt-related merchandise amounts are $600 and $600. Inspect each receipt and its corresponding bill, while keeping the PO's outstanding quantities clear between arrivals. If a chair is rejected, record the receiving result accurately before reviewing the accounting output. If a receipt is corrected, use the supported correction flow and retain the reason. A manual accounting edit on its own can leave the operational record telling a different story.

Check freight and other charges against the allocation chosen for the receipt. The true-cost walkthrough follows that connection from PO charges to the accounting record. The merchandise amount is only the beginning when a piece carries inbound freight, duty, or brokerage.

Match a factory prepayment to the later bills

OrderPilot's vendor-prepayment flow records money paid before goods arrive and supports applying that vendor deposit to bills later. Review the selected payment account and the vendor match before posting the sample. Say a factory receives $600 against the $1,200 chair purchase before shipment. The prepayment and the later bills must reconcile without counting the $600 as a second outgoing payment. Inspect the deposit record, its application, and what remains owed after each receipt according to the agreed flow.

Use vendor deposits and prepayments for the fuller treatment. This article describes the OrderPilot connection; it does not prescribe a general manual prepayment procedure for every QuickBooks company.

Give factory payments a reference the bookkeeper can match to the PO and bank evidence. “Deposit” alone is a label that travels poorly in a furniture business, where both customers and factories may have paid or received one.

Inspect cost of goods after the furniture leaves

The first fulfillment is a useful final test of the stock-cost path. Follow a sample received piece through delivery or collection, then inspect the supported cost-of-goods entry.

Check the same basic facts in both systems: the item and quantity, the recorded event, and the cost drawn under the agreed method. Where the store also sells through Shopify online or POS, include the supported native fulfillment route in the rehearsal rather than testing only an OrderPilot-created sale.

For a return, distinguish a money refund from goods actually restocked. The supported cost reversal follows the relevant inventory event; a refund on its own should not be assumed to put a sofa back in the warehouse. Use a representative restocked-return case when reviewing that part of the connection.

Review the first month with a short reconciliation list

The bookkeeper or accountant remains responsible for the books. The connection gives them linked purchasing information to reconcile, and a defined place to investigate when it differs from the vendor paperwork or bank record.

1. Confirm the company and vendor mappings on the first synchronized PO.
2. Match each sample receipt to its bill, including a partial receipt.
3. Follow one factory prepayment through its later application.
4. Verify the payment account and original payment reference.
5. Review freight and other landed-cost charges against the receipt.
6. Trace a fulfillment into cost of goods under the agreed method.
7. Inspect a supported correction or restocked return and its reversal.
8. Reconcile customer deposits through the store's separate customer-money process.

Write down the answer to each mismatch before expanding use of the same flow. Then continue with the complete furniture-store QuickBooks setup, using the tested purchasing path as its foundation.

Sources

1. Enter bills in QuickBooks Online — Intuit QuickBooks Help.