Excel Accounting Services
  • Home
  • Services
  • About
  • Blog
  • Contact
Family Fun
May 17 2020

3 Easy Steps to Effortless Paperwork for Your Business

Angella Uncategorized 0

As an accounting/bookkeeping provider, I’m frequently met with people frantically trying to pull together receipts and find missing papers to take to their bookkeeper or accountant – often in the last days of the tax season.

I can hear you thinking it now… “Yeah yeah, I know what you’re going to say. Keep your banking accounts separate, keep your receipts organized, blah blah blah”. I’ll let you in on a little secret… I’m with you. I roll my eyes every time I see those tips and tricks or “helpful” advice given out by a bookkeeper. Of course we all know we should keep our receipts. Of course we all know to track our mileage, never use our personal credit card for business expenses… and vice versa. Then real life sets in – and that’s not always as easy as it seems. Like most people, I like easy – and so do my clients. So here are a few easy ways to keep yourself organized with minimal effort and no stress.

Receipt Organization

Find an app like Receiptbank and buy a subscription. Yes, it’s a few extra dollars a month – but the time, hassle and headache it saves you will more than make up for it. Once Receiptbank is downloaded to your phone, you can snap pictures of receipts on the fly as you go about your day. Bought coffee for the office? Snap. Submit it to Receiptbank. Oops – paid for your groceries with the company card? No worries… snap and upload it. You can code it to owner’s draws. That meal with the client at the restaurant… take a picture. No worries about losing a piece of paper, either. CRA will accept digital copies of your receipts, so no more worrying about dropping or losing the receipt. Additionally, Receiptbook comes with its own email that can be provided to vendors to allow them to email invoices directly into Receiptbank. From Receiptbank, invoices and receipts can be coded and posted to your cloud based accounting system with the click of a button. Receiptbank isn’t the only option. There will be others available depending on your needs.

Mileage Logs

The bane of proprietors, salespeople, and employees everywhere. The dread mileage log. Hop in the car. Write down the mileage. Is this business or personal? Arrive at destination and record mileage. No wonder so many people just… don’t… do it. I don’t either. However, Intuit has recently added a new function to their Quickbooks Online app – automatic mileage tracking. Just… get in your vehicle and drive. When you arrive, you should probably pull out your phone, click the app, and swipe right for personal or left for business so it’s fresh in your mind, but you can do it later if you like. And that’s it! Mileage tracked!

Bank, Credit Card, Payment Processor Statements

While most small business accounting packages will link directly to your bank account and download transactions and match them up, some will link to your bank account and pull the statements as well – although the banks they work with are limited, and they don’t seem to work with the payment processors (like Stripe or Paypal). However, there are other apps on the market that will do that as well – Hubdocs, for example, will link to your bank accounts, your Paypal accounts, Stripe, and many other payment providers to download your transactions and statements for you – the catch being that you do have to set them up for e-statements for it to work.

With cloud based accounting and the range of business applications providing affordable services, remaining organized is not only possible, but even the busiest of us can do so with ease as we go about our daily lives.

Lawyer
May 8 2020

Trust Accounting in the Legal Industry

Angella Accounting Tips, Legal accounting, Trust accounting bookkeeping, law firm, legal accounting, rust accounting, trust reconciliations 0

Trust accounting, as any lawyer will tell you, is one of the two most critical pieces of accounting in his practice. The other, tracking billable hours and costs, may cost him money if performed incorrectly, but the repercussions of inadequate trust accounting can mean the end of the responsible lawyer’s career! Clearly, it is important to get this correct.

So, what is so special about trust accounting in the legal industry?

ALL MONEY IN THE TRUST ACCOUNT BELONGS TO THE CLIENT AND MUST ONLY BE USED FOR THE BENEFIT OF THE CLIENT

