Common reconciliation errors

The following table lists some common reconciliation errors.

Type of Error

Correction

Incorrect posting

If you posted a transaction with an incorrect amount, the transaction amount between the reconciliation report and bank statement differs.

Incorrect bank posting

Checks occasionally clear the bank for a different amount. Look at the magnetic coding at the base of the check to determine the amount paid by the bank. Compare this amount to the amount appearing on the bank statement and to the actual amount for which the check was written.

Incorrect dates

If a transaction appears on the bank statement but does not appear in the 1-5 Bank Reconciliation window, you might have posted the transaction with incorrect dates. To locate the transaction, use 1-3 Journal Transactions and search for the missing transaction.

Missing entries

When charges or credits appear on the bank statement but do not appear in your records, post the charges and reopen 1-5 Bank Reconciliation.

Returned items

If the bank returns a check due to insufficient funds, reverse the check and post the charge for insufficient funds.

Forged items

While rare, it is possible that someone has altered a check amount. Another possibility is that someone has stolen check forms and forged checks.

It is important to identify forgery and alert the bank, thereby eliminating additional problems and preserving your ability to recover lost funds.

Links to more information . . .

More resources

For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.

For additional training on Sage products, visit Sage University.