When bank feeds were first introduced they were lauded as a software feature that would save small businesses hundreds of hours of work per week and they have definitely saved time, despite the apparent risks that have been published about how they can compromise your internet banking security.
It almost seemed like Xero was giving you $27.50 of extra value when they announced their $2 per month increase last week. These effects take effect on 18 March 2020 but not everyone wants Hubdoc and competitors like QuickBooks already offered similar functionality!
Xero has had a love/hate relationship with bookkeepers ever since the days when they promoted their accounting software as so easy that small business owners could use it themselves – without the cost of a bookkeeper – and it looks like they are well on their way with this mission. Continue reading Xero going up a pesky $2 rather than $27.50
THE DEFINITION OF a training course has changed a lot over the last 20 years. With new online internet technologies comes new ways of learning. The concept of the “micro course” is gaining momentum as students look for information when they need it, known in the industry as “just in time learning”.
There are lots of time and cost pressures for students as they juggle part-time work, kids and mortgage payments. As a result, we’re launching a brand new Online Training Service for past EzyLearn students AND new students — EzyLearn’s Video Training Library Membership.
The payment plan for the MYOB AccountRight COMPLETE Training Course package for $20 per week has proven to be popular and is still currently available. Better still we’ve just launched a payment plan for the Bookkeeping Academy COMPLETE COMBO – that means you can pay a low weekly fee of $20 and receive training on EVERY major accounting program in Australia, from Beginners’ to Advanced!
The dollar is tanking, trade is down, house prices are still going down, consumer spending is the lowest for a decade, wage growth is slow! It sounds pretty bad when you read the news and business articles isn’t it?
One thing I’ve noticed for sure is that course prices are going down and competition is increasing, not just from other physical training centres in Sydney, Melbourne and Perth but also larger US and overseas companies who will promise anything to make a sale!
We’ve always prided ourselves on offering low course prices direct to students and now we’ve gone a step further.
In our educational guide, Bookkeeping Beginner Basics, which you can download from the EzyLearn website for free, you’ll learn how to record journal entries in your accounting software, whether you’re using MYOB, Xero or QuickBooks. Most bookkeeping newbies don’t know what a journal entry is, though, which is what this blog post – the latest in our Bookkeeping Beginner Basics guide companion series – is going to help you to understand.
The journal vs. the general ledger
An accounting journal is the record that keeps accounting transactions in chronological order (i.e., as they occur), while the general ledger is a record that keeps accounting transactions by the account – see our previous post on the chart of accounts [Bookkeeping Beginner Basics: The Chart of Accounts] if you need help understanding what the term ‘account’ means in this context. Before computers, bookkeepers used to log all the financial transactions of a business in paper journals, and then at the end of the month transfer these journal entries into the general ledger, which was divided into various accounts that is now called the chart of accounts, and all the transactions were posted to these accounts using a method called double-entry bookkeeping.
Journal entries using accounting software
Today, however, accounting systems, such as MYOB, Xero, QuickBooks and the like, will automatically record most business transactions into the ledger immediately after the software prepares sales invoices, issues cheques to creditors, or processes receipts from customers, and as such you don’t have to create journal entries for most of your business’s transactions.
That being said, some journal entries still need to be processed, in order to record transfers between bank accounts and to record adjusting entries. You would need to make a journal entry, for example, at the end of each month to record depreciation or to record interest accrued on a bank loan.
If journal entries and general ledgers and the double entry bookkeeping method sound a bit too much, and you think you’d rather stick to the cash-based accounting method instead, prepare yourself for bad news: all businesses, whether they use the cash-based accounting method or the accrual accounting method, use double-entry bookkeeping to keep their books, and all accounting software applications, by default, are set up to adhere to the double-entry method, too. The double-entry bookkeeping method reduces errors and also ensures that your books balance, so as complicated as it may seem, it’s much easier in the long run.
If you still feel a little out of your depth, however, you can hire a reliable bookkeeper to manage your bookkeeping system and deal with all the journal entries and double-entry business for you, instead. Visit the National Bookkeeping website for to find a highly qualified bookkeeper whose experience and skills suit your business needs.
This blog post is part of our Bookkeeping Basics series, which are being published to complement our new educational guide, also titled Bookkeeping Beginner Basics, which you can download for free from the EzyLearn website.
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.
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.