Skip to main content
LetCompliance

Help centre: Compliance and tax

How do I bring in last year’s income and costs from a spreadsheet?

Save the spreadsheet as a CSV file and drop it on Bank statements. Its date, description and amount are read, and its Category and Property columns too if it has them, so each line arrives sorted. Nothing is recorded until you confirm it.

Collect the rent, log every cost and keep the tax figures ready, from £7.99 a month.

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.

Where this lives

Bank statements.

Open it in LetCompliance

Still stuck? Ask LetCompliance directly. A person reads it.

Run the whole let from one login.

Advertise and reference tenants, sign the agreement, collect the rent, log repairs and keep the tax figures ready all year. Certificates, deposits and deadlines are tracked alongside, so nothing expires unnoticed.

Plans from £7.99 a month, with a 3-day trial and no card. Making Tax Digital, recognised by HMRC, comes with every paid plan, not the trial.