Contact us today: (866) 4-WEBSAN (932726)

View our free webinars Sign up for WebSan University

It’s no surprise that every business somehow uses Excel in their everyday routine. It’s the easiest and the most popular tool to organize your company’s data. But eventually your data starts to outgrow Excel possibilities. Here are 3 signs that your business needs to switch from spreadsheets to more advanced accounting software.

1. Your spreadsheets aren’t manageable anymore

If finding a single figure in your spreadsheet makes you feel tired, angry and irritated, it’s a sure sign that you need a database. Once your spreadsheet reaches 100,000 rows, it will slow down your computer and make it almost impossible to find necessary information. A comprehensive solution like Microsoft Dynamics GP can easily store your data with a possibility to create powerful and useful reports for your business. 

2. You use advanced Excel functions on a daily basis

Stop overwhelming yourself with advanced Excel functions every single day. If you use such functions as VLOOKUP, PIVOT and SUMIF, you just don’t need Excel anymore. Consider looking into a new accounting system, which can produce stronger calculations. Moreover, it’s much easier to use.

3. You need to secure your data

No matter what size your business is, you have some confidential data and Excel isn’t your friend in this case. An Excel file can be easily transferred through email or USB stick without you noticing. Just imagine, how big of a damage it can cause your business if one of your employees attaches the wrong file. You need a new accounting solution, if you have any confidential information.

Do these scenarios ring a bell? Then try our free Microsoft Dynamics GP Demo and do away with a headache from Excel forever. 


Alina Hura, Digital Content Creator, WebSan Solutions Inc., a 2014 Ontario Business Achievement Award Winner for Service Excellence

Published in Tips & Tricks
Wednesday, 31 July 2013 06:06

Excel Based Journal Entries

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Most office staff today perform a lot of analysis in Excel.  Staff are comfortable in Excel & familiar with its various functions.  As a result, staff may prefer to upload general journal entries through an excel based template.  Many times, large entries, such as those to a payroll clearing account, may need to be calculated in Excel before they can be entered in the system.  When staff already have the entry in Excel, its very convenient to be able to directly upload into GP.  As such, WebSan offers it's clients an Excel based Journal Entry upload tool capable of handling multiple journal entries spanning as many lines as required.

All customers should ensure their ERP partner / VAR offers the same baseline functionality in their system.

 

GL Upload

 

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Published in Microsoft Dynamics GP