Blinkby Theta Advisory

Blink › Guides

Xero and QuickBooks Online reports in Excel

Blink is an add-in for Excel. It pulls reports and transactions from Xero or QuickBooks Online onto tabs in your own workbook and pulls them again when you ask. There are no export files and nothing to paste.

What you can pull

Report or listXeroQuickBooks Online
Trial balanceYesYes
Profit and lossYesYes
Balance sheetYesYes
Aged receivables and aged payablesYesYes
Sales invoices and credit notesYesYes
Bills and supplier creditsYesYes
General ledgerNoYes
Account transactionsYesNo
Manual journalsYesNo
Chart of accountsYesNo
BudgetsYesNo

Profit and loss and balance sheet can be split into columns by month, quarter or year. In Xero they can also be split by tracking category, and in QuickBooks Online by class or location.

Set up

  1. Add Blink to Excel, or have your IT admin deploy it for the team.
  2. Open Blink and sign in with your work Microsoft account.
  3. Open the Xero or QuickBooks group, go to Orgs and click Connect to Xero or Connect to QuickBooks. You sign in on Xero’s or Intuit’s own page. Blink never sees your password.
  4. Go to Reports, set the date or date range on the report you want, and pull it.

Where the report goes

Each report goes to its own tab, named for the report (Trial Balance, Profit and Loss and so on). You can also send it to a new tab, or to a tab you already have, starting at the cell you pick.

If that tab already has content, Blink asks before it writes, and you choose what happens: overwrite what is there (to replace budget with actual, say), or keep it and have Blink move it aside.

Where your own formulas read a pulled tab, look figures up by account, not by cell position, so they still work when a new account adds a row.

Refreshing

Each tab keeps the organisation and dates it was pulled with, saved in the workbook. On the Reports tab, every pulled tab has four controls:

  • Refresh pulls the same report again for the same dates, picking up anything posted since.
  • Edit changes the dates and pulls again.
  • Roll forward moves the dates on one period (a month, a quarter or a year) and pulls again.
  • Refresh All does every tab from that ledger, one at a time.

To stop Blink refreshing a tab but keep the figures, use Remove report from tab.

All four write to the same tab, so formulas that read it keep working. If the workbook holds both Xero and QuickBooks Online tabs, run Refresh All once under each.

Things to know

  • There is no cash or accrual switch in Blink, and no prior-year comparison column. For a comparison, pull the prior period to a second tab.
  • Xero aged receivables and payables take a few minutes for a large organisation, so Refresh All runs them last.
  • Xero account transactions leave out entries Xero creates automatically: foreign exchange revaluations, fixed asset depreciation, inventory cost of sales, payroll, expense claims and conversion balances. For accounts those touch, the list will not agree to the trial balance.
  • If QuickBooks Online says a pull has too many transactions, narrow the date range and pull again.

Into Word and PowerPoint

A figure in the workbook can be linked into a Word report or a PowerPoint deck from the Live Links tab. When the workbook figure changes, the linked figure changes with it. Because links point at a tab by name, Blink does not rename a tab when you roll it forward.

Questions

Does it work in Excel for the web and on the desktop?

Both, with a current Microsoft 365 subscription. Business Basic includes the web apps only, and Blink runs there too. Perpetual Office (2019, 2021) isn’t supported. More on supported plans.

Does Blink work with QuickBooks Desktop?

No. Blink connects to QuickBooks Online and Xero.

Can one workbook hold reports from more than one company?

Yes. Each tab remembers its own organisation, and Refresh All updates all of them. To put several companies side by side in one report, see group reports.

Can Blink post back to the ledger?

Yes. Journals, sales invoices and bills can be posted from Excel, one at a time or in a batch. See posting from Excel.

Can IT add it for the whole team?

Yes. An admin deploys Blink once from Integrated apps in the Microsoft 365 admin center, and it appears in Excel, Word and PowerPoint for the people they choose. See the admin steps.

Get started with Blink

Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.

More guides