Excel for Small Business Owners

As a confirmed excel nerd, there is something about large amounts of data that I am inextricably drawn towards . I suppose it has something to do with an affinity for organization combined with a love of numbers and the innate desire to solve problems. As an accountant and financial consultant , I am often presented with the task of organizing and analysing data into a format that allows for greater insight into my clients businesses . And although good accounting software is absolutely necessary for any small business owner, a significant amount of analysis and reporting is done most effectively in excel.

Read More

GST and QST Considerations For New Business Owners

The Goods and Services Tax or GST is a consumption tax that is charged on most goods and services sold within Canada, regardless of where your business is located.  Subject to certain exceptions, all businesses are required to charge GST , currently at 5%, plus applicable provincial sales taxes.  A business effectively acts as an agent for Revenue Canada by collecting the taxes and remitting them on a periodic basis.  Businesses are also permitted to claim the taxes paid on expenses incurred that relate to their business activities.  These are referred to as Input Tax Credits.

Does Your Business Need to Register?

Prior to engaging in any kind of commercial activity in Canada, all business owners need to determine how the GST and relevant provincial taxes apply to them. Essentially, all businesses that sell goods and services in Canada, for profit, are required to charge GST, except in the following circumstances:

Read More

9 Tips For Managing Your Customer Receivables

Having Accounts Receivable i.e. amounts owing by customers is both good and bad.  It's good because it means that you have sales and customers.  It's bad because it is cash that you don't have now, and there is always a possibility that you won't collect.  When you offer credit terms to your customers it is extremely important to have a system in place to manage your accounts receivable.  It is difficult to collect amounts due when you don't actually know how much you are owed or when it is due.  Having the information at your fingertips  (this really relates to any kind of information) also makes a great impression. Below are some steps to help manage and collect on your accounts receivable:
Read More

4 Metrics to Help Improve Your Small Business Cash Flow

In a recent study by TD Bank Financial Group it was determined that one of the primary challenges facing small business was cash flow (The other two were managing clients and government red tape).  This probably comes as no surprise to most small business owners, especially in the early stages.  Of course, the simple answer to this problem would be a limitless source of cash.  (Of course if we had unlimited funds, we may not find it necessary to endure the trial and tribulations of business ownership).  Since this is usually not possible, we need to do the next best thing: analyze our cash flow requirements and find the most cost effective and easily available solution for any shortfalls.  Even the most successful business can find itself shutting its doors if it is not able to manage it's cash flow needs. 

Below are 4 financial metrics, which if monitored regularly, can actually help improve your business' cash flow:

Read More

NeatDesk Scanner: Effective Bookkeeping Tool?

As an accountant, I occasionally (literally) get shoeboxes of documents from my small business clients.  Receipts are stuffed in and scrunched up and comprise everything from gas (good) to toilet paper (bad).  As I contemplate the mind numbing exercise where I will have to sift through everything, identify missing information and worst of all, enter it all into an accounting software (usually Quickbooks), I often feel a sense of dread.  I've often fantasized about a tool that could do it all for me (of course I could outsource, but since I only have a handful of these types of clients, it is not worth it, yet...). So, when I saw an ad for the Neatdesk scanner (shown ad nauseum on CNBC), I felt a little bit of glee as I perceived a potential solution to (at least part of ) the problem. 

Read More