I’ve just started running an online “click and collect” service for my business, with payments received via PayPal. The way the system works it takes payment from the customer when they place their order, but the sale only shows in the EPOS daily sales figures once the order has been collected. At the end of each day I get a report out of the EPOS giving the total completed sales for that day with the exact net and VAT totals (we sell a mixture of food at 0% and confectionery & toiletries at 20% so the amount of VAT varies from day to day). So what I’d like to be able to do is:
- use the PayPal feed to assign all the incoming payments as prepayments to a single client account but not create any invoices
- have the feed account for the PayPal fees in the normal way
- I then take the report from the EPOS system, use that to create a sales invoice with the right net and VAT totals, and pay that invoice using the prepayment credits already received via PayPal.
However I’m a bit stuck on point 1 - if I tell the PayPal feed settings to assign to a single client it will create invoices with the wrong VAT amount, but if I tell it to leave the tagging to me then the transaction descriptions of just “Client Name (PayPal reference number)” mean that there’s nothing they have in common that I can use to define a bank tagging rule.
Is there anything I can do about this other than manually tagging every PayPal transaction individually or giving up on the feed and having to manually generate a PayPal report each day. Is it possible to add a prefix like "PayPal payment from " to the bank transactions generated from the feed, so they can be matched by a tagging rule?