100 Best ChatGPT Expense Categorization Prompts for Bookkeepers

Direct Answer

The best ChatGPT prompts for expense categorization for bookkeepers are a curated set of 100 precise, ready-to-use prompts that standardize vendor mapping, tax alignment, department allocation, project coding, and audit trails for every expense line item. They enable consistent reporting and faster month-end closes with minimal ambiguity.

Introduction

This page is a practical prompt library focused on expense categorization for bookkeepers, designed to improve accuracy and speed in coding expenses to the right accounts.

It helps professional bookkeepers, accounting technicians, and bookkeeping firms standardize their categorization processes with ready-to-run prompts that cover common and edge-case scenarios.

How to Use These ChatGPT Prompts

• Replace placeholders like [vendor], [department], [projectCode], and [taxRegion] with your actual data before running a prompt.
• Add or tighten constraints to match your chart of accounts and internal policies.
• Request outputs in your preferred format, such as CSV, JSON, or YAML, and specify required columns or fields.
• Verify outputs by spot-checking a sample of items and comparing against source documents.
• Store prompts with versioned names and maintain a change log for auditing.

100 Best ChatGPT Expense Categorization Prompts for Bookkeepers

1. Vendor category mapping: Role: You are a junior bookkeeper. Task: Categorize each expense line item by exact vendor category and assign to the most appropriate GL account. Context: The dataset includes fields: date, vendor, description, amount, tax, and existing category. Output format: a CSV with columns date, vendor, amount, originalCategory, newCategory, glAccount, confidence. Constraints: use only allowed vendor categories defined in the master catalog. If vendor is unknown, create a new vendorCategory with notes.
2. Mileage and travel classification: Role: Senior bookkeeper. Task: Classify expenses in a travel batch into mileage, airfare, lodging, meals, and other. Context: Each line item has description and amount. Output format: JSON array with fields: description, amount, category, subcategory, taxCode, note. Constraints: mileage should be recorded under travel mileage; use taxCode 0 for non taxable; provide justification notes for edge cases.
3. Recurring expense normalization: Role: Bookkeeping assistant. Task: Normalize recurring expenses into the same category across months. Context: Data spans 12 months with vendor, amount, and category. Output format: table where each row shows month, vendor, amount, normalizedCategory, rationale. Constraints: enforce consistent mapping to the chart of accounts; flag deviations.
4. Tax code alignment: Role: Tax compliance analyst. Task: Map each expense to the correct tax code based on product or service. Context: Each item has taxPaid, location, and supplier. Output: list with itemID, taxCode, justification, and any tax exemptions. Constraints: use jurisdiction-specific tax rules and update for shared expenses.
5. Split billing allocator: Role: Accounts payable specialist. Task: Split a single invoice into multiple GL lines across departments. Context: Invoice has total amount, line items with descriptions, and department hints. Output: YAML with lines: description, department, amount, glAccount. Constraints: ensure sum equals total; include a brief note per line.
6. Vendor-specific coding rules: Role: Controller. Task: Apply vendor-specific coding templates to each expense line. Context: List includes vendor, category, and project code. Output: CSV with vendor, originalCategory, recommendedCategory, glCode, rationale. Constraints: templates must map to the standardized COA.
7. Client-friendly categorization: Role: Bookkeeper for client; Task: Produce client-ready expense categories for monthly report. Context: Client requires layman terms; keep 2-3 word category names. Output: CSV: itemID, vendor, amount, clientCategory, internalCategory, notes.
8. Cross-month trend tagging: Role: Data analyst. Task: Tag expenses with trend tags such as seasonal, recurring, one-off. Context: One year of data. Output: JSON: itemID, tag, rationale. Constraints: use up to three tags per item.
9. Depreciation vs expense classification: Role: CPA assistant. Task: Distinguish capital expenditures vs operating expenses when description suggests asset purchase. Context: Each item includes assetFlag and lifetime. Output: table with itemID, type (capex/opex), glAccount, notes. Constraints: recommend capitalization where threshold met.
10. Multi-currency expense coding: Role: Global bookkeeper. Task: Code expenses in local currency to base currency while preserving detail. Context: Entries from three currencies with exchangeRate. Output: CSV with itemID, currency, amountLocal, amountBase, rateUsed, glAccount. Constraints: round to two decimals.
11. Accrual-friendly classification: Role: Accrual accountant. Task: Classify expenses for accrual reporting, including prepaid and accrued items. Context: End of period data. Output: JSON with itemID, accrualFlag, prepaidFlag, recognitionDate, glAccount.
12. Expense categorization automation: Role: Automation engineer. Task: Propose an automation-friendly categorization rule set. Context: Dataset includes vendors, descriptions, and amounts. Output: 2 logical rule sets with examples. Constraints: rules should be deterministic and auditable.
13. Card vs receipt alignment: Role: AP clerk. Task: Align credit card charges with receipts and categorize accordingly. Context: CardStatement items map to receipts. Output: CSV: cardItemID, receiptID, category, glCode, notes.
14. Vendor alias resolution: Role: Data steward. Task: Resolve vendor aliases to a canonical vendor name before coding. Context: List contains multiple spellings. Output: CSV: alias, canonicalVendor, category, glAccount; justification.
15. Departmentalization prompts: Role: Bookkeeper. Task: Assign each expense to the correct department within the chart of accounts. Context: Department hints exist but not always consistent. Output: table: itemID, departmentLabel, glCode, confidence. Constraints: report any ambiguities.
16. Project-based coding: Role: Project controller. Task: Map expenses to project codes when present. Context: Some items lack projectCode. Output: CSV: itemID, projectCode, glAccount, note. Constraints: flag missing codes for follow-up.
17. Audit-ready summaries: Role: Internal auditor. Task: Build a minimal audit trail for each expense. Context: Each item requires justification. Output: JSON: itemID, category, glCode, justification, reviewerNotes. Constraints: ensure traceability.
18. Income tax category prompts: Role: Tax assistant. Task: Distinguish deductible vs non-deductible expenses for income tax. Context: Descriptions vary in detail. Output: CSV: itemID, deductibleFlag, reason, taxImpact.
19. Non-billable item handling: Role: AP manager. Task: Identify non-billable items and reclassify. Context: Some items are client-absent. Output: CSV: itemID, originalCategory, newCategory, justification.
20. Reimbursable vs company expense: Role: Compliance analyst. Task: Separate reimbursable claims from company expenses. Context: Employee name, amount, reason. Output: JSON: itemID, claimant, reimbursableFlag, category, notes.
21. Template-driven coding: Role: Bookkeeping assistant. Task: Apply a given coding template to a dataset. Context: Template defines category mappings and constraints. Output: CSV: itemID, templateCode, mappedCategory, glCode, notes.
22. Sales-related expense tagging: Role: Revenue coordinator. Task: Tag expenses that directly relate to sales activities. Context: Each item has description field. Output: CSV: itemID, isSalesRelated, category, glCode.
23. Purchase order alignment: Role: AP clerk. Task: Cross-check PO lines with expense entries and code accordingly. Context: PO numbers present. Output: JSON: itemID, poNumber, category, glCode, matchConfidence.
24. Recurring vs one-off tagging: Role: Data manager. Task: Tag each line item as recurring or one-off across a year. Context: Monthly dataset. Output: CSV: itemID, tag, rationale, period.
25. Software expense coding: Role: IT finance specialist. Task: Code software subscriptions to correct license type and cost center. Context: Vendor, licenseTier, renewalDate. Output: CSV: itemID, licenseTier, costCenter, glCode, notes.
26. Office supplies classification: Role: Office admin. Task: Categorize office supply purchases by type (stationery, furniture, breakroom). Context: Description contains item details. Output: CSV: itemID, type, subType, glCode.
27. Travel vs meals prompts: Role: Expense reviewer. Task: Separate travel-related meals from other meal costs. Context: Bundle contains transport and meals. Output: JSON: itemID, travelMealFlag, category, note.
28. Vendor tax status check: Role: Tax specialist. Task: Flag expenses from vendors with ambiguous tax status. Context: taxStatus field present or missing. Output: CSV: itemID, taxStatus, recommendedCode, rationale.
29. Expense description normalization: Role: Data cleaner. Task: Normalize descriptions to standardize categorization. Context: Inconsistent wording. Output: CSV: itemID, normalizedDescription, category, glCode.
30. Depreciation check prompts: Role: Auditor. Task: Identify items that may be depreciable assets but miscategorized as expense. Context: assetFlag, assetYear. Output: JSON: itemID, potentialCapex, suggestedCategory, rationale.
31. Subscription lifecycle prompts: Role: Subscription admin. Task: Track subscription expenses through renewal date and category. Context: RenewalDate, vendor. Output: CSV: itemID, renewalDate, category, glCode.
32. Event and training costs: Role: Training coordinator. Task: Categorize events and training fees appropriately. Context: includes venue, catering, speaker. Output: CSV: itemID, subCategory, glCode, notes.
33. Advertising spend coding: Role: Marketing finance. Task: Code advertising costs to correct campaigns and channels. Context: CampaignID present. Output: JSON: itemID, campaignID, channel, category, glCode.
34. Reconciliation prompts: Role: Reconciliation clerk. Task: Reconcile categorization with bank statements. Context: Monthly bank feed. Output: JSON: itemID, bankMatch, glCode, discrepancyNotes.
35. Expense notes quality checks: Role: Controller aide. Task: Generate concise notes for each expense to justify category. Context: Free-text notes field. Output: CSV: itemID, noteQualityFlag, justification.
36. Green accounting prompts: Role: Sustainability accountant. Task: Tag eco-friendly categories and report on green spend. Context: Category list includes sustainability labels. Output: CSV: itemID, ecoTag, glCode, amount.
37. Capex vs opex audit: Role: Audit lead. Task: Validate that capitalization criteria are met before classifying as capex. Context: Amount, usefulLife, recovery period. Output: JSON: itemID, eligibleForCapex, rationale.
38. Receivable-related expenses: Role: AR manager. Task: Distinguish expenses tied to client projects from general overhead. Context: ProjectCode field present. Output: CSV: itemID, projectCode, category, glCode.
39. Expense policy prompts: Role: Policy auditor. Task: Check each item against the company expense policy. Context: PolicyVersion; violations flagged. Output: JSON: itemID, policyMatch, violationNotes.
40. Import-ready coding: Role: Data import specialist. Task: Produce a clean, import-ready CSV with itemID, vendor, category, glCode. Context: No ambiguous fields. Output: CSV: itemID, vendor, category, glCode, amount.
41. reimbursable policy checks: Role: Compliance officer. Task: Identify reimbursable items and verify submission requirements. Context: EmployeeName, date, amount. Output: CSV: itemID, reimbursableFlag, submissionStatus.
42. Petty cash prompts: Role: Cash controller. Task: Code petty cash expenses to appropriate categories. Context: cashDate, amount, description. Output: JSON: itemID, category, glCode, notes.
43. Vendor risk prompts: Role: Risk analyst. Task: Tag expenses from vendors with high risk indicators. Context: riskScore present. Output: CSV: itemID, vendor, riskScore, category, glCode.
44. Client-specific coding: Role: Client bookkeeper. Task: Align client-chosen codes with standard COA. Context: ClientCode mapping provided. Output: CSV: itemID, clientCode, standardCode, glCode.
45. Zero-based category mapping: Role: Data architect. Task: Rebuild category mapping from scratch ensuring zero-based budgets align. Context: Budget lines provided. Output: JSON: itemID, newCategory, glCode, budgetImpact.
46. Petty cash reconciliation: Role: Cash reconciler. Task: Match petty cash entries to receipts and categorize. Context: Receipts attached. Output: CSV: itemID, receiptID, category, glCode.
47. Tax-exempt handling: Role: Tax advisor. Task: Identify tax-exempt purchases and apply exemptions. Context: exemptionCertificates present. Output: JSON: itemID, taxExempt, exemptionCode, notes.
48. Mill rate prompts: Role: Tax accountant. Task: Apply local tax rates to eligible items and adjust for exemptions. Context: rateTable available. Output: CSV: itemID, taxRate, taxCode, finalAmount.
49. Food and beverage prompts: Role: Event planner finance. Task: Classify meals and beverages as client entertainment or internal meals. Context: receipts with attendees. Output: JSON: itemID, category, clientEntertainmentFlag, glCode.
50. Utility expense prompts: Role: Facility manager. Task: Categorize utilities and allocate to departments. Context: meterReadings present. Output: CSV: itemID, utilityType, department, glCode.
51. Travel expense prompts: Role: Travel accountant. Task: Code transport, lodging, and misc travel costs. Context: itinerary details. Output: JSON: itemID, transportCode, lodgingCode, otherCode, glCode.
52. Marketing collateral prompts: Role: Brand finance. Task: Classify marketing spend by channel and campaign. Context: campaignID present. Output: CSV: itemID, channel, campaignID, category, glCode.
53. Vendor master prompts: Role: Data steward. Task: Clean vendor master data before coding. Context: duplicates and typos exist. Output: CSV: oldVendorName, canonicalVendor, category, glCode.
54. R&D expense prompts: Role: R&D controller. Task: Distinguish research vs development costs for capitalization. Context: projectStage present. Output: JSON: itemID, rAndDFlag, capitalizationRecommendation, glCode.
55. Healthcare spend prompts: Role: Healthcare finance. Task: Code medical supplies and services to correct departments. Context: supplierType present. Output: CSV: itemID, supplierType, category, glCode.
56. Education and training prompts: Role: L&D finance. Task: Classify training costs by employee level and program type. Context: programCode. Output: JSON: itemID, programCode, level, category, glCode.
57. Subscriptions renewal prompts: Role: License manager. Task: Track renewals and categorize recurring subscriptions. Context: renewalDate present. Output: CSV: itemID, renewalDate, category, glCode.
58. Freight and shipping prompts: Role: Logistics finance. Task: Allocate freight costs to products or cost centers. Context: shipmentID present. Output: JSON: itemID, costCenter, freightCode, glCode.
59. Insurance expense prompts: Role: Risk finance. Task: Classify insurance premiums by policy type and department. Context: policyType field. Output: CSV: itemID, policyType, department, glCode.
60. Lease and rent prompts: Role: Real estate accountant. Task: Distinguish operating lease vs equipment rent. Context: leaseTerm, assetFlag. Output: JSON: itemID, leaseType, glCode, notes.
61. Interest and bank charges: Role: Treasury analyst. Task: Code interest and bank charges to correct categories. Context: bankStatement present. Output: CSV: itemID, chargeType, category, glCode.
62. Miscellaneous expenses prompts: Role: Bookkeeper. Task: Determine miscellaneous items and best-fit category. Context: vague descriptions. Output: JSON: itemID, recommendedCategory, rationale.
63. Conference and travel prompts: Role: Events finance. Task: Separate conference fees from travel costs and code accordingly. Context: attendeeList present. Output: CSV: itemID, conferenceCode, travelCode, glCode.
64. Refund and reversal prompts: Role: AP clerk. Task: Handle refunds by reversing and reclassifying as needed. Context: refundAmount and originalItemID. Output: JSON: originalItemID, reversalAmount, newCategory, glCode.
65. Audit trail prompts: Role: Auditor. Task: Append an audit note to each item describing why the category was chosen. Context: 1 sentence note per item. Output: CSV: itemID, auditNote.
66. Non-profits prompts: Role: Nonprofit accountant. Task: Classify grants, donations, and program service expenses appropriately. Context: fundCode present. Output: JSON: itemID, fundCode, category, glCode.
67. Grant-related expenses prompts: Role: Grant manager. Task: Allocate grant-specific expenses to program codes. Context: grantCode, period. Output: CSV: itemID, grantCode, programCode, glCode.
68. Chart of accounts alignment: Role: COA administrator. Task: Verify each item maps to the correct COA account. Context: COA snapshot. Output: JSON: itemID, suggestedAccount, justification.
69. Inventory-related expenses: Role: Inventory controller. Task: Distinguish between inventory purchases and overhead costs. Context: assetFlag present. Output: CSV: itemID, isInventory, glCode.
70. Non-operating expenses: Role: Controller. Task: Flag and explain non-operating expenses for reporting. Context: category field may misclassify. Output: JSON: itemID, nonOperatingFlag, explanation.
71. SaaS expense prompts: Role: SaaS finance. Task: Code software as a service charges to correct cost centers. Context: seatCount, licenseTier. Output: CSV: itemID, licenseTier, seatCount, glCode.
72. Professional services prompts: Role: PMO finance. Task: Classify consulting, legal, and advisory fees properly. Context: engagementType present. Output: JSON: itemID, engagementType, category, glCode.
73. Office equipment prompts: Role: Asset admin. Task: Distinguish purchases of equipment vs consumables. Context: assetFlag, depreciationPolicy. Output: CSV: itemID, assetFlag, category, glCode.
74. Marketing spend prompts: Role: Marketing finance. Task: Break down by channel and campaign performance. Context: campaignCode, channel. Output: JSON: itemID, channel, campaignCode, category, glCode.
75. Training grant prompts: Role: Education grants finance. Task: Track training spend funded by grants and allocate accordingly. Context: grantCode. Output: CSV: itemID, grantCode, category, glCode.
76. Facility maintenance prompts: Role: Facilities finance. Task: Classify maintenance vs capital improvements. Context: projectCode, lifecycle. Output: JSON: itemID, category, glCode, notes.
77. Bank reconciliation prompts: Role: Reconciliation analyst. Task: Reconcile categorization against bank feeds to resolve mismatches. Context: bankStatement; transactionDescription. Output: CSV: itemID, matchStatus, notes.
78. Asset disposal prompts: Role: Asset manager. Task: Classify disposal costs and update asset records if needed. Context: disposalDate. Output: JSON: itemID, disposalCostCategory, glCode, notes.
79. Cloud hosting prompts: Role: IT finance. Task: Code hosting and cloud costs to correct projects and centers. Context: projectCode; environment. Output: CSV: itemID, projectCode, environment, glCode.
80. Advertising tax thresholds: Role: Tax planner. Task: Flag ad spend that crosses thresholds for different tax treatments. Context: taxJurisdiction, threshold. Output: JSON: itemID, taxTreatment, rationale.
81. Mileage expense prompts: Role: Travel admin. Task: Separate mileage reimbursements from other travel costs. Context: odometer, route. Output: CSV: itemID, miles, rate, category, glCode.
82. Donation vs program costs: Role: Nonprofit bookkeeper. Task: Distinguish donations from program expenses. Context: fundCode; donorInfo present. Output: JSON: itemID, donationFlag, programCode, glCode.
83. Credit note prompts: Role: AP specialist. Task: Apply credit notes to the correct outstanding invoices and reclassify. Context: creditNoteID, originalItemID. Output: CSV: creditNoteID, originalItemID, newCategory, glCode.
84. Refund offset prompts: Role: Revenue controller. Task: Offset refunds against the original revenue category. Context: revenueItemID present. Output: JSON: revenueItemID, refundAmount, adjustedCategory, glCode.
85. Audit-ready labels: Role: Auditor. Task: Generate standardized labels for each item to expedite reviews. Context: labelSet provided. Output: CSV: itemID, label1, label2, label3.
86. Data privacy prompts: Role: Compliance. Task: Redact or mask sensitive fields in exports while maintaining categories. Context: PII present. Output: JSON: itemID, maskedFields, category, glCode.
87. Ethics and compliance prompts: Role: Compliance officer. Task: Flag expenses with potential ethics concerns related to vendors or purposes. Context: riskNotes present. Output: CSV: itemID, concernFlag, note.
88. International tax prompts: Role: Global tax advisor. Task: Apply correct tax treatment for cross-border expenses. Context: countryCode, tax treaties. Output: JSON: itemID, taxCode, justification.
89. Travel insurance prompts: Role: Travel finance. Task: Classify travel insurance as travel expense or reimbursable item. Context: policyNumber. Output: CSV: itemID, category, policyNumber, glCode.
90. Client billable checks: Role: Billing administrator. Task: Ensure client-billable expenses align with client agreements. Context: clientID, contractRate. Output: JSON: itemID, billableFlag, notes.
91. Vendor payment terms prompts: Role: AP manager. Task: Apply payment terms to expense invoices for early payment discounts. Context: terms, dueDate. Output: CSV: itemID, discountApplicable, discountAmount, glCode.
92. Budget vs actual prompts: Role: FP&A analyst. Task: Flag expenses that breach budget thresholds. Context: budgetLine, actualAmount. Output: JSON: itemID, variance, category, glCode.
93. Pcard reconciliation prompts: Role: PCard admin. Task: Reconcile PCard charges with receipts and categorize. Context: cardStatement, receiptAttach. Output: CSV: itemID, receiptID, category, glCode.
94. Cross-entity coding prompts: Role: Consolidation accountant. Task: Map expenses to the correct legal entity and chart. Context: entityCode present. Output: JSON: itemID, entityCode, glCode, notes.
95. Expenditure escalation prompts: Role: Finance lead. Task: Escalate anomalies in categorization to the appropriate owner. Context: anomalyReason. Output: JSON: itemID, escalationTo, reason, status.
96. Accounts reconciliation prompts: Role: Reconciliation specialist. Task: Produce reconciled listing of expenses by category for month-end. Context: bankFeeds. Output: CSV: itemID, category, reconciledAmount, glCode.
97. Contracted services prompts: Role: Procurement finance. Task: Code contracted services to correct categories and cost centers. Context: contractID. Output: JSON: itemID, contractID, category, glCode.
98. Tax return prompts: Role: Tax preparer. Task: Prepare expense categories for tax return line items. Context: formCode, taxYear. Output: CSV: itemID, formCode, taxYear, category, glCode.
99. Expense dataset validators: Role: Data validator. Task: Validate dataset integrity before coding. Context: requiredFields present. Output: JSON: itemID, validFlag, issues.
100. Final review prompts: Role: QA reviewer. Task: Perform a final review pass to ensure all items have a category, glCode, and justification. Context: datasetComplete. Output: CSV: itemID, category, glCode, justification, reviewStatus.

