Bank Activity

Bank and credit card transactions can be imported from a file downloaded from the bank or credit card website. Download a CSV, QFX, or QIF file and map a portion of the transaction description from the file to a payee. Select a contact for that description or choose the option to Ignore. Contacts must have a default GL Account set up on the Vendor Tab.

1. Select Write Up>Import Transactions>Bank Activity.
2. Select the downloaded file. (If the selected file is a CSV file, refer to the CSV file instructions below.)
3. Select the desired bank and credit card account from the drop-down list.
   
4. Enter the desired portion of the Transaction Description in the Payee field.
   
5. Select the appropriate Contact in the Map To field. Select Ignore payee to exclude transactions from the import.
   
6. Check the Reverse Sign box if necessary.
7. Click OK.
   
   

Importing a Tab or CSV File

These steps only apply to a Tab or CSV file.

1. Review the downloaded file and make a note of the Header Row and the First row of data.
   
   
2. Select the appropriate rows for Data starts in row and Header is in row.
3. Map the columns in the import file to the appropriate fields in FCA.
   
   
4. Click OK and return to Step 4 above.

Batch

Each import will be assigned a unique Batch name that follows a similar pattern. Batch STMT 2016 4-1 indicates that the import is the first Bank Activity import done in period 4 of 2016. If a file is imported in the same period using this import, the batch name would be STMT 2016 4-2.

Undo by Batch

To delete all transactions imported in a batch, select Writeup>Import Transactions>Bank Activity. Select the Batch to be deleted in the Undo by batch field and select Undo. Batches that have been imported in prior periods cannot be undone.

View Imported Transactions

1. Select Search Transactions from the Utilities menu.
2. Clear the Date fields.
3. Select the Batch from the Batch field drop-down list.

Additional filters may be set to zero in on particular transactions.