Calling for Nominations

Submit Your Nominations for the 2012-2013 Sage Small Business Accounting Solutions (SBAS) Gold Development Partner of the Year Awards by Friday, May 31, 2013.

At Sage, we value the contribution of our Gold Development Partners and feel strongly about recognizing them for their contributions. These partners strive to provide you with an exceptional customer experience in utilizing their products that interface with the Sage suite of solutions. In order to recognize Development Partners most deserving for their efforts, Sage needs to hear from you, our partners.

We are asking that you take a moment to rate any of the Development Partners you have worked with or have purchased solutions from in the last year. Please rate all partners that you have had experience with.

Begin the brief survey

All surveys are due by May 31, 2013.

This survey has been designed to be quick and easy. Thank you in advance for your time and response, as this information will help us to best identify those partners who can serve as models for our entire partner community. Your participation is greatly appreciated.

The winner will be announced at the 2013 Sage Summit conference.

 

Product Feature -The Daily Business Manager

The Daily Business Manager (DBM) can function like a dashboard, centralizing access to many types of transactions, as well as providing you with business performance information such as current cash balance data and other financial ratios.

Using the current calendar, DBM provides timely details such as due dates and discounts available for pending transactions. Convenient batch processing is also available through DBM. Transaction types include:

  • Payments due.
  • Sales receipts.
  • Pending purchase orders (convert to invoices).
  • Pending sales orders (convert to sales invoices).
  • Recurring transactions.
  • Customer, vendor, or employee memos.

You can configure the DBM to open automatically when you start Sage 50 Accounting or when you change the session date. Go to User Preferences to manage the settings.

DBM is located on the Business Assistant menu or as an icon at the top of any navigation screen.

Sage Summit

You’re too busy; how could you possibly attend Sage Summit? 

As it is, you’re working 50+ hours each week; work-life balance is a dream you only experience with your eyes closed, and you’re probably feeling stretched too thin. What’s worse than that, maybe you think your clients are feeling the strain, and worried about retention becoming an issue long term.

At Sage Summit we have just the type of sessions to help you change your “Overworked” status. There’s something for everyone. Just browse through the Sage Accountants Network Recommended Session Guide to easily identify sessions that will help you maximum your time at Sage Summit.

Register today for Sage Summit, and don’t forget, Sage Accountants Network members who register before May 31 pay only $395 for the 3-day Partner Days pass or pay only $695 for the 6-day Full Conference pass. Receive your exclusive member discount by entering the discount code on the first registration page—3DAYSANCAN13 for the Partner Only Days or 6DAYSANCAN13 for the full conference. Do not delay! The SAN discount expires May 31, 2013. Standard published Sage Summit rates apply after this date.

Excel© Tips and Tricks

Trapping Error Messages by Using the IF Error Function

If you’ve worked with formulas, you’ve probably encountered the dreaded formula error; rather than returning a numeric result, the formula cell displays a strange message such as #VALUE! or #DIV/0!.

Most of the time, this means you need to track down the source of the error and fix it. But sometimes a formula error simply means that the data used by the formula is not yet available. For example, say you run a small telemarketing company. You might have a spreadsheet set up to track your daily sales as a percentage of calls made.

Applies to: MS Excel 2003, 2007 and 2010

v2

1. The formulas in column D do the calculations that come up with the percentages. For example, cell D4 contains the formula =C4/B4.The answer was then converted to percentages by using the percent style option.

2. The formula does its job well–as long as there is data to calculate. An empty cell (such as B9) is treated as a zero, and division by zero is not allowed. As a result, Excel displays an ugly #DIV/0! error message, which makes your entire worksheet look like it was created by a novice.

3. You can avoid displaying formula errors by rewriting your formula to use an IFError function. For example:

=IFERROR((C4/B4),””)

4. Displays a blank cell if the division operation results in an error (cell B4 is empty or contains 0), yet still displays valid results.

5. If you prefer, you can replace the empty string (“”) with other text of your choice–just make sure the text is enclosed in quote marks.

Sage E-marketing

Six Quick Tips for Mobile-Friendly Email Design
By Audrey Howes

More and more emails are being read on mobile devices every day. As email marketers, we need to take notice and make sure our emails are friendly for the mobile reader. Here are six quick tips to get you on track with your email designs:

1.       Enlarge your call to action.

Call to action buttons should be at least 44×44 pixels. CTA buttons need to stand at attention in your email to make sure the mobile reader doesn’t miss them.

2.       Less is more.

We’ve always told you to keep your emails short and sweet. Now that emails are being read at the gym, in bed, while stopped at red lights, and so on, brevity is key to your communication success.

3.       Use images wisely.

Apple products are the only mobile devices that currently default to showing images. Other devices require a click to download like desktop email clients. Make doubly sure your email makes sense without images turned on.

4.       Rethink your layout.

Two-and three-column layouts are challenging to read on mobile devices. Consider moving to a more streamlined email template design.

5.       Design with fingers in mind.

Think about font sizes, line spacing, text links, buttons, and white space when you are putting your email together. Give fingers plenty of room to “play” as they search for what they’d like to click.

6.       Test it out.

Send your email to a variety of mobile devices to see how it looks. If you don’t have a variety of mobile devices represented in your office, try a service such as Bright Peak’s email analysis to get a picture of what your email looks like in a variety of email clients.

Stay ahead of the curve by implementing these tips before your competitors do!

Sage 50 Accounting Inteligence Reporting Tip of the Month

