cats:procedures:accounting:importtransaction

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
cats:procedures:accounting:importtransaction [2014/12/08 18:11] amandacats: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>0;Bank/Import Transactions;-}}{{entry>0;Transactions/Import;-}}{{entry>0;Import/Transactions;-}}
 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 **''XX''** in the **Action** column to ignore them. 
 +  - When finished adjusting transactions, pick **Tools > Process** again. 
 +  - Select **Yes** when prompted to move transaction to history. 
  
 ==== Preparing to Import ==== ==== Preparing to Import ====
Line 24: Line 35:
 [{{:cats:procedures:importtransactions:importtransactions_toolsmenu.png|Select Import Records from the Tools menu}}] [{{:cats:procedures:importtransactions:importtransactions_toolsmenu.png|Select Import Records from the Tools menu}}]
  
-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 46: Line 57:
 <note>You can use the **Process** function for the same set of transactions as many times as necessary.</note> <note>You can use the **Process** function for the same set of transactions as many times as necessary.</note>
  
-Once all the transactions are successfully cleared (or ignored with "XX") CATS will prompt you to move the current transaction list to the history file. Select Yes to clear the transactions from the list, otherwise the cleared transactions will remain in the list. It is recommended that you archive the transactions as it clearer after each successive month.+Once all the transactions are successfully cleared (or ignored with "XX") CATS will prompt you to move the current transaction list to the history file. Select **Yes** to clear the transactions from the list, otherwise the cleared transactions will remain in the list. It is recommended that you archive the transactions as it clearer after each successive month.
 [{{:cats:procedures:importtransactions:importtransactions_movetohistory.png|Click on Yes to archive this statement's transactions.}}] [{{:cats:procedures:importtransactions:importtransactions_movetohistory.png|Click on Yes to archive this statement's transactions.}}]
  
Line 53: 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>"bank transaction import" "import credit card statement" "import transactions"}}{{entry>0;Bank/Import Transactions;-}}{{entry>0;Transactions/Import;-}}{{entry>0;Import/Transactions;-}}+{{tag>"bank transaction import" "import credit card statement" "import transactions"}}
  
  • cats/procedures/accounting/importtransaction.1418062289.txt.gz
  • Last modified: 2017/12/19 03:21
  • (external edit)