Skip to main content

Trial balance from Dynamics 365 Finance & Operations via SFTP

This guide is for the IT team setting up automatic trial balance delivery from Microsoft Dynamics 365 Finance & Operations (F&O) to Revizo. It takes about an hour once you have an SFTP server.

How it works​

  1. F&O exports the trial balance to a file on a schedule.
  2. The file is placed in a folder on an SFTP server that you control.
  3. Revizo connects to that server, fetches new files and imports the balances into the right company and period.
Revizo fetches, you don't upload

Revizo pulls files from your SFTP server. Uploading files to a Revizo-hosted SFTP server is not available yet.

1. Export the trial balance from F&O​

Revizo only needs the file. How you produce it is up to you. Common setups:

  • Data management export project on a recurring schedule (Workspaces → Data management), with a Logic App or Power Automate flow that picks up the exported file and writes it to the SFTP folder with the SFTP-SSH connector.
  • A Logic App that triggers the export itself (the Data management ExportToPackage action), downloads the package and writes the trial balance file to SFTP.

Use the same content your finance team gets today from General ledger → Inquiries and reports → Trial balance → Export to Excel. Revizo already reads that layout.

Columns​

ColumnRequiredNotes
MainAccountYesThe main account number
Closing balanceYesClosing balance in the accounting currency
NameRecommendedAccount name
Opening balanceRecommendedOpening balance for the period
DataAreaId (or Company)If one file has several legal entitiese.g. DK01, UK01
Period or DateOptionale.g. 2026-09 or the period end date 2026-09-30. If you leave it out, put the period in the file name

The file needs a header row. Other columns (Debit, Credit, … - Reporting currency) are fine and are ignored.

File format and naming​

  • Format: .xlsx, or .csv in UTF-8 (separator ;, , or tab).
  • Name: include the period, e.g. TB_DK01_2026-09.xlsx or TB_202609.csv. You can also use 2026_09 or Sep 2026. If you add a timestamp, put it after the period (TB_DK01_2026-09_20261002T0600.xlsx).
  • No period at all? Revizo can use the month before the file arrived instead. It uses the file's modification time on the SFTP server, so don't preserve the source file's timestamp when you upload.
  • One file per legal entity, or one file with a DataAreaId column. Both work.

Frequency​

Deliver once after month-end close. You can also deliver daily during the close. A new file for the same company and period replaces the earlier one in Revizo, and an identical file is skipped.

2. Prepare the SFTP server​

Create a dedicated SFTP user for Revizo that can access the export folder.

WhatDetails
AuthenticationSSH key (recommended). Revizo sends you its public key; add it to the user's authorized_keys. Passwords are also supported.
PermissionsRead access to the folder. Write/delete access only if you want Revizo to move or delete files after reading.
Port22, or the port you use.

After a file has been read, Revizo can leave it (the default, and files are never imported twice), move it to a folder such as /processed, or delete it. Tell us which one you want.

3. Allow Revizo through your firewall​

Only allow SFTP traffic from Revizo's outbound IP addresses. Revizo sends you these addresses during setup, covering both the scheduled import and the "Test" and "Sync now" buttons in Revizo. Only use the addresses we give you. Addresses found elsewhere may change.

4. Send Revizo the connection details​

Send these through a secure channel (not in plain email):

  • Host name and port
  • Username
  • SSH host key fingerprint (SHA-256), e.g. from ssh-keyscan -p 22 <host> | ssh-keygen -lf -
  • Folder path (e.g. /export/trial-balance) and file pattern (e.g. *.xlsx)
  • Company codes and which Revizo company each belongs to (e.g. DK01 = Protector Denmark, UK01 = Protector UK)
  • What should happen to files after reading (leave, move, or delete)

Credentials are encrypted (AES-256-GCM) in Revizo and are never shown again after they have been saved.

What you will see in Revizo​

  • After each delivery, Balance reconciliation shows the balances for each company and period (e.g. Protector Denmark, September 2026). New accounts are created automatically.
  • If no period can be found for a file (not in the file, the file name or the period rule in Revizo), nothing from that file is imported. Your Revizo administrator gets a notification, and the file is tried again at every sync until a period can be found.
  • Rows with a company code that is not mapped are skipped and your Revizo administrator is notified. The rest of the file is imported. Once the mapping has been added, deliver the file again.
  • The sync status and the last fetch time are shown under Settings → Integrations → SFTP.

Checklist for IT​

  • Recurring F&O export of the trial balance with the columns above
  • File written to the SFTP folder, with the period in the file name or a Period/Date column
  • Dedicated SFTP user with Revizo's public SSH key and read access to the folder
  • Firewall allows Revizo's outbound IP addresses on the SFTP port
  • Connection details, host key fingerprint and company codes sent to Revizo

Questions? Contact support@accountcontrol.no.