Trust accounts are set up differently from operating accounts and maintained differently from operating accounts. While all banks have bank fees for all business bank accounts, the fees for a trust account must be withdrawn from the operating account. If the bank does happen to make a mistake, this must be rectified immediately! Any shortages, including those fees taken by the bank, will need to be reimbursed out of the operating account when necessary to ensure all client monies are intact at all times.

About trust accounts, the types of accounts, and disbursements of any interest earned

A law firm will usually have a pooled trust account with mixed funds from various clients. This account may earn interest – but any interest received on this account does not belong to the clients or to the law firm. Interest earned on this account is to be remitted to the Alberta Law Foundation. They may also have a separate interest-bearing account that is maintained on behalf of a specific client. This account would be used in particular circumstances such as real estate transactions. Any interest earned on this account must be recorded and is to be disbursed to the client with the regular trust monies.

Special Reconciliation Considerations

When you reconcile the operating acount or, indeed, any other bank account, you merely reconcile the bank account and the general ledger to ensure they both match. However, trust accounts actually require a 3-way reconciliation. While you still need to ensure the GL and bank accounts reconcile, you also need to maintain a trust ledger detailing the source of all monies received, all monies paid out (payee, cheque number, client name/file number, and balance) and this ledger must also always remain in balance with the GL and bank account balance. A trust account reconciliation must be completed and signed off by the responsible lawyer within one month of the statement date. If this is not done in time the responsible lawyer must file for an extension with the law society. Failure to comply with this can cost the responsible lawyer his license to practice law, so clearly law firms are extremely particular about ensuring the accuracy and timeliness of all trust account reporting.

Additional trust records to be maintained

Not only must a trust reconciliation and trust ledger be maintained as above, but all law firms most maintan a ledger of all transfers between the trust ledger accounts, a general journal detailing all transactions, a billing journal/ledger, bank account statemnts containing duplicate deposits and negotiated cheques, a receipt book, in duplicate, recording any cash payments received by the client, record of cash payments made to the client (including client signature of receipt), and a detailed accounts receivable ledger showing all bills, receipts, and running balance for each client. These items, with the exception of the trust ledger account (which must be maintained in a format capable of being printed on demand) must be printed every month. In the age of digital technology, printing to pdf format is considered acceptable. This must be maintained for 11 years at the place of business.

The adequacy of record keeping for a trust account – and the necessity of ensuring that all funds held on behalf of clients are in the trust account at all times, including, if necessary, replacing funds out of the firm operating account for bank errors, NSF deposits from clients if funds have been disbursed on behalf of the client, and any other shortages however they happen – is paramount to all law firms and should be taken with extreme seriousness.

Bookkeepers working with law firms need to ensure they understand and comply with these rules at all times – and they need to be certain to immediately contact the responsible party should anything unexpected occur in this account!

Theft Control
July 9 2018

6 Theft Controls Your Business Should Be Implementing

Angella Accounting Tips, Controls, Employee Theft Controls, Employee Theft 0

Recently, my attention was drawn by another local bookkeeper being arrested for fraud. In this case, the bookkeeper had managed, over a period of six months, to embezzle $275,000.00 from the company she worked for, and the police believe there may have been other victims!

$275,000 over a period of six months. That’s crazy! That will destroy most small businesses, and a lot of mid-sized ones as well!   We all want to believe our staff is honest, but the sad truth is that if you leave an opening for theft, somebody (not everybody) is going to take advantage of it.  Ideally, the person who helps you with this is your bookkeeper, but clearly that is not always the case.  So, what steps can we take to protect ourselves?

Protect Your Bank Account

Do not allow unfettered access to your bank accounts.  Not ever.  If your bank will allow you to set up templates – use them.  Limit where and how your AP staff can send money.  Set up a second approving authority.  If you do not want to do it yourself, and you are too small to have a second accounting staff, consider hiring an outside controller.  Talk to local bookkeeping or accounting companies to see if they have the ability to serve in this capacity.  The cost for this can be quite affordable – and definitely cheaper than fraud if it occurs.  Have a person not responsible for entering and paying bills perform the bank reconciliations.  Again, you can use an external service for this if you are a small business.  Do not allow any employee sole signing authority on your bank account.  Either you sign, or two employees sign, with a third employee (or external party) reconciling accounts.

