Showing posts with label Small Business Software. Show all posts
Showing posts with label Small Business Software. Show all posts

Saturday, April 3, 2010

10 Financial Yardsticks for Your Small Business

Time and again, accountants and consultants who specialise in small businesses say that such enterprises don't pay enough attention to cash flow. That's the measure of how much money you really have in the business.

Be Wary of Big Contracts

"Small entrepreneurs wind up taking big orders that get them in trouble," says Ronald Lowy, who heads a college business administration department. "They want the big contract, but they're not getting enough money at the front end of it and they don't have the cash reserves to pay workers and other bills while they're waiting to get paid themselves. They might show a profit on an accrual basis, but from a cash-flow standpoint, they don't."

Judith Dacey, a certified public accountant, calls a cash-flow statement "probably the most important thing in telling you if your business is on or off target." As an example she describes how board members of a non-profit group were not examining their cash-flow statements.

"They were hiring people and spending money on membership campaigns, and doing all of these things based on money they thought they had from looking at the profit-and-loss (P&L) statements," Dacey says. "They didn't realise that the profit-and-loss statement was an accrual statement, which basically means you are including paper promises of payments to come, not money that you have in the bank."

The non-profit board became aware of the difficulty only when the organisation bounced a check. Employees had to be laid off, and belts were tightened. "That could have been avoided if they'd seen the cash-flow statements," Dacey says. "A cash-flow statement tells you here's the cash that has actually come in and that you can work with."

A statement of cash flow starts with the bottom of your profit and loss statement — the line that shows your net income. Several adjustments are made to that number. The details are a little complex but a good accounting program that does a P&L and a balance sheet will also calculate this statement for you.

Tracking the Big 10

If you've established a way to track cash flow, then you can go on to organise and track 10 financials for your business. That's a big list, but don't panic: As with profit and loss statements, you can take advantage of software programs to automate tracking for many of the following:

Your Assets

Tracking your equipment, furniture, real estate and other holdings should be easy. But to have a true idea of the value of your business, you also have to track changes in the value of those assets. More than one small business has found itself located on a piece of land that's worth more than the business itself. Similarly, you also will want to track the declining value of assets such as computers and office furniture.

Your Liabilities

On the face of it, this is easy — liabilities are what you owe. But what you owe isn't always as obvious as a bill from your landlord. Payroll taxes are a liability that depend on the size of your payroll. Loans are a clear liability, but in repaying them you'll want to be able to track how much of a payment is applied against principal and interest.

What does it Cost You to Produce What You Sell?

If you're buying a finished item for resale, this is relatively easy. It's trickier if you have to calculate all the factors, such as labour, that go into manufacturing a product.

What's it Costing You to Sell What You Sell?

Advertising, marketing, labour, storage and the catch-all category of overhead — it's useful to know how much it costs you to get a product sold as well as what it costs you to create it.

What's Your Gross Profit Margin?

This is calculated by dividing your total sales into your gross profit. If your gross profit margin is staying consistent or trending upward, you're probably on track.

Being able to track a declining margin can give you a heads-up that you must adjust your prices or your costs. In the worst cases your gross profit and profit margin disappear altogether. At that point, you'll be like the fellow who lost money on every sale but figured he could make it up in volume. Don't do it.

What's Your Debt-to-asset Ratio?

This ratio can let you know how much of the stuff you have in your company is actually owned by someone else — your lender. Having this ratio climb can be a bad sign. It can happen as part of a major expansion, but it can also indicate that you're getting in over your head.

What's the Value of Your Accounts Receivable?

This is the money you are owed. If accounts receivable are on the rise, you may be getting a warning that the folks you sell to are starting to stumble.

What's Your Average Collection Time on Accounts Receivable?

This is probably one of the most aggravating pieces of information for cash-strapped businesses, because it tells you how many days you're acting as 'banker' for the people who owe you money.

What Are Your Accounts Payable?

The flip side of accounts receivable. An increase in your accounts payable may merely reflect a larger amount of purchases overall. But an increase that hasn't been planned or managed can be an internal warning that your company's financial strength is waning.

