Imports financial entries into a draft (journal), optionally auto-booking them when the draft balances.
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 the step to add the entries to the finance journal.
This action has no Compare function – see the section below for how the lines are processed.
The action imports entry lines into a finance journal (chosen with DraftIdentifier). Note: this action has no Compare – the lines are added directly to the journal.
Each line consists of e.g. financial date, due date, amount, debit/credit (Kind), account number, optional contra account and an actor (debtor/creditor).
Enable `AutoBook` to post the journal automatically once it balances. AutoIncAppendixBasedOnAltAppendixNo groups lines into the same voucher based on an alternative voucher number. IgnoreNonFinancialAccounts skips lines on non-financial accounts.
Direction: from file/SQL into the finance journal (and optionally posted).
Parameter | Explanation |
| When enabled, the draft is automatically booked after the entries are imported. |
| When enabled, appendix numbers are auto-incremented per distinct alternative appendix number. |
| When enabled, the source rows are deleted after a successful import. |
| The name of the draft (journal) the entries are imported into. |
| When enabled, entries posted to non-financial accounts are skipped instead of causing an error. |
Field | Explanation |
| The account number the line is posted to. |
| The identifier of the actor (customer or supplier) on the line. |
| An alternative appendix number used to group or auto-number entries. |
| The amount of the entry line. |
| The appendix (voucher) number of the entry. |
| The contra account the line is balanced against. |
| The description text of the entry. |
| The due date of the entry. |
| The booking date of the entry. |
| The identifier that groups the rows belonging to the same entry. |
| The kind of entry line, for example debit or credit. |
| The organizational unit the entry belongs to. |
See also the overview SyncTool – actions.
