SFTP and trial balance — get started

Revizo can automatically fetch files from an SFTP server and import them. This is especially useful for organisations that use SAP or other ERP systems without a direct API integration.

What can be imported

File type	Format	What happens in Revizo
Bank files	CAMT.053 (XML)	Transactions are imported and matched automatically via Smart Match
Trial balance	CSV or Excel	Account balances are updated in balance reconciliation

What you need

Before you start, make sure you have:

1. Administrator access in Revizo
2. SFTP server details from the bank or IT department:
   • Server name (host) and port
   • Username and password, or SSH key
   • The folder where the files are located
3. At least one client created in Revizo

Who has SFTP access?

For bank files: contact your bank for SFTP access. Most Norwegian banks (DNB, Nordea, Danske Bank, SEB) offer this for corporate customers.

For SAP files: contact your IT department. SAP can be configured to export trial balance automatically via SFTP.

---

Step 1: Create an SFTP connection

1. Go to Settings → File transfer → SFTP
2. Click "+ Add connection"
3. Fill in:
   • Name — a descriptive name, for example "DNB Operating account" or "SAP Trial balance"
   • Server — the server address (for example sftp.dnb.no)
   • Port — normally 22
   • Username — the SFTP username
   • Authentication — choose password or SSH key
   • Folder — the folder where the files are delivered (for example /outgoing or /export)
   • File pattern — the file types to fetch (for example *.xml for bank files, *.csv for trial balance)
4. Click "Save connection"
5. Click "Test connection" to verify that Revizo can connect to the server

Connection fails?

Common causes:

• Wrong username/password — double-check with the IT department
• Blocked port — make sure port 22 (or the configured port) is open in the firewall
• Wrong folder — check that the folder exists and that the user has read access

---

Step 2: Connect a client to SFTP

1. Under Client connections, click "+ Connect client"
2. Select client and SFTP connection
3. Select file type:
   • Bank file (CAMT.053) — for bank transactions
   • Trial balance (CSV/Excel) — for account balances from SAP/ERP
4. Set the polling interval (how often Revizo checks for new files)
5. Click "Connect client"

For bank files

Enter the bank account number in the client connection. This is used to route transactions from files that contain data for several accounts.

For trial balance

A bank account number is not required. Revizo identifies accounts based on the account numbers in the file.

---

Step 3: Verify the import

After the connection is created:

1. Click "Synchronise now" to fetch files immediately
2. Check the result:
   • Bank files: Go to the client’s transaction view — new transactions appear in Set 2
   • Trial balance: Go to Balance reconciliation — the account balances are updated

After the first synchronisation, Revizo fetches new files automatically based on the polling interval you chose.

---

Manual upload of trial balance

You can also upload trial balance files manually, without SFTP:

1. Go to Balance reconciliation
2. Click "Upload trial balance"
3. Drag and drop the file, or click to select
4. Select company and optionally period
5. Click "Import"

Revizo updates the account balances and stores a historical copy of the import.

---

File format for trial balance

CSV format

Revizo supports two formats:

3 columns (with company code):

2032;I001500;-1234567,89
2032;151800;987654,32

2 columns (without company code):

1500;-1234567,89
1920;987654,32

Autodetection

Revizo automatically detects:

• Delimiter: semicolon (;), comma (,), or tab
• Number format: Norwegian (1.234,56) or international (1,234.56)
• Number of columns: 2 or 3

The file does not need a header row.

Excel format

Same column structure as CSV. Revizo reads the first worksheet in the file.

Account numbers

Revizo supports all types of account numbers — including those that do not follow the Norwegian standard chart of accounts (NS 4102). Examples:

Account number	Type
1500	Standard Norwegian chart of accounts
I001500	IFRS account (SAP)
P183264	Cash pool account (SAP)
302000	Numeric SAP account

Accounts that do not exist in Revizo are created automatically on import.

---

Advanced settings

Polling interval

Interval	Recommended for
15 min	High-volume bank files (many transactions daily)
60 min	Standard bank files
360 min	Trial balance (daily or weekly export)
1440 min	Trial balance (monthly export)

After download

You can configure what happens to files after they have been fetched:

• No action — the file is left in place (default)
• Move to folder — the file is moved to an archive folder
• Delete — the file is deleted from the SFTP server

Some banks delete files automatically

DNB deletes files from the SFTP server after they have been fetched. If you use DNB, enable "Files disappear after reading" in advanced settings. Then Revizo does not need to check for files that have already been processed.

---

Troubleshooting

Files are not imported

Problem	Possible cause	Solution
0 files found	Wrong folder or file pattern	Test the connection and check that the files are in the correct folder
"Duplicate file"	The file has already been imported	Revizo never imports the same file twice — this is expected
Parsing error	Invalid file format	Check that the file follows one of the supported formats (see above)
Accounts missing	New account numbers in the file	Accounts are created automatically — check Balance reconciliation

Connection problems

Problem	Possible cause	Solution
"Authentication failed"	Wrong username/password	Contact IT for new credentials
"Connection refused"	Wrong server/port or firewall	Verify the server address and that the port is open
"Connection timeout"	Network problems	Try again — contact IT if the problem persists

---

Security

All SFTP connection details (username, password, SSH keys) are encrypted with AES-256-GCM before they are stored. Credentials are never shown in plaintext after storage.

For more information about the security measures around SFTP file transfer, see SFTP security documentation.

---

Need help setting up SFTP? Contact support@accountcontrol.no.