Import Norway Audit File (BETA)

Download app: ch.banana.no.autidfile.sbaa

Development: importapps

Auditors can use the SAF-T file to recreate in Banana Accounting a full accounting file, allowing them to access the data at any time. Even if they do not have access to the original accounting software, they can view the accounting data, extract reports and other information.

Great advantages for auditors:

  • Access and display of the SAF-T file data.
  • Accounting data on the auditors computers.
  • Save time to do the audit.
  • Work faster.
  • Improves the efficiency.
The currently "Import Norway Audit File" BananaApp is in Beta version. Changes may be made in future.

We kindly ask our users to cooperate with us to improve the app.

The "Import Norway Audit File" app provides to import in Banana Accounting the following data from the SAF-T file:

  • General ledger accounts.
  • Customers accounts.
  • Suppliers accounts.
  • Transactions.

In order to use this app and import correctly the data, it is required to follow the following steps:

  1. Install Banana Accounting software (required version 9.0.4 or more recent).
  2. Install the "Import Norway Audit File (BETA)" BananaApp.
  3. Create a new accounting file.
  4. Run the "Import Accounts" app.
  5. Run the "Import Transactions" app.
  6. Adjust the accounting plan

Install Banana Accounting software

Download and install Banana Accounting (version 9.0.4 or more recent) on your computer.

Install the BananaApp

See the Manage Apps documentation to install the "Import Norway Audit File (BETA)" app in Banana Accounting.

After the installation the apps will be visible in the Accounting1 > Import to accounting... menu:

  • Select "Accounts" to see the "Norway Audit File - Import Accounts (BETA)" app.
  • Select "Transactions" to see the "Norway Audit File - Import Transactions (BETA)" app.

Create and set up the accounting file

After these installations the software is ready. Auditors can now start to setup an accounting file in order to import the SAF-T data in it.

Create a new accounting file

Set up the accounting file

  • Change the accounting period in the Accounting tab:
    • Menu File > File and accounting properties...
    • Insert the opening and closing dates of the accounting based on the period of the SAF-T file.

The accounting file is now ready for a new and clean data import from the Audit file.

Importing Accounts in Banana Accounting

To run the import accounts app:

  • Menu Accounting1 > Import to accounting...
  • In the import section select Accounts
  • From the list select Norway Audit File - Import Accounts (BETA)
  • In the File name field, click Browse and insert the SAF-T xml file
  • Confirm with OK

For more information, please visit Import into accounting and Import accounts.

When the app is executed, the script retrieves the following data from the Audit file:

  • General ledger accounts
    • Account number
    • Description
    • BClass
    • Opening balance
  • Customers and suppliers accounts
    • Account number
    • Description
    • BClass
    • Address

All the data retrieved are then inserted in the Accounts table of the accounting file:

  • Accounts are imported on top of the file's Accounts table.
  • Accounts that already exist in the Accounts table are not imported.

Importing Transactions in Banana Accounting

To run the import transactions app:

  • Menu Accounting1 > Import to accounting...
  • In the import section select Transactions
  • From the list select Norway Audit File - Import Transactions (BETA)
  • In the File name field, click Browse and insert the SAF-T xml file
  • Confirm with OK

For more information, please visit Import into accounting and Import Transactions.

When the app is executed, the script retrieves the following data from the Audit file:

  • Transactions lines
    • Date: date of the transaction.
    • Doc: doc number (rows with the same doc number belong to the same transaction).
    • Description: description of the transaction.
    • Debit Account: debit account of the transaction.
    • Credit Account: credit account of the transaction.
    • Amount: amount of the transaction.

The transaction data are taken row by row and added to the Transactions table of the accounting file:

  • Transactions are split in multiple lines, at least two rows per transaction.
  • Transactions do not contains VAT codes but instead the accounts releated to them.

After the import

When the import processes are terminated, the auditor can freely adjust the chart of accounts, the transactions, accounting properties, and finally use all the Banana Accounting features to help him do his work.

 

 

Share this article: Twitter | Facebook | Email