Open Forum

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

    Posted Dec 02, 2018 09:53 AM
    Edited by Anthony Merriwether Dec 02, 2018 11:52 PM
    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

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