Big E-Z Importer Instructions

CSV Importer - General Usage   (Available in the 2015 version of Big E-Z®)


The CSV importer is designed for importing several types of CSV data which banks provide to their customers.  Since there are apparently as many types of CSV as there are brands of banks, and therefore no standardized format, this is a complex task.  Some banks use different column names.  Some separate data into different columns, whereas others combine them.  Even something as simple as an account type can't be taken for granted, since some banks may use the same format for both checking accounts and credit cards.  This CSV Importer provides a best-effort solution (though due to the aforementioned problems, I can not guarantee that it will work for everyone).


There are two workflows built into the importer:  The Short Workflow, which is for files it recognizes, and the Detailed Workflow, for files which it does not recognize, but can be configured for.  


Importer Elements:


Load File button - Use this to load data into the importer.

Accept button - Use this to transfer the loaded data into your workbook.

Reset button - Use this to reset the importer and clear all loaded data.


Account Type box - This is used to specify what type of account the CSV data represents.  

Transaction Type Identification Mode - This is used to specify how debits and credits appear and are to be distinguished from each other.

Credit Identifiers - This is used to identify which text(s) identifies a transaction as a credit (only for "Distinguishing Field" type identification mode).


Colored Buttons - these are used to identify the columns which the CSV importer looks at.  The labels and number of these buttons will vary when different Transaction Type Identifications mode are active (as needed).  When clicked, these buttons tell the importer that the currently selected cell is the column header which corresponds to the text above.  (the text on the button is always set to the text from the CSV header).  For convenience, the cell in the CSV file is also marked with the button's color.



The Short Workflow:


1  In the CSV Importer sheet, click the "Load File" button.


2  On Using the File Open Dialog (which should appear), navigate to and select your CSV file, select it, and click the "Open" button.


3 In the "Account Type" box, select the "Checking" option if the CSV data represents activity in a checking account or the "credit card" option if it represents credit card activity.


4  After the transactions are properly identified (credits marked with green and debits marked with red), click the "Accept" button to transfer all the data into the appropriate spreadsheets.



The Detailed Workflow:


1  In the CSV Importer sheet, click the "Load File" button.


2 On Using the File Open Dialog (which should appear), navigate to and select your CSV file, select it, and click the "Open" button.


3  In the "Account Type" box, select the "Checking" option if the CSV data represents activity in a checking account or the "credit card" option if it represents credit card activity.


4  In the "Transaction Type Identification Mode" box, select an option based on how transactions appear in the CSV data...

4a  If both credits and debits appear in the same column and negative numbers are used to represent debits, select the "Together" option.

4b  If credits and debits appear in two separate columns, select the "Separate" option.

4c If credits and debits appear in the same column and another column is used to distinguish between them select the "Distinguishing Field


5  Identify the columns in the CSV data.

5a Click the date column header in the CSV data, then click the yellow button below the "Date" cell (B12).

5b  Click the description column header in the CSV data, then click the green button below the "Description" cell (C12).


5c If in "Together" mode:

Click the amount column header in the CSV data, then click the blue button below the "Amount" cell (D12).

 

If in "Separate" mode:

Click the credit column header in the CSV data, then click the blue button below the "Credit" cell (D12).

Click the debit column header in the CSV data, then click the red button below the "Debit" cell (E12).

  

If in "Distinguishing Field" mode:

Click the amount column header in the CSV data, then click the blue button below the "Amount" cell (D12).

Click the header of the column which distinguishes credits and debits in the CSV data, then click the red button below the "Date" cell (E12).

In the "Credit Identifier(s)" box, select all texts which identify a transaction as a credit.  (all others are assumed to be debits)

 

5  Click the reference column header in the CSV data, then click the orange button below the "Reference" cell (E12 or F12).


6  After the transactions are properly identified (credits marked with green and debits marked with red), click the "Accept" button to transfer all the data into the appropriate spreadsheets.



If neither of the workflows works, you will have to input transactions manually on the appropriate worksheets (Deposits, Checks, and Cash & Charges).


On 01-02-2015 I got this error when trying to import Cameron’s 2014Checking file into the 6/30/2015 program (this program year ending should allow data from 7-1-2014 through 6-30-2015)  His data started in July 2014. When I asked the program to Accept it only entered the July Deposit data and stopped. Then I removed the Deposit data and found it did enter the rest of the data into the Checks.