Finance & Admin Prompts

Expense Categorizer and Admin Summary

Organize a list of expenses into categories with a monthly summary and admin action items, without giving financial advice.

✱ By PiSkill TeamFreeClaudeChatGPTGeminiMicrosoft Copilot

Best for

Freelancers, small business owners, and individuals who want to organize a list of expenses into clear categories and a summary without receiving financial or tax advice.

Suitable LLM groups

FrontierReasoning

Prompt

You are acting as an administrative assistant who helps me organize and categorize expenses. You do not provide tax, accounting, legal, investment, or debt advice, and you must not invent amounts, categories, or tax rules that I have not provided. If an expense is unclear, mark it as needing manual review rather than guessing its category.

Here is my information:

List of expenses: {{input_text}}
Time period covered: {{context}}
Categories I typically use, if any: {{examples}}
Any recurring subscriptions I know about: {{constraints}}
What I want this summary for, such as budgeting or expense reports: {{goal}}

If the expense list is missing key details, such as dates or amounts, ask me clarifying questions before proceeding.

Please produce a structured response with the following sections:

1. Categorized expense table: Organize the expenses into a clear table with category, description, and amount, using only the information provided.
2. Unclear items: List any expenses that could not be confidently categorized and need manual review.
3. Monthly summary: Summarize total spending by category for the period covered.
4. Missing receipts: List any expenses that appear to be missing supporting documentation, if mentioned.
5. Subscription notes: List recurring subscriptions identified from the data and flag any that seem duplicated or unused.
6. Admin action items: Suggest simple administrative next steps, such as filing receipts or confirming unclear charges.

Do not provide tax advice, accounting guidance, investment recommendations, or debt management advice. Do not invent expense amounts, dates, or categories that were not in the data provided. For any tax or accounting questions, recommend consulting a qualified professional.

How to use

Paste your list of expenses with dates, descriptions, and amounts into the input_text placeholder.
Specify the time period and what you want the summary for.
Run the prompt in your preferred AI tool.
Answer clarifying questions if key expense details are missing.
Review unclear items and admin action items before finalizing your records.

Example input

Expenses: March 3 Adobe Creative Cloud 54.99, March 8 client lunch 32.50, March 12 office supplies 18.75, March 15 Adobe Creative Cloud 54.99, March 20 laptop stand 45.00. Period: March. Purpose: preparing a monthly expense report for my accountant.

Example output

Categorized expense table: software subscription Adobe Creative Cloud 54.99 on March 3, meals and entertainment client lunch 32.50 on March 8, office supplies 18.75 on March 12, software subscription Adobe Creative Cloud 54.99 on March 15, equipment laptop stand 45.00 on March 20.
Unclear items: none of the listed expenses are unclear based on the descriptions provided.
Monthly summary: software subscriptions total 109.98, meals and entertainment total 32.50, office supplies total 18.75, equipment total 45.00, for a combined total of 206.23 for March.
Missing receipts: no information was provided about receipt status, so this cannot be determined from the data given.
Subscription notes: Adobe Creative Cloud appears twice within the same month, which may indicate a duplicate charge and should be verified.
Admin action items: verify whether the two Adobe Creative Cloud charges are both legitimate or a billing duplicate, gather receipts for all listed expenses before sending the report to your accountant, confirm the purpose of the client lunch expense for your records.

Customization tips

— Provide your own preferred category names if you want the table to match an existing system.
— Ask for the summary broken down by week instead of by month if that fits your workflow better.
— Combine several months of data for a quarterly summary.
— Export the categorized table into a spreadsheet for further processing.

FAQ

No, it explicitly avoids tax, accounting, legal, and investment advice and recommends a qualified professional for those questions.

Rate this prompt

How helpful was this?

Comments

Sam O.

Used this to ship 6 SEO articles in a week — the FAQ block alone is worth it.

Ines P.

Wish it had a Spanish voice preset, but overall very solid.

Related skills coming soon — browse all skills.

Related articles coming soon — visit the Learn hub.