Top 10 Reasons to use Quickbooks over Simply Accounting

Written by on September 17, 2008 | Accounting Best Practice, QCDocs Best Practice

I get asked about bookkeeping applications a lot!  I’d say I’ve pretty much mastered three- Quickbooks, Simply Accounting and Peachtree (or at least Peachtree 2004 – haven’t used it since then).  Peachtree and Simply are very similer products and I guess this is why Sage (owner of both Simply and Peachtree) has decided to discontinuing developing Simply Accounting in the US…

Simply Accounting is very popular in Canada, I suspect because Sage has gotten Simply Accounting into all the educational programs… clever, clever!  See a QCDocs virtual Company stocked with demo documents coming to a school near you in the future!

Once you use Quickbooks; however, there’s no going back!  Which brings me to my top 10 list.

  1. The most common complaint I’ve heard about Quickbooks is that it lacks an “audit trail” ie. you can change anything and people will screw it up!  This isn’t actually true as you can turn on an audit trail that runs behind the scenes.  What it doesn’t do is clutter your General Ledger with all your mistakes- hurray!   Despite SOX, bookkeeping is still an art!  Getting it just right takes time and you need a system that allows you to aggressively pursue financial reports that really work well for your business.  Having to reverse corrective entries and repost is a disaster!  It makes the General Ledger look an absolute mess and sure you can retrace your steps but you’ve created a maze that no one can follow!  The Key- Good financial Close processes and lock down your month and QB’s does just that and QCDocs helps guide the process!
  2. Speed, speed, speed… everywhere from opening the program to navigating the program to report creation, Quickbooks does it in about half the time as Simply!  
  3. Period close processes.   I may need to retract my Simply expertise hat here as I still don’t fully get why they make this so complex… enough said!?
  4. Chart of Account Management and Merge- Quickbooks this is slick!  You can whip together a great set of financials with subtotalling managed entirely by indenting of accounts (watch out for posting to headers…a wee pet peeve of mine that produces ” ….- Other” accounts!  Merging redundant accounts accidentally thrown in there…see point 10!  S..t happens in accounting…give me tools to fix it fast!
  5. Stability… In 8 years of using Quickbooks almost every day I’ve only seen one legitimate crash.  Still recovered just fine so just by pure volume I have to give the nod to QB’s here!
  6. Multicurrency- Nice job here Intuit although it takes some getting use to as this is my number one area of Quickbooks training- Home Currency Adjustments!  I think Intuit Canada is still suffering from the bombardment of QB’s 2008 without a multicurrency version… well at least for a couple of weeks until “2008-Multicurrency showed up- ie. QuickBooks 2007 with 2008 payroll tables! LOL’s but thanks anyway as 90% of our Canadian clients do business in the States.
  7. Subledger integration- This a common accounting application problem that haunts auditors everywhere- why doesn’t the subledger tie into the General Ledger?  Accountants call it a reconciliation- I call it an “f-up”. Quickbooks is the first accounting application that I’ve seen that makes it almost impossible to have this problem occur… a few multi-currency issues in there that still cause it grief but superior to others by a long shot.
  8. Customer invoicing- Time and reimburseable expense flow through.  Combine what QB’s does with this and what QCDocs does with tying the time reporting and reimburseable bills and receipts together and you have customer billing heavan!
  9. Reporting- Quickbooks produces some amazing reports- my favorite are trended P&L and Bal Sh (would like to see improvements in cash flow reports but this is tricky for GAAP).  I like collapse to show a crisp R&D, S&M, G&A and Facilities for my tech companies to match public companies peers (facilities to be allocated accordingly).  Fast clean A/P, A/R and detailed P&L.  
  10.  Integration with third party software… was there any doubt- batch upload from QCDocs of bills and expense reports into Quickbooks is a thing of pure beauty and joy to every bookkeeper… Simply Accounting not so much…!?  It still works but there must be an easier way to do it… Quickbooks did it!? iif!  Time batch entry as well- slick!   I actually like how QCDocs syncs with Simply a bit better but I have to give the nod to Quickbooks!

Big forewarning– I’ve seen bookkeepers butcher QuickBooks too!  Good processes are key to any accounting application and this is where QCDocs comes in.  QCDocs forces good bookkeeping practices by driving Bill association with Bill entries (ie. robust subledgering and proper accrual accounting!) and same goes with customer invoicing!  Accounting applications should use AP and AR subledgers and minimize the use of General Journal entries and cash entries… and all will be well!

Tags: , , ,

BC Technology Startup in Journal Entries!

Written by on September 14, 2008 | Accounting Best Practice, Technology Startups

Note: All numbers & GST calcs are approximations and tax issues should be discussed with a qualified professional tax advisor!

Incorporate Business 
Dr. Incorporation Costs $1,000
Cr. Accrued Accounts Payable $1,000

Open bank and put in consideration for founder’s shares and some working capital
Dr. Bank $5,000
Cr. Shareholder’s loan 4,999
Cr. Common shares 1
Go to NCIX or Apple World and buy shwanky computer on credit card.  Go home and sign up for 30 day free QCDocs and crank out your first expense report using CSV download- Hey nice policy it reminded me to get my mileage and parking in there!!)
Dr. Computer assets $3,745
Dr. GST receivable 210
Cr. Shareholder payables $3955
Dr. Mileage & Parking expense $33.65
Dr. GST receivable 1.35
Cr. Shareholder payables $35
Few weeks later the legal bill for incorporation shows up… dam they never mentioned those Ministry of Finance charges and PST… what’s up with that… lawyers in the States don’t have to put up with that!?
Dr. Incorpation costs $250
Dr. Accrued Accounts Payable 1,000
Dr. GST receivable 119
Cr. Accounts payable $1,369
Set yourself up with payroll and bootstrap doing SR&ED eligible work for a while making monthly payroll remittances only.
Dr. R&D wages $5,000
Dr. Payroll expenses (just CPP if you own more then 40%)) 233
Cr. Shareholder payable $3,782
Cr. Due to Receiver General 1,451
Cut a cheque by the 15th of the next month to pay the Receiver General and pay the lawyers tab
Dr. Due to Receiver General $1,451
Dr. Accounts payable 1,369
Cr. Bank Account $1,451
Cr. Bank Account 1,369
Oh no cash running low better go convince Family, Friends or Angel you met at Bootup Labs to finance your build.
Dr. Cash $50,000
Cr.  Common Shares or Convertible Note (See Top 10 list)? $50,000
Carry on doing development only taking out what you need to live and file your tax return with SR&ED.  Remember to use QCDocs to track your time for SR&ED and bills/etc. along route so you can get Tandem Accounting to crank out some QB’s financials in a flash and shoot to Rolfe Bensen, Entrust or Strategix to crank out a T2 and T661for you.  Might call Ed Levinson who sits across from me at Bootup or Nick Arden somewhere along the line to tee up S
R&ED writeup!
Dr. SR&ED Receivable $22,825 (or there abouts)
Cr. Research and Development contra expense $22,825

