Reconcile a Bank Account

Import the statement

1. Go to Accounting → Bank Transactions.
2. Choose the bank account, click Import Statement and upload a CSV export from your bank. The file needs Date, Description and Amount columns. Type and Reference are optional; the type is worked out from the sign of the amount if it is missing.

Match money in and money out

For each transaction that paid an invoice or a bill, click Match. Plenix suggests invoices (for money in) or bills (for money out), ranked by amount, due date and reference.

Select one or more and click Accept match. This records the payment against each document and reconciles the transaction in one step.

• Selecting several splits one bank payment across several invoices or bills.
• If the transaction is for less than the document, a part payment is recorded and the rest stays outstanding.

Reconcile everything else

Bank fees, interest and similar items are not tied to an invoice or a bill. Click Reconcile and choose the account this belongs to, for example bank charges. Plenix posts a journal entry between your bank account and that account.

Choose Already in the books only for a movement you have already recorded, such as a transfer you entered as a manual journal. The transaction is ticked off and nothing is posted.

Undo a match

Click Unmatch on a matched or reconciled transaction. Any payment or journal entry it created is reversed, and the invoices or bills it settled are owed again. You can then match it correctly.

Track progress

Use the All / Unreconciled / Reconciled filter at the top of the page to work through a statement.

Where to go next

• Understand the whole module → How Accounting Works
• Payments
• Next in this module → File a VAT Return
• Create Journal Entries
• See where this fits in the bigger picture → How a Lead Becomes Cash