Finance Integration

QuickBooks Online,
connected to your
entire order flow.

Sales invoices, credit notes, purchase orders and sales receipts — all posted automatically from your ERP, IMS or eCommerce platform. Bidirectional sync keeps QBO and your operational systems aligned. Class and Location tracking applied at posting so your reporting stays intact without manual intervention.

QuickBooks Online connects to
By the numbers
2-way
Bidirectional sync
POST and GET · both directions covered
99.9%
Uptime SLA
Monitored 24/7 · alerting included
4types
Transaction coverage
Invoice · credit · PO · sales receipt
Live finance flow
Unleashed invoice despatched
INV-6041 · The Home Edit Ltd · £2,840.00
ERP
Invoice posted to QBO
Class: Wholesale · account codes applied · customer matched
POSTED
Shopify order paid · sales receipt created
Order #8841 · £74.00 · payment via Stripe mapped
RECEIPT
Purchase order raised in QBO
PO-0312 · Supplier Co · £4,200.00 · vendor matched
PO
Credit note posted to QBO
CRN-0088 · return matched to INV-5984 · Class preserved
CREDIT
What Supply Lens handles

Four transaction types.
One connected finance layer.

QuickBooks Online distinguishes between transaction types in ways that matter operationally. Invoices, sales receipts, credit notes and purchase orders each have their own QBO model, their own workflow and their own place in your chart of accounts. Supply Lens handles each correctly.

Sales invoices (bidirectional)
Supply Lens posts sales invoices into QBO when orders are despatched or approved in your ERP, IMS or eCommerce platform. The invoice lands in QBO with the correct customer record, line items, account codes, tax treatment and payment terms. The bidirectional element means QBO is also read — where your workflow requires it, the authorised or paid invoice status in QBO can be retrieved and reflected back in the source system, closing the loop without anyone manually checking QBO to confirm payment.
POST on despatch or approval Customer matching Account code mapping Tax handling Payment terms GET paid status back
Credit notes
Returns, cancellations, short-payments and adjustments generate credit notes in QBO automatically. Each credit note is matched to the original invoice, carries the same account code and Class or Location assignments, and is linked to the correct customer record. Where the credit results from a partial return, the credit note reflects the returned lines only — the unreturned portion of the original invoice is not affected. The finance record stays accurate without anyone logging into QBO to create adjustments manually.
Automated credit notes Original invoice matching Partial return handling Class and Location preserved Short-payment handling
Sales receipts (from paid orders)
In QBO, a Sales Receipt is the correct transaction type for an order that is paid at the point of purchase — a Shopify or WooCommerce DTC order, for example — rather than an invoice raised on payment terms. Supply Lens creates Sales Receipts rather than Invoices for paid eCommerce orders, using the correct QBO payment method (Stripe, PayPal, card on account) and the correct deposit account. This keeps your QBO accounts receivable clean — paid DTC orders do not appear as outstanding invoices that need to be manually marked as settled.
Paid order → Sales Receipt Payment method mapping Deposit account routing Clean AR — no phantom invoices Shopify and WooCommerce
Purchase orders
When a purchase order is raised in your ERP or IMS — for a supplier restock, an inbound goods receipt, or a wholesale purchase — Supply Lens creates the corresponding QBO purchase order against the correct vendor record. Vendor accounts are matched by name or code and created if they do not exist. Line items map to the correct expense or cost of goods accounts. Where the PO is subsequently received and a supplier bill raised, the bill can be matched to the open PO in QBO automatically, keeping your accounts payable current without manual reconciliation.
ERP PO → QBO purchase order Vendor matching and creation Account code mapping Bill matching on receipt AP reconciliation
Class and Location tracking
QBO's Class and Location dimensions let you report by channel, brand, department, region or cost centre without restructuring your chart of accounts. Supply Lens applies Class and Location values automatically at the point of transaction creation, derived from the source order data — the channel the order came from, the warehouse or entity that fulfilled it, the customer type, or any combination you define. Every invoice, sales receipt, credit note and purchase order arrives in QBO correctly tagged, so your P&L splits and segment reports are accurate without anyone manually editing transactions.
Class auto-assignment Location auto-assignment Channel-derived rules All transaction types tagged Configurable mapping rules
Customer and vendor sync
Every invoice, sales receipt and credit note needs a valid QBO customer record to post against. Supply Lens resolves the correct QBO customer from the source order — matching by name, email, account reference or any identifier you define — and creates the customer in QBO if they do not already exist. The same applies to vendors for purchase orders. Customer and vendor records are kept consistent between QBO and your ERP or IMS so financial records reference the same entities as your operational records.
Customer matching and creation Vendor matching and creation Match by name, email or ref Bidirectional customer sync ERP and QBO aligned
Where QBO integrations break

