Reconcilaion Summary is off?

SUGGESTED

My reconciliation summary is off by exactly the amount of my uncleared deposits.

If they are outstanding for the month, why are they not showing up on the reconciliation report?  

  • 0

    Look at the Bank Deposit Report for the month that you are reconciling.  Check to see if the CHECK date is the same as the DEPOSIT date.  The Receipt (Check) date is probably in the next month and the Deposit date is in the prior month.  To correct this, void the Deposit (Cash Management - Void Bank Transactions) and reenter the Bank Deposit in AR using the same date as the Receipts.  For the future, be sure that the cash receipt date is correct and that the deposit date is the same.  This often happens at month end.

    Barbara

  • 0 in reply to bem

    They are.  I printed the bank deposit report to confirm they were on there.  Compared the Trial Balance for that cash account for the month to the Reconciliation Report as well as the Bank Deposit report.  The totals are reflected on the deposit report and the trial balance, but do not show up as outstanding checks for the reconciliation summary.

  • 0 in reply to dmkeller

    I should have asked if you use the Accounts Receivable module before I answered.  Do  you use the Accounts Receivable module or do you enter deposits using Enter Bank Transactions in Cash Management?

  • 0 in reply to bem
    SUGGESTED

    A/R, Post Receipts, apply to invoices

    then

    Bank Deposit to create the deposit.  

  • 0
    SUGGESTED

    dmkeller-

    If your deposits are missing from the bank reconciliation I would check to make sure that they were posted to the correct cash account and that they were not marked as reconciled in the previous or other month.  If they are still missing then you may want to follow Knowledge Base (www.SageKB.com) article #18700 "Why are transaction missing from my bank reconciliation".  This gives you suggestions including doing a backup and rebuilding your module.  The rebuild does not resolve it, then you can redeposit the transactions in AR, Transactions, Bank Deposits OR CM, Transactions, Enter Bank Transactions and deselect the Post to GL option.

    Thanks,

    Coleen