I understand this isn't strictly CiviCRM, but it's more a question to the community in how they work with the payouts of the popular payment processors Stripe & GoCardless.
As I understand it, both payment processors group income and payout at a certain frequency as a single payment to a bank account.
As part of our annual accounts submission, we have to show income separation between membership & donations. At the moment, that requires us to go back into Stripe or GoCardless admin UI once we receive our monthly bank statement and try and piece together how much of that payout was membership vs donations that month. Once that's done, we then can correctly input and tag it in our bookkeeping software (Sage in this case).
Is there an easier or more streamlined way to handle this?
Apologies if this is too far removed from CiviCRM subject matter and thus needs to be removed.
Any input would be greatly appreciated.