QUICKBOOKS INTEGRATION

QuickBooks Online Integration: Invoices Out, Payments Back

Open Pantry connects your wholesale operation to QuickBooks Online. Finalised orders are created as QuickBooks invoices against your own income accounts and tax codes — and because QuickBooks tells us when something changes, a payment recorded in QuickBooks flows back and closes the order off in Open Pantry without anyone reconciling it by hand.

  • Finalised orders become QuickBooks invoices automatically — or on your say-so
  • Payments recorded in QuickBooks flow back and settle the order in Open Pantry
  • Customers and items seeded in before go-live, so nothing duplicates

★★★★★  Trusted by 600+ suppliers across Australia

Open Pantry Accounting Sync connected to QuickBooks Online, listing wholesale invoices with per-invoice Synced, Awaiting sync and Sync failed statuses
Recommended by:M&J ChickensFood & Drink BusinessFoodService REPGoogle ★★★★★
Built for food & beverage wholesalersMeatSeafoodProduceDairySmallgoodsBakeryBeverages

The order is already done. Why is someone typing it into QuickBooks?

Every delivered order keyed a second time into QuickBooks by hand

Duplicate customers and duplicate items, because nothing was matched first

GST-free produce and taxable freight decided line by line, from memory

Payments taken in QuickBooks that nobody has reconciled back to the order

Connect QuickBooks Once, Then Let It Run

1

Connect your QuickBooks company

Authorise QuickBooks Online from Open Pantry and choose the company you invoice from. Read-only to start with — nothing is written to QuickBooks at this stage.

2

Preflight and choose the source of truth

The onboarding wizard checks the connection, then asks which system leads for customers, products, pricing and stock. Your answer governs everything that follows.

3

Seed your existing QuickBooks records

Your QuickBooks customers and items are pulled into a staging area and matched against Open Pantry first. You review the matches before a record is created on either side.

4

Invoices out, payments back

From then on, finalising an order creates its invoice in QuickBooks. When a payment is recorded against that invoice in QuickBooks, it flows back and marks the order paid in Open Pantry.

Start Your Free Trial

Free trial · Cancel anytime

Seeded from QuickBooks, staged before anything is written

If your customers and items already live in QuickBooks, that is where setup starts. Open Pantry imports them into a staging area, matches them against your Open Pantry records, and shows you what it matched and what it is unsure about. Nothing is created in QuickBooks, and nothing is overwritten in Open Pantry, until you say so.

  • QuickBooks customers and items imported into staging, not straight into your data
  • Preflight checks and an explicit source-of-truth choice before seeding runs
  • Confident matches linked automatically; the rest queued for you to review
  • Re-runnable later — connect first, tidy up over a week if you would rather
Open Pantry accounting onboarding wizard seeding QuickBooks Online customers, items, accounts and tax codes into staging and matching them before anything is created

A finalised order becomes a QuickBooks invoice

Finalise an order in Open Pantry and its invoice is created in QuickBooks Online — customer, line items, the quantities actually picked, delivery, income accounts and tax codes all carried across. QuickBooks has no draft invoice state, so it arrives ready; if you want a human gate first, leave automatic sending off and send each invoice from the order.

  • Invoices carry the quantities that were picked, not the quantities ordered
  • Automatic on finalise, or sent from the order when you are ready
  • Payments taken in Open Pantry are recorded against the QuickBooks invoice
  • Lines mapped to your income accounts and QuickBooks tax codes
A finalised Open Pantry wholesale order flowing into QuickBooks Online as an invoice with GST-free produce lines and a taxable delivery line

The one that talks back: payments and stock from QuickBooks

QuickBooks Online notifies Open Pantry when something changes on its side, which most accounting connections cannot do. A payment recorded against an invoice in QuickBooks marks that order paid in Open Pantry, and a change to an item’s quantity on hand updates the stock figure your team is picking against. Reconciliation stops being a weekly job.

  • Payments recorded in QuickBooks settle the matching Open Pantry order
  • Item quantity-on-hand changes flow back into Open Pantry stock
  • No spreadsheet reconciliation between the two systems
  • Chasing lists reflect what has actually been paid
Open Pantry matching QuickBooks Online customers and items by stored ID, item code, email and name, with per-invoice synced, awaiting and failed statuses

Your income accounts, your GST — mapped once

Sales post to the income account you choose from your own QuickBooks chart of accounts, and tax follows the QuickBooks tax codes you already use. That matters more in food than in most trades: fresh produce is GST-free, the freight line on the same invoice is not, and getting it wrong is a BAS problem months later.

  • Default income account, or a different one per product category
  • GST-free and taxable lines on the same invoice, treated correctly
  • Freight and card-processing fees mapped to their own accounts
  • Set at onboarding with your bookkeeper, then left alone
