Import a statement and reconcile

Purpose

The bank statement import reads the CSV export of your bank and reconciles each credit with the open amounts (rents and service charges). Matching relies on the reference, the amount and the name of the payer, in order to validate most monthly payments in a few clicks.

Each line displays its status (“Matched”, “To confirm” or “Unmatched”) and the selected reason, so that the agent only verifies uncertain cases.

Where to find it

1. Finance
2. Transactions

“Bank statement import” block below the list.

Steps

1. Click “CSV file” and choose the export of your bank.
2. Map the “Columns” of the file, which must include at least the “Date” and the “Amount (signed)”, or the “Credit” and the “Debit”, followed by the “Counterparty”, the “Counterparty account” and the “Reference”.
3. Click “Import”, so that REOS indicates the number of imported, matched and already known lines.
4. In “Lines to validate”, verify the “Matched with” proposal or choose another amount in “Choose an amount”.
5. Select the correct lines and click “Validate selection”, or dismiss a line with “Ignore”.

Good to know

• Column mapping is saved for the next import, in order to avoid repeating it every month.
• An already imported line is not created a second time, and outgoing payments are not proposed for matching.
• Validation updates the status of rents to “Paid” and triggers the sending of receipts.

Related guides

• Rent and financeTrack transactionsConsult all expected and received amounts, rents, service charges, fees and expenses, and record receipts.
• Rent and financeRecording a payment and the receiptMark a rent as paid so that REOS generates the receipt, sends it to the tenant, and files it within their documents.
• Account and subscriptionManaging portal credentialsRegister the publication credentials for real estate portals, and identify those that connect on request.