Accounting and Financial Outsourcing

Article Dean Dorton

With the recent release of GP 2013 R2 comes some exciting new features! One of them gives us the ability to copy data from an Excel file and paste into the GL as a journal entry.

To do this, we may highlight and copy the data from Excel, and then choose the Paste button in the GL Transaction Entry window. A validation report will print to identify any errors in the data copied into the GL.

In the Excel file, there are 4 columns that must be present as follows:

  • Description: This is the Description of the transaction that will appear in the Distribution Reference field when imported. It is not required, but the column must be present within the file.
  • Account: GL account number that we’re posting to.
  • Debit: Enter the debit amount for the account.
  • Credit: Enter the credit amount for the account.

 

Article Dean Dorton

Have you been thinking about adding more users or new functionality to your current Microsoft Dynamics GP solution?  Well, now is the time to buy!

Microsoft has just announced that they will be making some big changes to their pricing starting July 1st, 2014. Microsoft has decided to realign the Dynamics GP  user prices across versions and licensing models effective July 1, 2014, resulting in a price increase for additional users you might need in the future. So, if you think that you will need more users in the next 6 to 12 months, there is no better time to buy those users than now.

How will this affect you?

If you are currently on Microsoft Dynamics GP 2013 and Microsoft Dynamics NAV 2013 the following price changes apply to you:

  • 10% or MORE PRICE INCREASE. This change impacts customers that are on the Professional Modular licensing as well as the Starter Pack, the Extended Pack, all Client Access License types, and all modules available through the Perpetual Licensing model, except Microsoft SQL Server 2012 Standard Edition Runtime licenses.

BUY NOW and take advantage of the current Microsoft Dynamics Pricing before those user and module prices go up on July 1, 2014.

If you have NOT upgraded to Dynamics GP 2013 yet, price changes depend on which legacy pricing model you are on. To find out more about how you can save, please contact us via email or phone at 919-875-9635 extension 1.

Article Dean Dorton

Fixed Assets in Dynamics GP is a full-function fixed assets system that’s included as part of the financial area.

The fixed assets module is well integrated with the rest of GP. On the procurement end you can identify a fixed asset in the PO process and the payables process. This creates a nice audit trail from each asset, to the procurement transaction related to the asset’s acquisition. There is also a tight integration with the general ledger that accurately records all depreciation, movement, and disposition transactions.

The reporting is list based and is well suited for typical requirements, e.g. asset listings by state/county, inventory lists with asset costs and net values, insured property list, etc.

Article Dean Dorton

Accounting software systems typically have one or more big functions or features that distinguish them from their competitors.  Some systems are extremely easy to use; some systems have sophisticated manufacturing; some systems have strong eCommerce and some systems have many smaller things that distinguish them.

Intacct is one system that has many strong differentiators from the competition.  Revenue recognition is a big strong point, as is project accounting and time and billing.  Dashboards and reporting really stand out.  The best feature of Intacct, to me, however, is the DIMENSIONS concept.

What is a DIMENSION you ask?  A dimension is a whole new way to look at your General Ledger chart of accounts.  Instead of having one long string of number and letters in a secret code-like format (100-20-4010, for example); dimensions let you concentrate on your real account number (4010) and establish other “dimensions” or cost centers for your transactions.  Dimensions are independent ways to “tag” ALL transactions in Intacct for reporting purposes.

How does this help?  Imagine you have a traditional account structure with three segments (100-20-4010) where segment one is the department, segment two is the location and segment three is the main account number.  Now imagine you add a new location in Chicago with a segment value of 40.  In this traditional structure, you will need to a multitude of accounts for all the different combinations of department and main account – often resulting in one hundred or more accounts.

Now consider how Intacct would handle that.  With Intacct, first of all, your chart of accounts would only be one segment – the main segment.  The department and location would each be dimensions.  How does that help?  With Intacct, when you open the new Chicago office, you simply add ONE new dimension (40) and you are all set.  That’s right!  Not hundreds of accounts – ONE dimension!  You can see the simplicity and time savings right?

Dimensions are a VERY powerful feature in Intacct.  The example above is just one way that dimensions can save you time and headache.  Look for more examples in later posts in this blog.