Import C/M Transactions
Cash Management Import Transactions is used to import cash activity into a special batch file without creating related g/l. Typically a separate g/l batch is imported which covers all related g/l transactions. This program works hand in hand with Post Imported Transactions.
Import Settings
- Import File: Select the file (typically a .csv file). After import this file will be renamed with a .bk1 extension.
- G/L Account: The cash g/l account being imported. This must match the account in the transaction records in the input file.
- Batch ID: This is auto-created as IMP-{session_no} reflecting the current session number of this import program.
- Batch Date: This is the date of the batch. The actual dates in the import file are assigned to the individual transactions.
- File Contains Header: Check this if the first line of the file is a header record.
- Transaction Amount Handling:
- Trx Type: Use this when all amounts in the input file are stored (normally) positive and the transaction type indicates credit or debit handling. In this case checks and deposits are + in the input file.
- Trx Amount: Use this when the amount in the input file are set as positive for debit and negative for credit. In this case checks are - and deposits are + in the input file.
Import File
The expected file should be a comma delimited text file (.csv)
Fields
- GLAccount
- TrxDate
- TrxAmount
- CheckNo
- EntityId (optional)
- Description (optional)
- CheckMemo (optional)
- VoidInd (optional)
- DirDepositFlag (optional)
- TrxType (optional) 2=Check (Default)
- Name (optional)
- Address1 (optional)
- Address2 (optional)
- City (optional)
- State (optional)
- Zip (optional)
Sample File
This file would be imported as "Transaction Type" since checks are recorded positive and with "File Contains Header" because the first line is a header record.
GLAccount,TrxDate,TrxAmount,CheckNo,EntityId,Description,CheckMemo,VoidInd,DirDepFlag,TransactionType,Name,Address1,Address2,City,State,Zip 1030.20.4,03/08/2021,319.07,,,DEPT. OF REVENUE,,N,N,2,,,,,, 1030.20.4,03/15/2021,319.07,,,DEPT. OF REVENUE,,N,N,2,,,,,, 1030.20.4,03/22/2021,319.07,,,DEPT. OF REVENUE,,N,N,2,,,,,, 1030.20.4,03/29/2021,319.07,,,DEPT. OF REVENUE,,N,N,2,,,,,, 1030.20.4,03/08/2021,132,,,STATE ACTION UNIT,,N,N,2,,,,,, 1030.20.4,03/15/2021,41.42,,,STATE ACTION UNIT,,N,N,2,,,,,, 1030.20.4,03/22/2021,112,,,STATE ACTION UNIT,,N,N,2,,,,,, 1030.20.4,03/29/2021,222.3,,,STATE ACTION UNIT,,N,N,2,,,,,, 1030.20.4,03/08/2021,3497.71,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/15/2021,3779.26,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/15/2021,1738,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/22/2021,7754.87,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/29/2021,7693.53,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/29/2021,1738.15,,,OFFICE OF THE TAXATION,,N,N,2,,,,,, 1030.20.4,03/08/2021,66.67,802506,,UNITED STATES TREASURY,,N,N,2,,,,,, 1030.20.4,03/15/2021,66.67,802510,,UNITED STATES TREASURY,,N,N,2,,,,,, 1030.20.4,03/22/2021,66.67,802514,,UNITED STATES TREASURY,,N,N,2,,,,,, 1030.20.4,03/29/2021,66.67,802517,,UNITED STATES TREASURY,,N,N,2,,,,,, 1030.20.4,03/08/2021,588.74,802507,,LESTER E. FULBRIGHT,,N,N,2,,,,,, 1030.20.4,03/15/2021,588.74,802511,,LESTER E. FULBRIGHT,,N,N,2,,,,,, 1030.20.4,03/22/2021,588.74,802515,,LESTER E. FULBRIGHT,,N,N,2,,,,,, 1030.20.4,03/29/2021,588.74,802518,,LESTER E. FULBRIGHT,,N,N,2,,,,,, 1030.20.4,03/08/2021,609.63,802508,,SUSAN K. SPEARS,,N,N,2,,,,,, 1030.20.4,03/15/2021,575.93,802512,,SUSAN K. SPEARS,,N,N,2,,,,,, 1030.20.4,03/22/2021,575.93,802516,,SUSAN K. SPEARS,,N,N,2,,,,,, 1030.20.4,03/29/2021,575.93,802519,,SUSAN K. SPEARS,,N,N,2,,,,,,