Bank Reconciliation
Pro and Max plan feature: Bank reconciliation is included in the Pro and Max plans. If your plan doesn’t include it, opening the page takes you to the License page, where you can upgrade.
With bank reconciliation you upload your bank statement and FatturaSmart matches each transaction to the corresponding invoice: you review the proposals and register payments in bulk, instead of recording them one invoice at a time. It works both for income (issued invoices) and for payments (received invoices).
Uploading the bank statement
Step 1: Open Bank reconciliation
Click Bank reconciliation in the side menu.
Step 2: Upload the file
In the “Drag your bank statement here or click to browse” area, upload the file downloaded from your bank. Supported formats are CSV and Excel (.xlsx, .xls), up to 10,000 transactions per file.
Statement already uploaded? If the file was already processed in the past, FatturaSmart warns you and lets you confirm re-uploading it to repeat the processing.
AI and privacy: match suggestions are generated with the help of artificial intelligence. Counterparty names and transaction descriptions are replaced with anonymous codes before being sent to the AI service. Details are in the privacy policy.
Mapping the columns
Every bank exports statements with different columns, so on the first upload FatturaSmart asks you to map the columns: “Tell us which file columns correspond to the required fields.”
| Field | Required | Description |
|---|---|---|
| Date | Yes | The date of the bank transaction |
| Amount | Yes | The column holding the transaction amount |
| Debit column / Credit column | Only for files with separate columns | Fill in only if the file uses separate debit and credit columns |
| Description | Yes | The transaction description |
| Counterparty | No | The name of the payer or beneficiary |
| Currency | No | The transaction currency. Transactions in currencies other than euro are not matched automatically |
Automatic: FatturaSmart remembers your bank’s column mapping. You won’t have to redo it on future uploads.
Click Process: the “Analysis in progress” starts — FatturaSmart compares the transactions with your invoices, which can take a moment.
Reviewing the matches
On the “Review the matches” page you check the proposals, edit or reject matches, then register the payments. Transactions are grouped in three sections:
| Section | What it contains |
|---|---|
| Auto-matched | Transactions matched to an invoice with high confidence, ready to register |
| To confirm | Match proposals to check one by one before registering |
| No match | Transactions for which no compatible invoice was found |
For each proposal you see the suggested invoice, the amount, the match confidence and the signals that produced it — for example an exact amount, a matching name, the invoice number found in the description, the distance between dates, or a possible duplicate of an already-registered payment.
Checking and correcting a proposal
- View document opens the invoice details: issue date, due date, collected amount, remaining due and lines, with a button to open the full document.
- Edit match lets you pick a different invoice: use “Search for an invoice” by number or client, with the remaining due amount shown for every result.
- Reject discards the proposal: the transaction stays unmatched and won’t be registered.
Registering the payments
Select the transactions to register — one click selects all auto-matched ones — and press Approve & register.
FatturaSmart asks for confirmation with “Register the payments?” and a summary: “N payments totalling X will be registered. This operation cannot be undone.”
This cannot be undone: confirmed payments are registered on the matching invoices with the bank transaction date. Review the proposals before approving.
At the end you see the outcome: all payments registered, or a partial registration with the list of skipped transactions and the reason:
| Reason | Meaning |
|---|---|
| Payment already registered | The invoice already had a payment for that transaction |
| Invoice not found | The matched invoice no longer exists |
| Amount exceeds the remaining due | The transaction amount is higher than what is still due on the invoice |
Automatic: every registered payment immediately appears on the invoice and in the Journal, just like a manually recorded payment.
With Upload another statement you start the cycle again with a new file.
Next steps
Now that you know how to reconcile your bank statement:
- Use the Journal to check the registered movements
- Manage payments for payments you register manually
- Configure Balance Accounts to organize movements by bank
Need help?
If you have questions about bank reconciliation:
- WhatsApp: +39 351 410 2536
- Email: info@fatturasmart.com
We respond personally, no bots!
Frequently Asked Questions
Which bank statement formats can I upload to FatturaSmart?
You can upload your bank statement as CSV or Excel (.xlsx, .xls), with up to 10,000 transactions per file. No specific layout is required: after uploading you indicate which columns hold the date, amount, description and counterparty, and FatturaSmart remembers the mapping for future uploads.
Does bank reconciliation use artificial intelligence? What data does it see?
Match suggestions are generated with the help of artificial intelligence, but counterparty names and transaction descriptions are replaced with anonymous codes before being sent to the AI service. Details are described in FatturaSmart's privacy policy.
Can I correct a proposed match?
Yes. From each transaction you can open Edit match and search for the right invoice by number or client, with the remaining due amount shown for every result, or click Reject to discard the proposal.
What happens when I click Approve & register?
The selected payments are registered on the matching invoices with the bank transaction date and appear in the Journal. The operation cannot be undone: before registering, FatturaSmart shows a summary with the number of payments and the total.
Which plan includes bank reconciliation?
Bank reconciliation is included in FatturaSmart's Pro and Max plans. If your plan doesn't include it, opening the page takes you to the License page, where you can upgrade.
Are transactions in currencies other than euro matched?
No: transactions in a currency other than euro are not matched automatically. They remain visible among the unmatched transactions and you can register them manually on the invoice.
