Newarc Academy · Oracle EPM

Oracle Account Reconciliation training

Run a faster, cleaner close with Reconciliation Compliance, Transaction Matching and Enterprise Journals.

Duration
24 hours
Level
Foundation to intermediate
Modules
6 modules · 6 hands-on labs
Delivery
Live virtual or on-site
Group size
Up to 12 participants
Environment
Your own test pod
Pricing
Contact us for a tailored quote
ARCS

About this course

From the first balance load to a reviewed, signed-off reconciliation. Participants learn how profiles, formats and rules fit together, how high-volume matching works, how adjusting entries flow through Enterprise Journals, and how to keep the close on track with custom reports and dashboards.

Who it’s for

Reconciliation preparers and reviewers, close managers, and ARCS administrators.

Prerequisites

Familiarity with your month-end close. No ARCS experience needed.

Afterwards, your team can

  • Prepare and review reconciliations confidently
  • Design matching rules that raise the auto-match rate
  • Manage adjusting journals through Enterprise Journals
  • Build the reports and dashboards controllers and auditors ask for

Course outline

6 modules over 24 hours. We adjust the depth and examples to the people in the room.

  1. 01

    How ARCS is organised

    • Reconciliation Compliance and Transaction Matching
    • Profiles, formats, frequencies and periods
    • Roles, teams and the preparer → reviewer workflow
  2. 02

    Loading balances

    • Data Integration from ERP and other sources
    • Mapping source accounts to profiles
    • Reviewing load results and fixing kickouts
  3. 03

    Preparing and reviewing reconciliations

    • Balance comparison and account analysis methods
    • Auto-reconciliation rules
    • Explaining differences, adjustments and attachments
  4. 04

    Transaction Matching

    • Reconciliation types and data sources
    • One-to-one, one-to-many and many-to-many rules
    • Auto-match, suggested matches and manual matching
    • Adjustments and balancing the reconciliation
  5. 05

    Enterprise Journals

    • Journal templates, types and workflow
    • Preparing, reviewing and posting journals
    • Posting adjustments back to the ERP
  6. 06

    Custom reports and dashboards

    • Built-in dashboards and compliance reports
    • Building custom reports with queries and templates
    • Designing dashboards for preparers, reviewers and controllers
    • Aging, risk ratings, overdue items and the audit trail
Hands-on

Labs in your own test pod

Participants practise on your configuration and data, so what they learn carries straight into their day-to-day work.

  • Build a reconciliation format
  • Load and map GL balances
  • Configure a bank-to-GL match
  • Run auto-match and resolve exceptions
  • Create and post an enterprise journal
  • Build a custom report and dashboard

How the training runs

Format

Live virtual or on-site, fully customisable and scheduled around your team’s calendar

Group

Private cohorts of up to 12 participants. Larger teams are split into separate groups.

Environment

Your own test pod, with your configuration and data

You keep

Course presentations (PPT), workbook and lab guides

Frequently asked questions

Who is the Account Reconciliation course for?

Reconciliation preparers and reviewers, close managers, and ARCS administrators.

How long is the Account Reconciliation course?

24 hours of instructor-led training. We split it into sessions that fit around your team’s calendar.

What do participants need beforehand?

Familiarity with your month-end close. No ARCS experience needed.

Is the training virtual or on-site?

Both. Most courses run as live virtual sessions, and we can deliver on-site when that suits your team better.

How much does the Account Reconciliation course cost?

Pricing depends on the course structure we build with you, including the modules, depth and number of groups. Contact us and we’ll send a tailored outline and quote.

Is the training delivered on our own Oracle environment?

Yes. Labs run in your own test pod, so participants practise on your configuration and data rather than a generic demo.

How many people can attend?

Up to 12 participants per group. Larger teams are split into separate groups so everyone gets hands-on time.

What do participants keep after the course?

The course presentations (PPT), workbook and lab guides.

Plan Account Reconciliation training for your team.

Tell us who you’d like to train and what they need to do afterwards. We’ll come back with a tailored outline and schedule.

Request this course