What's Happening With Your Inventory?

There are occasions, even in this just-in-time business world, when building up a significant inventory can be a good thing.

If prices for items you sell or use in production are relatively low, putting some of your money into inventory may make sense.

Being able to track your inventory can tell you whether business is increasing or slowing down. It also tells you how much money is tied up in this unproductive asset.

Knowing what's up with your cash flow is essential to your business. But sometimes the figures can be difficult to understand. Don't ever be afraid to turn to professionals for some help.

Monday, March 22, 2010

7 Ways to keep Customers Coming Back to Your Site



You've built a website. Wonderful! The next question to ask is this: Once you get a visitor's attention, how can you bring them back?



Of course, you don't want every visitor returning, but rather customers and potential customers. Articles and other content published on your site should be relevant, interesting and well written. Unique content will give your site a better chance of reaching targeted visitors through search engines.



Here are seven ways to keep customers coming back to your website:




1. Run short-term specials. Internet users love a bargain, and sales are a sure way to capture attention. Use short sales periods to motivate people to act — giving them three months to make a decision will just help them avoid making the decision to buy. Let users know that the items on offer are always changing to encourage them to visit your site regularly. And get creative with your specials. For example, consider giving away a free gift rather than just cutting the price.



2. Make your site topical. Internet users often look online to learn more about interesting topics in the news. Creating a link between your business and a hot news story can be a great way to attract visitors to your site. This is a common tactic used by public relations firms to get media coverage, and could work equally well for you.



3. Update information regularly. Why would a user want to return to a website that rarely changes? Keeping your information up-to-date sends a message to visitors that your company is current and serious about doing business.



4. Hold a competition. This is a great way to get visitors excited about your website and what you do. Consider asking users for feedback, so that it doubles as a market research tool. Prizes don't need to be extravagant, but should be fun and appropriate for your target market.



5. Send out an e-mail newsletter. This popular promotional tactic is an effective one. Don't expect to build a list of thousands of subscribers, but focus instead on building a high quality list of targeted readers. When sending a newsletter, keep it short and informative. Promotions are expected, but don't overdo it.



6. Join niche e-mail groups. If you have the time, participating in a targeted e-mail list is a great way to connect with potential customers and keep reminding them about your business. Participation in a group works best when your company services a niche market. For example, the owner of a pet store might join a mailing list for pet owners. By participating as an expert, the storeowner is able to promote his business to a community of prospective clients.



7. Know your customers. An understanding of the needs and goals of your clients is the best way to ensure that your marketing efforts are effective. Statistics and tracking reports will help you gauge the interests of visitors to your website. Website usage statistics will help you understand how people come to your site, and what they do once they have arrived. Are they finding what they want, or do certain pages on your site trigger them to leave? Was the contest you ran successful? This understanding will help you hone your online marketing efforts.

Saturday, February 20, 2010

5 Tips and Tricks for Using Word for Business

<p><b> Handy features can save you time and money </b></p>
<p>Most people don't use every feature built-in with their software applications. We tend to pinpoint those we find helpful and call it a day. <br>
  <br>

Here are five features within Microsoft Word, the word-processing software in Microsoft Office that I use in my business to save time and money. <br>

