Open Forum

Expand all | Collapse all

Fixed Asset Reports

  • 1.  Fixed Asset Reports

    GOLD CONTRIBUTOR
    Posted 15 days ago
    ​​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
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Fixed Asset Reports

    GOLD CONTRIBUTOR
    Posted 14 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Fixed Asset Reports

    GOLD CONTRIBUTOR
    Posted 14 days ago
    ​Thanks for the info Gerald!

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

    Conference-GPUG_200x200


  • 4.  RE: Fixed Asset Reports

    Posted 14 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Fixed Asset Reports

    GPUG ALL STAR
    Posted 6 days ago
    Hi @Tracy Yaklyvich, MBA

    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.

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role