Tag » accounting system

Still confused about cloud computing?

It has been almost a year since I wrote my last blog post on cloud computing and tons has been written about it since – and yet I think the recent article on CMSWire.com that claims that small and medium sized businesses are still confused is right on the money.  So in honor of the one year anniversary of my last post I’ll take another run on the subject.

The simplest definition is still this:  if you use technology in your business without buying software and installing on your own hardware you are using cloud computing.    But what does that mean to a small or medium sized business?

More Technology is Available for Your Business

Think about all the technology you use or could use in your business – email, calendars, accounting and CRM software.  Once upon a time only large companies could afford applications like these.  If you wanted this functionality you had to buy the software, buy the hardware and maintain both, at considerable expense.  Today any size company can utilize these applications for a monthly subscription (or sometimes it is even free!).  This allows small and medium sized businesses to be more nimble and more strategic than ever before.

You Can Save Money

Not only can your business take advantage of the technology the big guys use, you can do it for a lot less money.  Since you are essentially sharing the application with others your cost is much lower.  Even better though is you don’t have to buy or support the hardware infrastructure these applications often require.  In fact, businesses that have already invested in servers and have to pay employees or service providers to support them can often reduce those costs or eliminate them altogether by moving to cloud applications.  Maybe your business requires some specialized software that isn’t available in the cloud – you may still be able to reduce your over all technology costs by running that application on servers in the cloud.  Amazon, Rackspace and others provide on-demand computing services and bandwidth which means you don’t need your own servers.  Companies like these are staffed by experienced folks dedicated to keeping the machines up, running and secure.

It Isn’t Magic

Cloud computing opens up a wealth of opportunities for today’s businesses.  Like anything else though, it is not a magic bullet.  There are costs involved and every business needs to look at their needs and make decisions to “go to the cloud” on a case by case basis.  There are access and security risks to consider and data integration challenges to address.  Talk to an experienced technology advisor about the opportunities for YOUR business.


Is your order-to-cash cycle too slow? And getting slower?


Creative Commons Attribution-Noncommercial-No Derivative Works 2.0 Generic License by  Lynchburg College Archives

Invoice, Chas M Stieff Manufacturer of G by Lynchburg College Archives, on Flickr

In today’s installment of my series on small business growing plains I am going to talk about the order-to-cash cycle.  When a business is new it is easy to get so excited about the first sale that as soon as an order is received or a contract signed the business owner immediately sends out the associated invoice or statement.  Those simple documents are full of symbolism for the nascent concern – you are for real!  You have real customers and can bring in real money!  Woo hoo!

The Order-to-Cash Conundrum

As you get bigger and busier it is easy to put off creating those all-important documents that a)represent potential income to your company and b) signal your customer to pay you.  Maybe you don’t have time to create them more than once a week, or worse, once a month.  All of a sudden getting paid is taking longer and longer.  Even if you get administrative or bookkeeping help you’ll likely settle on a set schedule for billing, perhaps once a week, that doesn’t jive with when you actually sold the order or the contract.

When you get even bigger and busier it can get worse – let’s say now you have sales people to sell orders or contract work.  Or that you have field service technicians that have to do the work that in turn leads to an order.  These guys have paperwork to get filled out and they may not be in the office every day so it is easy for that paperwork to be delayed and then, when it is finally turned it, it may be incorrect and require a cycle of rework.  Now your invoices and statements are even MORE delayed.  Add that to the fact that your customers aren’t always in a hurry to pay you right away and you suddenly have a cash flow problem.

How can you avoid or rectify this ever-lengthening order-to-cash black hole?

Order or Contract Entry

