Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

One beta tester needed for GL/Sub Ledger (imbalance) Reconciliation Dashboard Report

  • 1.  One beta tester needed for GL/Sub Ledger (imbalance) Reconciliation Dashboard Report

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Edited by Anthony Merriwether 8 days ago
    I'm looking for a beta test site/user that is on a fiscal year 7/1 thru 6/30 accounting basis to test a new Power BI - GL/Sub Ledger (imbalance) Reconciliation Dashboard Report that is designed to show ALL GL/Sub Ledger imbalances down to the T- Account and Journal Entry level.  In other words, all OPEN transactions that are in the Sub Ledger that did not make it into the General Ledger.  After viewing the discrepancies - variances in the dashboard report, you will see exactly which transactions in the Sub Ledger are causing the imbalance and you will be able to make accurate adjusting entries to correct the imbalance as needed and,  you will have a basis to understand why the Sub Ledger transactions did not make it to the GL.  You can keep the dashboard report after beta testing.

    This is not a solicitation.  This is a request for a beta test only.  If you wish to participate, please email me.  Only 1 beta tester will be required and, afterwards, I will mark this post as closed.  Please note that the dashboard report only surfaces the data.  It does not have the ability to change data.  If your GP database is an on-premise installation that is preferable.  Thank you.

    GL/Sub Ledger Reconciliation

    ------------------------------
    Anthony Merriwether
    ETL Source LLC
    www.etlsource.com
    amerriwether@etlsource.com
    ------------------------------