Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
cats:procedures:accounting:importtransaction [2014/09/30 15:53] – created tom | cats:procedures:accounting:importtransaction [2017/12/19 03:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 2: | Line 2: | ||
The **Import Transactions** feature allows you to import transactions directly from your bank statement into CATS. | The **Import Transactions** feature allows you to import transactions directly from your bank statement into CATS. | ||
+ | {{entry> | ||
Every bank has its own format for their electronic documents. To set up a new bank, it will be necessary to submit a sample statement to NDS to facilitate importing the records. | Every bank has its own format for their electronic documents. To set up a new bank, it will be necessary to submit a sample statement to NDS to facilitate importing the records. | ||
+ | |||
+ | ====Quick Steps==== | ||
+ | - Download the bank statement from your bank's website into any folder that CATS can access. | ||
+ | - Go to **Accounting > Import Transactions** from the main menu. | ||
+ | - Select a bank or credit card from the bank chooser and pick **Continue**. | ||
+ | - Choose **Tools > Import Transactions** from the menu. | ||
+ | - Select a bank statement file from the list and chooser **Continue**. | ||
+ | - From the top menu, pick **Tools > Process**. Note which items have cleared. | ||
+ | - For all uncleared items, enter account codes and G/L numbers or put an **'' | ||
+ | - When finished adjusting transactions, | ||
+ | - Select **Yes** when prompted to move transaction to history. | ||
==== Preparing to Import ==== | ==== Preparing to Import ==== | ||
- | First you need to download the electronic bank statement from your bank's website. Usually, this is available as a CSV file. Download the file and place it in the " | + | First you need to download the electronic bank statement from your bank's website. Usually, this is available as a CSV or QFX file. Download the file and place it in the " |
- | In CATS select | + | In CATS select |
- | [{{: | + | [{{: |
CATS displays a list of the banks it knows about. Select the bank or credit card to use for the import and pick Continue. | CATS displays a list of the banks it knows about. Select the bank or credit card to use for the import and pick Continue. | ||
- | [{{: | + | [{{: |
==== Importing Transactions ==== | ==== Importing Transactions ==== | ||
Line 20: | Line 31: | ||
This will bring up the list of imported transactions for the selected bank. Normally, when you start this procedure the list will be blank (as the previous month' | This will bring up the list of imported transactions for the selected bank. Normally, when you start this procedure the list will be blank (as the previous month' | ||
- | To import the bank statement, select | + | To import the bank statement, select |
- | [{{: | + | [{{: |
- | CATS will display a list of the bank statement export files that it can see. Select the appropriate file and click on Continue to proceed. (If you do not see the statement file listed, you will need to ensure that you downloaded the file to the correct folder.) | + | CATS will display a list of the bank statement export files that it can see. Select the appropriate file and click on **Continue** to proceed. (If you do not see the statement file listed, you will need to ensure that you downloaded the file to the correct folder.) |
- | Note: The bank statement file does not have to be strictly for one month based on date (though this is usually the case with a bank statement). | + | Note: The bank statement file does not have to be strictly for one month based on date. |
- | + | [{{: | |
- | [{{: | + | |
==== Clearing Transactions ==== | ==== Clearing Transactions ==== | ||
CATS will now pull in a list of transactions from the file and display them to you in the list of imported transactions. | CATS will now pull in a list of transactions from the file and display them to you in the list of imported transactions. | ||
- | + | [{{: | |
- | [{{: | + | |
You can manage the list of transactions by entering values in the **Action " | You can manage the list of transactions by entering values in the **Action " | ||
- | + | The **Action " | |
- | The **Action " | + | |
Enter a **G/L # ** and/or an **Account** code in the appropriate fields to assign them to a transaction. CATS will recognize and automatically identify transactions that use accounts and GL#s from prior months. This can save you time if you have repeating monthly transactions. | Enter a **G/L # ** and/or an **Account** code in the appropriate fields to assign them to a transaction. CATS will recognize and automatically identify transactions that use accounts and GL#s from prior months. This can save you time if you have repeating monthly transactions. | ||
- | Once you have made your entries, it's time to compare the list of transactions against your GL. Select | + | Once you have made your entries, it's time to compare the list of transactions against your GL. Select |
+ | [{{: | ||
- | [{{: | + | There may be transactions on the bank statement that CATS couldn't find or properly process. It may be necessary to exit this screen and enter new transaction or adjust existing |
- | There may be transactions | + | < |
- | < | + | Once all the transactions are successfully cleared (or ignored with " |
+ | [{{: | ||
- | Once all the transactions are successfully cleared (or ignored with " | + | <note important> |
- | [{{: | + | Processed transactions will be marked with the bank statement month and year and will now appear in the Ledger Scan. |
+ | |||
+ | {{tag>" | ||
- | <note important> |