GP #LifeHacks 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 … Continue reading GP #LifeHacks 103: Track JE’s in #Excel – Paste into GP

GP #LifeHacks 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 … Continue reading GP #LifeHacks 133: Keep your budget data safe from accidental edits in GP

GP #LifeHacks 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 … Continue reading GP #LifeHacks 121: Keep your AP & AR in balance with your General Ledger