Get a cheque up to 6 months later if you clear audits, etc. if applicable.
Dr. Bank Account  $22,825
Cr.  Cr. Sr&ED Receivalbe $22,825

Note: if you raise more money and do other stuff like marketing, business planning, etc. you will get the full benefit of the Proxy method for SR&ED and get even more money back!  Investors will be impressed that you can get extra mileage out of their investments and recommend you to their richer friends and you get more money.

Eventually you build some skookum tech and you get aquired by Google for obseen cash and you and your investors each walk away with at least the minimum $750,000 tax free capital gain for having developed such a successful qualifying small business corporation.

Tags: ,

Which Bank for a Tech Startup in BC?

Written by on September 13, 2008 | Technology Startups

Either Coast Capital or Vancity and a “no brainer” for startups for these reasons:

  1. Lowest fees by a long shot!  
  2. Affiliation with “Big Bank” because “we’re going to be a Big Company” is a myth- big banks don’t look at you unless you have more than $500,000 in your chequing account.  They will happily bring you on when you can afford them and even then it is questionable whether it is worth it given how far Vancity and Coast Capital have come in establishing a really good business banking offering…!  The exception is when your investors have some “relations”! LOL’s
  3. Online services are free (GST, payroll remittances, and viewing cleared cheques)
  4. Transactional history goes back forever not just 3 months like big banks.
  5. Easier to get credit line/credit card or other forms of financing if you need it.
  6. Exchange rates and wire transfer rates are better although everyone uses Globex anyway.
  7. Fully Quickbooks, Simply Accounting and QCDocs compatible of course!
  8. Great service!  I’ll give the nod to Coast Capital as I personally bank with them.