Reconcile and Review Everything

Again, if necessary, hire an outside service to oversee this.  Vendor statements should be reconciled.  Customer statements should be reviewed.  Suspicious revenue reversals should be questioned, as should suspicious payments.  All bank account transactions should be reviewed to ensure they make sense.  In the case of the person mentioned above, she wasn’t even that smart about her theft – she received email transfers, deposited them into the company bank account, then transferred them out to her own account.  A simple review of the bank transactions would have instantly caught this large amount of money being stolen!

Inventory Counts

If you are conducting regular inventory counts, you can catch discrepancies and monitor for employee theft.  Have service store clerks count high value, high theft items (lottery tickets, cigarettes, etc) at the beginning and end of each shift.  Implement periodic inventory counts to ensure acceptable loss levels.  If the loss starts to increase, conduct more frequent counts – and try to narrow down a reason for the loss.

Implement Cash Controls

Count cash yourself, or have a second person count cash in a designated area that is monitored by video surveillance.  Watch for cash shortage trends.  Implement a POS system that scans barcodes into a system.  This system can also be used as a double check for inventory counts to help reduce theft.

Use Purchase Orders

Requiring the use of purchase orders makes it more difficult for employees to engage in fraudulent purchases.  Monitor the purchase orders.

Control Vendor and Customer Set Up

Allow only one party, not the party entering invoices and printing cheques, to set up new vendors and customers.  This will prevent the employee from fraudulently sending goods or submitting false invoices from a fake vendor for payment.

Ultimately, when it comes to protecting your business and your assets from unscrupulous employees, we should hope for the best – honest employees – but prepare for the worst.  It can make the difference between success and failure for your business.

Why you need a bookkeeper
July 5 2018

5 Very Good Reasons Why Your Business Needs a Bookkeeper

Angella Accounting Tips, New Business accounting tips, Bookkeeper, edmonton, small business bookkeeping 0

Why do you need a bookkeeper?  Many small business owners ask themselves this critical question.

Two words:  time and money.

A qualified bookkeeper can save you both.  OK.  Time is a given – and wouldn’t you rather spend your evenings enjoying your family, friends, and hobbies than dealing with a pile of paperwork after working all day on your business?  How much money is that downtime worth?

But I said a bookkeeper would save you money!  So how do you save money by spending it on a bookkeeper?  Well, a qualified bookkeeper does more than just crunch numbers so you can pay your taxes and keep CRA off your back (although that is important of itself).

Managing Profit Margins

A qualified bookkeeper is an active partner in ensuring the success of your company.  Your bookkeeper can help you keep an eye on profit margins – and bring your attention to depleting profit margins.  This can allow you to take proactive measures to bring your profit margins back in line and keep your company on track.

Managing your obligations

Your bookkeeper will keep you current with vendors and government remittances.  This means reduced interest, reduced penalties, and, when it makes sense, this can allow you to take advantage of early payment discounts – putting money back into your pocket.

Managing your income streams

Your bookkeeper can help you manage your credit granting processes.  It’s a great feeling to get the job but, let’s face it, in the business world, a job well done is not its own reward.  Getting paid is!  Your bookkeeper can manage your receivables, ensuring only worthy clients get credit and making sure you get paid for the work that is done.

Managing your cash flow

Your bookkeeper can keep a critical eye on incoming and outgoing funds and help you ensure you always have cash on hand to meet your obligations.  This means no sudden credit card use, your debt and lines of credit can be managed, and you don’t have to scramble to make payroll.  Your bookkeeper will help you make sure you have it in the bank.

Processes and Controls

