Domi Vera

Import payments from a bank statement

Bring in a month of bank activity from the PDF statement or a CSV export, checked and matched to leases, with a review before anything is written.

Start: Payments → Import Result: confirmed payments recorded against the right leases, and the statement kept in History.

Steps

  1. Choose PDF or CSV and upload the statement. A PDF can be the one your bank emails you; if it’s password-protected, Domi Vera asks for the password once and never stores it.
  2. PDF only, the first time for a bank: teach the layout. This takes about a minute and only happens once per layout. See teach a statement layout.
  3. PDF only: review the rows beside the statement. Domi Vera checks every row against the balances the bank printed. Continue once it says Proven.
  4. Check the matches, fix any it couldn’t place, then Record.

Why a PDF is checked against its own balances

Every bank statement prints a running balance. Each row’s balance must equal the one before it plus that row’s amount, and the opening balance plus every row must equal the closing balance. If a row was missed, doubled or misread, the numbers stop adding up at that row, and Domi Vera shows you exactly where.

Often it can name the line that was missed and offer to Add this line. If not, fix the row by hand or re-teach the layout. You can’t continue to matching until the rows add up.

A few statements print no balances at all. Domi Vera can’t prove those, so it asks you to tick that you’ve checked the rows yourself.

How matching works

First by the lease’s payment reference, which is exact. Where the tenant didn’t use it, by name, unit and amount: a best guess, shown for your confirmation rather than applied silently.

Only money coming in is matched. Payments out, such as owner payouts and bank fees, are left out.

A payment already recorded for the same lease, date and amount is flagged as already recorded and left unticked, so importing an overlapping statement is safe.

The single highest-value thing you can do for month-end is get tenants using their payment reference. Everything downstream (matching, balances, interest, arrears chasing) is easier when the money arrives labelled.

What Domi Vera can’t read

A scanned PDF is a picture of a page with no text in it, so there’s nothing to read. Download the statement from online banking instead, or export a CSV.

Related

  • The Payments tabWhere bank statements come in, where every imported statement is kept, and where you see what each unit's tenant and owner owe.
  • Teach a statement layoutShow Domi Vera once where the transactions are on your bank's PDF statement. Every later statement in that layout is read automatically.
  • Payments and allocationRecording what came in, and what it settles. A payment reduces a balance — it is not attached to one invoice.
  • Record a paymentPut money received against a lease so the balance and interest are right.