Big bank order of preference:

  1. TD Bank (because of TD Waterhouse- easier to setup US ops)
  2.  Bank of Montreal (overdraw services is great but only for big companies.)
  3. CIBC- I still haven’t figured out their online statement system yet.
  4. Royal Bank- unless you establish debt with them they won’t give you an account manager?

US Banks

  1. Toronto Dominion NY, NY (if with TD only)
  2. Bank of America (Pain free experiences)
  3. Citigroup (Personally bank here but limited Corp experience- big is good presumably but suppose subprime exposure should be checked for all US banks.. see 1.)
  4. Silicon Valley Bank (I’d love to recommend these guys as dealt with them lots over the years when I was in Bay Area and back in Vancouver but their online system is unreal and they still got nailed although I think it was an E-Trade problem?

Top 10 Tips for Bootstrapping a Tech Startup in Canada

Written by on September 11, 2008 | Technology Startups

  1. First and foremost be building technology that qualifies for SR&ED (Scientific Research & Experimental Development Credits”!  Let’s just say you’re building something that all you’re buddies with comparable technical backgrounds would be impressed with ie. “Peer test”  How this works is you do the qualifying work, pay the developers/scientists, file your corporate tax return (T2) and up to 6 months or so later (for first time filers), you get a cheque in the mail from CRA (Canada Revenue Agency) even though you may not have even generated any revenue yet… sweet!  Several caveats so see my Top 10 things you need to understand about SR&ED!
  2. All nice but you have to pay everyone first and wait 6 months after you file…need some working capital!? Well, given that you’re doing, or think you’re doing cool, qualifying tech- go hammer on the door of NRC-IRAP (National Research Council- Industrial Assistance Program).   If you get through their sniff tests you can get typically 50-75% of your developer/scientist salaries comp’d (employees get higher % so plan accordingly!!).  A cheque will come every month following the month after you incur the costs!  They audit you so get a good bookkeeping system going- we recommend QCDocs!  See top 10 things you need to know about NRC-IRAP Programs! 
  3. Okay now things are looking hopeful!  With NRC contract (actually NRC will want to see this first so timing needs to be perfect!) in hand go talk to Mom and Dad or your rich Uncle, also known as a Friends & Family round!  Treat them just like regular investors and you’ll go a long way! Now hopefully you’ve got enough cash to get a development program started!
  4. Now enroll for GST with quarterly filing!  While you’re losing money guess what- you get your GST back for everything you pay GST on- ie. Legal fees, cellphone, mileage, meals & entertainment (only 1/2 though!), office supplies, etc.)  File each quarter and get your cheque!
  5. Now you need some space- work from home!  (Note: rent is backed out of SR&ED proxy so getting swanky office in Yaletown not good for Bootstrapping!)  Alternatively find a good incubator- I recommend Bootup Labs for obvious reasons!  Danny, Boris and Jordan have it going on so try to squeeze on in!  SFU Time Centre is good as well across the street at downtown campus!  Part-timers use Workspace in gastown!
  6. If you work from your apartment where you’re paying rent/mortgage interest then apportion a reasonable amount of space out and get some of that rent, utilities, etc. deductible!  Some tricks here so see my top 10 Tax tip links
  7. Telephone- oh my dear god don’t get me started!  Get a cheap Rogers home phone plan with call forward! Get 1 or 2 cellphones and start the juggling act or better yet get skype and never leave your desk!  Whatever cell phone plan you do get call every 3-6 months to find out what discount they are offering that they don’t volunteer until you call…baaah!? 
  8. Health Benefits- MSP is what it is so no help there…pay your monthlies personally to minimize T4 taxable benefit pains at year end!  Hook up with and get low cost insurance for risky stuff- ie. long term disability, AD&D, critical illness and life insurance ($12-$25/month) plus a Personal Health Spending Account (PHS) for $25-$50/month.  The PHS program is cool as it allows you to pay using after tax dollars for utilization items like prescription drugs, dental work, contact lenses and everything else covered by the tax act with no “deductibles and restrictions” often bundled with insurance packages.  You just go online, enroll, set your thresholds up for your employees and they just log in and submit their receipts and get reimbursed.  You’re company gets billed monthy and builds up a trust account that you can pull back into the company if you don’t use it all!  Sweet!
  9. Bookkeeping- Do it yourself using excel and a shoebox!  If you believe your time is better spent building your technology/core competency and you don’t want an outrageous year end tax bill that grinds your SR&ED refund then think twice!  Guess what, technology is fixing this problem too!   Shameless self promotion for our sister firm Tandem Accounting Group Ltd.  powered by QCDocs!  Point your mail to PO Box # and receive all your mail by “email” while simultaneously having all your bookkeeping requirements maintained in QuickBooks.  All your accounting, HR and legal docs are filed online for your ease of reference with a virtual A/P setup and maintained through your own QCDocs Portal! Each month you use QCDocs to manage your expense reporting using CSV uploads from your online credit cards where you put all your startup expenses so you can maximize your air miles or cash dividends!  Developers log their time in QCDocs timetracker to document time for NRC-IRAP and SR&ED compliance requirements.  The lovely and talented Tamara, Lindy and Gail take care of the rest spitting out your cheques/payroll when and where you need them and firing you investor ready financials each month.   Cash management Monday reports keep you bootstrapping along!  Negotiate partial pay in equity… the owner is a bit of an entrepreneur himself!
  10. Bank with Vancity or Coast Capital to minimize egregious bank charges  – see top 10 list of recommended banks.

Tags: , , , , ,

Top 11 Compliance and Setup things to do for BC Startups

Written by on September 8, 2008 | Technology Startups

  1. Register your business here. Note: Most Lawyers don’t do trademark searches just Provincial name searches. Check US and Canadian Trademark sites to size things up or count on doing this process all over again in short order!
  2. Phone 1-800-959-5525 and Register for GST (if you’re going to be losing money initially) and Payroll (if you’re doing SR&ED work!). See top 10 GST lessons and top 10 SR&ED lessons!
  3. Setup a bookkeeping system (See QCDocs)- Expense reporting is key process at this stage. See Expense reporting top 10 list!
  4. Buy a shoebox, binder or file folder and stuff all your receipts, bank statements and CRA correspondence files in it or use QCDocs and have a virtual bookkeeper take care of it. See top 10 Manual Filing Systems
  5. Open a Bank Account as soon as possible to simplify separation of expenses between personal and business. See top 10 bank lessons. Get cheques with stubs and complete the stubs and don’t lose any- write void on voided cheques so they are accounted for! Business accounts return cleared cheques or copies of them- never, never lose them as there is no replacements (except copies (ie. Vancity and Coast Capital))
  6. Buy bookkeeping software- Quickbooks- no brainer, see my top 10 list why Quickbooks is better than Simply Accounting. Try out Clarity accounting as well… and tell me if it is good!? Looks good to me but haven’t tried it yet!
  7. Go online and register for WCB (the earlier the better so you can get “no claims” history for when you actually need to hire people.
  8. Continue to pay MSP (BC Medical Services Plan) personnally until you have at least 5 employees as it is a taxable benefit and will complicate your payroll.
  9. Sign up for VIPMD Personal Health Spending Account Pay for dental cleanings, prescriptions, contacts, massages with aftertax dollars!! Sign up for your “Risk Insurance” at the same time- see top 10 lessons about Canadian extended Benefits Plans!
  10. If you’re going to raise some financing from BC investors enroll here as an EBC. This will give your investors 30% tax refund for investing in your business- nice start!
  11. If you’re doing tech stuff call the NRC-IRAP to chat about helping you out. See top 10 lessons about Government funding

Tags: , , ,

« Previous Page « Previous Page Next entries »