I hope you could help me. I have many small amounts paid for postage & they need tagging to one single monthly Royal mail Click & Drop invoice. I tried selecting all the postage that was paid in a particular month & bulk tag to that month’s invoice however the bulk tagging couldn’t help me to tag any particular invoice but to a supplier creating multiple invoices for tiny payments. I know you can tag each payment to the monthly invoice individually however there are more than 100 transactions that needs tagging single monthly invoice.
Is it not possible in Quick file to tag to invoice directly rather than payment on account to supplier. That way we can reconcile the invoice & payments made to that particular invoice.
I have same issue for tagging ebay, etsy fees to their particular invoice with multiple fees payment are made & they send us monthly invoice for that.
I get my monthly invoice from Click and Drop and enter this as a purchase invoice. I enter the small payments on the bank transactions as Click and drop postage. When reconciling the bank account, I tag these as to Click and Drop and “paying down an invoice” this shows the outstanding invoices and you just allocate it.
It does take some time, I haven’t found an easy way to do all payments at the same time, but at least it all tallies.
Hi
The bulk tag functionality in its current state is not suitable for micro transactions as it creates multiple invoices for each payment. If there is pop up box when lines/payments are selected to be bulk tagged. gives both the options - one single invoice OR multiple invoices (default & only option right now) to be raised, then that feature will resolve the problem for us & hopefully other users too.
In the past we used the holding account way around & it worked when the number of holding accounts is small. We have hundreds of lines for - Royal Mail, Ebay, Etsy, Amazon, Worldpay & actual supplier holding account where we genuinely transact & settle contra invoices where a supplier becomes a customer too in some instances. So it will be too many holding accounts to manage on top of multiple bank, merchant, currency, marketplace accounts. So I am hoping that a purpose built feature can be brought to resolve this in an easier way.
The other option (to avoid creating multiple invoices or using merchant accounts) is to tag them all to the suppliers account (as payments on account) then you can create a single invoice and pay it using the credit (oldest credit is used first.)
Will the above suggested way to tag to supplier on account & tagging the payments to each invoice from the balance from supplier account be able to track the payments that are tagged in current account to that particular invoice?
This method would build up a credit on the supplier account which can then be used to pay invoices but it would use the oldest credit first when allocating the credit.
e.g.
Payment 1 = £2
Payment 1 = £2
Payment 1 = £4
If you raise and invoice for £4 then try and apply the payment using the credit, it would assign Payments 1 and 2 to clear the balance.