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,,,,,,