Keep your personal money separate from your company and your holding, without a graveyard of spreadsheets.
Each set of books is its own entity. Transfers between them are labelled as transfers, so a loan to your company never looks like an expense.
Photograph, confirm, move on. Rental income, home-office, and USD subscriptions are all handled honestly.
One clean export per entity, in their nomenclature, with every figure marked for their review.