[Tracy Yaklyvich, MBA]

??Good morning.  Can someone please share which fixed asset reports they use to help reconcile to the GL?  Every report I run is hundreds of pages long.  I am looking in particular for balance reports by year and GL account.

Thanks so much, Tracy

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————

[Gerald Buenafe]

Hi Tracy,

Here’s a KB on this topic:

How to reconcile Fixed Assets to verify that the balances are correct in General Ledger in Microsoft Dynamics GP

https://support.microsoft.com/en-ph/help/857464/how-to-reconcile-fixed-assets-to-verify-that-the-balances-are-correct

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Tracy Yaklyvich, MBA]

?Thanks for the info Gerald!

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————
——————————————-

[Laurie Stewart]

Hi Tracy,

I print 5 reports each month. 

1. Additions- PTD
2. Additions- YTD
3. Depreciation by Ledger Class Summary- Active (to get the ending balances)
4. Depreciation by Ledger Class Summary-Active and Retired (to get the YTD depreciation only)
5. Retirements- PTD
6. Retirements- YTD

I keep a spreadsheet rollforward with all my individual asset information also.  I use the GP reports to tie everything out to the spreadsheet.  Then, I make sure it ties to the GL.  I have a few asset classes that are in the same GL account, so I use another spreadsheet to do this.

——————————
Laurie Stewart
Ted’s Montana Grill
Atlanta NC
——————————
——————————————-

[Jo deRuiter]

Hi ?

I understand exactly what you are saying.  In essence, I have built out a few automations around this.  

You are right the reconciling reports can get crazy long, but here it is in a nutshell.

Create an Excel Refreshable of the transactions in the Cost Accounts and Accum Depr Accounts from the Balance Sheet, you can add depreciation expense if you want.  Do this on one tab of an Excel Spreadsheet
Create an Excel Refreshable of either the Fixed Assets Summaries pulling in the Life to Date Depreciation and the Cost Basis, and YTD Depreciation if you are reconciling Expenses.Do this on another tab of the Excel Spreadsheet

Using Pivot Tables (I always add them on the same Excel Tab) Pivot the GL Accounts by the account number and description 
Pivot the Assets on the Class to get totals

FA Cost = Asset Cost in GL
FA LTD Depr = Asset Accum Depr in Gl
FA YTD Depr = Expense Depreciation.

This assumes that your classes are a good mirror of your cost and accum depr accounts.

There are some existing views you can use to create the Excel Refreshables so no work should be needed there.

Let me know if you have any questions on this.

If you don’t have a clear one-to-one match of class and cost then that is something you should look into doing.

——————————

——————————
——————————————-