MUbase
MUbase

Solutions for your tasks

Open your own account

Finance | base4 min readUpdated:

Export data from Sage 50: guide for switching

Journal, account sheets, receivables, chart of accounts and payroll from Sage 50 (now Infoniqa ONE 50): routes per the manufacturer’s help.

KMU | base editorial team

DeutschEnglishFrançaisItaliano
By emailLinkedIn
Stacked cardboard boxes, ready for the move

Since Infoniqa took over Sage Switzerland in 2021, Sage 50 is called Infoniqa ONE 50. If you want to switch, you need your data as files. This guide shows the routes the manufacturer’s help describes. The details rest on excerpts of the online help; check the labels in your version.

Before you start: what you need

Sign in with a user who may see and export every area. Create a folder where you collect all the files. Export before you cancel Sage 50 (heute Infoniqa ONE 50): once the contract ends, access is gone, yet you must keep the accounting records for ten years (art. 958f Swiss Code of Obligations, CO). Note the date of the last export; anything booked afterwards would have to be entered by hand.

Step by step: exporting from Sage 50

  1. Evaluations to Excel: open the evaluation you want, for example journal, account sheet or open items. In the «Datei» menu choose the command «Ausgabe», enter path and name, and under «Dateityp» pick Excel (or Word, HTML).
  2. Addresses, personal accounts, postings and chart of accounts: according to the manufacturer’s help, the interface module for accounting handles the formats TAF, Beam and CSV. TAF is recommended, with a separate file for each type of data.
  3. Payroll journal: open the evaluation «Lohnjournal» and output it to Excel as above, via «Datei» › «Ausgabe».
  4. Staff master data: the file export in ASCII format creates the file «pers.asc». The fields are set in «pexport.def»; according to the help, only the dealer or support change them.
  5. Whole client file: via «Extras» › «Link» › «Exportieren» you export the client file with a reference date, uncompressed or as a ZIP. The format is Sage’s own and meant more for handing over to your fiduciary. According to the help, exported postings stay locked until the data is read back; agree this with your fiduciary first.

For KMU | base the Excel evaluations are usually enough: journal per financial year, account sheets, open receivables and payables, and the chart of accounts.

What the help does not describe

For articles, invoices as PDF, absences and documents we found no export in the manufacturer’s help. Ask your Sage dealer or the manufacturer’s support, or let us help: we are happy to show you the export. The interface command of order processing (global export, reconciliation of personal accounts) transfers into the accounting client file and does not produce a file for switching.

Practical example: Alpstein Bau AG

Alpstein Bau AG is a fictional construction firm with twelve employees that has used Sage 50 for years. In December the bookkeeper outputs the journal of the last three years to Excel, plus the account sheets, the open receivables at the reference date and the chart of accounts. She puts the payroll journals and the staff master data in the same folder. The fiduciary also receives the client-file export for the archive. KMU | base reads the files in a trial run; the bookkeeper compares the old and new balance account by account and approves only then.

How KMU | base helps

1. We take care of it. The data transfer is free and takes at most 24 hours on working days. You supply the export, we sort the data and enter it. Everything else is on the page From Sage 50 to KMU | base.

2. Trial run before the transfer. You see what will be newly created and what already exists. Nothing is transferred until you approve it, and a transfer can be reversed.

3. Not sure which file is missing? We are happy to show you the export before you cancel Sage 50.

To try it yourself, take a look at the demo or open a test account.

Sources

This guide describes the menus of Sage 50 according to the manufacturer’s help; labels may change. Information as of 9 November 2026.

Back to top

Collaboration ×

The next step starts with a conversation.

What does your business need?

Try the demo account Request a quote