Imports the chart of accounts, creating and updating financial, text, interval and sum-from accounts and their account intervals.
1. Select the action in the Action field. 2. Point to your data source – a file (CSV or Excel) or a SQL query. 3. Map the source columns to Sapera's fields in the column mapping (see Source fields below). 4. Run Compare to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run Update Sapera to perform the import.
Use the Allow create and Allow update parameters to control whether new rows are created and whether existing ones are updated.
Each row is matched on the account number (AccountNumber). Matching accounts are updated and new ones created.
The action processes four account kinds in order: text/headline accounts, financial accounts, interval accounts and sum-from accounts. The kind is driven by the AccountKind column (compared with the parameter type names).
Interval and sum-from accounts use FromAccountNumber/ToAccountNumber to define the account range they cover.
The Delete unused accounts before import parameter clears accounts that are not in use before the import. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, accounts that do not already exist are created. |
| When enabled, existing accounts are updated with the values from the source. |
| The source value that marks a row as a balance-sheet (status) account. |
| When enabled, accounts that are not in use are deleted before the import runs. |
| The source value that marks a row as an interval (sum) account. |
| The source value that marks a row as a profit-and-loss (operation) account. |
| The source value that marks a row as a sum-from account. |
| The source value that marks a row as a text (heading) account. |
Field | Explanation |
| The kind of account, matched against the account-kind parameters to decide how the row is treated. |
| The unique account number that identifies the account. |
| The account number that this account is closed into. |
| A longer description of the account. |
| The name shown for the account. |
| The first account number in the range for interval and sum-from accounts. |
| Whether the account is active. |
| Whether the account can be used for manual entries. |
| Whether movements on the account are shown in drafts. |
Standard account number ( | The account number in the Sapera standard chart of accounts to match this account to. |
| The last account number in the range for interval and sum-from accounts. |
| The VAT type code linked to the account. |
See also the overview SyncTool – actions.
