Bank & Credit Card

Transactions can be created from an imported bank or credit card statement to reduce processing time. FCA™ will import transactions from statements downloaded in the .QFX or .QIF format. The date, description, and amount of each transaction will import. You can enter a general ledger account for each transaction with a simple procedure, and edit the description if desired.

Note: These transactions are not created with a Contact in the Payee field so there is no 1099 tracking for them. Transactions imported in Write Up>Import Transactions>Bank Activity have payees and are tracked for 1099 purposes.

To import a bank or credit card statement:

1. Download the appropriate statement.
2. Open the client in FCA.
3. Select Activities>Import Transactions>Bank & Credit Card.
4. Select the downloaded file.
5. Select the desired Bank account from the drop-down list.
   

   Note: Accounts with a Type of checking are always available. To select a credit card account, the Type in Setup>Accounts must be Accounts Payable. Select Screen Options and set the Include Accounts Payable Type to Yes.

   
   
6. Change View Records From: date, if necessary.
   
7. Click the Row Number field on the From Statement grid for the first transaction to be created.
   
8. Select Create or press Shift+F4.
9. Enter the desired Account and edit any other desired fields.
10. Press the Enter key until a new blank row is created and use the Enter key to move through the Account field. Press the spacebar when the Create button is highlighted or select Create.
11. Select Create (Shift+F4) again if the next item From Statement is to be created as a transaction or click the next row number.
12. Repeats Steps 8 through 11 until all desired transactions have been matched.
    
13. Click OK.

This import may also be used to create transactions from a bank statement with numerous debit memos (such as debit card transactions, ACH payments, and EFT payments) which have not been entered previously. After selecting the downloaded file, sort the From statement transactions by Status. Create transactions for the Unmatched transactions.