All businesses, whether large or small, need processes and controls.  Your goal is grow your business, but a business that grows without implementing controls and truly understanding their numbers, profits, and ratios is at risk of failing from too much of a good thing.  Processes and controls, implemented at the start, allow any small business to take advantage of opportunities as they present themselves and be well situated to handle their growth seamlessly.

The question isn’t “Why do you need a bookkeeper?”  The truth is that you can’t afford to be without one!

WIP
July 1 2018

Work in Progress in the Construction Industry

Angella Accounting Tips, Construction Industry, Work in progress 0

Work in progress is a method of valuing inventory or projects in progress at the end of a reporting period.  In the construction industry, this calculation allows you to monitor the progress of your jobs and the cash flow relevant to them, provides a method for more accurately ensuring your costs remain on track through the life of the job, and ensure costs and revenues are adequately matched, which provides a consistency in financial statements that will provide a sense of comfort to banks and lenders.

A work in progress report compares the costs incurred, the costs anticipated, and the contract value, allowing the business owner to monitor his project and know immediately if his project is incurring major cost overruns, figure out why, and correct the issue before the project becomes a major money drain.  The larger the project, the more difficult these cost overruns can be to spot – and the more likelihood of them becoming major disasters.

A work in progress report allows a business owner to analyze his billing practices, ensuring he is not underbilling and causing cash flow shortages for himself.  Similarly, during negotiations with the contractors who, in an effort to keep their cash flow healthy, will often dispute the completed portions on a progress invoice a work in progress can allow a subcontractor to confidently support his billing position.

Because a work in progress provides a method for allocating revenues to the months the costs are incurred it eliminates wild swings in profitability.  This consistency keeps lenders comfortable – which can be important when you’re trying to finance a major project.

Without a work in progress, it is virtually impossible to be certain of your margins or your profitability.  Large material purchases at the start of a project that have not been used can drastically reduce profit margins.  Consistent inadvertent overbilling can lead business owners to believe they are far more profitable than they turn out to be when the project is done.  This misinformation can lead to decisions that cause stress on a business.

And, finally, at tax time a work in progress calculation can prevent the business owner, who is in an overbilled state, from paying taxes on a profit that he doesn’t really have.

Work in progress is critical to the informed decision making of any construction professional, especially the business owner trying to expand his market – as most of us are.

GST Logo
June 27 2018

Registering for GST. Should I, or shouldn’t I.

Angella GST applying for a GST number, Bookkeeping tips, GST, Small business tips 0

Many new business owners ask themselves this question.  While you are not required to apply for a GST number if your revenue (not profit) is less than $30,000 per year, that does not mean you shouldn’t.  In fact, I recommend that you do – and here’s why:

Let’s say you make a sale of $100.00.  You collect GST of $5 on it.  It costs you $50 in materials to make that sale – and it is likely that your supplier does charge GST, so you pay $52.50.   GST filing time comes around and you subtract the $2.50 you paid from the $5.00 you collected and give the government the remaining $2.50.  This leaves you with $50 profit in your pocket before taxes.  If you pay 30% tax on that, you are left with $35 cash in your pocket after taxes.

Now, we look at the same transaction if you have no GST number.  You still make a $100 sale but you collect no GST, and it still costs you $50 in materials to make that sale.  Your supplier still charges you GST on that material, so you pay $52.50, and you simply record the total as an expense.  There is no GST to file and at the end of the transaction you are left with $47.50 pre-tax profit.  After paying your same 30% tax on these funds, you are left with a remaining after tax balance of $33.25.

As a new small business owner, you want to keep as much money in your pocket as humanly possible!  Why give it to the government if you don’t have to?

Cash flow
June 21 2018

Cash Flow vs Revenue

Angella Accounting Tips, Analysis, Cash flow cash flow management, Revenue vs cash flow 0

I have had business owners, baffled, ask me “Why does my income statement show I’m making money, but I have none in my bank account?”

