General Ledger Reconcile Bank Account Correcting Payments
Reconcile a Bank Account - Correcting Payments (continued)
Bank Payment is a lower amount than the SedonaOffice Check to a Vendor
If the check was written to a Vendor for an amount which is lower than what your check shows in SedonaOffice, you will need to void the original check and re-issue another check with the amount processed by your bank. Before voiding the original check, make certain to write down the bills that had previously been marked for payment so you know which bills to select when creating a new check. Create the new check using the Write Checks function. Since the original check was processed for less than the original check, one of the bills will need to be short-paid to arrive at the total check amount processed by your bank. When writing the new check, use the original check number followed by RI(reissued) for better traceability. Make certain to use the same date as the original check number so that it will appear on the bank reconciliation form for the month you are attempting to reconcile.
Bank Payment is a higher amount than the SedonaOffice Check to a Customer (refund check)
If your bank processed a check to a Customer for an amount higher than what your check shows in SedonaOffice, you will need to do two things: write a check for the amount of the overpayment and create a miscellaneous invoice on the customer account for the amount of the overpayment.
Use the Write Checks function to write a check to the Customer for the amount of the overpayment. We recommend setting up a GL Account to use for these situations; an expense type account labeled Bank Over/Under Payments. When writing the check for the amount of the overpayment, make certain to use the date of the original check that was overpaid by your bank; this check will then appear on the bank reconciliation form. Instead of using a check number, the original check number followed by OP (3019 OP) in the check number field. Entering the original check number as part of the check number provides a better audit trail.
Before creating the invoice on the Customer's account, you must first setup an Invoice Item in SedonaSetup to use for over-payments. When creating the Invoice Item, instead of using an income account in the account field, use the GL Account created for Bank Over/Under Payments.
When creating the Miscellaneous invoice, select the Invoice Item for Bank Over/Under Payments. Date the invoice the same date as the date of the original refund check date and the amount will be the amount your bank over-paid the check. Naturally you should contact your customer to let them know you are aware of the the banking error.