Open Pantry mapping sales, freight and card-fee income accounts plus GST-free and GST 10% tax codes to a wholesaler’s own QuickBooks Online chart of accounts
More product lines purchased
24%
Your always-on branded store and app put your full range in front of customers, so baskets grow.
Less order-processing cost
95%
AI order capture and auto-invoicing remove the manual keying between order and books.
Fewer picking errors
80%
Tablet pick & pack with FEFO lot and expiry tracking catches shorts and wrong items before they ship.

Real gains suppliers report after moving ordering, fulfilment and invoicing onto Open Pantry.

QuickBooks Is One of Eleven Ledgers We Connect To

M&J Chickens

Trusted by M&J Chickens

M&J Chickens use Open Pantry to move ordering out of calls and messages and into one digital workflow — giving customers a smooth ordering experience and giving the team fewer errors and less admin.

Alex Ortiz — Head of Sales

With Open Pantry, we launched our own fully branded ordering app — it’s helped us protect our customer base, move to digital ordering, and deliver a much better experience to our venues.

Alex Ortiz — Head of Sales
Alex Ortiz — Head of Sales
M&J Chickens

A CSV export is not an integration.

Exporting a file and importing it into QuickBooks moves the typing around; it does not remove it. Nothing is matched, so customers and items breed. Nothing is mapped, so GST is decided by whoever is doing the import that day. And nothing comes back — a payment recorded in QuickBooks stays invisible to the people chasing it. A sync built into the system that raised the invoice knows what was picked, who it was for and which account it belongs in, and it hears back when the money lands.

A CSV export and re-key into QuickBooks compared with Open Pantry’s built-in QuickBooks Online sync, showing duplicates and manual GST versus matched records and payments flowing back

Questions Suppliers Ask About the QuickBooks Integration

Does Open Pantry integrate with QuickBooks Online?
Yes. Open Pantry connects to your QuickBooks Online company. Finalised wholesale orders are created as QuickBooks invoices with the customer, line items, income accounts and tax codes already resolved, so nobody re-types a sale that has already been processed operationally.
Does anything come back from QuickBooks, or is it one way?
Things come back. QuickBooks Online notifies Open Pantry when an invoice is paid, so the order is marked paid without anyone reconciling it, and changes to an item’s quantity on hand flow back into your Open Pantry stock figure. This is the most two-way of our accounting connections.
Do invoices arrive as drafts in QuickBooks?
No — QuickBooks Online does not have a draft invoice state, so an invoice arrives created. If you want a review step before that happens, leave automatic sending switched off and push each invoice from the order when you are ready.
Do invoices go across automatically, or do I send them?
Your choice, and it is a single toggle. With automatic sending on, finalising an order creates its invoice in QuickBooks straight away. With it off, you send invoices yourself from the order menu or from Accounting → Orders.
Can Open Pantry import the customers and items I already have in QuickBooks?
Yes — that is how setup starts. The onboarding wizard pulls your QuickBooks customers and items into a staging area, matches them against Open Pantry, and shows you the result. Nothing is created in QuickBooks and nothing is overwritten in Open Pantry until you confirm.
Will it create duplicate customers or items in QuickBooks?
It is built specifically not to. Open Pantry looks for the stored QuickBooks record first, then falls back to item code, email and exact name. A new customer or item is only created when there is genuinely nothing to match against, and the seeding step exists to make that rare.
Which income account do invoices post to?
One you choose from your own QuickBooks chart of accounts. You can also send a particular product or category to a different income account, and map freight and card-processing fees to their own accounts.
How is GST handled on food lines?
Lines are mapped to the QuickBooks tax codes your company already uses, so GST-free produce and taxable lines such as freight can sit on the same invoice and each carry the right treatment. It is set up once during onboarding, ideally with your bookkeeper in the room.
Can credit notes go to QuickBooks as well?
A credit raised in Open Pantry can be sent to QuickBooks as a credit memo where your setup supports it — worth confirming with us during onboarding rather than assuming, because credit handling differs between accounting providers. Payments and invoices are the parts that are switched on for everyone.
Which plan includes the QuickBooks integration?
Accounting integrations are part of the Pro plan; ERP integrations sit on Enterprise. The pricing page sets out exactly what is included in each.

Connect QuickBooks Once. Stop Re-keying Invoices.

Join 600+ Australian suppliers running their ordering, fulfilment and invoicing on Open Pantry.

Setup done for you · Cancel anytime · Your data stays yours

See plans & pricing