An effective SOS Inventory and QuickBooks Online integration requires more than a live connection between the two systems. The business must decide where each transaction begins, which employees are responsible for it, and where corrections should be made and the understanding which system act as the source of record. Without those decisions, both platforms can appear to operate normally while inventory records and financial reporting gradually move out of alignment.
This article assumes the business has already integrated QuickBooks Online, cleaned key records, mapped workflows, and prepared the systems for implementation. The question here is narrower: once the integration is operating, which system should employees use for each transaction?
The most reliable principle is that every transaction should have one approved system of origin. It is the position of the author that all inventory transaction should originate in SOS Inventory however that may not be ideal for the workflow. Once the connection is established, your choices of where you can originate a transaction are limited. Mush of the inventory specific functionality is removed from Quickbooks and essentially outsourced to SOS Inventory. SOS will generally control activity that changes inventory quantities, availability, purchasing status, or fulfillment as well as give far greater insight into inventory characteristics . QuickBooks Online should generally control financial transactions, such as payments, banking, reconciliations, and general accounting activity. Transactions that affect both operations and accounting need a documented workflow rather than an informal department preference.
Table of Contents
One Transaction Should Have One System of Origin
Transaction ownership determines where a record is created, who is responsible for its accuracy, where later changes are made, and how it reaches the other system. It is an operating-control decision that is bigger than a software setting.
Problems develop when employees treat SOS Inventory and QuickBooks Online as interchangeable entry points. A salesperson may create an invoice in QuickBooks Online while the warehouse fulfills the same order in SOS Inventory. Accounts payable may enter a vendor bill without reference to the purchase order and receipt already recorded by operations. Each employee may believe the work is complete, but the business can end up with duplicate documents, unmatched quantities, timing differences, or financial records that do not reflect the physical movement of inventory.
During implementations, these problems are often described as synchronization failures. In many cases, the integration is transferring exactly what it was configured to transfer. A framework that I have always used is to question if something was a feature or a bug. Meaning that even though software is not giving you the result you want, if that is the way it is designed, it is a feature and not a bug! The underlying issue is that the company never established which system should create the transaction and that leads to different downstream process, avoiding established controls and not fully utilizing the full tracking capabilities and exception reporting.
A practical way to assign ownership is to identify what the transaction primarily controls. If it controls purchasing, physical inventory, order status, or fulfillment, SOS Inventory will usually be the appropriate origin. If it controls cash settlement, bank activity, or financial adjustments, QuickBooks Online will usually be the appropriate origin. The most important thing is that one persons is responsible for an entire process.
Where Items, Customers, and Vendors Should Be Created
Items, customers, and vendors are master records as opposed to transactions. Inconsistent ownership creates many of the same problems only worse because these errors are pushed automatically to the transactions. For example, if a customer name is has an an alternate address for “ship to” the a accounting department may decide another master record needs to be put into QuickBooks for a customer. Since this isn’t the department that is responsible for customers record maintenance, you could have duplication, and then any subsequent orders would be split between two customers. When users create similar records independently in both platforms, the result can be duplicates, failed synchronization, incorrect mappings, and fragmented reporting.
Inventory items will generally require their operational setup in SOS Inventory. That may include units of measure, purchasing and sales descriptions, locations, assemblies, reorder information, account mapping and lot or serial tracking. Often times the default settings are either inadequate or incorrect in the assignment of attributes to key features when items are sent from QuickBooks Online to SOS Inventory. The related chart-of-accounts structure, including inventory assets, revenue, expenses, and cost of goods sold, remains governed through QuickBooks Online.
Customer and vendor ownership depends more heavily on the company’s operating model. A business may decide that customers begin with the sales process or that vendors begin with accounting approval. Also, the company may have a third party integration like a CRM or bill pay application that would govern QuickBooks Online as the origination point for either vendors or customers. Either approach can work when it is consistent. Problems arise when sales, purchasing, and accounting can each create a new record without checking whether one already exists.
The company should define one standard creation path, one process for reviewing possible duplicates, and clear responsibility for correcting synchronization issues. This preserves cleaner customer and vendor histories and reduces the risk of transactions being posted to the wrong record.
Purchase Orders Should Usually Begin in SOS Inventory
Purchase orders are operational commitments. They affect expected inventory, supplier lead times, production planning, fulfillment expectations, and future cash requirements before the business receives a vendor bill.
For inventory purchases, purchase orders should generally originate in SOS Inventory. Purchasing and warehouse teams need a common record showing items ordered, quantities, expected dates, open commitments, partial receipts, and backorders. That record becomes the basis for receiving and later supports the review of vendor billing.
When an inventory purchase order begins only in QuickBooks Online, operations may lack the documentation needed to manage the incoming inventory. Employees then augment the order in SOS Inventory sometimes not having all the information, receive the goods without a connected purchase order, or rely on spreadsheets and email to track what remains open.
Consider a distributor ordering 500 units from a supplier. Accounting enters the purchase order in QuickBooks Online, but the warehouse works in SOS Inventory. Then either the PO was entered with the wrong vendor or didn’t sync properly. When 300 units arrive, the receiving team creates another purchasing record to process the shipment. The company now has two versions of the same commitment, and neither provides a complete view of the remaining 200 units.
Starting the purchase order in SOS Inventory keeps the operational commitment and receipt history connected. It also gives management a more reliable view of incoming inventory and purchasing obligations. Further complications may happen if if the company is creating a purchase orders so that they can convert it into a bill inside QuickBooks this will not increase companies in inventory in SOS Inventory, the system of record.
Receiving Inventory Belongs in SOS Inventory
Receiving changes the physical inventory record. It affects quantities on hand, availability, locations, lot or serial information, and the status of the purchase order. The receiving transaction should therefore be recorded in SOS Inventory.
This becomes especially important when shipments are partial, damaged, rejected, or delivered to different locations. QuickBooks Online may record the financial value of a purchase, but it does not replace the detailed operational record showing what physically arrived and where it was placed.
Businesses must also distinguish between receiving goods and recording the vendor’s financial obligation. Those events do not always occur at the same time. Goods may arrive before the bill, or the invoice may arrive before receiving has completed inspection. Recording the receipt in SOS Inventory allows operations to document the physical event. The accounts-payable process can then verify that the billed quantities and costs agree with what was ordered and accepted.
This separation supports stronger purchasing control. It also reduces the risk of paying for quantities the business did not receive or adding inventory to the financial records before operations can confirm it exists.
Vendor Bills Depend on the Nature of the Purchase
Vendor bills sit at the boundary between inventory operations and accounting. The correct process depends on whether the purchase affects inventory, the choice of payment method, and wheter there is a 3rd party bill payment system in the mix.
Inventory-related bills should generally follow the purchase-order and receiving workflow that began in SOS Inventory. Keeping the bill connected to those transactions preserves the relationship among quantities ordered, quantities received, vendor charges, inventory cost and inbound shipments. That connection is important when the business needs to investigate price differences, partial billing, landed freight cost, or quantity discrepancies.
Non-inventory bills are different. Rent, insurance, utilities, subscriptions, professional services, and similar expenses do not require an inventory transaction. They should normally be entered directly in QuickBooks Online because they affect accounts payable and the general ledger without changing inventory. Often there are inventory type items that are not necessarily tracked by the company that could be entered as cause a good soul directly into QuickBooks. However, this should be segregated from accounts that SOS inventory uses for posting. Reconciliation will be made far easier if balances of transactions are mutually exclusive when used for SOS Inventory posting or not.
The mistake is not choosing one system or the other, not intentionally deciding based on observed workflows. The largest mistake is allowing employees to choose based on convenience alone. When similar costs follow different entry paths, purchasing reports become incomplete and inventory-margin analysis becomes less reliable. The business should document which categories follow the inventory workflow and which remain entirely within accounting.
Sales Orders Should Always Begin in SOS Inventory
Sales orders represent operational demand. They affect inventory availability, commitments, backorders, purchasing, production, and fulfillment before the company recognizes a receivable. Until recently, this wasn’t an option, however, Intuit now has sales Holder capability in QuickBooks. It is important to note that these documents are not integrated with what SOS calls a sales order. Therefore, any reliance on sales orders inside QuickBooks do not translate into inventory visibility in SOS Inventory, the system of record. With that being the case, it is suggested that sales orders are only utilized within SOS Inventory to maximize the usefulness of the document in the inventory workflow. The system needs to reflect what the customer ordered, whether inventory is available, what quantities are committed, and whether the order can be fulfilled on the requested date.
When employees create inventory invoices directly in QuickBooks Online, accounting may show a receivable before operations have confirmed that the product is available or shipped. The inventory system may not reflect the customer commitment, leaving the same stock available for another order. That disconnect can contribute to stockouts, missed delivery commitments, and customer-service problems even though the accounting entry appears correct.
This is a common challenge when a company historically used QuickBooks Online for order entry. Continuing the old process feels efficient because employees know it well. However, bypassing SOS Inventory prevents the system from providing the inventory availability and fulfillment control the company implemented it to achieve.
Picking, Shipping, and Fulfillment Belong in SOS Inventory
Picking, packing and shipping track the various stages of fulfillment as well as when inventory physically leaves the business. These activities also establish which location supplied the order, what remained backordered, and which lot or serial numbers were used. These stages are exclusively available in SOS Inventory as part of inventory operations. The fulfillment process should reduce the correct quantities, update the order status, and create the appropriate downstream financial result through the approved integration workflow.
Timing and order of operation matter. If an invoice is created before the related fulfillment transaction is complete, revenue, cost of goods sold, and inventory depletion may be recorded in different periods. This can distort gross margin and increase month-end reconciliation effort. It can also produce customer statements that suggest an order has been completed when the warehouse still shows unshipped quantities.
The fastest way to produce an invoice is not always the most reliable process. Financial reporting should follow the underlying operational event rather than get ahead of it.
Inventory Invoices Should Follow the Fulfillment Workflow
For inventory sales, customer invoices should generally be generated from the approved SOS Inventory sales and fulfillment process where the Sales Order becomes a tracking document of the sales cycle. This creates a defensible connection between what the customer ordered, what the warehouse shipped, what inventory was relieved, and what accounting billed.
Creating an independent invoice in QuickBooks Online can break that connection. The company may record revenue without reducing inventory, produce a duplicate invoice when the SOS transaction later synchronizes, or create a customer balance that does not agree with fulfillment history. This may also result in keeping sales orders open by not showing actual invoiced activity. Returns and credits also become harder to resolve because the financial transaction is separated from the inventory event that supported it.
Some invoices should still originate directly in QuickBooks Online. Service-only billing, finance charges, consulting fees, and other transactions unrelated to physical inventory do not need to pass through an inventory workflow. The determining question is whether the invoice depends on an inventory movement. When it does, the billing process should follow that movement rather than bypass it.
Payments and Banking Activity Should Remain in QuickBooks Online
Customer payments, vendor payments, bank deposits, credit-card transactions, undeposited funds, and bank reconciliations should remain under QuickBooks Online control unless the company utilizes the SOS Pay feature in SOS Inventory.
These transactions settle receivables and payables and affect cash accounts. They do not change the physical quantity or location of inventory. Accounting should therefore retain responsibility for recording, applying, and reconciling them.
SOS Inventory may display synchronized balances or payment status, but QuickBooks Online should generally remain the financial system of record for payment activity. This separation also supports stronger internal control. Operational employees can process orders and inventory movements without receiving unnecessary access to banking, payment, and reconciliation functions.
The division is practical: SOS Inventory supports the inventory activity that creates the receivable or payable. QuickBooks Online manages the financial settlement.
A Practical Transaction Ownership Matrix
The following matrix is a useful starting point for many SOS Inventory and QuickBooks Online integrations:
| Record or transaction | Normal system of origin | Primary responsibility |
|---|---|---|
| Inventory items | SOS Inventory | Inventory or Operations |
| Customers and vendors | Approved company-specific process | Sales, Purchasing, or Accounting |
| Inventory purchase orders | SOS Inventory | Purchasing |
| Item receipts | SOS Inventory | Receiving or Warehouse |
| Inventory-related vendor bills | SOS Inventory purchasing workflow | Purchasing and Accounts Payable |
| Non-inventory vendor bills | QuickBooks Online | Accounts Payable |
| Vendor payments | QuickBooks Online / SOS Pay | Accounting |
| Inventory sales orders | SOS Inventory | Sales or Customer Service |
| Picking, shipping, and fulfillment | SOS Inventory | Warehouse or Operations |
| Inventory-related invoices | SOS Inventory fulfillment workflow | Sales and Accounting |
| Service-only invoices | QuickBooks Online | Accounting |
| Customer payments | QuickBooks Online | Accounting |
| Deposits and bank activity | QuickBooks Online | Accounting |
This matrix is not a universal configuration rule. Transaction volume, user roles, reporting requirements, and the company’s integration design may justify a different process. The important requirement is that each record has an intentionally defined origin, an accountable owner, and a consistent correction procedure.
The Bottom Line
An SOS Inventory and QuickBooks Online integration should not make both platforms interchangeable transaction-entry systems. That flexibility may appear convenient, but it weakens the connection between physical inventory activity and financial reporting.
SOS Inventory should generally control inventory purchase orders, receipts, sales orders, production, fulfillment, and the inventory-related billing workflows connected to those activities. QuickBooks Online should generally control payments, banking, reconciliations, non-inventory expenses, accounting structure, account balances and general accounting activity. Bills and invoices require the most judgment because they sit between operations and finance.
The best workflow is not necessarily the one that allows every employee to continue working exactly as before. It is the one that preserves inventory detail, prevents duplicate entry, establishes accountability, and produces financial records that leadership can trust.
Define a Reliable Transaction Workflow
Mariner Consulting Group helps manufacturers and distributors define transaction ownership, configure SOS Inventory and QuickBooks Online integration workflows, establish user responsibilities, and validate the resulting inventory and financial records.
As an independent implementation and consulting partner, Mariner evaluates how purchasing, receiving, sales, fulfillment, and accounting should work together before configuring the system. That operating design gives employees a clearer process and provides leadership with more reliable information for managing working capital, customer service, gross margins, and profitability.
This article was written by Kevin Lacey CPA/MBA, principle of Mariner Consulting Group, Inc. Too many small businesses are stuck with spreadsheets, the wrong software, or data without real insight, leading to reactive processes that drain cash. In my blog, I share practical inventory management strategies and financial insights to help business owners turn their operations into profit-driving systems.https://marinergrp.net/kevin-lacey-bio/
Leave a Reply