Open Forum

Expand all | Collapse all

Reconcile to GL differences

  • 1.  Reconcile to GL differences

    Posted Aug 13, 2019 02:52 PM

    When I run the Reconcile to GL routine for inventory, I am seeing a difference between the balances in the subledger and GL.   The resulting report shows the unmatched transactions (there are JE's in IV sub that don't show a match in GL) but I'm not sure how to handle those transactions and I'm not sure why they didn't post through to the GL in the first place.

    Anyone have experience with this that could give me some direction on best practices for troubleshooting?

    Thanks, Austin



    ------------------------------
    Austin Adams
    American Innovations
    Austin TX
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Reconcile to GL differences

    GOLD CONTRIBUTOR
    Posted Aug 14, 2019 11:04 AM
    Hi Austin,

    There is one item in inventory that you don't see anywhere else.  It has a checkbox on the batch creation screen that allows it not to post to the GL.


    This could create your differences.  There are drill down abilities in the Spreadsheet you created to further research.

    Hope this helps.
    Mike


    ------------------------------
    Michael Taranto, CPA
    President
    ERP Consulting, LLC
    Pataskala, OH 43062
    614-342-0098 mtaranto@erpconsultingLLC.com
    erpconsultingllc.com
    ------------------------------

    Conference-GPUG_200x200


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