Bank tagging for small amounts to one invoice

Hi

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.

Does anyone know a better way to tag them.

Regards
Ruchi

Hello @Ruchi

One option which I use frequently is to

  • Select all the items in the bank.
  • Click Tag Selected.
  • Tag them as a bank transfer (I set up a postage holding account in the bank screen to use for this).
  • Open the Invoice and pay it off using the postage holding account.

You can also set up a bank tagging rule to auto tag “Royal Mail” payments to the holding account to speed things up

Thank you for your reply.

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.

Hello @Ruchi

Etsy and eBay fees should be made using the above method using a merchant account.

https://support.quickfile.co.uk/t/handling-payments-from-merchant-accounts/8865

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.

Hello @GMB

The above process may work quicker for you.

  • Create a merchant bank account for Click and Drop
  • Select all the small payments on the bank transactions and “Tag Selected” as a bank transfer using the new merchant bank (so you can do it in one go).
  • Open the monthly invoice and log payment using the new merchant bank

The balance on the merchant account would be zero indicating they reconcile

Thank you! I will try this

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.

Hello @galarahul

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.)

  • Select all the items in the bank.

  • Click Tag Selected.

  • Tag them as Supplier Payment

  • Tag as payments to a supplier account

  • Create the invoice

  • Click Log Payment > Apply from credit xxx

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?

Hello @galarahul

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.

There may be implications on cash vat accounting.