What is it?
Bank CSV import lets you read a statement as a CSV file and match the payments received to open invoices.
Import a bank statement: match payments without retyping
Invoicing & admin
Upload a CSV statement from your bank, check the rows and match incoming payments to your invoices. This is a CSV import, not a bank connection.
Start free, no credit card needed.
Who is it for?
For freelancers who keep track of which invoices have been paid themselves and no longer want to check that line by line in their banking app.
What problem does it solve?
Tracking which invoice is paid means laying bank lines next to your invoice list. With an import and a match per payment you see at once what is still open.
What you get
01
Match payments to invoices
Match an incoming payment to the invoice it belongs to; the invoice gets the payment recorded.
Start for free02
Suggestions and search
SmartWerk suggests invoices that fit a payment, and you can search yourself.
Start for free03
Duplicate rows in view
The same row in two files is flagged, so you do not count it twice.
Start for free04
Works with your own file
You use the CSV file from your own bank and map the columns yourself.
Start for freeHow it works in SmartWerk
Create a bank account
Give the account a name, optionally an IBAN, and choose the currency.
Import the CSV file
Choose the file and map the columns: date, amount (or debit and credit), description, reference and counterparty.
Check the summary
See how many rows were read, accepted, rejected or possibly duplicate.
Match to an invoice
Choose Match invoice on an incoming payment, or undo the match.
Part of one workflow
SmartWerk follows a job from client to bookkeeper. The highlighted step is this page.
What you can do
The import closes the loop after invoicing: you match the payment to the invoice, and what is paid needs no reminder.
Configurable column mapping
Set delimiter, date format, decimal format and columns so the file from your bank fits.
A file only once
Importing the same file again creates no new transactions.
Review duplicates
You keep possible duplicates or mark them as duplicate; nothing is deleted.
Match and unmatch
Match a payment to an invoice, partially too, and undo that if needed.
Overview of transactions
Search and filter imported rows by direction and status.
Connected to other tools
Frequently asked questions
Is this a connection to my bank?
No. You import a CSV file yourself. SmartWerk does not read your bank account by itself.
What happens if I import the same file twice?
No new transactions are created. SmartWerk reports that the file has already been imported.
Can I match a payment to an invoice?
Yes, for incoming payments in euro. An amount higher than what is still open is rejected; a lower amount counts as a partial payment.
Do I need to set anything up per bank?
You set the separator, date format, decimal sign and columns yourself so the file from your bank fits. There are no ready-made settings per bank.
Try it with your own data
Create a free account and start with one client. Upgrading can wait until you really need a feature.