</p>
<ol>
  <li><strong>Create and design your company's letterhead, choosing from an array of free clip art from Microsoft. </strong><br>
      <br>
    One thing every business needs is official letterhead. You don't have to buy it. If you know the design you want, you can create it in Microsoft Word and save it as a template to use time after time. <br>
    <br>
    Creating a letterhead doesn't have to be complicated; it can be as simple as the company name, address and telephone number. Word provides a wide variety of fonts, and you can vary type sizes. <br>
    <br>
    You may want to add art to your letterhead. You can scan in your logo and use it in your letterhead. Or there is another option. <br>
    <br>
    Microsoft maintains a huge collection of free clip art. For instance, if you want to add a flower, Microsoft has more than 1,000 designs. The clip art collection is available to registered users of Word. You'll find it at Microsoft Office's Design Gallery Live. <br>
    <br>
    Microsoft also offers free templates for letters, labels and forms. They're located in the Template Gallery. (Most run in Word, although some require other software programs. For example, the project management templates require Microsoft Project 2000 or a later version.) <br>
    <br>
  <li><strong>Send the same letter to many people without addressing each separately. </strong><br>
      <br>
    Sometimes you need to make an advertising pitch to all of your customers. Or you want to announce a change in your staff. This can seem daunting but it doesn't have to be. Word's Mail Merge tool simplifies things greatly. <br>
    <br>
    Basically, Word uses a list of names and addresses from a table. The table can be created in Word, in Microsoft Access or even in Microsoft Outlook. All are part of Microsoft Office. <br>
    <br>
    This obviously works best with planning. You'll probably need a database and Access is the better way to go for that. But the learning curve here is much steeper than putting everything in Excel (also part of Microsoft Office). I'll use Excel as the example but keep in mind that you have more choices. <br>
    <br>
    Start this process with your letter. The same letter goes to everyone; you can't do a lot of customisation. When you write the letter, leave space for the person's address and the salutation. <br>
    <br>
    When setting up Excel, you obviously need the person's name and address. You'll also need a salutation field. If Rocky Jones is one of the people receiving the letter, you might want the salutation to be Dear Rocky. If your relationship with Dr. Rocky Jones is more formal, the salutation might be Dear Dr. Jones. So the names in the Salutation column would be "Rocky" or "Dr. Jones." <br>
    <br>
    Next, open your letter. Click Tools &gt; Letters and Mailings &gt; Mail Merge. Follow the wizard's directions on the right side of the screen. To select recipients of your letters browse to your list of contacts in Excel, Outlook or another database. <br>
    <br>
    In addition to letters, you can address envelopes and labels with Mail Merge. It can make life a lot easier. <br>
    <br>
  <li><strong>Add a watermark to a document so everyone knows that it is a draft. </strong><br>
      <br>
    If you are circulating a proposal to your staff, you don't want it mistaken for the finished product. A good way to avoid that is a watermark that says "Draft," "Confidential," "Sample" or anything else you'd like. <br>
    <br>
    A watermark is clearly visible on the document, but does not damage the legibility of the writing. You can even establish it in a variety of colours. <br>
    <br>
    You can also use a picture for a watermark. Suppose you run a flower shop. You can use a drawing or picture of a flower that would appear on everything you print. How cool is that? <br>
    <br>
    To use the watermark, click Format &gt; Background &gt; Printed Watermark. Make your selections and click OK. If you expect to use a watermark regularly, create a template (see No. 1 above). <br>
    <br>
    Remember that there is a fine line between cool and irritating. If people must struggle to read the document because of the watermark, they may give up. Be sure you have "semitransparent" or "washout" selected. <br>
    <br>
  <li><strong>Keep an eye on changes that people are making to documents. </strong><br>
      <br>
    When a sales plan or another document is returned to you, it is sometimes difficult to see changes made by others. Word has a simple way to show them to you. <br>
    <br>
    Here are the instructions for Word 2002/2003: First, open the newer Word document. Click Tools &gt; Compare and Merge Documents. Browse to the original Word document. Click it once to highlight it. In the lower right corner, click the drop-down box and select "Merge Into Current Document." <br>
    <br>
    For Word 97/2000: Click Tools. Go to Track Changes. Click Compare Document. Find the original Word document and click it once so it is highlighted. Click Open. <br>
    <br>
    Sometimes, the development of a document is so arduous that we lose sight of what we're trying to do. Looking back at previous versions can help. <br>
    <br>
    That's easy to do in Word. Click File &gt; Versions. Select "Automatically save a version on close." Every time you close the document, that version will be saved. <br>
    <br>
    When you want to look at an old version, follow the same path. All of the versions will be listed in the box. The most recent will be on top. Highlight the version you want and click Open. <br>
    <br>
    You can turn off this "versioning" feature by clearing the check mark from "Automatically save a version on close." Or, you can delete individual versions. Just highlight the ones you want to dump and click Delete. <br>
    <br>
  <li><strong>Use a shortcut for many of your tasks. </strong><br>
      <br>
    For some tasks, I can work faster using the keyboard than the mouse. You probably know the standards: Ctrl+C to copy, Ctrl+V to Paste, Ctrl+Z to Undo, Ctrl+A to Select All and Ctrl+P to Print. But here is a list of other shortcuts you might find helpful as you use Word. <br>
    <br>
  </li>
