Skip to content

User guide

Using AnselIQ

This guide follows the order you'll work in: describe your files, build a ledger, tell AnselIQ how to match, then review and resolve what it finds. If the terms are new, read how AnselIQ models money first.

Getting around

Signing in and roles

Sign in with the email and password an administrator created for you. Each user has one role:

RoleFor
AdminEverything an Analyst does, plus managing users, reversing write-offs and fixing badly ingested files.
AnalystDay-to-day reconciliation: setting up feeds and ledgers, matching, writing off, and working exceptions.
ViewerRead-only access to everything: ledgers, reconciliations, movements, exceptions and reports. Viewers can search and test a feed's parser, but can't change anything or be assigned exceptions.
Work
Dashboard: for Analysts, the exceptions assigned to you or raised by you, and how long unreconciled movements have been waiting. Exceptions: every exception, across all ledgers.
Ledgers
Your ledgers, and from each one its balances, reconciliations, movements and setup.
Data
File Feeds, File Inventory (every file found), Jobs (background work) and Events (the activity log).
Insights
Reports: match rates, coverage, backlog and exceptions over time.
Admin
Users, shown to Admins only.

Setting up a file feed

A file feed tells AnselIQ where a family of files arrives and how to read it. Create one for each source, such as one processor report and one bank statement, under Data → File Feeds → Create.

Name
Shown wherever the feed is picked or reported on.
S3 Connection: Bucket and File Path
The S3 bucket and the folder inside it where the files land. AnselIQ picks up every file in that folder. Your administrator grants AnselIQ read access to the bucket.
Expected File Cadence (hours)
Optional. How often a new file should arrive. If none arrives within this many hours, AnselIQ raises a FileMissing exception on the feed, which closes itself when the next file arrives. Leave it empty for feeds without a schedule.
File Format
One of the four formats below, and the fields to keep from each row.

File formats

For every format you choose which values to keep and the name to store each one under. Those names become the movement's properties: they're what matching rules compare and what you search on. Exactly one value must be the amount.

CSV

BAI2

JSON (one record per line)

Fixed width

Testing a feed before going live

On the File Feeds list, Test Parser lets you upload a sample file and see how the feed's configuration reads it: the parsed rows with their stored fields and amount, and every line that failed with the reason. Nothing is saved, so try it as often as you like. Large files are cut off after their first lines, which the page tells you.

Setting up a ledger

  1. Go to Ledgers → Create. Give the ledger a name and a Daily Report Cutoff: the hour of the day (0–23) after which the day's reporting snapshot is taken.
  2. Open the ledger and go to its Setup tab. The diagram shows the ledger's accounts and the links between them, with Primary accounts on the left, Recon accounts in the middle and Secondary accounts on the right.
  3. Add the accounts with New Account: a name and its type (Primary, Secondary or Recon). A typical ledger has one of each.
  4. Link each Primary and Secondary account to the Recon account. A link is a movement spec: choose the file feed whose rows post across this link, and give it a name.
The Ledgers page, listing one ledger named Operating Cash with its created and updated times, and a Create button.

Feeds that cover several accounts

Some files carry rows for several accounts, such as a BAI2 statement for every bank account you hold. Link each of those accounts to the same feed and give each link a Routing Filter: a field and the value it must equal, such as account_number equals 000123456. Each row then posts only to the link whose filter it matches. A link with no filter takes every row its feed has that no other link claims.

Rows that match no link aren't dropped silently. AnselIQ raises an UnroutedRecord exception on the feed so someone can add the missing link. Close it by hand once that's done.

Matching rules

Each Recon account has one reconciliation rule. On the account's card on the Overview tab, choose Set up (or Configure Reconciliation), then fill in:

Primary and secondary movement spec
The two links whose movements are matched against each other.
Relationship
OneToOne: one movement on each side, such as a payout and its bank deposit.
OneToMany: one movement on one side against any number on the other, such as a settlement total and the card transactions behind it. A group that doesn't balance yet stays In progress while more of it may still arrive.
Aging Limit
For OneToMany, how many days an In progress group may wait for the rest of its movements before it's marked Mismatched and an exception is raised.
Reconciliation rule
Which fields must agree, described below.

