Guides

Getting Started

Accounting Reconciliation in Atlar matches your bank transactions against accounting documents from your ERP, helping your finance team maintain an accurate, up-to-date view of outstanding items and GL account balances. This page walks you through everything that must be in place before reconciliation produces useful results — work through the steps in order the first time you set up a new entity.

Prerequisites

Before reconciliation can run, confirm each of the following is in place:

Bank account connected — at least one bank account is connected to Atlar and producing booked (settled) bank transactions. Pending transactions are excluded from matching. This should be covered in the delivery process, consult your Atlar contact.

ERP Connection established — a connection to your ERP has been established. This should be covered in the delivey process, consult your Atlar contact.

GL entities and bank GL accounts configured — your legal entities and GL accounts have been fetched from your ERP and mapped to their counterparts in Atlar: each ERP legal entity to an Atlar legal entity, and each bank GL account to the corresponding Atlar bank account. Steps outlined below.

Accounting documents flowing in — your ERP is sending accounting documents to Atlar. See the Accounting Document page for details on what document types are supported and how the integration works. After finishing the above step, consult your Atlar contact.

Reconciliation Configuration setup — each entity has a Reconciliation Configuration defining its start date and how FX gain/loss, fees, and overpayment residuals are handled. See Create a Reconciliation Configuration below and the Reconciliation Configuration page. Steps outlined below.

If any of these are missing, reconciliation will have no data to work with. Resolve them before continuing.

GL entities and bank GL accounts configured

After having an ERP connection established and asked your Atlar contact to initiate a first fetch of data you can connect your GL entities and GL Accounts to the corresponding Atlar counterparts.

  1. Navigate to **Settings > Third-party Connections **
  2. Click on your ERP connection type, e.g. NetSuite or Business Central.
  3. Under which you should find the connection you want to feed data from.
  4. Click arrow icon underneath action to view the Connection details.
  5. Click on the tab GL Entities:
    1. Click Edit
    2. Connect your ERP's entities with entities setup in Atlar.
    3. Click Save
  6. Ask your Atlar contact to trigger another fetch of data. Atlar will now fetch the GL Accounts belonging to your connected GL Entity.
  7. Click on the tab GL Accounts.
    1. Click Edit
    2. Connect your ERP's GL Accounts with bank accounts setup in Atlar.
    3. Click Save

Reconciliation Configuration setup

The Reconciliation Configuration record contains entity level configuration for your reconciliation process.


FieldWhat it controlsUnit
EntityThe entity this configuration applies to. Each entity has exactly one configuration.—
FX gain thresholdThe largest favourable foreign-exchange difference Atlar absorbs automatically on a cross-currency match, where the exchange rate is inferred as the ratio between the booked transaction and accounting document amounts. Not applied to manual matches.Percentage
FX loss thresholdThe largest unfavourable foreign-exchange difference Atlar absorbs automatically on a cross-currency match, where the exchange rate is inferred as the ratio between the booked transaction and accounting document amounts. Not applied to manual matches.Percentage
Overpayment thresholdThe largest overpayment Atlar absorbs automatically so the match still reconciles. Not applied to manual matches.Percentage
Fee accountThe GL account that bank fees deducted from a transaction are posted to when a fee is absorbed.—
Fee ThresholdThe largest fee Atlar absorbs automatically, posting it to the fee account. Fees above the threshold are surfaced for review. Paired with Fee account. Not applied to manual matches.Percentage
Test Period Start DateConfigured by the Atlar team. The date from which booked transactions are marked OPEN for reconciliation during a trial period used to evaluate the matching process. Note that matches posted during this period still affect your ERP's accounting.Date
Start DateConfigured by the Atlar team. The date the reconciliation product goes live. Once it passes, booked transactions dated before it are marked NOT_ELIGIBLE — excluded from matching, and any pending matches are reverted. Matches already approved or rejected are left untouched.Dat

To create a new reconciliation configuration.

  1. Navigate to Settings > Reconciliation > Configuration
  2. Click Create
  3. Populate the fields in the dialog.
  4. Click Create

Create Reconciliation Rules (Optional)

Reconciliation Rules let you define criteria that Atlar evaluates automatically when the Reconciliation Assistant runs. A rule can:

  • Automatically confirm a suggested match when specified conditions are met.
  • Automatically create an outgoing document (such as a payment or credit memo) to send back to your ERP.

Rules are optional — reconciliation works without them — but teams that configure rules significantly reduce the volume of manual work in the Matches tab.

See the Reconciliation Rules page for instructions on creating and prioritizing rules.

What Good Looks Like After Setup

Once the prerequisites are met and configuration is complete, you should see the following:

  • The Overview tab begins to populate with your reconciliation progress, a breakdown of outstanding items, and GL account balances for each configured bank GL account.
  • The Matches tab starts showing suggested matches as the Reconciliation Assistant completes its first run.
  • The Outstanding tab shows only items on or after your configured start date, giving you a clean working view of what still needs attention.

If the Overview tab remains empty or the Matches tab shows no suggestions, please reach out to Atlar and together verify that the prerequisties are complete.