Match a bank statement to your invoices

What it does

Instead of recording each payment by hand, you upload the CSV from your online banking. Welodge picks out the incoming payments and suggests which invoice each one settles. Nothing is recorded until you confirm it. Available on the Landlord plan and above.

Steps

1. Download a statement as CSV from your bank. Most banks offer this under statements or transactions.
2. Go to Bank import, choose the file and select Upload and match.
3. Each payment has a drop-down with Welodge's suggested invoice already chosen. Change any that are wrong, choose Not rent – ignore for anything that isn't rent, or leave it on Decide later.
4. Select Record payments. The matched payments are recorded against their invoices, and rows left on "Decide later" wait for next time.

How matches are chosen

• If the payment reference contains an invoice number, it is matched with confidence.
• Otherwise Welodge looks for the tenant's name together with the exact amount owed.
• Failing that, an amount that matches exactly one open invoice is suggested.

Good to know

• Uploading the same statement again is safe: payments you have already confirmed are skipped.
• Works with exports from most UK banks. If your bank's file isn't read correctly, email us the column headings (not the transactions) and we'll add support.
• The file is only used to find rent payments.