Category: General Ledger

Attend my GPUG Summit Nashville breakout sessions! #GPUGSummit

GPUG Summit is right around the corner (October 10-13, 2017) – I cannot wait!  Great city, great people, tons of fun and oh yeah, tons of educational sessions about Microsoft Dynamics GP and much more!

It’s going to be a blast and I hope you join me! 

View the entire breakout session schedule online here. Remember, content is the king of GPUG Summit.

I am extremely fortunate (and excited!!!) to be participating in 7 breakout sessions this year!

Below is a list of these sessions and a link to take you to more details about them!

Continue reading “Attend my GPUG Summit Nashville breakout sessions! #GPUGSummit”

#GPLifeHacks 103 – Track JE’s in #Excel – Paste into GP

I love Excel!  Who doesn’t, right?  As an accountant, I live in Excel.  This is the easiest place for me to track and create Journal Entries. But after all that work, how do we get it into our accounting system, Microsoft Dynamics GP? Easy, we just ‘Paste’ the entry. Simple, I know.

GP Life Hack #103

Dynamics GP offers the cool functionality of pasting in copied data from Excel.  This includes distribution reference, the GL Account number, Debit Amount and the Credit Amount:

1

GP Life Hack #103 … click to see original posting

#GPLifeHacks 133 – Keep your budget data safe from accidental edits in GP

Budgets… not the most exciting topic but one of the most important aspects to any business.

Microsoft Dynamics GP has a user friendly (and excel friendly) budget component built within the financial module. Users can easily build an excel file based on previous year actual balances, existing budget files already in the system, as well as blank budgets. Using the Excel portion of the budget process means that companies can use formulas in excel to automatically update accounts based on other factors. Formulas can be linked to other account values, other worksheets, other files, etc. This makes budgeting for payroll expenses, taxes, depreciation, etc… very easy!

GP Life Hack #133 … click to see original posting

#GPLifeHacks 121 – Keep your AP & AR in balance with your General Ledger

I know your team works hard… day in and day out… and at month end, you reconcile your Accounts Payable or Accounts Receivable sub ledger to your GL Trial Balance with an optimistic approach that never seems to really pay off.  No matter how hard you try, there is always a reconciling adjustment needed in order to balance…  UGH!  Whether it’s a penny, 1,000.00 or 61,312.76… it’s downright frustrating.

What is causing this variance?  Usually it is a journal entry.  We all love them, but let’s be honest… not everyone makes journal entries with the same level of confidence as you do.  Let’s get this game of ‘tug of war’ fixed once and for all!

GP Life Hack #121

Here’s a little GP Life Hack that could save you hours and hours of research.  By using a setting on your Dynamics GP account maintenance window, you can restrict non system entries to certain accounts, specifically your AP or AR accounts.  After all, in order to balance the sub ledger to the general ledger, there should be strict continuity…. Right?  RIGHT!  So let’s get things in balance and keep them there once and for all.