And that’s a very good question. Why does it look like you’re making money, yet your bank account is low, or even overdrawn? There are a number of things that could be causing this – and we’ll touch on a few of them here.

Holdbacks – these are a cash flow killer in the construction industry. If you are following my earlier advice and recognizing the revenue for the holdbacks, there will be an increased discrepancy between cash flow and profits. Make sure you review your uninvoiced holdbacks regularly, keeping in contact with the client to ensure you invoice this money as soon as possible.

Accounts Receivable turnover – Great! You’ve made the sale, but it is even more important to collect it! If it is taking too long to collect your money – if a large segment of your receivables are over 90 days – you are heading for trouble. Make sure you stay on top of your receivables – or better yet, implement good credit granting and management policies right off the bat. Bad customers can kill a viable business quickly, costing them the time and money to provide goods and services they never receive payment for.

High inventory – sure you need to keep inventory on hand, and there may even be value to buying larger than necessary quantities in terms of volume discounts – but keep a close eye on the turnover rate to ensure you are maintaining a balance between the inventory you need, the price you’re paying for it, and your cash flow. Having inventory in hand can help speed up production, but the inventory can’t pay the lights or salaries. Make sure you maintain sufficient cash flow levels.

Revenue recognition and underbilling – in the construction industry, it’s often a negotiation between the subcontractor and the general contractor as to how much of a project is complete for billing. If you are underbilling, your cash flow will suffer. A properly completed set of records in the construction industry includes WIP, which will properly allocate revenue to costs, but make sure you keep an eye on the WIP. If your WIP is consistently adding revenue to the bottom line, you are likely underbilling your jobs.

These are just a few of the reasons for discrepancies between cash flow and revenue. Some others may be heavy shareholder draws and personal spending, acquisition of large assets, and a heavy debt load – the principal portion reduces cash, but not your income.

If you are having cash flow issues, you should be sitting down with your accounting provider to determine exactly what the cause is and how to minimize it. Your business may depend on it.

June 21 2018

Break-even points. What are they? Why do they matter?

Angella Uncategorized 0

A break even point is, quite simply, the point at which the business is making enough in sales to pay for its fixed costs (ie rent, utilities, admin staff) and the variable costs (wages and materials) required to make those sales.

This number, calculated by dividing either the contribution margin per unit (to calculate required sales by unit) or the contribution ratio (to calculate required sales by dollar) by the fixed costs, provides the business owner with an all important base ratio upon which to formulate plans and make decisions.

Take, for example, the small business person who is considering an expansion or large purchase. He will need to understand his base break even point, and understand how much more he will need to sell to pay for the purchase or expansion before he can determine the likelihood of meeting these new levels.

This calculation can also be used when preparing the annual budget to help the business owner aim for a particular profit margin.

.

Holdbacks
June 21 2018

Revenue Recognition for Holdbacks in the Construction Industry

Angella Uncategorized 0

Holdbacks provide a particularly interesting challenge in the construction industry. They tie up 10% of your cash – 10% of your profit margin – before you even leave the gate, forcing many contractors and subtrades to carry a line of credit from the bank to allow them to accept those lucrative contracts. Often, I see this 10% deducted, not only from the invoice, but from the revenue as well. While not technically incorrect, you can provide a much stronger financial picture to the bank by simply adjusting this revenue recognition policy.

When progress billing a job, revenue for the entire completed work should be recognized at the time of the billing; the holdback should be deducted – and tracked in a holdbacks receivable account on the balance sheet. This not only gives you an immediate 10% boost to your revenue in the financial statements you provide to the bank, but it allows you a foolproof method of tracking your holdbacks to ensure you never miss invoicing those important funds. And don’t worry – your accountant will defer the revenue at tax time so you don’t pay taxes on it before you absolutely have to.

May 18 2018

Hello world!

quang Uncategorized 0

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Excel Accounting Services
©2018 Excel Accounting Services
Powered by: Social Hero Media