Statements and reconciliation

Automatic Bank Reconciliation for Sage Intacct

Arkaio retrieves your bank statements, reconciles them with Sage Intacct entries and only brings you the transactions it could not match.

Why reconciliation takes so long

Manual bank reconciliation often follows the same cycle: download statements from each portal, import them into Sage Intacct, then tick off transactions one by one. Bank fees, partial payments and rejections make it harder, and the close waits until everything is matched.

With Arkaio, statements arrive automatically over the banking channel and reconciliation starts as soon as they are received. The statement is created in Sage Intacct cash management just like a manual import, so your team keeps its bearings. For the method, see Automated bank reconciliation: moving from D+5 to D+0.

What Arkaio reconciles

camt statements

camt.052, camt.053 and camt.054, retrieved over EBICS, Open Banking or SFTP depending on your bank and agreement.

Payments sent by Arkaio

Transfers and direct debits are matched with their entries and applied to the original invoices.

Transactions outside Arkaio

For fees or transactions made directly, the engine analyzes the transaction and generates the matching entry.

Customer receipts

Matching by IBAN, Arkaio identifiers and, in Switzerland, QR reference.

Loan installments

Each bank loan installment is matched with the statement and posted in Sage Intacct.

Rejections and returned funds

Only the amount actually paid is imported; returned funds generate a reversal entry.

Control and evidence

  • Exception review: when no match is found, a proposal is submitted to the user in Arkaio. Outside that case, no manual intervention is needed.
  • Submission control: the statement also checks that the batch sent was compliant and detects transactions refused by the bank, alongside pain.002 status reports.
  • Audit evidence: reconciliation evidence is available in Arkaio or in Sage Intacct, and a log records every transaction posted in Sage Intacct with its status.

Frequently asked questions

Do we still need to import statements manually?

No. Statements are retrieved automatically over the configured banking channel and then created in Sage Intacct cash management.

What happens to transactions Arkaio does not recognize?

The engine first tries to analyze them and generate the corresponding entry, for example for bank fees. If it finds no match, it submits a proposal to the user, who approves it in Arkaio.

Which statements are supported?

camt.052 (intraday), camt.053 (end of day) and camt.054 (debit and credit notifications). The messages you receive depend on your bank and your agreement.

See reconciliation on your own statements

A demo follows a statement from receipt to entries in Sage Intacct, on a case close to yours.

Request a demo