I have a problem trying to reconcile any inputs coming into the bank account through Xero. I want to be able to reconsile each daily Stripe/Paypal payout (made up of previous day/few days of website transactions) but have no way oif linking these payouts to the transactions. I have managed to get all transactions creating invoices in Xero but there is no way to link these to the payouts from Stripe/Paypal and it does not take into account any fees or refunds etc.
I want to be MTD compliant but I also want to be able to keep my bookkeeping up to date without speding hours reconsiling each individual transaction as there is up to 10,000 indivdual transactions per month. But only 20-30 payouts per payment processor. I am sure I am not the only one experiencing this problem but I cannot find a solution anywhere or someone with enough Xero and ecommerce experience to help me out.
I am hoping someone here has either dealt with this problem previously or has a solution that may help. Please advise any help greatly appreciated.