Summary
Steps on how to clear stale dated cheques and transactions from previous closed years from the bank reconciliation in Sage 50 Accounting.
Description
To clear an old transaction, you need to:
- Create a negative invoice to offset the old invoice.
- Create a negative payment to offset the old payment.
- Clear the transactions from the bank reconciliation.
Resolution
Create a negative invoice
- Go to Payables/ Vendors& Purchases, Purchases.
- Select the same Vendor that the original invoice was issued to.
- Select a date in the current year.
- Create a negative invoice for the same amount as the old transaction.
- For example, if the original invoice was $250, the current invoice should be -$250
Create a negative payment
- Go to Payables/ Vendors& Purchases, Payments.
- Select the same vendor that you just created the invoice for.
- Make sure the correct account is selected in the From drop down.
NOTE: The From account should be same account that has the old transaction on the bank reconciliation. - Select the negative invoice and click in the Payment Amount column.
- The negative amount will automatically show in the column
- Press tab on your keyboard to bring the amount in the Total box.
- Click Process.
Clear the transaction from the bank reconconciliation
- Go to Banking, Reconcile Accounts, and select the correct Account.
- Select the correct Statement End Date and Reconciliation Date.
- Enter the Statement End Balance.
- The transaction that you just processed will show as a positive amount in the Deposits column.
- Clearing this transaction will offset the old transaction
- Clear the transaction and proceed with your bank reconciliation as usual.