Conditions

A rule is made of conditions that compare one field from each side:

Either side of a condition can be a fixed value instead of a field: tick Match a constant value instead of a field. For example, match only bank rows whose type_code is 475.

Ignoring formatting differences

Two systems often write the same reference differently. Each text field can have transforms, applied in order before the two sides are compared:

TransformExample
Normalize (ignore case and punctuation)INV-2026/0042 → inv20260042
Strip prefixWith prefix ACH : ACH 12345 → 12345
Trim leading zeros000420 → 420

Alternatives

A rule can have alternatives: other ways for the two sides to match. They're tried in order after the main rule, each only on what is still unmatched, so adding one never changes what the rules above it match. Use them for a second reference that some rows carry, or for rules learned from AI suggestions.

Getting files in

Once a feed is linked to a ledger, AnselIQ checks its S3 folder every minute. Each new file appears in File Inventory and is ingested in the background, and the Recon accounts it touches are reconciled automatically afterwards. Large files are read in batches, and an interrupted ingestion resumes from the last line it committed.

To load a one-off file without putting it in S3, open the ledger and choose Ingest file. Pick the movement spec the file belongs to and upload it. Its feed's parser reads the file and the movements are posted to the ledger.

If a file has so many unreadable rows that ingestion stops, AnselIQ raises an ExcessiveParseErrors exception on the feed. Rows from batches committed before it stopped stay on the ledger. That usually means the feed's configuration doesn't fit the file: check it with Test Parser.

Running reconciliation

Reconciliation runs on its own after every ingestion. To run it now, for example after changing a rule, choose Run reconciliation at the top of the ledger. Every Recon account in the ledger is reconciled, and an interrupted run continues where it left off.

Each run:

Reviewing a ledger

A ledger has four tabs.

A ledger's Overview tab: the Recon account with a cash balance of $42.00, made up of $89.90 unreconciled, $0.00 in progress and -$47.90 mismatched, above its Bank and Journal accounts.
The Overview tab. Cash balance is the sum of the three figures below it.
Overview
A card for each Recon account with its cash balance and the three figures that explain it: Unreconciled, In progress and Mismatched. Each figure opens what's behind it: Unreconciled opens a search of those movements, the other two open the matching reconciliations. The card also has Manual Match and the account's rule.
Reconciliations
Every reconciliation in the ledger, filtered by status.
Movements
Search movements by account, whether they're reconciled, type (ingested, manual adjustment or reversal), adjustment type and date created. Once you pick a movement spec, you can also search on the file name and on that spec's fields, such as a particular payout_id.
Setup
The accounts and links described in Setting up a ledger, plus each Recon account's rule.

Opening a reconciliation shows its movements on each side, its balance and, for a mismatch, Why it doesn't balance: the primary total, the secondary total, the difference, and the exact values it Matched on. A manual match or an accepted AI suggestion says so instead. Any open exceptions appear alongside, with a link to their thread.

Resolving mismatches

A Mismatched or In progress reconciliation offers three ways forward.

A Mismatched reconciliation: Journal $42.00 against Bank $89.90, a difference of -$47.90, with Write off and Unmatch buttons, an open AmountMismatch exception and the two movements involved.
A Mismatched reconciliation shows each side's total and what it was matched on.

Write off

Use it when the difference is real and accepted, such as a bank fee. Choose Write off…, pick the movement to post the adjustment against and give a reason. AnselIQ posts the difference as a manual adjustment movement, the reconciliation becomes Final, and its AmountMismatch exception closes. Adjustments can be found on the Movements tab by type and adjustment type.

An Admin can undo a write-off with Reverse write-off…. AnselIQ posts a correcting entry (the original adjustment stays on the books), the reconciliation goes back to Mismatched, and a new exception is raised and linked to the old one.

Unmatch

