Monthly Excel reports from Xero, one pack per client
For fractional CFOs, bookkeepers and accounting firms who rebuild the same Xero export in Excel every month for each client.
Why teams use this
Xero holds the books, but owners, boards and lenders still ask for an Excel file. Exporting the report, pasting it into last month's workbook and re-checking the totals has to be redone for every client, every month.
How Ilka connects
Sign in with Xero and pick one organisation. Ilka requests read-only accounting scopes, stores the refresh token encrypted, and pulls one of four reports on each run.
- Sales invoices (receivables): customer, dates, status, totals, amount due, days overdue
- Bills (payables): the same shape, by supplier
- Profit and Loss for a lookback window, flattened to section, account and period columns
- Balance Sheet as at the run date, in the same section-and-account shape
Figures copied from Xero, then proved
You design the pack layout once and see it filled with the client's real numbers before anything is scheduled. After the layout is locked, each delivery copies and totals the amounts in code, straight from Xero; the model never types a figure. The last sheet, Source check, recomputes each total with Excel formulas and shows the difference with the source.
- Locked layout reused every month
- Source check sheet with live formulas
- Delivery stops with a clear message if a Xero column disappears
Best-fit workflows
Monthly management accounts supplements, receivables chasing packs and payables reviews for a portfolio of clients, one Xero organisation per pack so books never mix.
- Monthly P&L pack per client
- AR aging from open invoices
- Payables review before the payment run
Delivery options
The same Xero schedule can email the .xlsx (under your firm's name on Firm), share a client portal link with optional password and expiry, upload to SharePoint or Drive, or POST a signed webhook.
FAQ
Which Xero reports can Ilka pull?
Sales invoices (receivables), bills (payables), the Profit and Loss for a lookback window of up to 365 days, and the Balance Sheet as at the run date.
What access does Ilka ask for in Xero?
Read-only accounting scopes (transactions, reports and settings). Ilka cannot create or change anything in Xero. The refresh token is stored encrypted and rotated on every run.
Can I run packs for several clients?
Yes. Connect each client's Xero organisation separately so a pack never mixes two sets of books. Free covers one client, Pro three, and Firm ten, then $5 per extra client.
Is there a row limit?
Invoice and bill pulls stop at 500 rows per run. Use a shorter lookback for busy organisations.
Can I see an example pack before connecting Xero?
Yes. Sign up free and build a pack from the built-in sample data first; it is labelled as a sample and not billed. Then connect one real Xero organisation.
Related: How-to guide · Ilka vs Coupler.io · Ilka vs Coefficient · All templates