Xero Tips & Integrations

When you haven’t got an automatic bank feed set up, here’s a quick guide on how to manually import the bank transactions… log in to your internet banking and download as a csv file open up the spreadsheet and delete any unwanted columns (the ones you want are date, description, amount - things like balance are irrelevant) save as a csv from the Xero dashboard, on the bank account you want to import a statement for, click manage>import a statement click 'browse' and select the csv you have just saved click 'import' you may need to assign some columns to the correct fields in Xero. The only two you must ensure are correctly assigned are date and transaction amount when the import is complete make sure the 'statement balance' per xero agrees to the actual balance per your bank statements in real life.  If it doesn't, let us know asap! repeat for any other bank account. Then you are free...

The problem - If you are currently a business owner or employee that has to travel for client meetings, to collect stock or a trip to the accountants, you will know the burden of recording the business mileage. First you have to write down where you start and where you are going to, find out how many miles this is and try to work out the ever changing fuel element of the mileage to work out the VAT. Then you need to send this to your accountant or enter this onto the system. This is something that takes up valuable time and has a lot of different factors that need to be checked each time you make a business related trip. The solution - We have a perfect solution to all the issues surrounding mileage claims and this is an app called 'Trip Catcher'.  The Trip Catcher app does exactly as...

Historically payroll has always been something that is completed separate from your accounts, ready to be entered in manually at some point (or left to your accountant to enter at the year end) and holiday calculations have always been a bit of a nightmare. But Xero have come up a with a new solution that is built into their existing online accounting software. If you are already using Xero (and if you’re not already using Xero - what are you doing?? Come and speak to us!), this is great news as it means everything is in one place and Xero payroll integrates with Xero accounting, which means no more manual entries. Day to day payroll needs are all provided for with flexible earnings, deductions, benefits and reimbursement pay types all able to be entered onto payslips, P45s that can be produced easily, and holiday entitlement calculated automatically. Also at the year end,...

I recently went down to London with Scott, where he was visiting a few of his clients to help them with Xero, amongst a few other things. This was a great opportunity for me to see a second round of Xero Training from the clients' perspective, what common questions were, and if they had progressed from their first sessions. Complex reporting & plan of action to fully move to Xero After a hectic race around the central underground line, we arrived at our first appointment 10.15am. This was a beautiful location, stone archways in the entrance and the main window, and based underneath the underground line. Processing using Xero had been great, and this was about looking at reporting features and tips on reviewing things in Xero to ensure accuracy of data. Firstly, a few questions on tracking categories and assigning projects to invoices - this feature allows you to easily track sales, costs & profit...

When I was invited to set up a small business on Xero I expected to be able to do it with my eyes closed. When I discovered that the business in question was an Australian trust that needed to file their Q1 BAS, and they were only in London for the next few days, I knew I had to be on top of my game. After first googling 'Q1 BAS' (so it's a bit like a VAT return, but more complicated, yet simpler!) we set the organisation up via the Australian Xero website and selected 'Australia' in the 'Where does this organisation pay it's taxes'. So far so good, and I was ready to play my first game of 'Aussie Rules'. Xero in Australia looks the same and feels the same as the UK Xero, but the labels to the boxes are a bit different, and there's a few more of them (and...

You took the great leap from spreadsheets to Xero for your general bookkeeping needs - you're adding purchase invoices, doing your sales invoices, reconciling your bank, and perhaps doing expense claims. But could you be using Xero more extensively?  Could it be helping you to do more by doing less? Tracking categories - this feature allows you to split results into categories, so you can compare how different sections are operating to each other.  This could be geographical location, different trades, different product lines.  The maximum you can have is two main categories with unlimited sub categories.  This feature will help you produce more meaningful reports that instantly highlight what areas of your business are doing well and which may need more attention. Inventory monitoring - this feature allows you to keep track of stock on hand and will automatically reduce/increase the stock items when sales/purchases are made.  The descriptions and...