Change of accounting software — data import and export

Tutorial: How to proceed when changing software and which data and formats can be imported and exported.

Content 

  1. What data can be imported?
  2. Before changing: close previous bookkeeping
  3. Journal: Bank account movements
  4. People: Import contacts and articles data
  5. Files: Documents, files (file upload)
  6. Which data can be exported?
  7. Good to know: Backup and restore
Change guide by CashCtrl

1. What data can be imported?

  • Journal: bank transactions as camt053, camt054 or MT940 file
  • Inventory: articles 
  • People: contacts
  • Files: Documents and files

2. Before changing: close previous bookkeeping

If you want to switch to CashCtrl, we recommend closing the previous accounting at year-end, mid-year or month-end. This is the basic way to start accounting with CashCtrl with the opening entries at a given date. Journal entries cannot be transferred from other accounting programs.

Set up CashCtrl in 8 steps

 

Screenshot of the checklist to set up CashCtrl

3. Journal: bank transactions

Transactions from your bank account can be loaded into CashCtrl via a transaction import. Supported are camt053, camt054 and MT940 files. You can get these files from your bank on request.

More about the bank import

Screenshot of import of a camt file into CashCtrl

4. People / Inventory: import contacts and articles data

Contacts

Contacts do not have to be typed manually, but can be conveniently loaded into CashCtrl with an importer for Excel, CSV and vcf (vCard) files. Duplicates can be recognized and entries can be complemented.

 

Articles

Your article master files do not have to be added again in CashCtrl. They can also be imported comfortably into the inventory. Excel and CSV files are supported.

Click here for the import tutorial

Screenshot of the columns mapping in the import window

5. Files: Documents and files (file upload)

Files are stored centrally in CashCtrl in the Files module. The file manager shows an overview of all files available in CashCtrl. Documents that are imported as attachments to book entries are also stored here. In the same way, documents from the previous accounting can be stored here.

Information about the file manager

Screenshot of the file manager in CashCtrl

6. Which data can be exported?

  • Journal: Book entries as PDF , Excel or CSV
  • Inventory: Articles as Excel or CSV
  • Orders: Single documents as PDF or multiple / all as .zip
  • People: Contacts as Excel , CSV   or vcf
  • Files: Single documents or receipts as .zip
  • Reports: account statements and reports as PDF , Excel  or CSV

7. Good to know: Backup and restore

Backups cannot be saved locally on your computer. CashCtrl offers a backup function, whereby the backups are stored at different server locations than the current accounting. Thus, the data is stored in different locations and therefore very safe.

Click here for the backup tutorial