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)
• Name (optional)
• Address1 (optional)
• Address2 (optional)
• City (optional)
• State (optional)
• Zip (optional)