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

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

As of April 1, 2013, the Government of Prince Edward Island is implementing the Harmonized Sales Tax (HST). The combined HST rate in PEI will be 14%, of which 5% will represent the federal part and 9% the provincial part. Further, the Government of British Columbia will be eliminating the HST and reinstating PST and GST on taxable services provided in British Columbia. As of April 1, 2013, you will be taxed GST at a rate of 5% and PST at a rate of 7%.

To create the ability to track these changes in Dynamics GP, one must utilize Tax Details and
Tax Schedules.  Tax Details identify specific taxes and their rate of taxation.  These are then assigned to & grouped on Tax Schedules for processing transactions in GP.  Tax Schedules can be assigned to Customers, Vendors, Items, etc.

Setting up Tax Details

  • Enter a Tax Detail ID and a Description.
  • It is important to set the Type properly as Tax Details can apply to either Sales (to a Customer) or Purchases (from a Vendor) exclusively.
  • Set a default GL Account to distribute tax transactions to in order to capture values in the general ledger.
  • Set both the Based On & Round values depending on the tax.  For HST & PST, these should be set to Percent of Sale / Purchase & To the Nearest Currency Decimal Digit respectively.
  • Set the Percentage for the Tax Detail.  For HST PEI, this is 14%.  For PST BC, this is 7%.

Tax detail maintenance 1

Setting up Tax Schedules

The Tax Schedule Maintenance window contains two list boxes:

  • The Available Tax Detail IDs list box displays a list of all the tax details entered.
  • The Selected Tax Detail IDs list box displays the details added to this schedule.
  • To add tax details to a tax schedule, highlight a detail in the Available Tax Detail IDs list and click Insert. The detail is inserted in the Selected Tax Detail IDs list and is included in this tax schedule. Continue selecting and inserting details until the complete tax schedule is created.

Tax detail maintenance 2

Assigning Tax Schedules to Customers/Vendors

Once tax schedules have been created and saved, the last step in the process is to assign the tax schedule to a customer or vendor, etc.  If a new tax schedule is to be applied to a customer, navigate to the Sales > Cards > Customer.  Then, select the appropriate customer & enter the appropriate value in the Tax Schedule field.  To assign the tax schedule to a vendor, navigate to Purchasing > Cards > Vendor.

For more information contact us at This email address is being protected from spambots. You need JavaScript enabled to view it., WebSan Solutions Inc., a Canadian Certified Microsoft Partner

Published in WebSan Blog

Save Money by Switching to a Cloud Hosted Solution

Do you manage your financial accounting using an on-premise solution? Are you spending a lot of money on licensing?

WebSan Solutions offers business the option of switching to a cloud hosting solution.  They offer faster deployment options when compared to on-premise.  You can save on licensing because you have access to your data through the web. No need to purchase hardware or software. You need to pay a low monthly fee, which helps you manage cash flow.

Frequently Asked Questions

WebSan Solutions Inc. is a cloud Microsoft Dynamics Certified Partner and IT consulting and solutions provider. In their web-based time and expense management system, they have added the FAQ page to tackle commonly asked client inquiries. This new enhancement will reduce their IT costs and create more productivity amongst their clients. This system is very easy to use because of its simple design and user-friendly navigation.

Paperless Office for expense reports

WebSan Solutions has also added a new document upload feature in the time and expense portal. This new feature allows employees to scan receipts and attached them to an expense report in the portal. When a manager is ready to approve it, they can automatically see the receipt. The document upload works in real time, so there’s no need to submit an expense then send in your receipts by mail into the office. You can now also use a tablet (iPad, Android) to take a picture of your receipt and still attach it to your expenses.

“Are clients have realized tremendous time savings and efficiencies from being able to upload expense receipts from a tablet or mobile device.” stated Andrew King, Managing Director.

To see WebSan Solutions time and expense management system in action, click this link: http://www.youtube.com/watch?v=MCu3BM3DInA&feature=player_embedded

Published in WebSan Blog

If you are thinking of starting a new business, or getting a new software system, what company do you choose? How do you know that the company that you decide to go with fulfills your needs? It’s time that you do your own research and be in charge of your business financial system. Here are some questions that you should ask before you make a decision:

1.       Will the accounting software grow with your business?

You want to make sure that you don’t outgrow your system. It’s better to get a system that has the capacity to grow with your business.

2.       Can access be restricted for some users?

Having the power to monitor who uses particular functions is very important to a company. Having control is very important for senior level employees to keep certain information confidential and private.

3.       Do you want to go towards cloud hosting or stay on premise?

Even though moving to the cloud would be less money and more current with what today’s businesses are doing, some people don’t feel comfortable choosing the cloud. But at least there are options to choose from.

4.       Can I afford this software?

Sometimes it takes money to make money. But if this decision will put you deep in debt then it’s not worth it. Be sure of the software you choose and thoroughly access the situation for the right budget.

5.       Ask for referrals from other business, clients and/or family.

If you don’t know where to start, ask around about the different accounting software people you know are using. Also, start to search on Google. If you have read this blog on our website then I just have given you an accounting software to look into, Microsoft Dynamics Great Plains.

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Partner

Published in WebSan Blog

Sending an email should be easy to compose and send, it also should be easy to reply and forward to different people. Hotmail has one of the simplest ways of navigating and organizing emails, but the problem with that is companies don’t use Hotmail as their email provider. So say the email system that you’re using is giving you a hard time by not sending emails properly or sending all your emails to the junk folder, many of these problems can be frustrating and make you appear to be unprofessional. Here are a few benefits of using email integration in Microsoft Dynamics GP.

  • Microsoft Dynamics GP 2010 allows users to effortlessly email single and/or numerous documents. You can also send emails from a list in the system. You have the option of choosing a document that you want to send to a specific customer or vendor.
  • With email integration, you can send documents as HTML, PDF, DOCX, or DOCX.
  • You can customize messages for each document and/or customer/vendor combinations.
  • You can also combine many documents and send them all at once in a single email.

So if you think your company needs a new email system and perhaps a new online accounting software system, why not kill two birds with one stone?

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Dynamics Partner

Published in WebSan Blog
Thursday, 01 December 2011 16:46

The Pros and Cons of Online Accounting Software

Buying accounting software is a big decision you have to make when the time is right for your company. It’s a harder decision, especially when you’re a small business owner and don’t know much skill about accounting. Some people might wonder if online accounting software is right for them. What I’m going to do is point out the pros and cons of inquiring online accounting software. Hopefully some of these pros and cons will give you an idea if it’s for you or not, make sure you do your research and find the right accounting software for you.

The Pros of using online accounting software:

  • Some software can be straightforward to use even though you don’t have much financial knowledge. Their job is to help small business owners with the necessary tools to operate their business.
  • It’s easy to make updates because it can be done automatically.
  • You can check up on your financials everywhere and anywhere you are because all of your finances are online.
  • The software company has online support just in case you have a question. 
  • Most accounting software’s out here have mechanisms to back up your data so nothing happens to your data.

The Cons of using online accounting software:

  • There’s still the risk of hackers getting in the software.
  • Make sure you have an up-to-date internet connection because if your computer is running slow, so is your accounting software.
  • Having mobility is a good thing to have but be careful if you ever have to log in a public computer or even a friends computer, make sure you log off properly because you don’t want just anyone looking at that information.

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Dynamics Partner

Published in WebSan Blog