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.