Welcome to “Accountants Nanaimo”!

Why such an odd name for a website? Well, I chose this name for a very specific reason. When business owners are looking for an accountant in Nanaimo, whether for bookkeeping, corporate tax returns, an audit, or just for someone to fill a temporary part-time accounting position, chances are that they will go to their favourite search engine and type in “Accountants Nanaimo” or “Accountants in Nanaimo” or some similar phrase. My guess is that is what you did, and here you are!

Accountant's best friend!

Accountant's modern convenience

I operate an accounting service providing temporary, part-time accounting help to companies/organizations of all sizes: from one-person shops to publicly-held corporations. If you are looking for a public accountant or auditor I would suggest a local public accounting firm serving businesses similar to yours.

From this point on, I’m going to assume that you are looking for someone to come into your office on an as-needed basis for any of the following:

  • Maternity leave
  • Vacation/Sick leave
  • Year-end or Quarter-end
  • Sudden vacant position
  • Interim Controller/Accounting Manager
  • Mentor/Coach to train a junior accountant to take a more senior role
  • Internal audit
  • Complex reconciliations
  • Financial analysis
  • Special one-time projects
  • Custom Excel solutions using automation with VBA

Did I miss any services you require?

The first question I hear you asking is “What are your qualifications?” I’m glad you asked; this is where I get to test my tuba! I am a professional accountant (Certified General Accountant) with close to twenty years experience in companies ranging in size from a local HVAC contractor to a multi-billion dollar multi-national. I have worked in many temporary/contract positions in diverse industries and held accountancy positions from clerk to controller.

Your second question is probably “Do I need an accountant with a designation?” The answer is, of course, that it depends on what you want done. My guess is that about 90% of the accounting work done in a typical small to medium size business (SME) is repetition – the same kind of transactions processed, the same reports generated, etc. As long as the person you get has experience with that level of work, you should be fine not bothering with a designation. The remaining 10% is what I call the “Oddball Sector”: transactions, reports, analyses, processes, and procedures which are not repeated often; ins and outs of commodity taxes; streamlining and finding efficiencies; mentoring/training junior staff; and other things that I will think of later when I am trying to sleep. Although there is no guarantee, a designated accountant will most likely have relevant skills/experience in those areas.

Another question people ask is “I have heard of (this) designation and (that) designation; how many are there and what’s the difference?” Here in Canada there are three professional accounting designations: Certified General Accountant (CGA); Chartered Accountant (CA); and Certified Management Accountant (CMA). All three have a demanding program of study (same or very similar courses) and rigorous examination and experience requirements prior to certification. CAs can get their education only through university programs. CGAs and CMAs can work full-time while taking their courses – a more attractive option for many who have financial responsibilities to meet while upgrading their skills. CAs and CGAs may enter public practice as employees of auditing firms (or as self-employed practitioners) or be employed in industry in whatever capacity the employer requires. CMAs usually get employed in a manufacturing environment and serve the cost accounting or management accounting needs of the company.

One of the things I noticed in every place I worked is this: people do something a certain way because that is the way it has always been done. The first example that comes to mind is a $10M family-owned wholesaler where I worked as Accounting Manager. The senior accounting clerk would print a blank cashflow projection Excel worksheet and then use a handheld calculator to calculate the balances and fill in the blanks with a pencil. That is what she was taught to do. At a $10M subsidiary of a large multi-national, the accounting manager used a worksheet to calculate the inventory value instead of using the inventory module for which the company was paying an annual license fee. A municipality with about 15,000 citizens was using simple Excel worksheets to track their fixed assets. A $100M logistics company tried tracking their fixed assets the same way; they lost track of three $150,000 trucks and several other assets. A medical services company had trouble tracking their intercompany transactions and lost track of $800K; a multi-billion dollar construction company had a similar problem and lost track of $5M. This list could go on for awhile, but I’ll stop there.

My favourite technology for finding more efficient ways of doing things is VBA. This is Visual Basic for Applications and comes installed in Microsoft Office products. There is a learning curve, but Excel VBA is your best bet for getting more done with less staff. You can automate many tasks: generate reports at the click of a button; extract data from an external database, import it into a preformatted Excel worksheet, update linked reports and send them to a list of Outlook recipients – all with a single click, or get the whole process to run on a specified schedule; and much more.

Another thing I noticed is that SMEs have accounting staff which tend to stay for the long haul; they are taught their jobs a certain way, and with a year or two of formal training behind them they generally have little experience to draw on when faced with the “Oddball Sector.” If a company grows, the accounting requirements will grow too, but not to the extent of needing additional staff; rather the company needs the current staff to take on more work and more complex work. The problem is, of course, who is going to train them? Since this is new work, they can’t rely on “This is the way it has always been done.” This is where I come in. I can train your junior staff to take on a more senior role; I would be available for a Q&A session on a weekly basis and coach them into becoming accountants.

I have been thinking about my Unique Selling Proposition (USP) and this is what I have to offer you: a broad range of accounting experience coupled with two passions: one, coaching, and two, using technology to drive efficiencies.

That’s about it for now. Take a look around and let me know what you think.

Did you know that every business in Canada which claims Input Tax Credits (ITCs) on their GST/HST returns are required, by law, to check the GST Registry for validity of each vendor?

If you read this article about GST audit risk you will readily understand the need to eliminate the risk of having to pay penalties and interest for claiming input tax credits from non-validated vendors.

