Video transcript
If the company keeps its books in Xero, QuickBooks or FreeAgent, you do not need a spreadsheet. Connect once, and the trial balance comes straight across.
On the trial balance start screen, find Connect your bookkeeping software, and choose your system.
You are taken to your bookkeeping software to sign in, and to choose which organisation to share. Then you come straight back.
You can also connect later, in Organisation settings, under System and Defaults.
Once connected, the period's balances are brought in, and each account is matched to a standard account. The strip at the top shows that the figures come from Xero.
The Imported Data tab lists every account, and where it went. Anything that could not be matched is highlighted, for you to map once.
When the books change, open Actions, and choose Sync with Xero to bring the balances in again.
Organisation settings shows the state of the link, and when it last synced.
If the link lapses, for example because access was removed in Xero, it is marked as needing reconnecting. Connect again, and the figures you already have are kept.
QuickBooks and FreeAgent connect in the same way.
If the company keeps its books in Xero, QuickBooks or FreeAgent, you do not need a spreadsheet. Connect once, and the trial balance for each period comes straight across. This page shows where to connect, what a connected period looks like, and how to sync again.
Connect from the trial balance
- Open Trial Balance for a period that has no figures yet.
- On the start screen, find Connect your bookkeeping software and choose Connect to Xero, the QuickBooks Connect button or Connect to FreeAgent.
- You are taken to your bookkeeping software. Sign in, and choose the organisation to share.
- You come straight back, and the period's balances are brought in.
A company connects to one system at a time.
Connect from Organisation settings
You can also connect at any time in Organisation settings, on the System & Defaults tab: open Connect to Accounting System and choose your system. The same tab shows the state of the link and when it last synced.
What a connected period looks like
The Entering figures by strip at the top of the trial balance names your system, to show where the figures come from. Each account from your books is matched to a standard account.
The Imported Data tab lists every account and where it went. An account that could not be matched is highlighted. Pick the right account from the list on its row, or use AI-map all unmapped and check what it chose. A match is remembered, so you only make it once. See Mapping your imported trial balance.
Sync again when the books change
On the trial balance, open Actions and choose Sync with Xero (or your system's name). The balances are brought in again, and your matches are kept.
Adjustments that belong in the books, such as the Corporation Tax charge, are best posted in your bookkeeping software and then synced.
If the link lapses
If access is removed in your bookkeeping software, or the link has not been used for a while, the connection is marked Needs reconnecting and the trial balance tells you. Connect again in the same way. The figures you already have are kept. See Reconnecting to Xero and Reconnecting to QuickBooks.
Common questions
Does connecting change anything in my books?
No. Tax Optimiser reads the balances. It does not post anything to your bookkeeping software.
Do I have to connect again for next year?
No. Once connected, each later period syncs from the same link.
My system is not listed. What can I do?
Export a trial balance and import it as a spreadsheet. See Importing your trial balance.
