bank reconciliation

Hi

Could you kindly assist me with an issue I encountered in Sage300? How Can I reduce “Withdrawals Outstanding” amount on bank Reconcile Statement without affecting in GL accounts?

  • Hi  firstly this shouldn't occur in the first place, do you know what the cause was?  How do you know the "Withdrawals Outstanding" amount is incorrect?  Before making an adjustment to the Book balance, forcing it to match the G/L cash balance you should check the following:

    1. Check there are no unposted batches in the General Ledger related to A/P Payments and A/R Refunds.
    2. Make sure your Statement Balance is definitely correct for the date you're reconciling too.
    3. Make sure its not a timing or mistyped payment date issue - push both of the dates in the Bank Rec to next period and see if any new Withdrawals show up you can reconcile.
    4. Check the Bank Reconciliation Posting Journal report for the last posting and make sure the closing Statement balance was correct and the problem wasn't introduced earlier.

    Basically check everything else before considering entering a Bank Entry to G/L account Cash at Bank to make your proposed adjustment because this issue should not occur and data corruption of this type is rare.  You want to make sure you're not just creating a problem that will show up again during the next Bank Rec.

    Hope that helps!...Tim