Is your Xero setup configured correctly so that you’re getting the most out of your accounting software?
After spending 5+ years working with Xero bookkeeping clients, we’ve noticed people often make the same errors. Here are the top 8 mistakes we’ve seen business owners make with their Xero setup.
Not allowing for immediate online payment
By default, invoices sent by Xero cloud accounting software won’t be able to be paid online immediately. It’s a no brainer to accept online payment and it’s a 5-minute job.
By adding ‘Payment Services’ to Xero:
- You can email an invoice to a customer.
- They can also use the payment button to pay you online immediately. This reduces the risk of being paid late or not at all.
To set this up you will need a Payment Service.
We recommend using both PayPal and Stripe which can be quickly configured via Settings / General Settings / Payment Services.
Not setting up your Xero Chart of accounts properly
The Xero Chart of Accounts is a list of all of the accounts hat transactions can be allocated to. For example, telephone expenses is an account within the Chart of Accounts.
Xero comes with a standard Chart of Accounts. So it’s pretty common for users to forget that they have the option to customise it to suit their business.
Most of Bean Ninjas’ clients are online businesses like coaches, consultants, info products, e-commerce, SaaS and others. So it doesn’t make sense to have 5 different lines for office expenses. For example office expenses, printing and stationery, subscriptions, general expenses, and light and power.
I prefer to only have accounts within the Chart of Accounts where we are reporting on these items separately.
For example, I like to have one line called “office expenses” and some other key expense lines might be:
- Marketing, and
- Software subscriptions.
If you don’t have them set up with the right names, you run the risk of items being incorrectly coded, As a result, reports won’t be as clear about how your business is performing.
You can update the Chart of Accounts in the General Settings / Chart of Accounts area in Xero.
If you are adding or editing accounts it is important to get the following settings right:
- Account type (eg sales or current liability)
- Tax type (eg GST on expenses or GST free)
If you’re unsure about the settings make sure to check with your bookkeeper or accountant as part of your Xero Setup process.
If you are using Xero, our full list of items to consider is included in our Xero Small Business Toolkit which you can grab below.
Not having multiple PayPal accounts set up
A lot of people know you can connect PayPal accounts to Xero, but it can present problems when you accept multiple currencies. This is solved by having a PayPal account set up in Xero for each currency.
If you only have 1 Paypal account, some transactions won’t be imported into Xero. So if you accept say AUD and USD, connect it up to Xero with 2 accounts, and you will solve the missing data issue.
Check out this help doc to learn more about setting up Paypal accounts in Xero as part of your Xero Setup process.Paypal and Xero - each Paypal currency needs a separate account in Xero Click To Tweet
Incorrectly configured external payment gateways
If you are using an external Payment Gateway like Stripe, these funds are transferred into your business bank account as daily batches rather than individual transactions. This means individual sales and processing fees aren’t accounted for fully.
There are a few options of how to treat this in Xero. If you want every transactions in Xero, you can use a tool like Silver Siphon to push this data into Xero.
This option works well for businesses who do need that level of detail in Xero, however it can also create additional work if there are heaps of transactions. Reasons why you might need to do this are wanting to split sales into different sale types in Xero or if you are giving credit terms to your customers and need to match up individual payments to specific invoices in Xero.
If you don’t need this level of detail we have a shortcut for you. Following these steps will help you to calculate the sales tax on transactions in Stripe, which your bookkeeper can then add to Xero with a manual journal.
- Log in to Stripe.
- In the “Balance’ tab click ‘Filter’, ‘Date’ and ‘Date is Between’ and input the first and last day of the previous month.
- Still in the filters box click ‘Type’ and ensure ‘charge’ is selected.
- Click Done.
- Open each charge and check the flag icon/country name.
- In a spreadsheet list each charge that is from Australia – the total amount in Australian Dollars.
- Ignore fees – we will pick them up from a different report.
- If a sale has been refunded please record both the sale and the refund in the spreadsheet – precede the refund amount with a minus (-) sign to ensure it is not added to the total
- Send spreadsheet to your bookkeeper or accountant.
Deciding whether to bring in every transaction from your Payment Gateway or to use a shortcut method will depend on your reporting needs. If your unsure discuss this with your bookkeeper or accountant.
Not following up unpaid invoices automatically
Following up customers who owe you money can be a big time waster and forgetting to do it is costing you precious $$. Why not automate this with Xero’s invoice reminder feature?
Automated invoice reminders allow you to prepare custom email templates to go out when invoices are a certain number of days late. Xero’s default reminders are sent at 7, 14 and 21 days after each invoice due date.
Invoice reminders can be activated by going to Accounts / Sales then Awaiting Payment.
You can customise the email text that is used when the invoices are followed up.
Forgetting about bank reconciliations
The bank reconciliation process is a key check to pick up missing transactions or duplicated transactions in Xero. Because Xero automatically matches statement lines with the accounting record, a lot of people think they can skip this step. This is a crucial process and still needs to be done with Xero, to make 100% sure that Xero has imported your bank statement lines properly.
You can do this by running the Reconciliation Report in Xero under Accounts / Bank Accounts/ Management Accounts / Reconciliation Report and comparing it with your bank statements on a particular date (usually the last day of the month / quarter).
The ‘Balance in Xero’ and the ‘Statement Balance’ may match, but I also like to compare the ‘Statement Balance’ to a copy of the Bank Statement as the ‘Statement Balance’ in Xero isn’t always correct.
If there is a difference between Xero and the Bank Statement then there are missing transactions which need to be imported or duplicate transactions which need to be removed. For more information about this refer to this longer post on bank reconciliations
Failing to understand cash vs accrual accounting
Accounting can be done on a cash or accruals basis and it is very important to understand the distinction.
Cash accounting means that transactions are recorded in the accounting system when the transfer of cash occurs. Whereas accrual accounting means the transaction is recorded when the transaction itself happens.
As an example, Bean Ninjas client Black Hops Brewing invoices their wholesale customers on 1 July 2016 and the customer pays on 30 August 2016.
Cash basis – the sale would be recorded on 30 August as that is when the cash is received
Accrual basis – the sale is recorded in 1 July 2016 as that is when the sale itself occurred.
Both pieces of information are useful to Black Hops. The cash sale allows them to stay on top of cash flow but to work out whether their sales function is performing, the accrual report is more relevant.
Small businesses will often start by reporting on a cash basis as that is what makes sense. Accrual accounting is a more advanced method, but becomes important as a way of matching the revenue and expenses to determine margins.
Xero runs on an accrual basis, but you also have the option to run reports on a cash basis. You do this by selecting the ‘cash basis’ option in the report settings. Refer to screenshot above.Every business owner should know the difference between cash and accrual accounting. Click To Tweet
Failing to lock dates for previous financial periods
Xero is a cloud accounting system which means that data is live. This means that there is the potential for data to be deleted or for users to go back and make errors in periods where reports and tax have been finalised. If you don’t do it, you can potentially change the historical record of what has already been reported to the tax authorities.
You can prevent this by using the ‘lock dates’ feature of Xero. Locking dates should become part of your process each time a reporting period is finalised (usually monthly or quarterly).
To do this go to Settings / General Settings / Financial Settings. Then in the Lock Dates screen select a date in the ‘Stop all users making changes on and before’. If you had recently completed the June 2016 quarter then you would enter 30 June 2016, so that no changes could be made to data on or before that date.
Want help setting up a new Xero account?
Our full list of items to consider, and a handy checklist, is included in our free Xero Small Business Toolkit.
Why not save yourself some stress and have an experienced professional set up your Xero file for you? Find out more about our Xero Setup service.
We hope this has been a useful article. If you have any questions, please feel free to leave a comment below.
Originally posted 2016-09-26 11:31:24.
Latest posts by Meryl Johnston (see all)
- Startup Growth Report: Bean Ninjas 4th Year Review - 8 July, 2019
- Why bank reconciliations are critical! - 27 June, 2019
- Powerful Productivity hacks from 6 successful entrepreneurs - 27 June, 2019