|
 Source file preview
The source file preview helps to see what data is stored in each column and select corresponding column on the left panel. The application tries to determine columns automatically when the file isloaded for the first time, so your will see some columns are already preselected on the left panel.
| |
 Date Drop down
The Date dropdown is used to select the corresponding field in the source file.
| |
 Memo Drop down
The Memo dropdown is used to select the corresponding field in the source file.
| |
 Amount Drop down
The Amount dropdown is used to select the corresponding field in the source file. If the amount is coming in two columns (deposits and withdrawals), then select "Do not use" for this column, otherwise select "Do not use" for the Debit and Credit dropdowns below.
| |
 Debit Drop down
The Debit dropdown is used to select the corresponding field in the source file. If this field is selected, the Amount drop down above should be set to "Do not use".
| |
 Credit Drop down
The Credit dropdown is used to select the corresponding field in the source file. If this field is selected, the Amount drop down above should be set to "Do not use".
| |
 Payee Drop down
The Payee dropdown is used to select the corresponding field in the source file.
| |
 Check Number Drop down
The Check Number dropdown is used to select the corresponding field in the source file.
| |
 Reference Drop down
The Reference dropdown is used to select the corresponding field in the source file.
| |
 Account Name Drop down
The Account Name dropdown is used to select the corresponding field in the source file.
| |
 Account Type Drop down
The Account Type dropdown is used to select the corresponding field in the source file.
| |
 Account Number Drop down
The Account Number dropdown is used to select the corresponding field in the source file.
| |
 Address Drop down
The Address dropdown is used to select the corresponding field in the source file.
| |
 Category Drop down
The Category dropdown is used to select the corresponding field in the source file.
| |
 Cleared Drop down
The Cleared dropdown is used to select the corresponding field in the source file.
| |
 Reimburse Drop down
The Reimburse dropdown is used to select the corresponding field in the source file.
| |
 Investment Action Drop down
The Investment Action dropdown is used to select the corresponding field in the source file.
| |
 Security Name Drop down
The Security Name dropdown is used to select the corresponding field in the source file.
| |
 Price Drop down
The Price dropdown is used to select the corresponding field in the source file.
| |
 Quantity of Shares Drop down
The Quantity of Shares dropdown is used to select the corresponding field in the source file.
| |
 Trnasferred Drop down
The Transferred dropdown is used to select the corresponding field in the source file.
| |
 Currency Drop down
The Currency dropdown is used to select the corresponding field in the source file.
| |
 Bank ID Drop down
The Bank ID dropdown is used to select the corresponding field in the source file.
| |
 Transaction Type Drop down
The Transaction Type dropdown is used to select the corresponding field in the source file.
| |
 OK button
The button activates set mapping and reload the last loaded file.
| |
 Cancel button
This button close the CSV Mapper window and keeps already loaded transactions as they are.
| |
|
|
