G/L does not match bank reconciliation

SUGGESTED

G/L does not match to bank reconciliation.  I checked to make sure all deposits and checks were correctly entered and marked off and I still have an imbalance in the g/l to cash account.  What report do I use to find this discrepancy?  Because of having to go back as far as November 2012 I cannot get the detailed information from the Trial balance report.  Is there another way to research where these problems started?  We are using Sage Business works 2012.  We would like to do a journal entry to the G/L cash account but are confused as to which account to use and which should be done first the debit or the credit.  It is an adjustment that simply credit and debits the same g/l cash account but which one do we use?

Parents
  • 0

    You can only make cash management entries back 12 months prior to the current CM month.  You typically would take the reconciliation report in CM and trace everything to the Trial Balance report or the Account detail report for the cash account.  If you are only keeping 24 months history you may not be able to run the gl reports back that far.

    If the GL cash balance on the reconciliation is incorrect you can enter a journal entry but only if it is within the last 24 months from the current GL month.

  • 0 in reply to CShular

    We would like to make a Journal entry to balance the amount so that we can close the fiscal year which ended in June.  Until June is closed I cannot process any bills into the system because it won't let me go into August.  I read the I could do a manual entry as long as the "allow journal entries to cash accounts without adjusting the bank register" is engaged.  How do I do this in Business Works 2012?  We tried several different accounts but only had to void the transactions because they did not correct the GL

  • 0 in reply to cjgebert
    SUGGESTED

    If you just need to adjust the general ledger cash account you would do a journal entry to that cash account in general ledger.  Look in cash management, Accounts, Maintain cash accounts.  Find the cash account you are reconciling and it will have the GL account number. Post your journal entry to that GL account number.  (Debit that account number to increase the balance or Credit that account number to decrease the balance.)

  • 0 in reply to CShular

    So if the G/L says it is a negative amount I should do a journal entry to credit the amount but in the J/E it needs another account that is to be debited doesn't it?

Reply Children
No Data