Can anyone advise me how to deal with a supplier account where invoices have been posted and payments on account have been made? I would like to get everything to start afresh so i can then pay each invoice off but not sure how to.
Also can you advise what to do with invoices that have been paid by a bank payment and that payment has now been reconciled but the invoice shows as outstanding?
1. You can go into the supplier payment screen select pay in full against the invoice and payment on accounts so you are effectively making a nil payment and then pay. This will match the invoice against the payment on account. Would probably pay through a dummy bank account so you dont affect your main bank account.
2. I assume what you mean is that the bank payment has been posted as a bank payment rather than a supplier payment. That being the case what nominal account has the bank payment been posted too? Assume it is the same account the purchase invoice has been posted to. To sort I would set up a dummy bank account and make a supplier payment to clear invoice outstanding and then make a bank receipt for the same amount and post to the nominal account where the original bank payment has been made. This will effectively cancel with the bank payment.
1. You can go into the supplier payment screen select pay in full against the invoice and payment on accounts so you are effectively making a nil payment and then pay. This will match the invoice against the payment on account. Would probably pay through a dummy bank account so you dont affect your main bank account.
This can be done through any bank account as long as the balance is zero, it wont affect the account and doesn't even appear on the audit trail.
I had a look at doing your suggestions regarding the supplier account however the payments on account don't add up to the invoice amounts (I have just started doing the bookkeeping and this has been going on for some time) so is there anyway that I can just get the account to zero?
Match what invoices you can against payments on account. Then depending on the balance left raise a dummy credit note or dummy invoice and then match that against the payment on account left to clear the account to zero.
