Stage and review a reconciliation CSV

Where to start
Admin Area → Property Management Flow → Accounting & Arrears → Transaction reconciliation

Before you begin

Prepare a CSV with date and amount columns. Use a reviewed transaction source and reconcile source counts before posting.

Follow these steps

1. Include date and amount; add reference/description and credit/debit direction where possible.
2. Keep the CSV at or below 5 MB and 5,000 transaction rows.
3. Enter Source / bank label and choose Stage & suggest matches.
4. Open the batch and inspect every suggested and unidentified transaction.
5. Compare date, amount, direction, reference and property with the original source.
6. Resolve invalid or missing rows before matching.

If something does not look right

Rows with invalid dates, invalid amounts or zero/non-positive normalised amounts can be skipped while the total source row count still advances. Compare the displayed rows with the original CSV rather than accepting the batch total alone.

Questions and answers

What date format should I use?

Use an unambiguous ISO date, YYYY-MM-DD.

What happens to a negative amount?

Its absolute value is stored and direction defaults to debit unless a valid explicit credit/debit value is supplied.

How are suggestions chosen?

The matcher checks an amount within £0.01 among a bounded set of eligible entries. A property code in the reference raises confidence. A suggestion is not proof of the correct match.

Related technical reference: Britixo's detailed product guide (opens in a new tab). The screens available to you depend on your configured modules, company and permissions.

Useful next steps

• Create rent schedules and generate charges
• Record a receipt and understand rent allocation
• Read arrears ageing and landlord statements

Contact the Proplix team if you need help with your setup. Include the page or record reference and a description of the issue; leave passwords and private access tokens out of the message.