QBO is straightforward to connect.
The transaction model is where it gets specific.

QBO's API is well-documented and the OAuth flow is stable. The complexity is in using the right transaction type, applying Class and Location consistently, and keeping customer and vendor records aligned across systems.

Our Shopify orders are posting as Invoices in QBO but they're paid at checkout — now we have hundreds of open invoices to clear.

QBO makes an important distinction between an Invoice (money owed, payment pending) and a Sales Receipt (payment received at the time of sale). Shopify DTC orders that are paid at checkout should create Sales Receipts, not Invoices — otherwise QBO's accounts receivable fills with transactions that have already been paid and need manual settlement. Supply Lens applies the correct transaction type based on the order's payment status and the configured rule for each source channel, so paid orders and on-terms orders each land in QBO in the right form from the start.

Transactions in QBO have no Class assigned so our P&L report by channel is useless.

Class tracking in QBO is only useful if it is applied consistently and correctly at the point of every transaction. A batch of manually entered transactions with missing Class assignments corrupts the entire segment report. Supply Lens derives Class and Location values from the source order data — the channel, warehouse, customer type or any rule you define — and applies them automatically to every invoice, sales receipt, credit note and purchase order at the moment of creation. There is no manual editing of QBO transactions to add Class values after the fact.

Every WooCommerce customer is creating a new QBO customer record and we have thousands of duplicates.

QBO customer records accumulate quickly when every order creates a new entry without checking for an existing match. Supply Lens resolves the QBO customer before creating any transaction — matching by email address, company name, account reference or any combination you define. Guest checkout orders are handled with a configurable strategy: match to an existing account, create a named record, or route to a single generic guest customer. The customer resolution logic runs before every transaction, so duplicates do not accumulate regardless of order volume.

Credit notes in QBO are not linked to the original invoice and reconciliation is a mess.

In QBO, a credit note is most useful when it is linked to the specific invoice it relates to — this keeps the customer's balance accurate, makes reconciliation straightforward and keeps the audit trail clean. Supply Lens matches every credit note to the original invoice reference from the source system before posting to QBO, linking the two transactions correctly. Where the return is partial, the credit note covers only the returned lines and the original invoice balance is reduced accordingly, leaving the unreturned portion correctly outstanding.

Getting started

Most QBO integrations
are live in 2 days.

The scope call usually takes 30 minutes. The main configuration work is account code mapping, Class and Location rules, and agreeing the transaction type logic per source channel.

What you need to provide
  • QBO OAuth credentials (we use standard Intuit app authorisation)
  • Source system credentials — ERP, IMS or eCommerce platform
  • Account codes for sales, COGS, shipping, discounts and tax
  • Class and Location names and the rules for applying them
  • Transaction type preference per channel — Invoice vs Sales Receipt
  • Payment method mapping (Stripe, PayPal, card on account etc.)
  • Customer resolution strategy — match by email, name or account ref
How we get you live
1
Scope
Credentials, account codes, Class rules and transaction type decisions collected.
2
Configure
Connection built in staging. Account mapping, Class logic and customer resolution applied.
3
Test
Sample transactions posted to QBO sandbox. All types validated — invoices, receipts, credits, POs.
4
Go live
Production activated. Transaction flow monitored from day one.

Ongoing support includes account code updates, Class rule changes and QBO API version compatibility maintenance.

Ready to connect QuickBooks Online
to your order flow?

Invoices, sales receipts, credit notes and purchase orders — all four transaction types automated. 30-day trial available.