Transaction file map

The transaction files (.CSV) that you download from your bank or credit union and credit card websites can be used in You Need A Cash Plan to:

• balance checking account statements
• add new credit card transactions
• reconcile credit card statements

The formats of the transaction files from different websites are not the same. To use a download file, therefore, you create a transaction file map. A file map identifies the rows and columns in a transaction file that are used by the program.

To start

A transaction file map can be created for your checking account or a specific credit card in the Map ... Transaction Download File window. To start:

• For your checking account:
  • Download a sample transaction file (.CSV) from your bank or credit union website.
  • In You Need A Cash Plan, open the Checking Account slider and click on the Map transaction file button.

• For a credit card:
  • Download a sample transaction file (.CSV) from the credit card company’s website.
  • In You Need A Cash Plan, right-click on the credit card in your cash plan and click on MAP file transaction in the pop-up menu.

Create the map

In the Map … Transaction Download File window:

1. Click on the Open button to locate and open the sample download transaction file. If the file does not display correctly in You Need A Cash Plan, open the file in a spreadsheet program to use as a reference.
2. Select the row for the First row of data.
3. Select the Columns for each of the useful columns that are present in the transaction file. If the sample file has only one amount column instead of both a Debit and Credit column, select the amount column as the Credit or Amount column.
4. Click on the Test button to verify that the row and column numbers are mapped correctly.
5. Click on the Save button to save the map and exit the window.