Bank reconciliation

Bank reconciliation is the process of matching the transactions on your bank statement to the invoices, bills, and other records in PLANA. When done correctly and frequently, it keeps your books accurate and your VAT report clean.

Where transactions come from

Three sources feed the bank journal:

Source	How
PSD2 (open banking)	Automatic pull from your bank every hour. Available for the 10 supported Bulgarian banks
CSV / OFX upload	Manual upload from your bank's online portal
Manual entry	Direct entry in PLANA (rare; for cash deposits)

PSD2 is the recommended source — see Plana extras → Banking PSD2 for setup.

The reconciliation screen

Accounting → Banks → click your bank journal → Reconcile.

You see two columns:

Left column	Right column
Bank transactions (from statement)	Suggested matches from PLANA
Newest first	Open invoices / bills / payments / journal entries

Each transaction has a suggested match if PLANA can find one. The confidence is shown as a colour:

• Green — exact match (amount + reference + counterparty)
• Yellow — partial match (amount only, or fuzzy reference)
• No match — manual reconciliation needed

Matching workflow

For each transaction:

Confidence: green — confirm

The transaction matches one open invoice or bill exactly. Click Confirm. PLANA:

1. Marks the bank transaction as reconciled
2. Marks the invoice / bill as paid
3. Creates the journal entry tying them together

Done in one click.

Confidence: yellow — review and adjust

PLANA shows the suggested match. Verify:

• The amount matches (or note the difference)
• The customer / vendor is right
• The reference makes sense

If the match is correct, click Confirm. If not, click Search and pick the right invoice.

For partial payments, accept the partial amount; PLANA leaves the balance open on the invoice for a future payment.

No match — manual

You'll see "No match found". Options:

Option	When
Search	Pick an invoice / bill from the open list
Create journal entry	For non-invoice items (bank fee, interest, owner deposit)
Match to multiple	The transaction covers several invoices
Defer	"I'll deal with this later" — stays unreconciled

Match to multiple

A single bank transaction can pay multiple invoices:

1. Click the transaction
2. Check the box next to each invoice it covers
3. Confirm

PLANA distributes the payment across the selected invoices and creates the journal entries linking everything.

Bank fees and adjustments

When the bank charges a fee, you see a small outgoing transaction (e.g. BGN 5 for a monthly account fee). To reconcile:

1. Click the transaction
2. Click Create journal entry
3. Pick the bank fee expense account (6219 or similar)
4. Click Confirm

The fee posts to the right expense account; the bank balance ties.

Reconciling cash

For cash accounts (cash drawer, petty cash):

• Use the Cash journal instead of a Bank journal
• Transactions are typed manually
• Reconciliation is the same flow — match cash receipts to invoices, cash disbursements to bills

When reconciliation goes wrong

A transaction doesn't match any invoice

The customer paid before you issued the invoice. Or the customer paid the wrong amount. Or the bank fee category is new.

Resolution: investigate. Often a quick call to the customer clears it up. The transaction stays in "unreconciled" until you resolve.

The bank balance and the GL balance disagree

Compare:

• The bank balance shown by your bank
• The GL balance of the bank journal in PLANA

If they differ, there's an unreconciled transaction. Filter the bank journal by "unreconciled" and reconcile the outliers.

A reconciled transaction was wrong

You can unreconcile:

1. Open the journal entry created by the reconciliation
2. Action menu → Cancel → confirm
3. The bank transaction returns to "unreconciled"
4. The invoice / bill returns to "open"

This is reversible. Just don't make a habit of it — the audit trail shows reconciliation undo events.

Multi-currency reconciliation

For foreign-currency bank journals:

• The bank transaction is in the foreign currency
• The matched invoice can be in any currency
• PLANA computes the exchange-rate adjustment (gain or loss)
• The journal entry includes the FX adjustment

The daily rates come from the European Central Bank. Override per-rate if your bank used a different rate.

See Multi-currency.

Pace

A typical SMB:

• Reconciles daily, ~5 minutes per day, end-of-day or first-thing
• Catches issues within 24 hours
• Closes month-end with all transactions reconciled

A monthly cadence is OK but invites surprises at month-end. Daily is the right rhythm.

Working with the Finance agent

BOS's Finance agent helps with reconciliation in two ways:

1. Suggested matches for unreconciled transactions ("here's what this BGN 12,500 incoming payment likely matches")
2. Investigation when something looks weird ("why is this BGN 47 showing up — is it a duplicate?")

See BOS → Workflows → Reconcile the bank.

Where to read more

• Customer invoicing — the invoices you reconcile against
• Vendor bills — the bills you reconcile against
• Payments — explicit payment registration
• Multi-currency
• BOS → Banking — the BOS-side view