Sage help needed with incorrectly paid invoice

[Blagger]

I have a small problem with an incorrectly paid invoice and need some help sorting it out in sage otherwise the bank won't reconcile properly. So:

Invoice amount: £964.80
Paid supplier: £946.80 (£18.00 short)
Invoice created in Sage: £964.80
Invoice paid in Sage bank account: £964.80

I had to pay the supplier the additional £18.00 which will show in the next lot of bank statements therefore making it appear in the next reconcile.

So in Sage the Invoice/bank payment is £964.80 but on the actual bank statement it is £946.80 that are in the same date range of this reconcile.

What is the best way to tackle this?

 

[sheelagh]

The most straightforward option would be to delete the incorrect supplier payment in the Corrections module then post a supplier payment for the amount you actually paid. This would enable you to reconcile your bank account and it would leave the £18.00 unpaid on the invoice. Then post the second supplier payment for £18.00 to clear the remaining balance of the invoice.
In certain circumstances you won't be able to do this. The scenario that springs to mind is if you are using Cash Accounting for VAT and you have run a VAT return since posting the transaction. If this is the case, post a Bank Receipt (BR) to the suspense (n/code 9998) and match this in your bank reconciliation. The details could be "adjust value of pyt to supplier XXX" .
Next month, when the £18 shows on the bank statement, post a Bank Payment (BP) to the suspense (n/code 9998), detail "reverse adjustment" and match this in your bank reconciliation.

 

[Blagger]

Thanks for that, didn't realise it would be that simple as I thought bank payments couldn't be deleted. Have done what you have stated and all sorted.

Sorry for delayed reply!