How to edit, delete, or reverse a vendor payment, deposit, or refund in Sage Accounting.
Resolution
Before you start
Review the transaction before you make changes.
- If the payment is allocated to an invoice, the payment remains matched to the invoice when you edit it
- If you reduce the amount below the invoice value, adjust the Paid amount on the invoice before you save
- If you increase the amount above the invoice value, Sage Accounting saves the remaining amount as a Payment on Account
- If the payment is allocated to the wrong invoice, remove the check mark next to the invoice when you edit the payment
▼Unreconciled transactions Edit an unreconciled vendor payment
- Go to Banking.
- Open the relevant bank account.
- From the Bank Activity tab, open the payment you want to edit.
- Change the Bank account, Method, Date, Reference, or Amount as required.
- If you change the amount and the payment is allocated, select the edit icon in the Paid column.
- In the Part Pay window, adjust the Amount to Pay or Discount as required.
- Select Save.
You cannot change the vendor on the payment. Delete the payment and enter a new one if you need a different vendor.
Delete an unreconciled vendor payment or refund
Delete a vendor payment or refund when it has not been reconciled.
- Go to Banking.
- Open the relevant bank account.
- Select the check box for the transaction you want to delete.
- Select Delete.
- Select Yes.
Sage Accounting removes the transaction from your accounts. The related invoice, credit note, or deposit becomes unpaid again.
▼Reconciled transactions What happens when you edit a reconciled payment
A reconciled payment is a payment included in a bank reconciliation. It shows a tick in the reconciled column on your bank activity.
The transaction stays reconciled when you change:
- Reference
- Method
- Ledger Account
- Date, if the new date remains within the reconciled period
The transaction is no longer reconciled when you change:
- Bank account
- Amount
- Date, if the new date is later than the end date of the reconciliation
When the transaction is no longer reconciled, Sage Accounting unreconciles it. Sage Accounting adds a Removed from reconciliation label to the Corrected Transaction column.
Reconcile an edited payment again
Reconcile the payment again when you change the Bank account, Amount, or Date.
- Go to Banking.
- Open the bank account you want to reconcile.
- Select Reconcile.
- Check the Statement End Date. Make sure it is the same as or later than the date of the edited payment.
- Check the Starting Balance.
- Find the edited payment with the Corrected label in the Corrected Transactions column.
- Select the check box in the Reconcile column.
- Check that the Reconciled balance is correct and the difference is zero.
- Select Finish.
The starting balance of your next reconciliation will now be correct.
Reverse a reconciled vendor deposit
If a vendor deposit has been reconciled, you cannot delete it.
- Reverse it instead
- Record a vendor refund against the deposit
- Use the same details as the original payment
This reverses the original deposit. Enter a new payment with the correct details if you need to change the original deposit.
Reverse a reconciled vendor payment allocated to an invoice
If you reconciled a vendor payment that was allocated to an invoice, reverse the allocation first.
- Remove the allocation between the payment and the invoice
- The payment becomes a vendor deposit
- Reverse the vendor deposit
- If required, record a new vendor payment with the correct details
The invoice becomes unpaid again after you remove the allocation.
Reverse a reconciled vendor refund
The steps depend on whether the refund was for a vendor deposit or a vendor credit note.
If the refund was for a vendor deposit:
- Create a new vendor deposit
- Use the same details as the original deposit
This offsets the refund.
If the refund was for a vendor credit note:
- Create a vendor invoice using the same details as the credit note
- Record a payment against the invoice
- If required, create a new credit note using the same details as the original credit note
The invoice reverses the credit note. The payment reverses the refund. The new credit note remains unpaid until you refund or allocate it.
Audit trail and reports
When you edit a transaction, Sage Accounting reverses the original transaction and creates a new transaction number. Apart from the audit trail, only the new transaction appears on reports.
For unreconciled transactions, reconciled other payments, and reconciled other receipts:
- Sage Accounting shows the original transaction with a line through it to show it was reversed.
- Sage Accounting creates a new transaction with the updated details and a new transaction number.
For reconciled customer receipts and vendor payments:
- Sage Accounting creates a new transaction to reverse the original transaction. This transaction has a type of Correction.
- Sage Accounting creates a new transaction with the updated details and a new transaction number.
Edit a recurring vendor payment
Edit the most recent payment. You can identify it by the recurring symbol.
- Go to Banking.
- Open the bank account used for the original payment.
- From the Activity tab, open the most recent recurring payment.
- Edit the payment.
- Select Save.
Sage Accounting creates a new payment with the updated details on the next repeat date. Previous recurring payments remain unchanged.
Related Solutions