How to Auto-Reconcile Invoices with Bank Payments

The Problem with Manual Reconciliation

If you send more than a handful of invoices each month, you know the pain: logging into your e-banking, scrolling through transactions, cross-referencing amounts and reference numbers, and manually marking each invoice as paid. It's tedious, error-prone, and a massive time sink.

• Cross-referencing amounts — Scrolling through endless bank transactions trying to match numbers
• Error-prone process — Manual data entry leads to mistakes and missed payments
• Hours wasted monthly — Time spent on admin instead of doing the work you actually invoice for

What You'll Learn

In this tutorial, you'll learn exactly how to:

• Export your bank transactions from your e-banking portal
• Import the transaction file into Magic Heidi
• Let the app auto-match payments to your outstanding invoices

The entire process takes less than a minute, even if you have dozens or hundreds of invoices waiting to be reconciled.

Understanding Auto-Reconciliation

Magic Heidi uses a file-based approach: download a transaction export from your e-banking portal, then import that file into Magic Heidi. The app analyzes every transaction and compares it against your open invoices.

• Privacy & Security — Your bank credentials never leave your bank. Magic Heidi never asks for or stores your e-banking login details.
• Full Control — You decide exactly when and what data to import. Nothing happens automatically in the background without your knowledge.
• Universal Compatibility — Works with virtually any Swiss bank — UBS, PostFinance, Raiffeisen, ZKB, and more — that exports CSV or Excel files.
• Instant Matching — Transactions are compared against all outstanding invoices using amounts, reference numbers, and identifying data.

Reconcile Invoices in 3 Simple Steps

From your e-banking portal to fully reconciled invoices in under a minute.

Step 1: Export from E-Banking

Log into your e-banking portal, navigate to account transactions, select a date range, and download as CSV or Excel.

Step 2: Drag & Drop into Magic Heidi

Locate the downloaded file and drag it directly into the Magic Heidi app window. No special import menu or settings needed.

Step 3: Auto-Matching in Action

Magic Heidi reads every transaction, compares against open invoices, and automatically marks matches as paid.

Done — Review Results

Matched invoices disappear from your awaiting payment list in real time. The whole process takes just seconds.

As soon as you drop the file, Magic Heidi immediately begins processing. Matched invoices disappear from your "awaiting payment" list in real time. In the tutorial example, two invoices were awaiting payment — after import, both were automatically identified as paid and removed from the outstanding list.

Works with All Major Swiss Banks

Export transaction files from your preferred bank and import them seamlessly into Magic Heidi.

• UBS — Navigate to account transactions and click the download button for CSV or Excel.
• PostFinance — Use the "Export" option in your account movements section. CSV exports work perfectly.
• Raiffeisen — Go to account overview, select transactions, and use the export/download function.
• ZKB — Transaction exports are available under account details. Choose CSV format for best compatibility.

Best Practices

Reconcile Regularly

Make it a habit to reconcile on a consistent schedule — weekly, bi-weekly, or monthly. The more frequently you reconcile, the easier it is to identify missing payments early.

• Weekly reconciliation for high-volume invoicing
• Monthly reconciliation for smaller workloads
• Stay on top of overdue payments faster
• Keep financial records always current

Don't Worry About Duplicates

You can import the same or overlapping transaction files as often as you want. Magic Heidi won't double-mark an already reconciled invoice.

• Import overlapping date ranges safely
• No need to track which files were imported
• Re-import anytime without consequences
• Smart deduplication built in

Review After Import

While auto-matching is highly reliable, always do a quick review. Unmatched invoices may indicate pending payments, partial payments, or ambiguous transaction data.

• Check remaining unpaid invoices
• Identify payments still in transit
• Spot partial or mismatched amounts
• Manually mark edge cases as paid

Time Savings: Why This Matters

As your business grows, manual reconciliation becomes a genuine bottleneck. With auto-reconciliation, the time investment stays the same regardless of volume.

Real-Time Financial Visibility

Beyond saving time, automatic reconciliation gives you accurate, real-time visibility into which invoices have been paid and which are still outstanding. Follow up on overdue payments faster and maintain cleaner financial records with fewer human errors.

Quick Recap

Reconciling invoices with bank payments doesn't have to be a chore. Here's the entire process:

1. Download your transaction file from your bank's e-banking portal
2. Drag and drop the file into Magic Heidi
3. Done — invoices are automatically matched and marked as paid

It works with all major Swiss banks, handles any volume of invoices, and you can run it as often as you like without worrying about duplicates.