Importing Transactions from Files
You can import transaction into a reconciliation from a file. For example, you exported 10 invoices for Prepaid Expenses for July 2012 to a flat file from your source system. You import the transactions into the reconciliation for Prepaid expenses for July 2012 in Account Reconciliation Manager.
Transaction import files are comma-separated text files. The first row contains the column headings that identify the data in the columns; for example, Transaction code. Separate rows are used to define each transaction. Required columns are Transaction Code and Open Date.
You must also specify the amount and currency for any enabled currency buckets that are not subject to currency translation. The fields must be labeled Amount and Amount Currency, with a number to indicate the currency bucket; for example, Amount1 and Amount Currency1 specify the amount and currency for the first currency bucket.
You need not include amount or currency for translated buckets:
-
If you do not import these values, the amounts are calculated using the default currency codes.
-
If you specify a currency but not an amount, the amount is calculated using the currency code provided.
-
If you specify an amount and a currency code, the amount is compared to the calculated translated amount, and if it differs, the amount is marked as overridden.
When you import transactions, you can choose to add the transactions in the file to the transactions for the reconciliation, or to replace the reconciliations with the transactions in the file.
To import transactions from a file: