PRODUCT DOCS
Docs/Integrations/Hub

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.

Live5 min read

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

Answer in 20 seconds
How it connectsSelf-serve: Sources › Finance › Connect, then approve read-only access in Xero
What Luca readsProfit and loss, balance sheet, cash flow, trial balance, invoices, bills, payments, credit notes, bank transactions and journals
What Luca writesNothing
How often it refreshesOnce a day, overnight
What it unlocksMargin, working capital and cash figures beside Shopify and ad data
Other ledgersA 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.

Built from Luca's code-checked product facts · as at 20 Nov 2026
01

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. 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. 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.

02

Which finance figures need a ledger connected

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:

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 is a good primer.

03

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.
04 · Common questions

Common questions

Do I still need a sync app to post my store sales?

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?

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?

No. Luca reads your books and never writes to them. 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?

Store and ad figures, such as revenue, orders and spend by platform, work from Shopify and your ad accounts alone. So do MER and platform ROAS. The free-cash-flow forecast and the working-capital figures need Xero or QuickBooks connected.

Does Luca reconcile my 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?

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.

Luca AI Product team · Last verified 20 November 2026

Something wrong or missing? Send the page link with your correction to the Luca AI team.

Your numbers, answered.

Ask Luca about your own store.

Browse the product docs →Book a demo