Skip to main content
Workflow demos · Finance

Check every journal entry
with none left out

Checks every journal entry in the review period, with none left out. Finds entries where debits and credits do not balance, entries posted on weekends, holidays or late at night, and entries approved by the person who prepared them. Also finds possible duplicate payments, reversals after the closing date and large entries with amounts ending in 0. Analyzes the first-digit distribution of amounts (Benford analysis) and creates a sample that can be redrawn with the same seed.

Check rules
  1. R1Entries where debits and credits do not balance
  2. R2Entries posted on weekends, holidays or late at night
  3. R3Entries approved by the person who prepared them
  4. R4Possible duplicate payments
  5. R5Reversals after the closing date
  6. R6Large entries with amounts ending in 0
  7. R7First-digit distribution of amounts (Benford analysis)
  8. R8A sample that can be redrawn with the same seed
01

Task overview

Use it when you need a list of exception entries by rule (Excel), a chart of the first-digit distribution of amounts and a draft review summary from journal entries exported from the accounting system (CSV or XLSX, usually one year's worth).

02

Input

Company data to connect

  • Chart of accounts and counterparties

    The chart of accounts (code, name and type) and the counterparty list. The chart of accounts identifies the cash and deposit accounts used in the duplicate payment check, and counterparties missing from the counterparty list are flagged. When not connected, cash and deposit accounts are found by account name and counterparties are not compared.

  • Audit guidance

    Journal entry testing guidance from an accounting firm or the internal audit department. When connected, its thresholds (late-night hours, the large-amount threshold and the sample size) are applied instead of the skill settings, and the answer lists the values that changed. When not connected, the skill settings apply.

03

Processing steps

  1. Connect company data

    Copy the template and connect the chart of accounts, the counterparty list and the audit guidance.

  2. Upload journal entry files

    Attach the journal entries exported from the accounting system (CSV or XLSX, usually one year's worth).

  3. Review exceptions by rule

    You get a list of exception entries by rule (Excel), a chart of the first-digit distribution of amounts and a draft review summary.

  4. Recheck with the same sample

    With the same seed, the same sample can be drawn again later and checked.

See it with
your own documents

In a consultation, we connect a few of your documents so you can check the answer quality for yourself. Send us your questions and our team will get back to you.

Product videosReal product screens · Example company ACME Logistics · 16 videos