Importing letting agent statement as a sales invoice

Support
1

I’m trying to import my letting agent’s statement as a sales invoice. My CSV looks like this:

Issue Date,Client name,Description,*Total gross amount,*Invoice number,Currency,Sales nominal code

01/06/2026,Lets Ltd,Cleaning June 2026,*-27.00,*2026-06-21HR,GBP,6080

01/06/2026,Lets Ltd,Rent June 2026,*1049.00,*2026-06-21HR,GBP,4000

01/06/2026,Lets Ltd,“Management fee, flat 1”,*-104.86,*2026-06-21HR,GBP,6050

4000 is the account code for my rental income (sales)
6080, 6050 are expense accounts

When I’m trying to import this, I get a bunch of errors that look like this: “Error at line 1: Total gross amount should be a positive value.”

2

Hello @stogra

You can not import credits onto an account.

You have a mixture of sales and purchases on the statement.

It would be better to

  • Set up a bank account (merchant account) for the agent.
  • Import the statement (use the other option).
  • Tag the sales (rent income) as a sales invoice to a tenants client account.
  • Tag the purchases as purchases as invoices to a supplier account for the agent.

Here are some more articles explaining the best way to deal wit agents for landlords

Bookkeeping for Landlords - Recording Letting Agent Statements and Fees (Standard Method)

Bookkeeping for Landlords - Recording Letting Agent Statement and Fees (Alternative Method)