I have a retail client who registered for VAT on 1st September. Prior to that I would take the monthly paypal sales with am adjustment at year end for sales prior to the paypal receipt date. Now that they have gone VAT registered I need to work out a sysytem as how best to record sales. There are sales from an ecommerce site, mostly through Paypal but some through a card merchant, and direct paypal sales from facebook orders. So first port of call is to report all daily website sales, which isn't an issue, then record all direct paypal sales but discard the website sales, which is where I'm stuck. If the client has raised a paypal invoice, paypal records it on the day payment is made, which is usually the day after, and I have to work out which is a website sale, which is a paypal invoice sale, and which is a paypal sale without an invoice (this is usually when the clients customer just makes a payment and no invoice is raised, so that will be same day.
I've had a look on paypal but I can't see anyway to do this without manually checking each sale to get the correct date I need for the VAT, which is going to be a real ball ache. If anyone has any suggestions I would be eternally grateful.