</ol>
<table cellspacing="0" cellpadding="0">
  <tr>
    <td width="166" valign="top"><p><strong>Keystroke </strong></p></td>
    <td width="456" valign="top"><p><strong>Result </strong></p></td>
  </tr>
  <tr>
    <td valign="top"><p>Alt+Ctrl+C </p></td>
    <td valign="top"><p>Copyright symbol </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Alt+Ctrl+Period </p></td>
    <td valign="top"><p>An ellipsis </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Alt+Ctrl+R </p></td>
    <td valign="top"><p>Registered trademark symbol </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Alt+Ctrl+T </p></td>
    <td valign="top"><p>Trademark symbol </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+B </p></td>
    <td valign="top"><p>Bold text </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+E </p></td>
    <td valign="top"><p>Centres a paragraph </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+End </p></td>
    <td valign="top"><p>Skips to the end of a document </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+Enter </p></td>
    <td valign="top"><p>Inserts a page break </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+F </p></td>
    <td valign="top"><p>Opens the Find menu </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+G </p></td>
    <td valign="top"><p>Go to a page, bookmark, footnote, table, comment, graphic or other location </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+H </p></td>
    <td valign="top"><p>Opens the Replace menu </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+Home </p></td>
    <td valign="top"><p>Skips to the beginning of a document </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+I </p></td>
    <td valign="top"><p>Italics text </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+N </p></td>
    <td valign="top"><p>Creates a new document </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+S </p></td>
    <td valign="top"><p>Saves a document </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+Shift+F </p></td>
    <td valign="top"><p>Changes the font </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+Shift+P </p></td>
    <td valign="top"><p>Changes the font size </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+U </p></td>
    <td valign="top"><p>Underline text </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+W </p></td>
    <td valign="top"><p>Closes adocument </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Ctrl+Y </p></td>
    <td valign="top"><p>Redo the last action </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Esc </p></td>
    <td valign="top"><p>Close an assistant or tip window </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Shift+F3 </p></td>
    <td valign="top"><p>Changes the case of letters </p></td>
  </tr>
  <tr>
    <td valign="top"><p>Tab </p></td>
    <td valign="top"><p>Move between cells in a table </p></td>
  </tr>
</table>

Wednesday, January 27, 2010

4 tech must-haves for your mobile office

<p>Everything changes when you trade in your desktop for a laptop and your office for a hotel room. </p>
<p>Sometimes this is for the better: You're liberated from your cubicle and free to go where your work takes you. </p>
<p>But sometimes things change for the worse. Productivity suffers when you're in an unfamiliar place. The way a laptop keyboard cramps your hands is sometimes enough to keep you from getting the job done right. </p>
<p>Here are four technology "must-haves" for the mobile office, plus some tools that can boost your productivity while you're away. </p>

• <b>The Right Software </b>
<p>It isn't just downloading the necessary applications onto your laptop or PDA, it's also knowing whether the programs are suited to a mobile office. Is your email program built for the road or adapted from a bigger application meant for a corporate network? Do the programs work together on your laptop or do they freeze when your processor gets busy? </p>
<p>These considerations can become big issues when you're travelling. That's something Tab Stone, a doctor from Los Angeles, knows all too well. He installed a new email program on his laptop before leaving on a recent trip, but it wasn't suited for mobile use. He had to uninstall it shortly before takeoff, but that disabled his backup email program. That meant he couldn't download any messages to his PC. "I could not fix whatever was corrupted with either a fresh download or a copy downloaded from the internet," Stone recalls. </p>
<p><b>The latest: </b> Contact-management software programs let you integrate data with your PDA, so you can download and synchronise contacts, calendar appointments and notes to your Palm Pilot or Pocket PC. There's also a web-based version for travellers who either lose their laptops or prefer to work from a desktop at their destination. </p>

