IMBLANACE GL WITH AGED PAYABLE

SOLVED

We have a client running Sage 300 Cloud and they are experiencing imbalance aged payable with GL

Any guide on how to get it resolved would be highly appreciated.

Regards.

  • verified answer

    1. Ensure the report is running with a Fiscal Year / Period cut off
    2. Ensure that all G/L batches are posted
    3. Review transaction detail for the control account(s) and period and ensure that source codes are as expected (ie. AP-IN, AP-PY etc - there shouldn't be transactions from other modules)
    4. Review the A/P Account Sets to determine if pre-payments are mapped to the A/P control or not - run the aged payables accordingly

    The above are the "easy" items to assist in reconciling.  Beyond that, you enter the realm of looking for deleted G/L batches, G/L batches being modified to post to a different period etc.