CSV2QFX User Guide

Main window

Main window
1

Application menu bar

1. Application menu bar
Contains commands to manipulate the current view or document
2

Source file name field

2. Source file name field
The edit box shows the path to the last loaded file and allows to enter or edit the file name manually without calling the browse for file dialog. Once the file name is entered, press the Enter key to load the file.
3

Clear before load check box

3. Clear before load check box
The checkbox defines if already loaded transactions will be cleared before loading the next file or the next file will be appended to already loaded ones. Use the Edit Undo menu item under the main menu to undo the last file load.
4

Change the amount sign check box

4. Change the amount sign check box
Change the amount sign allows quickly change the amount sign for all loaded transactions. It useful when the amount for withdrawals supplied as positive number, but should be negative for correct conversion. Please note that all transactions (deposits and withdrawals) will change the sign (withdrawals become deposits, and deposits become withdrawals).
5

Select and Load button

5. Select and Load button
The Select and Load button calls the browse file dialog for the source file and load selected file (or multiple files).
6

Review Mapping button

6. Review Mapping button
This button calls the CSV Mapper window to review CSV mapping for loaded the source file
7

Paste from clipboard button

7. Paste from clipboard button
The Paste from Clipboard button processes data from the clipboard that was previously copied from a spreadsheet application.
8

Transactions tab

8. Transactions tab
The Transactions tab shows loaded transactions that will be used to create the output file. The tab is useful to verify the data and its right mapping before converting.
9

Source tab

9. Source tab
The source tab shows source data (not yet parsed) as a table and raw file. Reviewing it is useful to check that the application parsed source data correctly comparing it to the Transactions tab.
10

Settings tab

10. Settings tab
The Setting tab defines some important output setting (overall output file related).
11

Row Number Column

11. Row Number Column
The Row number column counts all loaded transactions
12

Date Column

12. Date Column
The Date column shows the transaction date
13

Amount Column

13. Amount Column
The amount column shows the amount for transaction. Positive number means deposit (credit), and negative number means withdrawal (debit).
14

Currency Column

14. Currency Column
The Currency column indicates the transaction currency. The currency should be the same for all transactions within the account.
15

Payee Column

15. Payee Column
The Payee column shows the payee reference for loaded transactions.
16

Memo Column

16. Memo Column
The Memo column shows the memo for loaded transactions.
17

Check Number Column

17. Check Number Column
The Check Number column shows the memo for loaded transactions.
18

Reference Column

18. Reference Column
The Reference column shows the memo for loaded transactions.
19

Transaction Type Column

19. Transaction Type Column
The Transaction Type column shows the memo for loaded transactions.
20

Transactions Grid

20. Transactions Grid
The Transactions Grid shows all loaded and parsed transactions. How transactions are presented in this grid is how the transactions will be converted.
21

Select All check

21. Select All check
The Select All checkbox allows to select or deselect loaded transactions. Only checked transactions will be added to the output file.
22

Save button

22. Save button
Once the file is loaded, click this button to save the data as the QFX file. File dialog will show up to select output directory and the filename.
23

Status bar

23. Status bar
The status bar shows how many transactions were loaded the last time.
(c) 2011 ProperSoft.