What are the ARCS standards for loading amounts for transaction matching?.
Summary: We are moving Account Reconciliation process from T-Recs to ARCS Oracle EPM. T-Recs handles all amounts as positive and have a field to determine if amount has a debit/credit balance. The ARCS application documentation shows examples of the matching engine with positive values for Source and Subsystem.
The GL file we are currently receiving is designed to be consumed by T-Recs with a field for the amount and another indicating debit or credit. Due to time constraints, we are taking the same file and making changes for ARCS file consumption.
The Bank data integration was loaded using BAI format in ARCS, amounts were loaded as positive or negative following the transaction type. I am not sure if we need to do some data transformation in data management pulling the data to Account Reconciliation.