There are a number of ways to improve the order or contract entry process :

  • Keep your sales customer information in sync with your accounting customer information.  This can make it quicker and easier to set up a new account for billing and make sure you apply the order or contract to the correct billing customer.  You can keep them in sync thru manual processes or by integrating your customer relationship management system with your accounting system.  Some applications integrate easily, others may require some help from a technical resource.
  • Provide mechanisms to allow your sales or field service folks to enter contracts or sales orders online.  This can be as simple as having them upload a spreadsheet to a specified place to as fancy as an application that they can access remotely, maybe even from a mobile device.  The quicker you can get the contract or order entered into your billing application the faster you can get invoices out.  Where possible cut out paper altogether; if it isn’t possible to go paperless try to change your process to match paper to online records on the back end.
  • Incent your sales and field service folks to enter their information online quickly and correctly.  Quite simply, if you can’t bill your customer maybe they shouldn’t get paid.  Hmm, just a thought.

Invoice Creation

  • Simplify invoice or statement creation.  Avoid “special” invoices for customers and make sure any invoice or statement can be easily produced from your accounting software.  If your accounting software doesn’t do this you might want to look for a system that does or look for a billing system that integrate with what you have.
  • If you can put invoice creation on “auto-pilot” where it runs on a regular schedule all on its own, do so.  If you can’t, adjust the back office processes to create invoices on a regular, frequent basis.  How regular and frequent?  It depends on your cash flow needs but daily, if it isn’t a complicated process, might not be too often.

It is easy for the order, contract and billing processes to get in the way of getting the customer a timely invoice.  Beyond prolonging the time until you get paid, what kind of message does a tardy invoice send your customer?  That you are unorganized?  That their business isn’t important?

If you think there are ways to improve your order-to-cash cycle, contact your technical advisor.  He or she can help you review your current processes and talk about where improvements, both manual and automated, might be in order.

If you thought this post was helpful you may want to check out the rest in this series so far.


Are you addicted to spreadsheets?

Instructions by Arbron, on Flickr
Creative Commons Attribution 2.0 Generic License by  Arbron

Don’t act innocent, you know what I mean.  Spreadsheet software is oh so easy to use and so inexpensive (or even free).  You can use it to keep your company books, to keep your budget and forecast, to keep lists of customers, to create invoices, to create sales orders, reporting and analytics, inventory…the list goes on and on.

It is time for a spreadsheet intervention!

Following are the top 10 reasons you should stop and reconsider the use of spreadsheets in your business:

  1. Sometimes the creator of the spreadsheet doesn’t know what they are doing and the calculations are incorrect.
  2. If you make changes to values on a spreadsheet and save it you no longer know what the original value was.  Unless you saved a version off first, creating yet another spreadsheet.
  3. If you have lots of versions, on hard drives, in email, on various computers you have no single version of the truth – whose spreadsheet is right?
  4. Often the creator of the spreadsheet leaves it on the hard drive of the computer.  And often that hard drive isn’t backed up.
  5. While we are on the subject of security risks, what do you think happens to all those spreadsheets you mail around?  Any idea where they go?
  6. As you put more and more stuff into your spreadsheet the more unwieldy it becomes.
  7. As you put more and more stuff into your spreadsheet and make multiple copies because of versioning you are now eating up disk space.  Every day.
  8. They waste time.  If you pay someone to do a repetitive task in a spreadsheet, add up how much time they spend on it each week.  Then find out how much it would cost to automate that task.  The numbers are usually enlightening.
  9. The second you save the spreadsheet the data is old.  Inventory is not up to date, customer contact information isn’t accurate, accounts are stale.
  10. It isn’t scalable.  You can’t continue to use spreadsheets as an integral part of your business for very long without running into roadblocks from bad or inaccurate data or the sheer manhours required to keep up with them.  Your company will grow, I’m sure of it, and if you rely heavily on spreadsheets you will get mired in the muck at some point.
  11. You can’t easily integrate the data from one spreadsheet to another.  So you copy and paste date, duplicating it and opening it up to errors or staleness.

See I couldn’t stop at 10.  I could go on even further but I think I’ve made my point.

Today’s business owners are fortunate – there are software solutions for most business needs and small businesses can get great functionality for free or low-cost.  CRM systems to keep up with customers, accounting systems for your numbers, inventory application and the rest are plentiful, have great functionality and have been tested to ensure the data and information they produce is correct.

