My client uses Xero for bookkeeping and the bank statements are imported (unfortunately in Ireland they don't seem to have not gotten around the issue of no live bank feeds since brexit but they are working on it) and they make sales using Worldpay and stripe for payments.
My issue is that the Worldpay and Stripe transactions come into the bank as single line transactions but the total of each of these transactions actually incorporate several sales to different individuals which are recorded separately on Xero.
Is there a straightforward way to reconcile the single line Worldpay/Stripe transactions from the bank with the multiple Xero entries that make each of them up?
Surely you dont just get the information from one source for most transactions! You need to get it from card providers. WP does a data link for xero now. Stripe does csv. BTW they dont 'make sales' using these 2, they are just payment mechanisms.
I understand they are just payment mechanisms, I should have said, "when the company make sales, they use WP and stripe for payment", please excuse my grammar.
I have access to the WP account which means I can reconcile the bank transaction with the WP payment transaction, but it still means I will have to individually reconcile each of the multiple sales transactions that make the total up of the WP payment transaction in the bank. WP does not identify the card holders that the sales are made to, whose details are recorded in Xero.
I was hoping to reduce the workload for reconciling all of these transactions.