We look at project management apps that integrate beautifully with Xero to keep your project within timeframe and budget.
FOR BUSINESSES WORKING on large projects spanning weeks or even months, keeping track of time, cash flow and profitability is imperative. This is even more so for businesses that work on fixed-rate contracts or tenders.
Such fixed-rate projects are common in the building and construction industry, but also the creative, engineering, and IT industries.
Many of these businesses manage a project’s workflow across a number of different documents (spreadsheets, their CRM, accounting software) — and many don’t manage it properly at all.
As a consequence, projects often come in over budget. A number of cloud-based project management and workflow apps aim to change that, however.
The sales spiels of many of the notable online accounting software packages like QuickBooks, Wave Accounting, Outright, Kashoo, LessAccounting, Clearbooks and even Xero, claim that this feature will save you time and effort as it imports your bank transactions. The truth is, this is not foolproof and won’t work 100 percent of the time (even if it’s just a matter of not being able to get your software and your bank to “connect” just as your mobile phone connection inexplicably doesn’t work sometimes).
Therefore, always double check your bank transaction data has been imported accurately. This said, importing your bank statement into Xero (or whatever accounting software you use) is a really important step in the bookkeeping process that a lot of business owners forget or don’t know how to do. And the technology is only going to get better!
Using the correct format
To import your bank statement into Xero, you must ensure it’s in the correct format. Xero can only work with a CSV file of your bank statement. Depending on your bank, you might be able to download your bank statement as a CSV file from your internet banking, or you will have to create one from scratch.
Creating one from scratch isn’t too difficult. If your bank doesn’t give you the option of downloading a bank statement as a CSV file, you can create one yourself in Microsoft Excel.
You can download an Excel template from Xero. It includes the recommended fields and is already set up as a CSV file, so all you need to do is add in your data.
Set transaction rules
Once you’ve created and uploaded your bank statement to Xero, you’ll need to set up transaction rules for recurring expenses. You’ll learn how to do this in our Cash Flow Reporting, Budgets and ROI Xero Course.
Setting rules for recurring transactions helps speed up the reconciliation process, which depending on the type of business you operate and how often you reconcile your account, can be the most time-consuming part of the process.
Importing your bank statement and creating rules for transactions that occur each week, month fortnight, year, etc, greatly speeds up this process.
No CSV? Use bank feeds
If your business has lots of expenses every week, and your bank doesn’t let you download your bank statement in a CSV format, you may find that manually creating one in Excel each month is too time consuming.
Set up bank feeds instead. Bank feeds is the process of linking all of your business accounts, whether they’re credit cards or bank accounts, to your accounting software, so that each time you make an electronic purchase, it’s automatically imported into your accounting software.
This will allow you to reconcile your account each fortnight, week or more frequently, if you desire, than once a month when your bank statement comes in.
Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points. NOW is the time to learn to use Excel, one of the most-used software applications in the world.
That’s not to say there are no expense apps that integrate with MYOB. There are. Receipt Bank is one, Squirrel Street is another, and there are probably a lot more on the MYOB marketplace (or add-ons page). Probably the best expense tracking application we found is ExpenseManager, and it only integrates with MYOB.
WE’VE ENTERED QUARTER 4 for the 2016/17 financial year, so we’ve been writing about the things your business should be doing this quarter in preparation for the end of the financial year. In our last post we wrote about writing off stock and inventory. Now we’re looking at business expenses.
In a previous post I suggested it’s a good idea to create a digital filing system for your business receipts and tax records. Storing tax records digitally is not just a space saver — it’s also an efficient way to share information with your accountant and bookkeeper, especially if you’re working with a remote bookkeeper, as it’ll speed up the process.
A HUGE PART of reconciling your bank account involves coding business expenses or purchases. You then need to keep a record of those expenses in the event you’re ever audited.
Our Xero Bank Reconciliations and Journal Entries Course covers how to code an expense or purchase in Xero, and it’s important to also store your receipts and get them to your bookkeeper if they’re working remotely.
Quickbooks is gaining traction in the Australian marketplace.
I’m a fan of QuickBooks as the functionality is excellent and the cost of the software is still low. I’m really pleased to announce that you can now enrol in our QuickBooks Online Daily Transactions Course — but does QuickBooks fulfil Australian legal obligations to be SuperStream compliant?
The background is that from July 1 this year, all Australian businesses with fewer than 20 employees were required, by law, to be SuperStream compliant.
SuperStream is a government initiative to improve the efficiency of Australia’s superannuation system, namely by making superannuation a totally electronic process.
Most cloud-accounting packages that have been developed for the Australian market (such as major applications, like MYOB, Xero, Reckon and so forth, but not smaller apps like Zoho or QuickBooks, which can be used in Australia but don’t interface well with Australian tax procedures) are now all SuperStream compliant, with one exception: QuickBooks. Continue reading QuickBooks Isn’t SuperStream Compliant, But It Doesn’t Matter!
Reconciling Your Accounts Daily Gives a True Picture of Cash Flow
The king was in his counting house, counting out his money… small businesses as well as large can get a true financial picture with daily reconciliation.
For a lot of business owners, just the thought of reconciling their accounts once a month is enough to make them go weak at the knees, never mind every day. Yet there are plenty of contract and remote bookkeepers who work for their clients each week, and some that work every day for the same client, reconciling their accounts and providing other vital bookkeeping services.
And they’re not just big businesses whose accounts are reconciled daily — plenty of small businesses do so too. In fact, with so many small businesses going asunder due to cash flow problems (often stemming from a lack of procedures in place for credit and debt management) it can be not only a cost-saver but a potential life-saver to your business. Continue reading Should You Reconcile Your Accounts Every Day?
Do You Have to Drop a Client Because of a Bad Credit Check?
It’s only business: but sometimes a bad credit rating doesn’t mean you have to end the working relationship.
A Credit Check is one of the most important first steps of good credit and debt management but you can still do business if the check comes back negative.
In a previous post on credit and debt management, I recommended that all businesses — regardless of whether they offer credit to customers on a 30-day account or not — perform a credit check on any new client who will spend more than $1000 on goods or services in one sale, on an ongoing basis.
What should you do if the credit check comes back negative, and shows that the potential customer is guilty of late payments, pending legal action or already carries a significant level of debt?Continue reading What if a Credit Check Comes Back Negative?
You can use your mobile phone to get paid – great for tradespeople as well.
No doubt about it, one of the biggest hurdles you face as a small business owner is managing your cash flow. A big part of this is ensuring your clients and customers pay your invoices on time.
If you’re working as a contractor and using an Australian business number (ABN), rather than a tax file number (TFN), you’re self-employed, and this means you will need to invoice your customers for the products or services you provide in order to get paid.
If you’ve only ever worked as an employee before, you’re probably used to being able to set your clock to payday, but unfortunately this isn’t often the case when you’re a contractor.
Getting paid late — or worse, not at all! — can seriously affect your cash-flow, and in turn, affect the success of your business, which is why we cover things like financial planning in our Small Business Management and Start Up Course.
We were recently surveying our PayPal account and discovered that you can now invoice customers directly using PayPal. While it doesn’t eradicate the need for a good piece of accounting software, this facility makes it very easy for people to get started in business — particularly businesses with very few expenses. Continue reading Invoice Your Customers Directly Using PayPal
This post has been created to demonstrate simple accounting principles for our MYOB Training Course students. It demonstrates, visually, a very simple fact that is often sensationalised.
I’ve been to many presentations, seminars and watched hundreds of webinars run by people who describe themselves as gurus yet the secrets they reveal are actually just plain old good accounting principles.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
