As of 13 August 2026, AI can create a customer statement of account.

What to actually do

1. Hand it to a person

   The route this page recommends

   A person who owns the outcome does this end to end, worth it when the failure is dear.

2. Use a tool built for this

   Second choice

3. Do it yourself

   The distant third

   A chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.

   How to actually do it

   1. Open your accounting or invoicing system and export the customer ledger for the required statement period, including the opening balance, invoices, credit notes, payments, refunds and adjustments.
   2. Check the export contains the customer name, account reference, transaction dates, document or payment references, amounts and whether each amount increases or reduces the balance.
   3. Remove unrelated customers and redact unnecessary personal or bank details, then paste the remaining records into the prompt under the source data section.
   4. Ask the model to produce the statement and its unresolved-items list using the supplied prompt.
   5. Compare the opening balance, every transaction, running balance and closing balance against the customer ledger and recalculate the closing balance in your accounting system or spreadsheet.
   6. Investigate every flagged duplicate, missing reference, unallocated payment or disputed credit with the person who maintains the accounts before sending anything.
   7. Save the checked statement as a PDF or approved document and send it through your normal customer communication process.

   Prompt

   Create a customer statement of account from the transaction data below. Use UK pounds and the date format DD/MM/YYYY. Include the customer name and account reference, statement period, opening balance, every invoice, credit note, payment and adjustment in date order, a running balance, and the closing balance. Treat invoices and other charges as increases to the amount owed, and credits and payments as decreases. Do not invent, infer or round any figures. Keep invoice numbers, payment references and dates exactly as supplied. If the opening balance is missing, the data contains duplicate or conflicting entries, or a payment cannot be allocated confidently, flag it clearly instead of deciding silently. Show the arithmetic used for the closing balance and list all unresolved items separately. Return a clean table suitable for checking and sending after approval, followed by a short plain-English summary. This is the source data:
   
   Customer name: [CUSTOMER NAME]
   Account reference: [ACCOUNT REFERENCE]
   Statement period: [START DATE] to [END DATE]
   Opening balance: [OPENING BALANCE OR 'NOT PROVIDED']
   
   Transactions:
   [PASTE THE ACCOUNTING EXPORT OR TRANSACTION LIST HERE]

   Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.