Cara Menggunakan AI untuk Rekonsiliasi Keuangan: Proses & Praktik Terbaik

I have two CSV files for bank reconciliation. File 1 is our internal ledger with columns: [list your columns]. File 2 is the bank statement with columns: [list your columns]. Before we start matching, tell me: (1) which columns I should use as matching keys, (2) any data format inconsistencies I should fix first, and (3) what edge cases I should watch for in this type of reconciliation.

Here is a sample of 15 rows from my internal ledger: [paste data]. Here is a sample of 15 rows from the bank statement: [paste data]. Based on these patterns, suggest the best matching rules — including what to use as the primary key, how to handle near-matches, and what threshold to use for date tolerance. Output the rules as a numbered list I can validate before applying.

Using the matching rules we defined: [paste your rules]. Apply them to the two datasets I uploaded. Output three tables: (1) Matched transactions — all items that reconcile successfully, (2) Near-matches — items that match on most criteria but have a minor discrepancy (specify what the discrepancy is for each row), (3) Unmatched items — items that appear on only one side, split into "only in ledger" and "only in bank statement." Format each table with clear column headers and include a summary count for each category.

Here are my unmatched exceptions from this month's bank reconciliation: [paste exception rows]. For each row, analyze the data and suggest: (1) the most likely reason for the discrepancy, (2) what I should verify first (e.g., check if payment cleared the next day, verify reference number formatting, check for duplicate entry), (3) how urgent this is (e.g., potential fraud indicator vs. routine timing difference). Format your analysis as a table with columns: Row ID, Likely Cause, First Action, Priority.

Generate a formal bank reconciliation summary report based on this data:

Period: [month/year]
Opening balance (ledger): [amount]
Opening balance (bank): [amount]
Total transactions matched: [count], [total value]
Unresolved exceptions: [list with amounts and categories]
Closing balance (ledger): [amount]
Closing balance (bank): [amount]

Format this as a professional reconciliation statement with clear sections, a summary table, and a noted exceptions section. The tone should be formal and audit-ready.

Here are the corrections from my last reconciliation cycle — cases where the AI matching was wrong and what the correct classification was: [paste your corrections log]. Based on these patterns, update my matching rules to prevent these errors in future cycles. Explain what caused each error and what rule change will fix it.