Importing Transactions

ChurchTrac will allow you to import your bank transactions from an OFX (Money), QFX (Quicken), QIF, or QBO (QuickBooks) file provided by your bank or financial institution. Many banks and credit card companies allow you to download your recent transactions (you may need to check your bank's website to see if they support this feature). These transported transactions can then be quickly added to your account register without having to type in the payee, check number, date, or amount.

Join our next Getting Started Workshop

How to Import Transactions

We made importing transactions quick and simple. Follow the below steps to complete the process.

Step 1

First, log in to your bank or credit card company's website and download one of the supported file types for a date range that you wish to import. (We recommend keeping the date range short, as it takes longer for the application to process the import if the file contains too many transactions).

Once the file is saved to your computer, go to the appropriate account register and click on the "Import" button on the bottom toolbar of the register.

Step 2

Next, drag and drop the downloaded file onto the import drop zone (or click the drop zone to browse for the file on your computer). After the file has been uploaded, a list of transactions contained in that file will be displayed.

Step 3

Click on the transactions in the list, one at a time, and update the information associated with each transaction (as needed). The date, check number, payee, and amount will automatically appear.

You will need to manually select a Category and Fund for each transaction. If the transaction type is a Deposit/Credit or an Expense/Charge, the transaction type will also automatically appear.

If you want to assign the transaction to multiple categories and/or funds, type in the amount for the first category/fund. Then click "Add Another Entry" and enter the amount for the next category/fund (similar to how you do this when adding a transaction manually).

Duplicate transactions (entries with the SAME date, payee, and amount) will appear red. Click on the "Remove Confirmed/Red Duplicate Entries" button to delete these transactions.

Tips

Account transfer

If the transaction type is an account transfer, you will need to manually select Transaction Type: "Transfer Between Accounts".

Total imported amount

The total amount for each of the entries MUST equal the amount of the imported transaction or the transaction will not import.

CSV and PDF files

Comma Separated Value (CSV) or PDF formats are not supported for transaction imports.