Bank Reconciliation

Question

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.

Coleen Graber · Answer

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

Coleen Graber · Answer

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

Sage BusinessWorks

Bank Reconciliation

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING