Connecting a client's QuickBooks Online or Xero file lets Tickloft code transactions, match receipts, reconcile bank accounts and prepare month-end work. Owners, admins and reviewers can connect, sync and disconnect. Staff can see the connection and the synced data.
If you don't see QuickBooks or Xero, connections haven't been turned on for your firm yet — contact Tickloft support. The same applies if the buttons appear with the note Not set up for your firm yet.
Connect QuickBooks Online or Xero
- Open the client and select the Accounting tab.
- Select Connect QuickBooks Online or Connect Xero.
- Sign in to QuickBooks or Xero with an account that has access to the client's books, and approve access for Tickloft.
- You return to Tickloft, which finishes the connection and starts the first sync.
Tip: Your client can also connect their own accounting system from the client portal, during the Accounting system step of their setup. This avoids asking them for their QuickBooks or Xero password.
Choose the organisation
If the login you used can access several companies, the status shows Choose organisation and Tickloft asks you to pick one.
- Select the client's company in the Organisation list.
- Select Use this organisation.
Check the name carefully: connecting the wrong company brings another business's data into this client's record.
Keep the data in sync
Tickloft syncs automatically on a schedule. You can also sync by hand:
- Sync now brings in changes since the last sync.
- Full resync reloads everything. Use it if data looks incomplete.
Recent syncs lists each sync with who or what started it, its status and how many records were new, updated or unchanged. The client's Overview tab shows the last sync date, and Manage connection takes you back to the Accounting tab.
Owners, admins and reviewers can see every client's connection and its sync health in Governance → Connections.
What Tickloft reads
Tickloft brings in the client's:
- chart of accounts
- customers and suppliers
- tax codes
- bank and card transactions
- invoices, bills and payments
- journal entries
Browse them under Synced data: choose the type of data, search, and tick Show deleted to include records deleted in the accounting system.
Write-back happens only after approval
Tickloft never changes the books on its own. The only changes it can make are:
- Transaction codings that someone approved in the Review queue.
- Journal entries that were submitted for review and approved.
If write-back is turned off for your installation, approved codings are recorded in Tickloft with the exact change it would make, marked Recorded (write-back off), and nothing is sent to QuickBooks or Xero. Follow each write-back on the client's Bookkeeping tab, under Write-backs.
Reconnect or disconnect
Access to QuickBooks and Xero expires from time to time. Tickloft warns you before it does, and the status changes to Needs reconnecting if access stops.
- Select Reconnect and sign in again. Data already synced is kept.
- To stop syncing, select Disconnect and confirm. Tickloft revokes its access, and data already synced stays available.
If a sync fails, the status shows Sync errors with the reason under Last error. Most temporary problems clear on the next sync.
Work without a connection: imported files
If a client doesn't use QuickBooks Online or Xero (they keep their books in another program or a spreadsheet), you can import their data instead. Bookkeeping, bank reconciliation, the month-end close checklist, sales tax figures and financial insights then work from the imported data. Nothing is sent anywhere.
On the client's Accounting tab, under Imported files:
- Bank or card statement (CSV): columns Date, Description and Amount (money in positive, money out negative), or separate Debit and Credit columns. Choose the bank account or name a new one. Importing the same statement again adds nothing, and transactions you've already coded keep their coding.
- Statements read from documents: bank and card statement PDFs that were uploaded and approved in review. Select Add as transactions to turn their lines into transactions to code.
- Chart of accounts (CSV): columns Code (optional), Name and Type (Bank, Credit card, Income, Other income, Expense, Cost of sales, Other expense, Asset, Liability or Equity). Import it first so coding can use the client's own accounts.
- General ledger (CSV): columns Date, Account (code or name), Debit and Credit, and optionally Entry and Description. Each entry must balance; entries that don't are listed and skipped. If a general ledger already covers a period, don't also code that period's bank statements in Tickloft, or amounts are counted twice.
- Trial balance (CSV): columns Account, Debit and Credit, with the trial balance date. It gives totals at one date, so import a general ledger for monthly figures, and don't import both for the same period.
Files can be CSV or Excel (.xlsx), and files exported from QuickBooks Online, Xero or the bank can be uploaded as they are, so there's no need to tidy them first. Tickloft skips the report title lines, totals and footers, takes each transaction's account from the account heading above it (QuickBooks General Ledger, Xero Account Transactions), reads dates written with month names, and splits account numbers out of names such as "1000 Chequing" or "Sales (200)". It lists what it did after each import. If dates could be day/month or month/day, choose the Date format and upload again.
What to ask a client who exports from QuickBooks Online or Xero: the chart of accounts (QuickBooks Account List, Xero Chart of Accounts), the general ledger for the period (QuickBooks General Ledger, Xero Account Transactions), and a trial balance at the period end.
Each form has Download a template. After an import, Tickloft shows how many records were new, updated or already there, and lists any rows it couldn't read with their row number.
Codings and journal entries you approve are kept in Tickloft. Cash in Insights uses a bank account's balance from the general ledger or trial balance, or the closing balance of its latest statement PDF; a CSV statement alone has no balance, so cash shows as unknown. Imports lists every import with the file name.
A client has either a connection or imported files, never both, so nothing is counted twice. To switch to QuickBooks Online or Xero, select Remove imported data and confirm, then connect.