What's the best way to add data from a spreadsheet to track what I owe my partner each month?

Every month or so, my partner passes me a spreadsheet that lists out what I owe him – what is the best way to incorporate this into my tiller spreadsheet so it doesn’t mess up any of the automated bank account pulls on my end? Looking for suggestions!

Are you had your partner create the reference data in the same column order as your Tiller Transactions sheet so you could just copy and paste the rows into your Transactions sheet manually?