Best Practices

• Keep your master COA and vendor master up to date so prompts map cleanly without manual tweaks.
• Reuse prompts across similar datasets by maintaining consistent field names and categories.
• Test prompts on a small sample before running full months to catch ambiguities early.
• Add concise justification notes to every coded item to aid audits and reviews.
• Regularly review and update tax and regulatory mappings to reflect changes.

Common Mistakes to Avoid

• Using vague category names that obscure reporting, making audits difficult.
• Applying a single mapping to all vendors without handling aliases or exceptions.
• Forgetting to include a projectCode or department when required by the prompt.
• Not validating multi-currency or tax context, leading to incorrect base amounts.
• Skipping audit notes or justifying outputs with generic statements.

FAQ

What is expense categorization in bookkeeping and why does it matter?

Expense categorization assigns each cost to a precise account, enabling accurate financial reporting, tax treatment, and budgets.

How do these prompts handle tax codes and compliance?

Prompts map items to correct tax codes based on vendor, product, and location to support compliant reporting.

Can I adapt prompts to different chart of accounts?

Yes. Replace glCode and category mappings to align with your COA structure and update templates as needed.

Do prompts support multi-currency expenses?

Some prompts include currency fields and base currency calculations; ensure exchange rates are current in your system.

How should I verify prompt outputs?

Run a pilot on a month with known results, compare against source documents, and adjust rules before full use.

Are there prompts for audits and trail generation?

Yes. Several prompts require justification notes and provide JSON or CSV outputs suitable for audit trails.