Hi,
Discovered how to find un-allocated supplier payments by using the Prepayment filter in supplier advanced search - top-tips from the forum! But now discovered issues from last year I don’t know how to sort.
This is what happened:
Online purchase, say £1,000.
Company then didn’t have all stock so actual invoice with delivery is say £700. This is what gets processed in QF.
Credit card then gets a refund for the undelivered stock of £300, which I tagged to the invoice.
However, because I processed actual invoice and tagged it to original payment QF has £300 unallocated money from the original payment. What do I do with it? It’s from a year ago.
I understand that essentially the original payment was against a pro-forma invoice and that is what should have been processed in QF. Banking all tallies but clearly supplier account is wrong.
Do I make a nominal code for these funds, but what?
Company then didn’t have all stock so actual invoice with delivery is say £700. This is what gets processed in QF.
Credit card then gets a refund for the undelivered stock of £300, which I tagged to the invoice.
However, because I processed actual invoice and tagged it to original payment QF has £300 unallocated money from the original payment. What do I do with it? It’s from a year ago.
Was the original payment of £1000 made and then £300 refunded?
If this is the case the invoice was for too much money and a credit will need raising for the £300 and you can allocate the £300 prepayment (as per the screenshots below)
Hi Steve,
Thanks for the reply.
I’ll do as suggested, although it feels odd to be doing a refund with a positive invoice! but I see what you mean. It won’t impact the VAT and it just makes some minor changes in P&L lines somewhere.
Thanks
Susie
The accurate way to deal with this would be to find the original £1000 payment record (there’s various routes to this but the simplest is probably to click the green “tagged” button on the original bank transaction and then follow the link to “this payment …” in the popup). This should show as £700 allocated to an invoice and £300 unallocated, with a button at the top to “refund balance”. This lets you choose a date and bank account to receive the refund and will create a pre-tagged money in transaction that is a duplicate of the untagged £300 from your bank feed - delete the untagged one to get everything to balance.
Whether this works for a payment a year ago I’m not sure, it may depend on your vat settings (if any).
