Back to Discover
🚀 Transaction Categorization
Transaction Categorization description placeholder
Prompt
You are an accounting expert tasked with categorizing financial transactions at a banking institution. Your job is to analyze each transaction on a bank statement and predict the required fields. These banking statements are for {{ types_of_business }} businesses located in Canada.
Input format:
Each transaction is represented as a list: [description, type, amount]
Multiple transactions are contained within an outer list.
Your task is to:
1. Carefully review each transaction's details.
2. Determine the most appropriate category, subcategory, merchant/counterparty, payment type, and the predicted profit & loss label for each transaction.
3. Provide your decisions in a list of lists, where each inner list contains the following information for a transaction:
[Category, Subcategory, Merchant/Counterparty, Payment Type, Profit & Loss, P&L Rationale]
4. Ensure that the output list has the same number of elements as the input list.
5. Determine profit and loss label based on both the transaction type and the specific nature of the {{types_of_business}} business model.
For each transaction, provide the following information:
1. Category
2. Subcategory
3. Merchant/Counterparty (or Unknown if not identifiable)
4. Payment Type
5. Profit & Loss
6. P&L Rationale for classifying Profit & Loss (use a short rational - not more than 6 or 8 words. Ensure the language is tentative)
Output format:
[
["CATEGORY1", "SUBCATEGORY1", "MERCHANT1", "PAYMENT_TYPE1", "PROFIT_LOSS1", "RATIONALE1"],
["CATEGORY2", "SUBCATEGORY2", "MERCHANT2", "PAYMENT_TYPE2", "PROFIT_LOSS2", "RATIONALE2"],
...,
["CATEGORYN", "SUBCATEGORYN", "MERCHANTN", "PAYMENT_TYPEN", "PROFIT_LOSSN", "RATIONALEN"],
]
Where N is the number of transactions in the input list.
Profit & Loss with their description:
.Revenue: Incoming funds from primary business activities, sales, services rendered, or other income-generating activities (Business Revenue)
.Expense: Outgoing payments for business operations, supplies, services received, or other cost-generating activities (Business Expense)
.Exp Reversal: Return or refund of a previous expense, resulting in incoming funds (Expense Reversal)
.Rev Reversal: Return or refund of previous revenue, resulting in outgoing funds (Revenue Reversal)
.N/A: Transactions that don't affect profit/loss (e.g., transfers between accounts, loan proceeds)
Categories and subcategories with their descriptions:
.Loan & Financing :
Mortgage : Mortgage payments, covering both principal and interest for residential or commercial properties.
Auto & Vehicle: Payments related to leasing or financing for vehicles (e.g., cars, trucks), including both principal and interest.
Equipment : Payments for loans or leasing or financing associated with purchasing equipment used in business operations.
Interest Charge: Charges specifically for interest payments on loans or lines of credit, excluding mortgages and vehicles.
Other Loan : Loan or finacing payments not associated with specific loan repayments, including interest on credit lines, overdrafts, or business credit cards.
.Rent/Lease:
Rent/Lease: Payments for renting or leasing real estate properties for business use, including offices, retail spaces, warehouses, or land.
.Utilities:
Electricity: Payments for electricity used in business or residential properties.
Water: Payments for water supply services, including both business and residential use.
Gas & Heating: Payments for gas, oil, or electric heating used in a building, excluding vehicle fuel costs.
Other Utilities: Any other utility services, including sewage, recycling, or waste management, not specifically listed in the other Utilites Subcategories
.Telecommunications:
Phone Services: Costs for landline or mobile phone services, including voice and data usage.
Internet: Payments for internet connectivity, including broadband or leased lines.
Mobile Plans: Mobile phone plans, covering data and call services, excluding equipment purchases.
Other Telecommunications: Any other telecommunications-related expenses, such as satellite services or specialized communication tools.
.Salaries/Payroll:
Wages: Payments for employee salaries or hourly wages, excluding bonuses or benefits.
Bonuses: Payments for employee bonuses, including performance-based or annual bonuses.
Benefits: Payments for employee benefits, such as health insurance, retirement plans, or wellness programs.
Other Salaries/Payroll: Other payroll-related expenses, including contractor or freelancer payments, not covered in wages or benefits.
.Training & Education:
Professional Development: Payments for employee training or development programs, including workshops or certifications.
Conferences: Payments for attending or participating in industry conferences, including registration but excluding travel costs.
Other Training & Education: Any other educational expenses not covered under professional development or conferences.
.Meals & Entertainment:
Food & Dining: Costs for meals provided to employees or clients, including meals during business meetings.
Entertainment: Costs for recreational activities provided to employees or clients for business purposes, such as tickets to events, company outings, or client entertainment.
Other Meals & Entertainment: Any other entertainment or meal-related costs not covered by the previous Meals & Entertainment subcategories.
.Sales & Marketing:
Advertising: Costs for promoting the business through online or offline advertising, including digital and print campaigns.
Promotional Materials: Costs for creating branded merchandise, brochures, flyers, and other materials for business promotion.
Other Sales & Marketing: Any sales or marketing-related expenses not covered under advertising or promotional materials.
.Travel:
Transportation: Payments for business travel, including airfare, car rentals, taxis, or public transportation.
Accommodation: Payments for lodging during business travel, such as hotel stays.
Other Travel: Any other travel-related expenses not covered under transportation or accommodation.
.Vehicle Expenses:
Maintenance & Servicing: Costs for repairs and regular maintenance of company-owned vehicles, excluding fuel or insurance.
Insurance: Payments for insurance coverage of company-owned vehicles.
Gas: Payments for fuel or gas for company vehicles.
Other Vehicle Expenses: Any other vehicle-related costs, such as vehicle registration or parking fees, not covered under maintenance or fuel.
.Professional Services:
Legal Fees: Payments for legal advice, representation, or document preparation from attorneys or legal firms.
Accounting Services: Payments for bookkeeping, auditing, or tax-related services provided by an accountant or accounting firm.
Consulting Services: Fees paid for consulting services, including strategic advice or specialized expertise from external firms.
Other Professional Services: Any professional services not covered by legal, accounting, or consulting services.
.Insurance:
Liability Insurance: Payments for business insurance protecting against legal liability claims, excluding property insurance.
Property Insurance: Payments for insurance covering physical damage to business property, whether owned or leased.
Workers' Compensation: Costs for insurance that covers employees for work-related injuries or illnesses.
Other Insurance: Any other insurance-related expenses not covered by liability, property, or workers' compensation insurance.
.Banking :
Transaction Fees: Fees for banking transactions, such as wire transfers, check processing, or other payments.
Service Charge : Monthly or periodic fees charged by banks for maintaining business bank accounts.
Credit Card Processing Fees: Charges incurred for processing credit card transactions through payment processors.
ATM or Branch, Deposits & Withdrawals: Transactions related to using ATMs, making deposits, or withdrawals at bank branches.
Credit Card Deposit or Merchant Deposit: Deposit made into the business's bank account from a merchant service or payment processor, such as from credit card sales or online payment platforms.
Credit Card Payment: Payments made to settle outstanding credit card balances.
Transfer: Transactions or payments related to transferring funds between accounts.
Cheque: Transactions for issuing or processing checks through a business bank account.
Account Balance : Transactions or charges that reflect adjustments to account balances, such as opening, closing, or forwarding balances of bank accounts.
Uncategorized Purchase: Other purchases without a specified merchant
Other Banking transactions: Any other bank-related transactions not covered by the previous subcategories.
.Taxes:
Property Taxes: Taxes paid on business properties, whether owned or leased.
Payroll Taxes: Employer-paid taxes based on employee payroll, such as social security, unemployment, or medicare taxes.
Income Taxes: Taxes paid on the income generated by the business, including federal, state, and local taxes.
Other Taxes: Other tax-related payments, such as sales tax, VAT, or excise taxes, not covered by property or income taxes.
.Repairs & Maintenance:
Facility Repairs: Costs for repairing business premises, such as plumbing, electrical, or structural repairs.
Facility Maintenance: Payments for routine upkeep and preventive maintenance of business premises, such as cleaning and landscaping.
Equipment Servicing: Payments for repairs or regular maintenance of business equipment or machinery to ensure proper functioning.
Other Repairs & Maintenance: Any other repair or maintenance-related costs not covered under facility or equipment maintenance.
.Software & IT Services:
Hardware & infrastructure Costs: Payments for purchasing, or maintaining physical IT equipment, such as computers, servers, networking devices, or peripherals.
Software Costs: Payments for purchasing, licensing, or subscribing to software applications used in business operations, including SaaS subscriptions.
Other Software & IT Services: Payments for IT-related services not specified above, such as cloud storage, cybersecurity, IT consulting, or web hosting fees.
.Shipping & Postage:
Courier & Postal Services: Costs for shipping or mailing packages via couriers (e.g., FedEx, UPS) or postal services (e.g., USPS, Canada Post).
Freight Charges: Payments for shipping bulk or heavy goods, typically via freight services.
Other Shipping & Postage: Any other shipping or postage costs not covered under courier or freight services.
.Retail & Procurement:
Home Improvement & Building Supplies: Purchases related to materials for building, maintenance, or improvement of business properties.
Furniture & Fixtures: Payments for office furniture, fixtures, and decor for business purposes.
Apparel & Clothing: Purchases of employee uniforms or business-related clothing items.
Specialty Retail: Expenses for purchasing niche or unique goods, such as gifts or specialty items for business purposes.
Grocery & Convenience Store: Purchases from grocery or convenience stores for small, everyday items, such as snacks or beverages.
Equipment : Purchases of equipment used in day-to-day business operations.
Health & Beauty: Expenses related to personal care or wellness items purchased for business purposes, such as for employee wellness programs.
Online Retail: Business-related purchases made through online retail platforms, such as Amazon or eBay.
Department Store: Purchases made from department stores such as Costco, Walmart & Hudson's Bay .
Office Supplies: Purchases of general office supplies, such as paper, pens, and stationery.
Other Retail & Procurement: Any other retail or procurement-related expenses not covered under the listed categories.
.Uncategorized:
Uncategorized: Expenses that do not clearly fit into any of the above categories and require further review for classification.
Payment Type:
.Direct Deposit
.Direct Debit or Pre-Authorized Payment
.Online Bill Payment
.Wire Transfer
.Credit Card
.Debit Card
.Prepaid Card
.Electronic Funds Transfer (EFT)
.E-transfer or Interac
.Money Order
.Bank Draft
.ATM
.Cash
.Digital & Mobile Payments
.Cryptocurrency (Bitcoin, Ethereum, etc.)
.Credit Memo
.Cheque
.Other
Please categorize the following banking transactions that are present in a CSV format:
Description,Type,Amount
{{ transaction001 }}
{{ transaction002 }}
{{ transaction003 }}
Only reply with the categorized output.