Xero Bookkeeping
Books kept in Xero by somebody who knows the difference between a matched bank line and a reconciled account, and who checks the sales tax return against the transactions it was built from rather than against last quarter.
Xero is a full general ledger and it is the system a lot of businesses picked once and never had a reason to leave. It is also a system whose screens are reassuring in a way that hides two or three things, and the ones below are the ones that turn up in a file somebody else has been keeping.
What the work looks like in Xero
Reconciled in Xero means matched, which is not the same as reconciled
The green tick on the Reconcile screen says a bank line was matched to a transaction. It says nothing about whether the account agrees with the statement from the bank. That lives on the Bank Reconciliation Summary, where the Xero balance and the statement balance sit side by side, and the two can differ by a duplicate, a manually entered payment that never cleared, or a transaction dated into a period the feed has already passed. A file can be a wall of green ticks and still not reconcile.
The Canadian GST/HST return is assembled from the tax rate on every line
Xero builds the return out of the tax treatment of each individual transaction rather than from a figure anybody types. One bill coded to the wrong rate, or an expense marked tax exempt because the rate defaulted that way, moves the return. The useful check is not the return against the previous one, it is the return against the transactions underneath it, which is a report Xero will produce and almost nobody opens.
Lock Dates come in two, and the second one lets an adviser straight through
Xero has a lock date for all users and a separate, later one for everybody except advisers. That is a sensible design and it means a user with adviser rights can still post into a month that has been closed and reported on. It is the usual explanation for a figure that was right in February and is different in May, and it is worth checking before anybody goes looking for the error itself.
Tracking Categories stop at two, so the third dimension lands in the chart of accounts
Xero allows exactly two tracking categories. A business that wants to see results by location and by department has used both, and when a third view is needed later the only place to put it is the account code. That is how a chart of accounts ends up with the same six expenses repeated per site, which works and then stops working at the fourth site.
A bank rule keeps applying long after the reason for it has gone
Bank rules code a transaction and carry its tax treatment with them, which is exactly what you want until the supplier changes what it sells or a recurring payment becomes something else. The rule does not announce itself in the ledger: the transaction simply appears, coded, in the place it has always gone. Reviewing the rules is part of the work, not an annual tidy.
Questions about Xero
Can you work in the Xero file we already have?
Yes, and that is the normal arrangement. We are added to your organisation with the access the work needs, and the subscription stays in your business's name. If it is currently billed to somebody else, that is worth changing before anything else happens.
We are on QuickBooks Online and keep being told to move to Xero. Should we?
Usually not for its own sake. Both are complete general ledgers and the migration costs real money and loses some history. The reasons that do justify it are specific: an app your operation depends on integrates with one and not the other, or you need multi-currency handled a particular way. Wanting a tidier file is not one of them, because a tidy file is a bookkeeping outcome rather than a software one.
Who files the GST/HST return?
We prepare and file it from your own books for Canadian businesses. Corporate, trust and partnership returns are done by our associated CPA, working from the year end file we produce.
Do you set the file up from scratch?
Yes, including the chart of accounts, the tax rates, the bank feeds and the tracking categories, and it is worth doing deliberately rather than accepting the default chart. The two tracking categories in particular are a decision that is awkward to revisit later.
More questions answered on the FAQ page.