Sage Intelligence Connector: Adding New Connections A Data Connection holds the relevant connection information to connect to a supported ODBC or OLEDB compliant data source. This data connection object is then used for all connections to this data source. By adding a data connection, the Connector can make data available from this data source.

To add a new data connection, double-click on the Enterprise object and select the relevant connection type (driver) to use for the connection, by clicking on it in the object window. Right-click and select Add Connection.

Connector

In the Connection Name field, type the name of your connection.

#2

Note: Depending on the type of the connection being created, certain values will need to be entered to specify how the data is accessed (some connection types will allow you to browse for data using the buttons to the right of the text boxes). Where paths or folder names are required for creating a Data Connection, always use the Universal Naming Convention as opposed to using drive mappings. For example \\Servername\c\mydata\ as opposed to X:\mydata where X is a mapped drive to \\Servername\c\. This will ensure that reports against this Data Connection can be run from any workstation regardless of drive mappings.

  1. In the Server box, browse to or add your server name.
  2. In the Database Name box, enter the name of your Database.
  3. In the User Id: text field, type your user ID if you have security settings on the data folder.
  4. In the Password text field, type your password for the above entered user ID.
  5. Click Add. The new Connection will now appear in the Object window.
  6. To test the Connection, right-click the Connection, select the Check/Test.

Watch the Patterns!

By Loren Taljard, Sage Alchemex marketing director

“5 Things Business Can Learn From a Tree,” The five principles he wrote about were:

1. Find Water

2. Grow

3. Branch Outward

4. Change

5. Watch the Patterns

It is principle number five that I want to dwell on for a short while. Why is it that so many small and midsized businesses (SMBs) don’t track their results? Sure, they may look at their Income Statement and Balance Sheet each month, but they don’t “watch the patterns.” They don’t track the trends, measure year-on-year numbers, or examine Key Performance Indicators against target. Very difficult then for them to meaningfully analyze what works and what doesn’t!

Analyzing data takes the guesswork out of moving forward. The analysis and interpretation of financial statements and other company data is useful in achieving several objectives:

1. Evaluating past performance

2. Assessing current status

3. Predicting future potential

4. Taking the right decisions to maximize profits and resources

Watching the historical patterns can provide a basis for a company’s response to current and future situations.

So, which patterns should an SMB watch? There are many but, arguably, three major patterns to track could be summed up as:

1. Actual vs. Planned Performance. It is no good to “hit and hope” each year. You need to plan the results you want to achieve. Then measure actual performance against the planned performance. If you had fewer sales than planned, you should know or find out why. Were there significant changes in your top-selling items? Did particular regions perform badly? If any costs were greater than planned, you should know or find out why. What were your top five expenses? Every dollar that is different from what you planned should be analyzed. You may need to scale back or focus better on one thing or sort out staff issues or identify new opportunities.

2. Trend Analysis. By comparing current performance to previous performance you can evaluate which areas of your business have changed and by how much.

• Are sales trending up? Sales are crucial to generate cash, so this trend needs to be closely monitored.

• Are certain costs trending up or down?

• Are profits trending up?

• Is your cash flow improving? Managing cash flow properly is important to the success of any organization. It is really important to constantly monitor cash flow so as to be aware of any potential problems and be able to stop any shortages of cash from happening. The aim over time is to grow cash reserves—after all, cash offers protection against tough times and gives companies more options for future growth.

Then you need to determine why the change occurred, whether positive or negative. It is likely that you will need to change your planning if you see a new trend emerging.

3. Industry Comparisons. Financial ratios not only allow you to compare your business’s performance to others in your industry, but also to standards set by your banker, your investor(s), your advisory group, or even yourself. Some of the more common financial ratios to analyse are:

• Balance Sheet Ratios, which typically measure the strength of your business

  • Current Ratio—one of the most widely used tests of financial strength, calculated by dividing Current Assets by Current Liabilities and used to determine if your business is likely to be able to pay its bills.
  • Quick Ratio—sometimes called the “acid test” ratio because it concentrates on only the more liquid assets of your business, calculated by dividing the sum of Cash and Receivables by Current Liabilities.
  • Working Capital—watched very closely by bankers as it deals more with cash flow than just a simple ratio, determined by Current Assets minus Current Liabilities.
  • Inventory Turnover Ratio—tells you if your inventory is turning over quickly enough, calculated by dividing Net Sales by your average Inventory (at cost).
  • Leverage Ratio—another of the analyses used by bankers to determine if your business is creditworthy and often the calculation a supplier to your business will make before extending credit to you, it shows the extent your business relies on debt to keep operating, calculated by dividing Total Liabilities by Net Worth (total assets minus total liabilities).

• Profit & Loss (P&L) Ratios

  • Gross Profit Ratio—the most common calculation on your P&L, simply your Gross Profit divided by Net Sales.

It is desirable to watch the trends and not let this number move too far from your target which you may set based on industry guidelines. It is important to watch the above three patterns to adapt to market changes and plan for future growth in your business. It is obviously easier for a mid-market enterprise with more resources to achieve this than for a small business owner who is constantly juggling his or her time to effectively manage multiple projects, relationships, and sales opportunities. No matter what the size of the business though, it is desirable that more time be spent on analyzing the information, as opposed to pulling it together.

Enter Sage Intelligence, a module of your Sage ERP/accounting solution, which empowers you to quickly and easily obtain information from across your entire business, in a variety of customizable Excel reports. With this reporting tool, you will get improved visibility of the patterns in your organization. And improved visibility gives you the capability to make better decisions for the future success of your company.

Follow

Get every new post delivered to your Inbox.

Join 526 other followers

%d bloggers like this: