Blinkby Theta Advisory

Blink › Guides

Trial balance in Excel

Blink pulls the trial balance from Xero or QuickBooks Online into your workbook as at any date. Lead schedules and reconciliations then read it from the same tab every month.

Pulling it

  1. In Blink, open Xero or QuickBooks, then Reports.
  2. Under Trial Balance, set As at and click Pull TB.
  3. It lands on a tab called Trial Balance, unless you choose another.

Not connected yet? Set up takes four steps.

Building on it

The trial balance comes back on the same tab each time, so the rest of the workbook can read from it:

  • Lead schedules that pick up each account’s balance with XLOOKUP or SUMIFS.
  • Balance sheet reconciliations that compare a schedule or subledger total to the ledger balance.
  • A check on each prepaid, accrual or fixed asset schedule that its closing balance agrees to the account.

Look balances up by account, not by row, so the formulas still work when a new account adds a row. For the full check, see agreeing schedules to the balance sheet and income statement.

Late entries and next month

Refresh pulls the trial balance again for the same date, so late adjustments flow through to every schedule that reads it. Roll forward moves the date on one month and pulls into the same tab.

To keep each month, pull the new month to a new tab and name it for the period.

Signing off a balance

On the Reconcile tab you can pick an account from the trial balance, compare it to a cell in your workbook and certify that they agree, or explain the variance. If the ledger balance or the cell changes afterwards, Blink marks the certification as stale.

Questions

Can I get several companies on one trial balance?

Yes, with one column per company and a total. See group reports.

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.

Get started with Blink

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

More guides