SMEs usually approach this problem (if they even know about it) by:
1. ignoring it and hope they are not audited
2. taking a sample of invoices/vendors and check the GST registry
3. assign this time consuming task to the most junior person on staff

Well, I have some good news! There is a fourth option: let my free utility do all the work – on autopilot. Put all your vendors in a list, start the utility, select the number of vendors in your list, and click “GO”. You can now take your lunch break and when you return your report will be complete. You will have a list of vendors which did not pass through the CRA web site check; you can then follow up with the vendors to get accurate data. You can also file digital images of all the results from the CRA web site instead of having to print them and file all those hard copies each month.

If you think this is something your business can use (what business wouldn’t!) simply

click here to subscribe to our newsletter

and I will send it to you right away.

Steps to Creating a Survey Form:

  1. What data do you want to collect? If possible, create questions with Yes/No answers using radio options; or use checkboxes; or select from a list; or fill in blank (textbox); or large comment area (textarea).
    Create an html file and name it “collectdata.html”; insert this code:

    Customer Satisfaction Survey Form

  2. Prepare the form to pass data to the php file, and create the php file.
    Change the first line in the code above to:
    form action=”sendmydata.php” method=”post”

    Place the file on your web server.

    “Sendmydata.php” will be the name of the php file; create a file on your web server with the name “sendmydata.php” and insert this code: (replace XXX code)

    $con = mysql_connect("localhost","XXXdb_username","XXXdb_password");
    if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("XXXdb_name", $con);
    $sql="INSERT INTO XXXtable_name (Q1, Q2_1, Q2_2, Q2_3, Q3, name, email, comments)
    VALUES
    ('$_POST[Q1]','$_POST[Q2_1]','$_POST[Q2_2]','$_POST[Q2_3]','$_POST[Q3]','$_POST[name]','$_POST[email]','$_POST[comments]')";

    if (!mysql_query($sql,$con))
    {
    die('Error: ' . mysql_error());
    }
    echo "Your message has been received and stored in a database.";
    mysql_close($con);
    ?>

  3. Create the database, table and fields to accept the data from the php file.
    Go to the CPanel in your web hosting account; select “MySQL Database Wizard” under “Databases”. Give your new database a name; click “Next”; create a username and password for your new database. Click “Next”; select “Insert” privilege only; click “Next” and “Return Home”.

    Under “Databases” select “phpMyAdmin”; select your new database on the left.
    The database is empty so create a new table. Give the new table a name and the number of fields is 8; click “Go”. Now we create the 8 fields we need to accept the data from the php file. Click “Save” after entering the following:
    Satisfaction Survey Form
    Now we add a field at the beginning of the table to hold a unique identifier for each record to take care of the warning “No index defined!” Select this:
    Customer Satisfaction Survey Form
    Click “Go” and fill in the following:
    Customer Satisfaction Survey Form

    Click “Save”. Now create one more field to stamp each record with the date and time received:
    Customer Satisfaction Survey Form

    Click “Save”. Table structure should now be like this:
    Customer Satisfaction Survey Form

  4. Go to the web page with the form (collectdata.html) and enter some test data and click “Send”. Now go into phpMyAdmin and check the result. Select your database on the left; select the table; click “Browse”; you should now see the test data you sent. Congratulations, you have created a web form and sent its contents to a database!

Do you need an easy to use, flexible Fixed Assets Register?

This asset tracking system is intended for anyone who has to keep track of assets in their employer’s Fixed Assets Register. With so many ways of doing business, is it any wonder that your company’s asset management software is not flexible enough to handle fixed assets the way you want? Add in annual license fees for an asset tracking module you don’t use and it becomes obvious why so many small to medium sized businesses look for an alternative. Depending on your business, there is a wide choice of options: from a simple Excel spreadsheet (a list), to an Access database with a user-friendly interface, to custom built stand-alone programs. My solution is somewhere in between the first two options: an Excel workbook using hidden functions, VBA, hidden sheets, and with a simple-to-use point-and-click interface (or you can stick with the keyboard only). No more copy and paste errors; no more bloated spreadsheets with dozens (or hundreds) of columns and thousands of rows to check and make sure all the formulas are correct; no more checking each asset to ensure depreciation hasn’t exceeded the original cost.

Steps to track your capital assets in your Fixed Assets Register:
One, use the Setup form to set your Preferences, Asset Categories, Depreciation methods/rates, etc.
Two, enter your assets one at a time using a user-form – or all at once using the Import function
Three, using the Find and Delete user-form, get rid of disposed assets – or fix an asset entered with an error
Four, run monthly/annual reports: Cost-Accumulated Amortization-NBV; Amortization Journal Entry data; Full List with Cost and Amortization; and more (fully customizable – let me know what you need)

There are two versions available: a free Trial version – play with it, test it out and see if this solution will meet your needs; and the (free) unrestricted full version with 10 asset categories, 5 depreciation methods, unlimited assets, and flexible fiscal year start. This (first) version was built using Excel 2003, so you should not have any problems using it in later Excel versions. At less than 500KB it is a small download. You are able to accumulate up to 20 years of depreciation data: you could, for example, enter assets purchased 15 years ago and still have 5 years ahead of you to use the Fixed Assets Register. I plan on building a more robust solution after getting suggestions for improvement/added functionality. Contact us to get the full version and you’ll automatically get any news on upgrades. Click here to get the PDF Help file.