<p><b>What's next? </b> Look for more integration between applications for wireless users. Contact managers are already assuming the role of email program, address book and database. The next step is making it more accessible to people who are using cell phones or PDAs. </p>
•<b> The Right Hardware </b>
<p>I'm not talking about owning the newest laptop computer. I'm talking about hardware that's created for life on the road. Let's face it: A lot of the gadgets on which mobile professionals depend aren't made with travellers in mind. For example, when Joachim Martin's laptop battery ran out on a recent flight, a helpful flight attendant offered to recharge it in a "secret" outlet in the back of the plane. "The batteries charged," remembers the software developer. "But when I got home, they were dead." The power source had to be replaced. Blame the airline, the battery manufacturer or even the unfortunate business traveller for not knowing better, but this kind of thing happens often. Phone plugs don't always fit; neither do power outlets. And a lot of the gadgets we rely on are traveller-hostile, impractical or both. </p>
<p><b>The latest: </b> Some hardware manufacturers are meeting the demand for traveller-friendly hardware with add-ons such as the Stowaway XT Keyboard. I've also been impressed with Microsoft's Mini Optical Mouse, which frees you from the restrictions of your laptop's finger-cramping pointer. </p>
<p><b>What's next? </b> As the convergence between cell phones, PCs and PDAs continues, it wouldn't surprise me to see devices that offer the ergonomic comfort of a desktop with the portability of a PDA. It won't come a moment too soon for many road warriors. </p>

• <b>The Right Connections </b>
<p>Connections are everything to the mobile office. </p>
<p>Remember Stone, the doctor without email? He eventually accessed his messages through an unwieldy web connection. Spencer Field, who recently returned from a trip to Melbourne, can also tell you about email trouble. He learned upon arrival that the dial-up numbers to his internet service provider (ISP) didn't work. "I thought that was probably the end of my online access," he says. "As a last-ditch effort, I let my fingers do the walking and checked out the Melbourne Yellow Pages for a local ISP." He found one and signed up for a one-month email account which gave him access to local numbers on his entire itinerary. </p>
<p>It isn't just internet connections that matter, but also hooking up to other devices such as cell phones, PDAs and laptops. Technologies such as Bluetooth let you communicate with other devices in an office or hotel room without the need for cables. </p>
<p><b>The latest: </b> According to a recent AT&amp;T study, the top barrier to working from a remote location is access to a high-speed data connection. Fast wireless networks are springing up everywhere — in hotels, airport lounges and coffee shops. And even though Bluetooth got off to a slow start, the concept behind it — which is to lose the wires — is fundamentally sound. </p>
<p><b>What's next? </b> It won't be long before Wi-Fi is as ubiquitous as cellular coverage and a majority of devices are Bluetooth-enabled. That's good news for those of us who work in a mobile office. </p>

•<b> The Right Web Applications </b>
<p>Web-based applications are so important to the mobile office that I've decided to give them their own category, even though they technically belong in the "software" section. The web is one of the most efficient ways for a mobile worker to gain access to a back-office system, intranet or database. </p>
<p>My ISP offers a rudimentary application that lets me check my email from the web. I can't remember how often I've had to use it because my email program failed to work properly. But I do remember the last time. I was stuck at a meeting out-of-town and my email account had sustained a spam attack — thousands of unsolicited messages — that would have taken hours to download. Instead, I logged on to the web and deleted them all in seconds. Were it not for the web application, I would probably still be downloading the spam. </p>
<p><b>The latest: </b> One of the most innovative Web applications is GoToMyPC , which lets you access the desktop in your home or office through the web. Another useful application for mobile users is web conferencing services such as Microsoft Office LiveMeeting. </p>
<p><b>What's next? </b> Expect these applications to become cheaper, more reliable and even more sophisticated. </p>