Client is on Xero. They started on Paypal/Stripe in January but didn't get to grips with the bookkeeping. At the moment they only have a working bank feed from their bank account.
They tried to start a bankfeed from Paypal last week, but didn't get the feed. When I looked at the Xero community section there are people complaining bitterly that a bank feed isn't possible. Someone called Karl has helpfully written out details on how to structure a csv file from Paypal, although I'm struggling to understand all his instructions.
First, do you agree that I won't be able to get a bank feed from Paypal? Will I have the same problem with Stripe?
I've just spent 3 hours matching the csv data to the Paypal statement. Many duplicate lines must be deleted and I still can't match the deposits line, but will get there one day, I'm sure.
So it is possible to construct an import file from Paypal if you've got nothing else to do all day.
MTD raises its ugly head here.
I read a post about this from another accountant on Aweb, I think last year. Someone advised him to put all the Paypal stuff in the bank account to a holding account, and then do a journal from there. That would compress the number of entry lines to 20 at the moment.
So, I think I need to forget the bank feed, and do this myself.
But what about MTD?