# Ecommerce Accounting Reports: Read Xero or QuickBooks Beside Your Store and Ad Data

Ecommerce accounting reports need the ledger beside store sales and ad spend: Luca AI reads Xero or QuickBooks Online read-only for margin, working capital and cash, and never posts into your books.

- Applies to: Brands that close the month in Xero or 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

Ecommerce accounting reports only explain the month when the ledger sits beside store sales and ad spend. Luca AI reads your Xero or QuickBooks Online ledger read-only and sets it beside your Shopify orders and ad spend, so margin after ads, working capital and cash come from one set of figures. It never posts sales, journals or payments into your books, so it sits beside a sync app rather than replacing one, and your accountant's reports stay exactly as they are.

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

| | Xero | QuickBooks Online |
|---|---|---|
| **How it connects** | Self-serve: **Sources** › **Finance** › **Connect**, then approve read-only access in Xero | Self-serve: **Sources** › **Finance** › **Connect**, then approve read-only access in QuickBooks |
| **What Luca reads** | Profit and loss, balance sheet, cash flow, trial balance, invoices, bills, payments, credit notes, bank transactions and journals | The full ledger, profit and loss, balance sheet and cash flow, with the same detail as Xero |
| **What Luca writes** | Nothing | Nothing |
| **How often it refreshes** | Once a day, overnight | Once a day, overnight |
| **What it unlocks** | Margin, working capital and cash figures beside Shopify and ad data | The same figures as Xero |
| **Other ledgers** | A custom connector built by Luca's team on request, at no extra fee | A custom connector built by Luca's team on request, at no extra fee |

Either connection unlocks ten finance figures that store data alone can't give you. They are gross margin, operating margin, ROCE, debtor days, creditor days, inventory days, the cash-conversion cycle, free cash flow, burn multiple and a forward free-cash-flow forecast.

## What this area covers {#what-this-area-covers}

Pick the page for the ledger you close the month in. Each one covers what Luca reads, what it never touches and how to connect.

- **[Xero reporting for ecommerce](https://ask-luca.com/product-docs/integrations/accounting/xero).** This suits a brand whose accountant keeps the books in Xero. It covers the connect dialog, the overnight read and how ledger gaps show up.
- **[QuickBooks reporting for ecommerce](https://ask-luca.com/product-docs/integrations/accounting/quickbooks).** This suits a brand that closes in QuickBooks Online. Luca reads it with the same detail as Xero, so the figures and checks match.

Both connect from the same **Finance** group on the **Sources** screen. If you are adding a ledger after your first day, follow the steps to connect a data source.

## Which finance figures need a ledger connected {#decision-guide}

Some figures depend on the books, because Shopify and your ad accounts don't hold your bills, bank lines or balance sheet. Connect Xero or QuickBooks first, then go to the page for the figure you need:

- **A cash forecast for the next 13 weeks or 12 months.** Use the [cash-flow forecast](https://ask-luca.com/product-docs/forecasting/cash-flow-forecast). Forecasting is switched on per client by Luca's team.
- **How many months of cash you have left.** Use [cash runway](https://ask-luca.com/product-docs/finance/runway), which works from the forecast and your burn.
- **Whether spend and profit are tracking the plan.** Use [budget against actual](https://ask-luca.com/product-docs/finance/budgets-and-plans).
- **What each order and channel earns after costs, fees and ads.** Use [contribution margin](https://ask-luca.com/product-docs/profit/contribution-margin), which runs down to operating profit from the ledger. To rank products the same way, use [product profitability analysis](https://ask-luca.com/product-docs/use-cases/product-profitability-analysis).
- **A monthly pack for your board or investors.** Use [board and investor reporting](https://ask-luca.com/product-docs/reports/board-and-investor-reporting), with the ledger in the same pack. For the same figures by email each week, set up [scheduled reports](https://ask-luca.com/product-docs/reports/scheduled-reports).

Reconciliation views and aged receivables will have their own pages in a later wave. For profit and cash as a monthly routine, read how to track profit and cash. If the difference between cash, revenue and profit trips up your team, this short guide to [cash flow vs revenue vs profit](https://ask-luca.com/blogs/cash-flow-vs-revenue-vs-profit) is a good primer.

## What to check {#what-to-check}

The figures only agree with your books when the books are coded. Run through these before a month-end review:

1. **Every bill carries a product code.** A bill without one leaves part of a cost, such as packaging, that Luca can't assign to a product.
2. **Every payout is booked.** A Stripe payout that isn't in the ledger yet shows up as a gap, such as "1 payout not yet in Xero".
3. **Fixes happen in Xero or QuickBooks.** Luca flags the gap, and you fix the record in Xero or QuickBooks because Luca never edits it.
4. **Last night's refresh has run.** Figures update after the next overnight refresh, and each connected card on **Sources** shows its last sync time.

## Common questions {#common-questions}

#### Do I still need a sync app to post my store sales? {#still-need-a-sync-app}

Luca doesn't post sales, fees or payouts into your ledger. If you want those entries booked, a posting app or your bookkeeper still does that job, and Luca reads whatever lands in the ledger on its next overnight refresh.

#### Can Luca read a ledger other than Xero or QuickBooks Online? {#other-ledgers}

Yes, through a custom connector. If your ledger or ERP isn't listed on **Sources**, Luca's team builds the connector on request at no extra fee, and it stays read-only like every other source.

#### Will my accountant see any change in the books? {#accountant-sees-change}

No. Luca [reads your books and never writes to them](https://ask-luca.com/product-docs/platform/read-only-access). It can't create or edit invoices, post journals or payments, reconcile transactions or edit your chart of accounts, so your accountant's reports stay as they were.

#### Which figures can I get without accounting connected? {#without-accounting}

Store and ad figures, such as revenue, orders and spend by platform, work from [Shopify](https://ask-luca.com/product-docs/integrations/commerce/shopify) and your ad accounts alone. So do [MER and platform ROAS](https://ask-luca.com/product-docs/marketing/roas-and-mer). The free-cash-flow forecast and the working-capital figures need Xero or QuickBooks connected.

#### Does Luca reconcile my bank lines? {#reconcile-bank-lines}

Not in your books. Bank reconciliation stays in Xero or QuickBooks. Luca can reconcile sales to payments, payouts and the ledger inside its own views, and Luca's team sets that up for each client.

#### What if my books close late each month? {#books-close-late}

Luca's figures follow the ledger, so last month's margin and cash stay provisional until the books are closed. Work through the checks in What to check above, then review after the next overnight refresh reads the closed month.

## Related {#related}

- [Is it safe to connect AI to your store?](https://ask-luca.com/product-docs/platform/read-only-access) Read-only access across store, ads and books.
- [Shopify analytics](https://ask-luca.com/product-docs/integrations/commerce/shopify) The store connection that the ledger sits beside.
- [Set up Luca](https://ask-luca.com/product-docs/getting-started/set-up-luca) The first day, from Shopify to inviting your team.
- [Answers across Shopify, ads and Xero](https://ask-luca.com/product-docs/chat/cross-source-answers) One plain-English question answered from every source.
- [Integrations](https://ask-luca.com/product-docs/integrations): every source Luca connects and how each one connects.
- [Commerce integrations](https://ask-luca.com/product-docs/integrations/commerce): the store connections that sit beside the ledger.
- [Advertising integrations](https://ask-luca.com/product-docs/integrations/advertising): ad spend that lands in the same margin figures.
