Únete gratis

Organize income and expense records into budget categories

Autor: AILesson9 min de preparaciónProbado con:ChatGPTRevisado el: 2026-08-28

Respuesta rápida

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

1

Añade tu contexto

Tu texto permanece en este navegador. AILesson Prompts no lo envía a un modelo ni a un servidor.

2

Tu prompt

Los campos sin rellenar permanecen visibles como marcadores de posición, para que puedas copiar y editar el 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.
Probar en Playground
Privado de forma predeterminadaLa preparación del prompt se realiza localmente en tu navegador. Evita introducir información confidencial en cualquier servicio de IA, a menos que tu organización lo permita.

De la entrada al resultado

Un ejemplo completo

Mira cómo un contexto concreto convierte esta receta en un resultado que puedes usar

Entrada real

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.

Ejemplo de salida

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.

Por qué funciona

  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

Comprueba el resultado

  • 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?

Úsalo con confianza

Preguntas frecuentes

Respuestas prácticas sobre cuándo usar esta receta, qué debes proporcionar y en qué casos la revisión humana sigue siendo importante

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.

Más formas de explorar

Dónde encaja esta receta

Indicaciones de textoFinanzas, adquisiciones y administraciónPara gerentes

Mantén el trabajo en marcha

AILesson · Cursos recomendados

Tu próximo paso: pon la IA a trabajar

Pasa de entender la IA a poner manos a la obra. Practica cómo dar instrucciones, revisar y mejorar resultados con lecciones interactivas para el trabajo y la vida cotidiana.

Explora todos los cursos
Portada de IA para principiantes

15 lecciones interactivas

IA para principiantes

Inicia una conversación útil con la IA, mejora la respuesta, comprueba lo importante y reconoce cuándo te corresponde dar el siguiente paso.

Explora este curso
Portada de Fundamentos de ChatGPT

10 lecciones interactivas

Fundamentos de ChatGPT

Aprende a usar ChatGPT mediante tres flujos de trabajo prácticos: completa una primera conversación, trabaja con un archivo y usa Projects para llevar un plan comprobado a una nueva conversación.

Explora este curso
Portada de Cómo funciona la IA generativa

7 lecciones interactivas

Cómo funciona la IA generativa

Comprende cómo los chats de IA habituales aprenden patrones del lenguaje, usan los mensajes actuales, construyen respuestas e incorporan fuentes y herramientas.

Explora este curso