Use it when the movements shouldn't have been matched together. The reconciliation becomes Voided and its movements return to the unreconciled pool, to be matched again by the next run or by hand. Final reconciliations can be unmatched too, except a written-off one: reverse the write-off first.

Wait

A OneToMany group can still be completed by a late movement. If one arrives that brings it into balance, the next run makes it Final and closes its exception.

Manual matching

For movements the rule can't match, open Manual Match from the Recon account's card. It lists the account's unreconciled movements on each side. Select the ones that belong together and choose Match Selected. If they don't balance, the match is saved as In progress (OneToMany) or Mismatched (otherwise), and you resolve it like any other.

AI match suggestions

When your administrator has turned on AI matching, AnselIQ looks at what each run left unmatched and suggests likely pairs, such as an invoice number the bank reformatted. The model runs inside your own environment. Suggestions are made for OneToOne rules, only between movements with the same amount created within a few days of each other.

Suggestions appear under Suggested matches on the Manual Match page, each with a confidence and a reason. When the model can show exactly why the two references are equal, the explanation is checked against the movements and shown as well. Accept matches the pair exactly as a manual match would. Reject records that they don't belong together, and that pair isn't suggested again. Who reviewed each suggestion is recorded.

Learned rules

When the same explanation has been behind several accepted suggestions, the rule form offers it under Learned from accepted suggestions, with how many suggestions it explained and how many unmatched pairs it would match now. Choose Add as alternative and those pairs match automatically from then on, without the AI.

Working exceptions

The Exceptions page lists every exception, with what it's about and its status. Open one to see the movement, reconciliation or feed it concerns, with a link to it, and its thread.

The Exceptions page: a table of four exceptions with their status, category, type, account, reference and detail.

From an exception's page you can:

To raise an exception yourself, open a movement and choose a category: Missing counterpart, Duplicate, Timing difference or Data quality, with an optional detail.

AmountMismatch and FileMissing exceptions are closed by AnselIQ when the problem is fixed, so they can't be resolved or reopened by hand. The exception page says what will close it. If a write-off was wrong, reverse it; if a match was wrong, unmatch it.
An AmountMismatch exception's page, with its comment thread and status and assignment controls beside a summary of the reconciliation it concerns.
An exception's page, with its thread beside the reconciliation it concerns.

Fixing a bad file

If a file was ingested with the wrong configuration, such as the wrong column marked as the amount, an Admin can undo it. On File Inventory, choose Fix bad ingest… on the file's row. Preview shows what will change, and Confirm posts a reversing entry for each of the file's movements and voids the reconciliations they were in. Nothing is deleted. Correct the feed, then ingest the file again.

Reports

Reports shows reconciliation health for all ledgers or one. Trends come from a daily snapshot of each ledger, taken after its daily cutoff hour.

The Match rate report: 96.1% matched, 74 of 77 movements, with a line chart of the rate over ten days. The Unreconciled aging report: none overdue, three movements aged 0 to 3 days, with a line chart of the backlog over ten days. The Open exceptions by category report: a donut chart of four open exceptions, two New, one Investigating and one Escalated.
Three of the report cards: match rate, unreconciled aging and open exceptions.

Jobs, events and file inventory

File Inventory
Every file found on every feed: its size, when it was last modified, its status (QUEUED, PROCESSING or COMPLETED), when it was processed and the last line read.
Jobs
The background work: ingestions, reconciliations, file scans, daily reporting snapshots and AI suggestions, with each job's status, attempts and any error. A failed job is retried automatically before it's marked as an error.
Events
The activity log: files detected and ingested (with record counts and timings), accounts reconciled, manual matches, unmatches, write-offs and their reversals, and exception changes.
The Jobs page: run history bars for Ingestion, Reconciliation, CreateFileInventory and SuggestMatches, above a table of reconciliation runs with their status, start time and record count.
The Jobs page. Pick a job type in Run history to list its runs.

Managing users

Admins manage users under Admin → Users: create a user with an email, name, role and password (at least 8 characters), change a role, deactivate a user who has left with Active, or Reset Password. The first Admin is created when AnselIQ is installed.