Draft reconciliations from ledgers and statements

Align the general ledger, subsidiary books, and external statements with the same base date and account and organize differences, adjustments, and open items. The existing reconciliation schedule format is maintained while the location of the supporting file is included.

Discuss this pilot Back to Soma

Account reconciliation draftDraft structure

book balance: 125,400,000ledger connection
external balance: 124,950,000Statement link
difference: 450,000Needs explanation
Balance after adjustment: 125,400,000Before review

The actual column names and output format match the form used when starting the pilot.

Input

Materials needed to begin

We don't ask for all the data at once. After checking the data you have, determine the pilot scope.

General ledger, subsidiary book, balance statement
External data from banks, clients, and systems
Previous period reconciliation schedule and current company form
Allowed variances and review criteria for each account

Workflow

Drafting workflow

01
Unification of standards
Create comparable tables by matching accounts, base dates, currencies, and amount units.
02
Balance connection
The corresponding balances of the ledger, subsidiary books, and statements are linked through rules and user selection.
03
Classification of differences
Divide the differences into timing differences, non-reflection, classification errors, and items requiring confirmation.
04
Reconciliation drafting
Post-adjustment balances, explanation of differences, basis location and review status are included in a draft balance sheet.

Output

Pilot deliverables

reconciliation schedule by account

Create a table of book balance, external balance, adjustment items, and balance after adjustment.

List of open items

We leave a separate list of differences that are unfounded or require explanation from the person in charge.

table of evidence

Allows you to track which file, sheet, or row each amount and description comes from.

What requires human approval

The cause of the difference, whether an adjustment journal entry is required, and the final settlement amount are not automatically concluded. Only what the person in charge confirms and approves of the documents and accounting policies is reflected in the final settlement sheet.

Other pilots