Olivs features importing multiple transactions from using CSV file, as well as view and remove entire import, if e.g. posted to an incorrect bank account.
If you’re looking to import single transaction with multiple lines (e.g. Opening Balances): this feature is in General Journal and Bank Transaction forms.
Importing is a two-step process:
- Import transactions to Bank Entries form – this step is described below.
- Adjust, validate and post transactions to accounts in Bank Entries just like manually entered transactions. This step is described in Bank Entries.
How to import transactions to Olivs:
- Go to Bank Entries and select ‘Manage Entries Import’, then select ‘Import transactions from file’
- Select CSV file
- Select bank account on which all transactions were made
- Click ‘Show Records’
- Assign columns and check automatic mapping by Olivs. Mapping details are below.
- Select records you wish to import – to select all, hit the checkbox in header
- Select ‘Import selected records’ and choose whether you want to use validation now
Transactions are imported to Bank Entries form. If there are any transactions already, they may mix and create duplication, or incorrect entries. Olivs will check existing entries and prompt you to:
- Delete existing entries in Bank Entries and continue import
- Keep existing entries and add this import to the list
- Abort import and move to Bank Entries
What data can be imported / column mapping
- Date – date of transaction
- Credit / Income – amounts in this column will be imported to Credit / Income column
- Debit / Expense – amounts in this column will be imported to Debit / Expense column
- + Debit / – Credit – amounts will be divided: positive amounts will appear in Credit / Income, negative in Debit / Expense
- – Debit / + Credit – amounts will be divided: negative amounts will appear in Credit / Income, positive in Debit / Expense
- Description – goes to Transaction Memo
- Account – entry by Account Number from Chart of Accounts
- Tax Code – tax code for transaction
- Priv Port 1..99 – private use percentage – use full amounts, e.g. 20% should be ’20’
- Contact Code – enter contact code to assign transaction to Contact
- Site Code / Name – enter site code or name to assign transaction to Department Site
You can import transaction with a rule that will assign similar transactions to this account and tax code. Read more about Bank Rules.
- Bank Rule – Search Text – transactions will be assigned to rules if this text is found in Description
- Bank Rule – Ranking – if more than one rule is found, rule with highest ranking will be applied
- Bank Rule – minimum amount – only amounts equal or below this amount will trigger this rule
- Bank Rule – maximum amount – only amounts equal or above this amount will trigger this rule