# QuickBooks Reporting for Ecommerce: Read QuickBooks Online Beside Your Shopify Sales

QuickBooks reporting for ecommerce: Luca AI reads your QuickBooks Online ledger read-only and shows margin by channel, working capital and cash beside Shopify and Amazon, without posting anything to QuickBooks.

- Applies to: Brands that keep their books in QuickBooks Online and connect it self-serve, read-only
- Status: Live
- Verified: 2026-11-20
- Canonical page: https://ask-luca.com/product-docs/integrations/accounting/quickbooks

QuickBooks reporting for an ecommerce brand usually stops at the ledger: unless every channel's fees and ad spend are coded separately, margin by channel ends up in a spreadsheet. Luca AI reads your QuickBooks Online books read-only and sets them beside your Shopify and Amazon sales, so you see margin by channel, working capital and cash in one place, while QuickBooks stays exactly as your accountant left it. Luca never posts orders, fees or payouts into QuickBooks, and it is not a sync app.

## At a glance {#at-a-glance}

| | |
|---|---|
| **What it does** | Sets your QuickBooks Online ledger beside Shopify and Amazon sales and ad spend, so you can read margin by channel and cash |
| **What it reads** | The full ledger: profit and loss, balance sheet, cash flow and trial balance, with invoices, bills, payments, bank lines and journals |
| **What it writes** | Nothing. No sales, fees, payouts, journals or reconciliations reach your QuickBooks company |
| **How you connect** | Yourself, from **Sources** › **Finance** › **Connect** on the QuickBooks card, then approve read-only access on QuickBooks' own screen |
| **How often it refreshes** | Every night, with the time of the last read shown on the QuickBooks card |
| **What it unlocks** | Gross, operating and net margin, ROCE, debtor, creditor and inventory days, the cash-conversion cycle, free cash flow and burn multiple |
| **Where you read it** | **Numbers**, on the **Profit** and **Cash** tabs, and in chat |
| **What never changes** | Your QuickBooks reports and your chart of accounts. Your accountant's close works the way it always has |

## Connect QuickBooks Online {#connect-quickbooks}

Connecting is the first job, and you can do it without waiting for Luca's team. You need admin or owner access to the QuickBooks Online company you connect.

1. **Open Sources.** Click **Sources** in the left rail.
2. **Expand Finance.** The **Finance** group holds the QuickBooks and Xero cards.
3. **Click Connect on the QuickBooks card.** Luca hands you over to QuickBooks to sign in.
4. **Approve read-only access on QuickBooks' screen.** QuickBooks asks you to confirm the connection with your own login.
5. **Return to Luca.** QuickBooks sends you back, and the card shows **Connected** with the time of the last sync.

