Bank Reconciliation

SUGGESTED

I import all my journal entries in SAGE, via a CSV conversion from Excel.  Will my imported "cash receipts" journal entries appear on the bank reconciliation?  I use "C/R" as the Journal ID.  Also, A/Ps are not appearing on the bank reconciliation.

  • 0
    SUGGESTED
    No. General Ledger journal entries will not show up in the Bank Reconciliation - whether they are entered manually or via an import. The journal entry will update the GL balance for the Cash account but will not put an entry in the Bank Reconciliation. Cash transaction need to per enter in the modules or through Cash Management Enter Bank Transactions. See Knowledge Base article #18041 "How to enter bank transactions in Cash Management". Also, there is no option to import bank transactions. To review our options for importing see #73278 "Import file formats". If you have already performed the journal entry and you need the item to appear in the bank rec, you can enter a Bank Transaction (see article above) and uncheck the field 'Post to GL' so it does not post the transaction to your GL a second time.
    Thanks,
    Coleen
  • 0 in reply to Coleen Graber
    We get a lot of cash receipts on a daily basis, is there an expedient way and/or alternative way to enter the cash receipt journal entries in the Cash Management module so that they will be part of the Bank Reconciliation process? I've learned to import into the G/L, which helped a lot, but it is a moot point if not recognized in the bank reconciliation.
  • 0 in reply to D A
    SUGGESTED
    If you had a chance to review the Import file formats, BusinessWorks does allow you to import customer payments for Accounts Receivable invoices. You would then need to still do the deposit for them in BusinessWorks and that will post to the bank rec. If you are unfamiliar with the Bank Deposit, then I would recommend you call 800-447-5700 to open a case with support so they can review what you are trying to accomplish and what BusinessWorks can offer. If your cash receipts are not for Accounts Receivable customer invoices, then there is no option to import cash receipts to show in the bank rec.
    Thanks,
    Coleen