Create intermediate Works with: Any AI

Customer Statement Reconciliation

Table output

Agree balances with the customer.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Reconcile my customer statement with their records. My statement lines (invoice, date, amount, credits, payments): [MY_STATEMENT]. The customer's records or their questions: [CUSTOMER_RECORDS].

Match the two sets line by line.
Output format:
1. A table: Item | My amount | Their amount | Difference | Likely cause (timing, missing invoice, unapplied payment, credit note not recorded, dispute, tax difference, currency) | Question to ask.
2. The net difference, the sum of explained differences, and the remaining unexplained amount, with the arithmetic shown.
3. A summary line: agreed balance, disputed amount, and the amount I will chase, each calculated, plus the date I propose to finish the reconciliation.
4. A message of about 120 words that proposes the steps to agree the balance, attaches the reconciliation, and asks for payment of the undisputed amount.
5. A log for disputed items with owner and date, and a rule to send statements monthly.
Do not guess amounts; ask for any line you cannot match.

Every figure and conclusion here is an estimate derived solely from the inputs I supplied. Nothing here is accounting, tax, legal or investment advice. Before acting, ask a qualified accountant or financial adviser familiar with [JURISDICTION] to check the output.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

• statement-reconciliation