I am not a spreadsheet hater – I think there are good uses for spreadsheets.  One time financial or what-if analysis.  As a front-end to a database for more detailed analysis and reporting.  For lists.  But not as an integral part of running a business of any size.  Its just not good business.


Why does it take your company so long to set up a new customer?

The Tower of Babel

Retail and food service businesses probably don’t have this problem but service companies that are growing know exactly what I am talking about.  After identifying a customer, engaging in a protracted sales process, and wrangling over the fine details of the contract you are ready to begin providing services to your new customer, and better yet, start invoicing them.  But when you talk to the various parts of your company you realize it is all a lot harder than you thought.  Why is that and why does it take so long?

To answer that let’s look at a typical set-up a medium-sized company might have:

  • Your customer is hopefully already set up in your CRM system, at least as far as your sales folks are concerned.  You will want to make sure your customer service folks have them set up for their needs too.
  • You will want the new customer set up in your accounting system…
  • And your billing system..
  • And in whatever operational system(s) you use (consulting firms might have project management systems, shipping companies might have logistics systems, wireless carriers will have network systems).

Even if you don’t have individual applications for these functions, you still have people who have to know about the new customer and to adapt their internal processes to accommodate them.

So why would doing this take a long time?  If you are a smallish company it might not be too bad – you may have to update your various applications, spreadsheets or lists yourself or holler over to the guy in the next chair.  As your company gets bigger, however, you’ll likely start dividing the work functionally – you may have an accounting group or department, another for billing, another for sales, one for customer service and another one for the operational aspects.  Suddenly getting everyone on the same page, and better yet, with the same information, becomes a challenge.  As you become more successful and grow you may find that your automation has become fractured – some groups have grownup applications, some use spreadsheets or their own databases.  This uneven growth and lack of integration across the organization becomes more and more difficult to manage.  Which leads to increases in your cost to onboard a customer.  And, because every group updated their processes and systems manually you may have played “telephone” with important information like customer name, addresses, contact info, etc.  This in turn will lead to issues down the road doing analytical reporting about things like the profitability of a customer.

The good news is this not a new problem – millions of companies face this all the time.  Think of it as a good sign, a growing pain for a successful company.  It is a legitimate problem though and if left to get out of hand can bog a company down, making your organization a modern day Tower of Babel.  Here are some of the symptoms:

  • You have  ”bad data” – which is, generally in this situation, inconsistent data.
  • You miss key dates – for example your contact stipulates an SLA period for follow up on issues that never made it to customer service.
  • You notice frequent miscommunications with customers.  Or about customers.
  • You experience more the than usual instances of over or under billing.
  • Or your numbers aren’t what you expect but you don’t know why.

What can you do?  Here are some thoughts:

  • When you start to see these symptoms force yourself to take the time to stop and take a look around.  If you are still small you may be able to institute some policies and procedures that govern how new customers are set up.  Something as simple as a check sheet can go a long way to staving off problems.  Collaborating with lists and spreadsheets in the cloud might help as well.  Look at Google Docs, Zoho, Dropbox or the like.
  • Listen to your employees carefully for statements that indicate the symptoms such as “We’re doing business with ABC in two different offices and it is so hard to keep it straight.  Sure would help if they were set up the same in both places!”.  When you hear this ask probing questions to figure out why.
  • Take the time to document your processes.  Then review them and look for inefficiencies and opportunities to automate processes or integrate processes for which you already have applications.  As a bonus you’ll have training material for onboarding new employees!
  • Review the processes regularly, at least annually, as input into your technology plan and budget for next year.

Like I said earlier, this isn’t the sign of a “bad” company, just one that has grown by focusing on getting the job done and not “how” the job gets done.  And as you can see, taking a look at the “how” now and again can help you continue to grow.

Has your company experienced this growing pain?


Bad Behavior has blocked 106 access attempts in the last 7 days.