From the next overnight refresh, answers in chat can draw on QuickBooks together with everything else you have connected. During onboarding, Luca's team maps your brand's data. The rest of the first day, from Shopify to inviting your team, is in [how to set up Luca](https://ask-luca.com/product-docs/getting-started/set-up-luca).

## What Luca reads from QuickBooks Online {#what-it-is}

The QuickBooks connection is a read-only link between your QuickBooks Online company and Luca. QuickBooks keeps the record of what you earned and what you owe. Luca joins that record to what sold in your store and on Amazon, in one private warehouse for your brand.

Luca reads QuickBooks Online with the same detail as Xero:

| Area | What Luca reads |
|---|---|
| **Statements** | Profit and loss, balance sheet, cash flow and trial balance, month by month and over time |
| **Sales side** | Invoices, payments, credit notes, customers and aged receivables |
| **Costs side** | Bills, suppliers and aged payables |
| **Bank** | Bank transactions and journals |

The four usual ways brands report on their books, from the ledger's own reports to a read-only layer, work the same way in QuickBooks as in Xero. They are laid out in [how ledger reporting gets done for an ecommerce brand](https://ask-luca.com/product-docs/integrations/accounting/xero#how-xero-reporting-works).

### What you see {#what-you-see}

QuickBooks sits in the **Finance** group of the **Sources** screen, next to Xero. Once connected, the card reads **Ledger, invoice, P&L** and shows when Luca last read your books.

![The Finance group on the Sources screen, with the QuickBooks card marked Connected, labelled Ledger, invoice, P&L, showing its last sync time, and the Xero card faded beside it with a Connect button.](https://ask-luca.com/product-docs/images/integrations/quickbooks-finance-sources.webp)

*Check the last sync time before a month-end review, so you know the ledger figures come from last night's read. The figures and dates are sample data for a demo brand.*

### What it is not {#what-it-is-not}

It is not a sync app that posts Shopify orders, Amazon fees or payouts into QuickBooks. It is not bookkeeping software either. Luca reads from every connected system and writes to none of them, and the only thing it posts anywhere is its own answers, into your Slack if you add it. The full list of what it can never change is in [Luca's read-only access](https://ask-luca.com/product-docs/platform/read-only-access).

## Read QuickBooks beside Shopify and Amazon {#read-beside-shopify}

Take a founder who still does the books at a US home-fragrance brand. Candles, diffusers and refills sell on Shopify and on Amazon, and she closes each month in QuickBooks Online. Her question every month is simple: which channel actually made money once Amazon's fees came off?

### Margin by channel, with Amazon fees taken off {#margin-by-channel}

The **Profit** tab shows a monthly profit and loss, refreshed every night. It splits contribution margin into layers: CM1 after product costs, CM2 after fulfilment and fees, and CM3 after ad spend. Product costs come from the bills in QuickBooks. Amazon referral and FBA fees and settlements come from Seller Central, and payment fees from Shopify payouts.

Below the profit and loss, a **Profit by product** card splits every product's CM3 by where it sold, Shopify or Amazon. That is the view for the founder's question. A diffuser that looks healthy overall can lose money on Amazon once fees and returns come off.

![The bottom of the monthly profit and loss on the Profit tab, with payment and marketplace fees, CM2, ad spend, CM3 and operating profit, above a Profit by product table with Shopify CM3 and Amazon CM3 columns.](https://ask-luca.com/product-docs/images/integrations/quickbooks-profit-by-channel.webp)

*The Shopify CM3 and Amazon CM3 columns show which channel each product earns on after fees and ads. The image shows Luca's demo skincare brand in pounds, not the home-fragrance brand in the example; the figures are sample data.*

Marketplace fees are why channel margin matters. Shopify's guide to selling on Amazon tells sellers to [subtract the product cost and Amazon's referral fee](https://www.shopify.com/blog/sell-on-amazon) before committing to a product. Luca does that subtraction every night, with costs from your ledger. For the margin layers in more depth, read [contribution margin by order and channel](https://ask-luca.com/product-docs/profit/contribution-margin). If you want each product ranked, open [product profitability analysis](https://ask-luca.com/product-docs/use-cases/product-profitability-analysis).

### Working capital and the cash-conversion cycle {#working-capital}

The **Cash** tab shows a cash forecast, a **Runway** card and a **Working capital** card. With QuickBooks connected, Luca works out stock, debtor and creditor days from your books. Together they give the cash-conversion cycle: how long cash sits between paying suppliers and getting paid.

![The Working capital card on the Cash tab, listing stock days, wholesale debtor days and creditor days now and 90 days ago, with the cash-conversion cycle highlighted and a note on stock bought ahead of Black Friday.](https://ask-luca.com/product-docs/images/integrations/quickbooks-working-capital.webp)

*The cycle lengthens when you buy stock ahead of a peak, and this card shows by how many days. The figures are sample data for a demo brand.*

Shopify's explainer gives the formula: the [cash-conversion cycle adds inventory days to sales days and takes off payable days](https://www.shopify.com/blog/cash-conversion-cycle). For a candle brand that buys wax, glass and holiday stock in early autumn, inventory days climb first. Working capital itself is [current assets minus current liabilities](https://www.shopify.com/blog/operating-cash-flow), which is why it needs the balance sheet and not just the store. If the founder is weighing that stock buy against the bank balance, read [months of cash left from your forecast](https://ask-luca.com/product-docs/finance/runway).

### Ask in chat {#ask-in-chat}

You can ask about QuickBooks and your sales channels in one question. Luca pulls from every relevant system into a single answer, so one reply can combine ad spend, store orders and the accounting ledger. Read more in [answers across Shopify, ads and your books](https://ask-luca.com/product-docs/chat/cross-source-answers).

> **Try asking Luca:** "What was Amazon's CM3 in November after referral and FBA fees, using product costs from QuickBooks?" or "How much longer is our cash-conversion cycle now than before the holiday stock buy?"

## Check Luca against QuickBooks {#check-against-quickbooks}

Reporting beside QuickBooks only helps if the two agree closely enough to trust. Luca checks this itself, every day, and shows you where a gap comes from.

### The daily data checks {#daily-checks}

Every source refreshes once a day, overnight. Luca's daily data-quality checks then compare its data with Shopify, Amazon and QuickBooks to catch gaps and duplicates. The checks run for every brand, so you don't switch them on.

### Sales to payouts to ledger {#sales-to-payouts-to-ledger}

Luca also matches sales to payments, payouts and the accounting ledger, following your own order of sources of truth. It follows each sales source from orders, through fees and payouts, to the amount booked in QuickBooks. Luca's team sets this match up with each client during onboarding.

### The two usual causes of a gap {#causes-of-a-gap}

- **A payout not yet booked.** An Amazon settlement or Shopify payout has reached the bank but not the ledger. Book it in QuickBooks.
- **A bill without a product code.** Part of a supplier's cost can't be assigned to products, so product margin drifts from the ledger. Add the product code to the bill in QuickBooks.

In both cases you fix the record in QuickBooks, because Luca never edits it. The next overnight refresh reads the corrected entry. For how the same definitions carry into board packs, read about [one set of KPI definitions](https://ask-luca.com/product-docs/use-cases/kpi-reporting).

## A worked example: November margin by channel {#worked-example}

This is an illustrative calculation with sample figures, not a Luca output. It follows the home-fragrance brand's November, with Shopify and Amazon side by side. To keep it short, fulfilment and shipping are left out. The step-by-step month-end done by hand is the same as on the Xero page, in [the manual method](https://ask-luca.com/product-docs/integrations/accounting/xero#manual-method).

| Line | Source | Shopify | Amazon | Both channels |
|---|---|---|---|---|
| Net revenue | Shopify and Seller Central | $120,000 | $60,000 | $180,000 |
| Product costs | QuickBooks bills | −$42,000 | −$21,000 | −$63,000 |
| CM1 after product costs | | $78,000 (65%) | $39,000 (65%) | $117,000 (65%) |
| Fees | Shopify payouts; Amazon referral and FBA fees | −$3,600 | −$18,000 | −$21,600 |
| CM2 after fees | | $74,400 | $21,000 | $95,400 |
| Ad spend | Meta, Google and Amazon Ads | −$30,000 | −$6,000 | −$36,000 |
| CM3 after ads | | $44,400 (37%) | $15,000 (25%) | $59,400 (33%) |

| Check | Arithmetic | Result |
|---|---|---|
| Shopify CM3 margin | $44,400 ÷ $120,000 | 37% |
| Amazon CM3 margin | $15,000 ÷ $60,000 | 25% |
| Gap to QuickBooks, if QuickBooks shows November revenue of $176,500 | $180,000 − $176,500 | $3,500 |

Both channels keep 65% after product costs, so the ledger alone makes them look equal. Amazon's fees take 30% of its revenue, and CM3 ends 12 points lower than Shopify's. That is the figure to weigh before moving more stock or ad spend to Amazon.

The gap of 3,500 dollars to QuickBooks is the next thing to check. A late Amazon settlement is the likeliest cause, so look for an unbooked payout before you close the month.

## How QuickBooks works with the rest of Luca {#works-with}

### Shopify {#with-shopify}

Shopify is the record of what sold: orders, refunds, discounts, payouts and fees. QuickBooks holds what was earned and owed. Together they give margin by product and month. The [Shopify connection](https://ask-luca.com/product-docs/integrations/commerce/shopify) brings your store's order history.

### Amazon Seller Central {#with-amazon}

Amazon sales, referral and FBA fees and settlements sit beside Shopify in the same profit and loss. Each settlement can then be matched to its line in QuickBooks. The [Amazon Seller Central connection](https://ask-luca.com/product-docs/integrations/marketplaces/amazon-seller-central) covers what it reads, and [Shopify and Amazon in one view](https://ask-luca.com/product-docs/use-cases/sell-on-shopify-and-amazon) shows the combined picture.

### Stripe {#with-stripe}

Stripe adds charges, processing fees, refunds and payouts, so each Stripe payout can be matched to its deposit in QuickBooks.

If your books are in Xero instead, the Xero connection works the same way and has its own page in this section.

## How Luca AI compares for QuickBooks reporting for ecommerce {#compare}

Luca reads the whole QuickBooks Online ledger into a warehouse it runs for your brand, turns it into working-capital days and matches store payouts to the ledger. No other platform here documents all three.

QuickBooks reporting for ecommerce, from each platform's public documentation:

| Platform | Full QuickBooks ledger read, with no warehouse for you to run | Working-capital days from the books | Store payouts matched to the QuickBooks ledger |
|---|---|---|---|
| **Luca AI** | Yes | Yes | Yes |
| **Saras Analytics** | Partly ([Daton loads it into a warehouse you configure](https://help.sarasanalytics.com/en_US/quickbooks-v2/how-to-integrate-quickbooks-v2-with-daton)) | Not in docs | Not in docs |
| **Lifetimely** | Partly ([costs mapped to four categories](https://help.useamp.com/article/1115-getting-started-with-quickbooks-online)) | Not in docs | Not in docs |
| **Triple Whale** | Not in docs | Not in docs | Not in docs |
| **Daasity** | Not in docs | Not in docs | Not in docs |
| **Northbeam** | Not in docs | Not in docs | Not in docs |
| **Shopify Sidekick** | Not in docs | Not in docs | Not in docs |

*Yes: documented and built in. Partly: documented with a limit, shown in brackets. Not in docs: not found in the vendor's public documentation.*

### Why Luca AI is the stronger choice for QuickBooks reporting for ecommerce {#compare-stronger}

- **The whole ledger, not a cost import.** Luca reads profit and loss, balance sheet and cash flow, while Lifetimely maps QuickBooks accounts [to four cost categories](https://help.useamp.com/article/1115-getting-started-with-quickbooks-online). See [Lifetimely alternatives](https://ask-luca.com/blogs/lifetimely-alternatives).
- **Working capital from your books.** Luca works out stock, debtor and creditor days from QuickBooks, while Daasity's [AI Analyst answers from governed Daasity metrics](https://help.daasity.com/core-concepts/ai-analyst). See [Daasity alternatives](https://ask-luca.com/blogs/daasity-alternatives).
- **Payouts matched to the ledger.** Luca follows each Shopify, Amazon and Stripe payout to its line in QuickBooks, a match Luca's team sets up with you. Saras loads QuickBooks tables [into a warehouse you configure](https://help.sarasanalytics.com/en_US/quickbooks-v2/how-to-integrate-quickbooks-v2-with-daton) and documents no payout match.

*Competitor details checked against each vendor's public documentation on 20 November 2026. Features and plans change, so confirm with the vendor before you decide.*

## Limits of the QuickBooks connection {#limits}

- Luca never posts anything into QuickBooks: no orders, fees, settlements, journals or payments. If you want sales posted into the ledger, that stays with your accountant or a posting app.
- Luca doesn't reconcile bank lines inside QuickBooks. It shows where store, payouts and ledger differ, and you make the fix in QuickBooks.
- QuickBooks' own reports don't change when you connect Luca. Its analysis sits beside them, in Luca.
- QuickBooks data refreshes once a day, overnight. A bill entered this morning appears in Luca after tonight's refresh.
- Luca compares ad spend with revenue and margin. It never ties a QuickBooks line to an ad, and it shows which ads produced orders only where Luca's team has set up an attribution model with your brand.
- The cash-flow forecast needs a connected ledger, Xero or QuickBooks, and Luca's team switches forecasting on for your brand.

## Common questions {#common-questions}

#### Does Luca post Shopify or Amazon sales into QuickBooks? {#posts-sales}

No. Luca reads your QuickBooks Online company and writes nothing to it. Sales, fees and settlements stay in Shopify and Seller Central, and Luca joins them to the ledger inside Luca only.

#### Will my QuickBooks reports change after I connect Luca? {#reports-change}

No. Your profit and loss, balance sheet and every other QuickBooks report stay as they are. Luca reads them and shows its own analysis, such as margin by channel, inside Luca.

#### Do I need admin access in QuickBooks to connect it? {#admin-access}

Yes. You need admin or owner access to the QuickBooks Online company. You then approve read-only access on QuickBooks' own screen, and QuickBooks sends you back to Luca.

#### How often does QuickBooks data refresh in Luca? {#refresh}

Once a day, overnight. The QuickBooks card on the **Sources** screen shows the time of the last sync, so you can confirm last night's read ran before a review.

#### Can I use Luca and a posting app together? {#posting-app}

Yes. A posting app writes sales into QuickBooks, and Luca only reads. Whatever the app books becomes part of the ledger that Luca reads on its next overnight refresh.

#### Which figures need QuickBooks connected? {#figures-need-quickbooks}

Gross, operating and net margin, ROCE, debtor, creditor and inventory days, the cash-conversion cycle, free cash flow and burn multiple come from the ledger. They need Xero or QuickBooks connected.

#### Why might Luca's margin differ from QuickBooks'? {#margin-differs}

Usually because of timing or coding. A payout not yet booked, or a supplier bill without a product code, leaves a gap. The figures line up once you fix the record in QuickBooks.

#### What if an Amazon payout isn't in QuickBooks yet? {#amazon-payout-missing}

Luca's revenue will run ahead of the ledger until the settlement is booked. Book it in QuickBooks, and the gap closes after the next overnight refresh reads the entry.

#### Can Luca reconcile my QuickBooks bank lines? {#reconcile-bank-lines}

No. Luca never reconciles anything inside QuickBooks. It matches sales, payouts and the ledger in Luca, shows where they differ, and leaves the fix to you or your accountant.

#### Can Luca tie a QuickBooks line to an ad? {#single-ad}

Not a ledger line. Luca sets ad spend against revenue and margin by channel. It does not show which ads produced which orders unless Luca's team has set up an attribution model with your brand. For spend against margin, read [break-even ROAS for your products](https://ask-luca.com/product-docs/marketing/ad-profitability).

#### Can I ask about my QuickBooks figures in Slack? {#slack}

Yes, on the Leadership plan and above. Add Luca to Slack and ask there. Luca posts its own answers into Slack and writes to no other system, QuickBooks included.

#### Does the cash-flow forecast need QuickBooks? {#cash-forecast}

It needs a ledger: Xero or QuickBooks. Without an accounting connection, the free-cash-flow forecast isn't available. Luca's team switches forecasting on for your brand.

## Further reading {#further-reading}

- [How to sell on Amazon (Shopify)](https://www.shopify.com/blog/sell-on-amazon): Amazon's selling plans and referral fees, and how to check margin after them before listing a product.
- [Cash conversion cycle (Shopify)](https://www.shopify.com/blog/cash-conversion-cycle): the formula from inventory, sales and payable days, and what a shorter cycle means.
- [Operating cash flow (Shopify)](https://www.shopify.com/blog/operating-cash-flow): how working capital is defined and how its changes move cash flow.

For the difference between the three numbers a founder reports, read [cash flow, revenue and profit side by side](https://ask-luca.com/blogs/cash-flow-vs-revenue-vs-profit).

## Related {#related}

- [Shopify and Amazon in one P&L](https://ask-luca.com/product-docs/use-cases/sell-on-shopify-and-amazon)
- [Accounting integrations](https://ask-luca.com/product-docs/integrations/accounting): Xero and QuickBooks Online, and how each ledger connects.
- [How Luca's read-only access works](https://ask-luca.com/product-docs/platform/read-only-access)
- [Conversational analytics across Shopify, ads and your ledger](https://ask-luca.com/product-docs/chat/cross-source-answers)
- [Cash-flow forecasting for ecommerce](https://ask-luca.com/product-docs/forecasting/cash-flow-forecast)
- [Contribution margin analysis](https://ask-luca.com/blogs/contribution-margin-vs-gross-margin)

*Updated 20 November 2026: first published, with read-only scope, margin by channel, the QuickBooks check, a worked example and 12 questions.*
