Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
cats:procedures:accounting:importtransaction [2015/10/27 17:20] – amanda | 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==== | ====Quick Steps==== | ||
- | - 1. Download the bank statement from your bank's website into any folder that CATS can access. | + | - Download the bank statement from your bank's website into any folder that CATS can access. |
- | - 2. | + | - 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 ==== | ||
Line 28: | Line 35: | ||
[{{: | [{{: | ||
- | 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. | Note: The bank statement file does not have to be strictly for one month based on date. | ||
Line 50: | Line 57: | ||
< | < | ||
- | Once all the transactions are successfully cleared (or ignored with " | + | Once all the transactions are successfully cleared (or ignored with " |
[{{: | [{{: | ||
Line 57: | Line 64: | ||
Processed transactions will be marked with the bank statement month and year and will now appear in the Ledger Scan. | Processed transactions will be marked with the bank statement month and year and will now appear in the Ledger Scan. | ||
- | {{tag>" | + | {{tag>" |