Bringing it in
1. In Excel or Google Sheets, save the sheet as a CSV file.
2. Open Bank statements and drop the file on the page, or choose it.
3. Check the columns it found: the date, the description, the amount, and the category and property if your sheet has them.
4. Go through the list and confirm each line, or set it aside.
The Category column
A category written exactly as a Finance category is used as it is. Anything that could mean two things, such as Mortgage (the whole payment, or only the interest?), is listed for you to choose before the file is imported.
The Property column
A property is matched by its address or postcode only when exactly one of yours fits. Otherwise you choose.
Not counted twice
A line that matches rent already marked paid, or an entry already in Finance, is shown as such rather than added again.
Why it matters mid-year
Making Tax Digital updates are cumulative, from the start of the tax year, so months kept in a spreadsheet before you joined need to be in before your next update.