At the GL account maintenance level, there should be a field prompting if this account is a bank account to tie to bank reconciliation. This field should only prompt and be required if the account type is CASH.

Currently, any entry that affects a bank account that is entered through General Journal Entry or Reoccurring Journal Entry is MISSING from Bank Rec, causing accountants to search for what is missing upon Bank Reconciliation time.

FIX - If an account, with this "Tie to Bank Rec" field checked in account maintenance, is used in GENERAL JOURNAL ENTRY or REOCCURING JOURNAL ENTRY, the system automatically ties this line into bank reconciliation. In bank reconciliation, this line then shows with the "Select for G/L Posting" checkbox cell Disabled since it has already posted to the GL through General Journal Entry or Reoccurring Journal Entry.

Most will say to go through Transaction Journal Entry, but correcting this will close the possibility of entering a cash/bank account into any journal process that does not tie into bank rec. Why have to remember and have the possibility of error when Sage could be programmed to catch these errors natively.

Even just notifying the user "User has selected a general ledger account that is tied to Bank Reconciliation. Please enter journal entry into Transaction Journal Entry to avoid missing data in Bank Reconciliation." would work in General Journal Entry and Reoccurring Journal Entry.

by: Alexander M. | over a year ago | Financial Management