11 Exporting Adjustments or Transactions as Journal Entries
In Transaction Matching, you can export adjustments or transactions from data sources as dual sided journal entries that can then be imported into your ERP system. The exported journal entries are provided in a .csv file. For detailed instructions, see Loading Exported Journal Entries in the Administering Data Management for Oracle Enterprise Performance Management Cloud guide.
Example of a Single Adjustment and Journal Entry Created for Export
Let's look at this example of a single adjustment's details and what the dual sided journal entry looks like that gets created from that information.
Table 11-1 Adjustment Details
|Account ID||Trans. Date||Amount||CCY||Short Desc||Adj Type|
|100-1150||6/15/2018||10.00||USD||Cash at bank is short||Cash Over/Short|
Table 11-2 Journal Posting Created From Adjustment
|Company Code||GL Account||Profit Center||Date||Amount||CCY||Text|
|100||1150||6/15/2018||-10||USD||Cash at bank is short|
|100||567345||1100||6/15/2018||10||USD||Cash at bank is short|
The first row in this table represents the side of the journal that hits the Reconciliation Account 1150 in the amount of 10.00 since the balance is too high currently.
The second row in this table represents the side of the journal that hits the Offset Account 567345. It's an expense account since the "missing" cash is being written off.
This also works for a single transaction based on a data source and two rows are also created as a journal entry. For example, for a bank fee.
During normal operation using Account Reconciliation Cloud, users create adjustments and load transactions into Transaction Matching. If you want to export adjustments or transactions as journal entries, you use the Match Types feature which uses a new concept of global attributes for Adjustment and Support Types.
The process flow within Match Types in Transaction Matching is:
- Create global attributes for Adjustment and Support Types
- Define the journal columns
- Map transaction/adjustment attributes to journal attributes
- Optionally, use filters on transactions.
- Perform the export of the journal entries to a text file