Join for free

Organize income and expense records into budget categories

Author: AILesson9 min setupTested with:ChatGPTReviewed: 2026-08-28

Quick answer

Classify transaction records with explicit rules for transfers, refunds, splits, uncertainty, and reconciliation. Provide: Transaction records, Budget taxonomy and rules, Output and control requirements. Expected result: A reviewable transaction table, category summary, unmatched queue, rule log, and reconciliation.

1

Add your context

Your text stays in this browser. AILesson Prompts does not send it to a model or server.

2

Your prompt

Unfilled fields remain visible as placeholders, so you can still copy and edit the prompt

Classify the supplied income and expense records using only the approved taxonomy and mapping evidence.

Records:
[records]

Taxonomy and rules:
[taxonomy]

Output controls:
[output]

Audit row IDs, dates, currency, signs, duplicates, pending items, reversals, transfers, refunds, and total coverage first. Preserve every source row and never silently merge, delete, convert, or repair it. For each row return category, optional subcategory, classification basis, confidence, review flag, and split linkage. Use Unclassified when evidence is insufficient. Keep internal transfers out of income and expense totals, link refunds to original categories only when supported, and make splits reconcile exactly to the source amount. Produce classified rows, category totals, an unclassified and exception queue, reusable mapping rules, and a reconciliation from source inflow and outflow to reported totals.
Private by defaultPrompt assembly happens locally in your browser. Avoid placing confidential information into any AI service unless your organization allows it.

From input to outcome

A worked example

See how concrete context turns this recipe into a usable result

Actual input

Transaction records
August, CNY, cash basis. T01 08-02 +12,000 ACME CLIENT settled business account; T02 08-03 -800 TRANSFER TO RESERVE settled; T03 08-03 +800 TRANSFER FROM OPERATING settled reserve account; T04 08-05 -360 CLOUDHOST settled; T05 08-08 -520 CITY MART settled, note ‘office fruit 320; personal items 200’; T06 08-10 -1,200 STUDIO RENT settled; T07 08-12 +120 CLOUDHOST REFUND settled, original T04; T08 08-15 -460 CLOUDHOST pending; T09 08-18 -300 FASTPAY no note; T10 duplicates bank export ID T06 and amount/date. Source totals including duplicate and pending: inflow 12,920; outflow 3,640.
Budget taxonomy and rules
Income: Client revenue. Expenses: Rent, Software, Office supplies, Meals, Travel, Fees, Tax, Owner draw. Internal transfer is neither income nor expense. Personal portion is Owner draw. Refund reduces the original category when original ID is known. Exclude pending from reported cash totals but retain it. Exact duplicate bank export IDs are flagged and excluded only after review; for this example T10 is confirmed duplicate. Splits allowed when note gives amounts. Merchant name alone is insufficient for FASTPAY. No tax inference.
Output and control requirements
Report settled August transactions. Expenses are positive in summaries but source signs remain. Columns: row ID, source amount, status, category, split amount, basis, confidence, review. High confidence requires explicit note, original link, or approved exact mapping. Owner reviews Unclassified. Do not expose account numbers.

Example output

Classification result

RowSourceStatusCategoryClassified amountBasisReview
T01+12,000settledClient revenue12,000explicit description and approved mappingno
T02-800settledInternal transfer800transfer pairno
T03+800settledInternal transfer800transfer pairno
T04-360settledSoftware360approved exact CLOUDHOST mappingno
T05-a-520 sourcesettledOffice supplies320explicit note splitno
T05-b-520 sourcesettledOwner draw200explicit note splitno
T06-1,200settledRent1,200explicit descriptionno
T07+120settledSoftware refund-120 expenselinked to T04no
T08-460pendingExcluded pending460status rulerevisit when settled
T09-300settledUnclassified300merchant alone insufficientowner review
T10-1,200duplicateExcluded duplicate1,200confirmed duplicate of T06retain audit link

Settled budget summary: Client revenue 12,000. Expenses: Rent 1,200; Software net 240; Office supplies 320; Unclassified 300. Owner draw 200 is reported separately. Total budget expense including Unclassified is 2,060.

Reconciliation: raw inflow 12,920 less internal-transfer inflow 800 = 12,120; this consists of client revenue 12,000 plus software refund 120. Raw outflow 3,640 less pending 460, confirmed duplicate 1,200, and transfer outflow 800 = eligible settled outflow 1,180? This conflicts with the listed eligible outflows of T04 360 + T05 520 + T06 1,200 + T09 300 = 2,380. Therefore the supplied raw outflow total is inconsistent by 1,200 and must be corrected before final sign-off. The classification is preserved, but reconciliation status is blocked.

Why this works

  1. 1

    Row-level evidence and an unclassified state prevent plausible merchant guesses from becoming financial facts

  2. 2

    Transfer, refund, and split controls prevent double counting while preserving the audit trail

Check the result

  • Does every source row appear exactly once or through a fully reconciling split?

  • Are transfers, refunds, pending items, duplicates, and uncertainty handled by explicit rules?

  • Do category totals reconcile to eligible source inflow and outflow without currency mixing?

Use it with confidence

Frequently asked questions

Practical answers about when to use this recipe, what to provide, and where human review still matters

What should I prepare before using “Organize income and expense records into budget categories”?

For “Organize income and expense records into budget categories,” prepare Transaction records, Budget taxonomy and rules, and Output and control requirements. Replace placeholders only with information you can verify. If a detail is unknown, preserve that uncertainty explicitly instead of asking the model to infer it.

When is the “Organize income and expense records into budget categories” result not ready to use?

The result is not ready if it does not yet deliver the stated outcome—A reviewable transaction table, category summary, unmatched queue, rule log, and reconciliation—from the supplied evidence, or if it relies on unresolved assumptions, missing approvals, or invented details. Use the checks as release gates: revise the source inputs or assign a named, authorized reviewer instead of polishing an unsupported output.

Which AI tools have recorded tests for “Organize income and expense records into budget categories”?

The published test record for “Organize income and expense records into budget categories” lists ChatGPT as of 2026-08-28. This confirms recorded runs, not guaranteed compatibility or identical results in later product versions. For another tool or version, keep every constraint visible and repeat the result checks before use.

More ways to explore

Where this recipe fits

Text promptsFinance, procurement & administrationFor managers

Keep the work moving