Importing Journal Entries affecting cash into the Cash Management module

SUGGESTED

I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module.  I have to manually re-enter the JEs via the "Enter Bank Transaction" function and de-select the "Post to G/L".  Is there a way I can import into the General Ledger module AND for it to be picked up in the Cash Management module?  And/or reimport into the Cash Management module without a "Post to G/L"?  In the end, I wish for cash transactions to depict on the Cash Account Register without having to type; there are many transactions.  Trying to bring efficiency to my work.

Parents
  • 0
    SUGGESTED
    DA,
    Journal entries, either entered manual or imported, do not post to subsidiary modules and therefore will not update the Bank Reconciliation. If you are using the Bank Reconciliation, any transactions that post to your cash account, should be performed directly in the Sage BusinessWorks program so it can properly post to the bank rec and general ledger. You are correct, if a journal entry is performed, you will need to go into Cash Management and do a bank transaction and deselect “Post to GL”. Unfortunately, there is no option to import in bank transactions or other cash transactions into Sage BusinessWorks. I have enclosed Knowledge Base article regarding this issue. I also included an article on the Import file formats. This will tell you want is allowed to be imported and the format.

    # 83620 Journal Entry did not post to my bank reconciliation

    #73278 Import file formats

    Thanks,
    Coleen
Reply
  • 0
    SUGGESTED
    DA,
    Journal entries, either entered manual or imported, do not post to subsidiary modules and therefore will not update the Bank Reconciliation. If you are using the Bank Reconciliation, any transactions that post to your cash account, should be performed directly in the Sage BusinessWorks program so it can properly post to the bank rec and general ledger. You are correct, if a journal entry is performed, you will need to go into Cash Management and do a bank transaction and deselect “Post to GL”. Unfortunately, there is no option to import in bank transactions or other cash transactions into Sage BusinessWorks. I have enclosed Knowledge Base article regarding this issue. I also included an article on the Import file formats. This will tell you want is allowed to be imported and the format.

    # 83620 Journal Entry did not post to my bank reconciliation

    #73278 Import file formats

    Thanks,
    Coleen
Children
No Data