Claude Prompts for Accountants

You are a senior accountant standardizing the month-end close for a small CPA firm. <context> Your firm closes books for 14 small business clients each month. You want a repeatable close checklist you can copy for each client with owner initials and due dates. </context> <inputs> - Firm: Alder & Pine CPAs - Close deadline: 10th business day - Standard steps: bank reconciliations, credit card reconciliations, AR aging review, AP aging review, payroll reconciliation, fixed asset roll forward, accrual review, trial balance review, financial statement generation, client delivery - Staff: Priya (reconciliations), Marcus (review), Dana (client delivery) </inputs> <task> Build a month-end close checklist with each step, the assigned owner, a target day within the 10-business-day window, and a checkbox column. Order the steps in the sequence they actually need to happen (reconciliations before review, review before delivery). </task> <constraints> - Keep to the 10 business day window, spread steps realistically rather than stacking everything on day 10 - Use only the staff named, don't invent additional roles - Include a checkbox or status column for tracking </constraints> <format> A markdown table with columns: Day, Step, Owner, Status. </format>

You are a staff accountant explaining a bank reconciliation discrepancy to a client. <context> Meridian Landscaping LLC's June bank statement balance doesn't match the general ledger cash balance. You've identified the reconciling items and need to write the memo explaining the difference. </context> <inputs> - Bank statement balance (6/30): $58,420 - GL cash balance (6/30): $61,150 - Reconciling items: two outstanding checks totaling $2,180 (check #1042 for $1,400, check #1045 for $780), one deposit in transit of $4,900, a bank fee of $50 not yet recorded in the GL </inputs> <task> Work through the reconciliation math to prove the bank balance ties to the GL balance, then write a short memo listing each reconciling item and the one adjusting entry needed (the $50 bank fee). </task> <constraints> - Show the reconciliation math explicitly (bank balance, plus deposits in transit, minus outstanding checks, should equal adjusted bank balance; GL balance minus unrecorded fee should equal the same number) - The two balances must tie out exactly using only the items given - State the one journal entry needed in debit/credit form </constraints> <format> A short memo with a reconciliation table (bank side and book side shown separately) and one journal entry at the bottom. </format>

You are an accountant reconciling a client's business credit card for the month. <context> Blue Anchor Marine Supply's business credit card statement needs to be matched against the GL credit card account for May 2026, with any unmatched items flagged. </context> <inputs> - Statement total charges: $14,280 across 22 transactions - GL recorded charges: $13,650 across 20 transactions - Known gap: two transactions posted to the statement on May 31 ($340 fuel, $290 supplies) that haven't hit the GL yet because of the bank feed delay - One duplicate suspected: a $210 Office Depot charge appears to be entered twice in the GL </inputs> <task> Build a worksheet reconciling the $630 gap between statement and GL: show the two late-posting items as timing differences and flag the suspected $210 duplicate as an item to verify with the source receipt before removing. </task> <constraints> - Show the math: statement total minus GL total should equal the sum of the flagged items - Do not assume the duplicate is confirmed, mark it as "needs verification" not as a correction already made - Keep the worksheet to one table plus a short notes section </constraints> <format> A markdown table (Item, Amount, Status) plus a 2 to 3 line notes section on next steps. </format>

You are an accountant reconciling intercompany balances between two related entities. <context> Alden Property Management LLC and Alden Retail Co need their intercompany receivable and payable balances reconciled at quarter end before consolidation. </context> <inputs> - Alden Property Management LLC books: Due from Alden Retail Co = $91,000 - Alden Retail Co books: Due to Alden Property Management LLC = $84,000 - Known difference driver: a $7,000 management fee invoiced by Alden Property Management LLC on the last day of the quarter that Alden Retail Co hasn't recorded yet </inputs> <task> Build a two-sided reconciliation showing each entity's recorded balance, the identified timing difference, and the adjusted balance after both entities record the same $7,000 fee, confirming the two sides tie out afterward. </task> <constraints> - Balances must tie to the same adjusted number on both sides after the fix - State the specific entry Alden Retail Co needs to book to close the gap - Do not introduce any other adjustment beyond the one identified driver </constraints> <format> A two-column reconciliation table (Alden Property Management LLC vs Alden Retail Co) with a closing "tie-out confirmed" line. </format>

You are a reviewing accountant checking a staff-prepared trial balance before financials go out. <context> A junior staff member closed Harbor & Vine Bistro's June trial balance. You're doing the review pass and found a few accounts that look off. </context> <inputs> - Prepaid insurance: $18,000 balance, unchanged for 4 months in a row (should be amortizing $1,500 per month) - Office supplies expense: $6,200 for the month vs a normal run rate of $800 to $1,200 - Accumulated depreciation: didn't move this month despite $2,300 per month depreciation normally posted - Owner draws: $12,000, consistent with prior months, no issue </inputs> <task> Write a review memo listing each flagged account, why it looks wrong, and the specific adjusting journal entry to propose (amounts and accounts) for the prepaid insurance and depreciation issues. Note the office supplies spike as a question for the client rather than an automatic adjustment. </task> <constraints> - Only propose entries for items you have enough information to calculate (prepaid insurance and depreciation), not the supplies spike - State proposed entries in debit/credit format - Keep owner draws out of the flagged list since it's confirmed normal </constraints> <format> A memo with a "Flagged accounts" table (Account, Issue, Action) followed by the proposed journal entries listed below it. </format>

You are an accountant preparing a personalized tax document request for a business client. <context> Crestline Dental Group (S-corp, two shareholder-employees) needs a tax document checklist ahead of their 2025 return, tailored to an S-corp with payroll and equipment purchases. </context> <inputs> - Entity type: S-corp - Shareholders: 2 (both on payroll) - Known 2025 activity: $34,200 in equipment purchases, one company vehicle used partly for business, health insurance premiums paid for shareholder-employees - Prior year issue: client was late providing W-2s and 1099s last year </inputs> <task> Build a document checklist grouped by category (payroll and W-2s, shareholder health insurance, fixed assets, vehicle use, general ledger and financials, prior year return) with a one-line note on why each item is needed. Add a due date reminder given last year's late W-2 issue. </task> <constraints> - Group items by category, don't list them as one flat list - Keep the "why needed" notes to one line each, plain language - Include a specific callout referencing last year's late W-2 delay </constraints> <format> A checklist document organized under category headings, each item as a checkbox line with its one-line note. </format>

You are an accountant helping a client plan quarterly estimated tax payments. <context> Meridian Landscaping LLC's owner, taxed as a sole proprietor, wants to know what to set aside for 2026 quarterly estimated payments based on projected income. </context> <inputs> - Projected 2026 net self-employment income: $148,000 - 2025 actual tax liability (safe harbor basis): $31,200 - Estimated 2026 effective tax rate (federal, self-employment, and state combined, per owner's last return): 29% - Payments made so far: Q1 already paid, $7,800 </inputs> <task> Build a worksheet showing the safe harbor method (110% of 2025 liability) alongside the projected income method (29% of $148,000), the resulting recommended quarterly payment under each method, and how much is left to pay in Q2 through Q4 after the Q1 payment already made. </task> <constraints> - Show both methods side by side so the client can see which is lower - Subtract the confirmed Q1 payment from the total before splitting the remaining quarters - Do not recommend one method as the "right" one, present both and note the client should confirm with their tax preparer </constraints> <format> A markdown table comparing the two methods, followed by a remaining-payments table for Q2 to Q4. </format>

You are an accountant tracking which vendors need a 1099 for the year. <context> Nova Ridge Construction paid a number of subcontractors and vendors in 2025. You need to identify which ones cross the $600 threshold and are 1099-eligible vendor types. </context> <inputs> - Vendor payments: Ridgeline Excavation LLC $42,000 (subcontractor, LLC), Summit Electric Inc $18,500 (subcontractor, corporation), Dana Ferris (individual handyman) $2,400, Office Supply Depot $3,100 (retailer, corporation), Torres Concrete Co $27,800 (subcontractor, LLC), Whitfield Law Group $5,200 (law firm, corporation) </inputs> <task> Build a tracking sheet listing each vendor, total paid, entity type, whether they cross $600, and a 1099-required flag, applying the general rule that corporations are typically exempt except attorneys, and non-corporate service providers over $600 need a 1099. </task> <constraints> - Apply the corporation exemption correctly, but flag the law firm as requiring a 1099 despite being incorporated, since legal services are an exception - Mark the retailer as not requiring a 1099 since it's for goods, not services - Note this is a tracking aid, final determination should be confirmed by the client's tax preparer </constraints> <format> A markdown table: Vendor, Entity Type, Total Paid, 1099 Required (Yes/No), Note. </format>

You are an accountant tracking a growing client's multistate sales tax exposure. <context> Harbor & Vine Bistro's parent company just started shipping branded merchandise online and has crossed meaningful revenue in a few states. You need a summary of which states are worth watching for economic nexus. </context> <inputs> - State revenue for the trailing 12 months: California $210,000, Texas $61,000, Nevada $38,000, Oregon $4,200, Washington $52,000 - Common economic nexus threshold used for screening: $100,000 in sales or 200 transactions (actual thresholds vary by state and change over time) </inputs> <task> Build a summary table flagging which states are above, near (within 25%), or well below the $100,000 screening threshold based on the revenue given, and a short note that Oregon has no general state sales tax so it can be excluded from monitoring. </task> <constraints> - Clearly label this as a screening tool based on a general threshold, not a confirmed nexus determination - Note that actual state thresholds and rules should be verified before filing decisions - Exclude Oregon from the "needs monitoring" list with the reason stated </constraints> <format> A markdown table (State, 12mo Revenue, Status: Above, Near, or Below threshold, Note) with a closing disclaimer line. </format>

You are an accountant building a fixed asset depreciation schedule for a client. <context> Nova Ridge Construction purchased several pieces of equipment in 2025 and needs a straight-line depreciation schedule for its internal books. </context> <inputs> - Excavator: $86,000, placed in service March 2025, 7-year useful life, no salvage value - Pickup truck: $42,000, placed in service June 2025, 5-year useful life, $4,000 salvage value - Office trailer: $18,000, placed in service January 2025, 10-year useful life, no salvage value </inputs> <task> Build a straight-line depreciation schedule for each asset showing annual depreciation expense, using a partial first year based on the in-service month (partial year for the excavator and truck, full year for the trailer since it's January), and show year 1 (2025) depreciation for each plus the annual run-rate from year 2 onward. </task> <constraints> - Show the math for the partial first year explicitly (months in service divided by 12, times annual depreciation) - Subtract salvage value from cost before dividing by useful life for the truck - These are for internal books only, not a tax depreciation method (no MACRS or Section 179 applied) </constraints> <format> A markdown table: Asset, Cost, Salvage, Useful Life, Annual Depreciation, 2025 Depreciation (partial year), 2026 Depreciation (full year). </format>

You are an advisory accountant building a cash flow forecast for a client managing tight liquidity. <context> Blue Anchor Marine Supply's owner is worried about cash through the slow season and asked for a 13-week rolling forecast starting from the current cash position. </context> <inputs> - Starting cash: $64,000 - Weekly recurring inflows: $38,000 average from sales, dropping to $22,000 average for weeks 6 to 10 (seasonal slowdown) - Weekly recurring outflows: payroll $18,000 (biweekly, weeks 1, 3, 5, 7, 9, 11, 13), rent $4,200 (monthly, weeks 1, 5, 9, 13), inventory purchases $12,000 average, other opex $6,000 average - One known large outflow: $28,000 boat lift equipment payment due in week 8 </inputs> <task> Build a 13-week cash flow forecast showing weekly inflows, outflows, net change, and ending cash balance, correctly timing the biweekly payroll and monthly rent, applying the seasonal sales drop in weeks 6 to 10, and including the week 8 equipment payment. Flag any week where ending cash drops below $20,000. </task> <constraints> - Payroll only hits the weeks specified, not every week - Rent only hits the weeks specified, not every week - Apply the seasonal sales figure only to weeks 6 through 10, use the normal average for all other weeks - Flag low-cash weeks clearly, don't bury the warning in the table alone </constraints> <format> A markdown table with 13 rows (Week, Inflows, Outflows, Net Change, Ending Cash) followed by a short "Weeks to watch" callout listing any week under $20,000. </format>

You are an advisory accountant preparing a KPI review for a client meeting. <context> Meridian Landscaping LLC's owner wants a simple KPI dashboard with a short narrative for their quarterly check-in call. </context> <inputs> - Gross margin: 42% (target 45%, prior quarter 39%) - Days sales outstanding (DSO): 38 days (target 30, prior quarter 44) - Revenue per crew: $61,500 per quarter (target $65,000, prior quarter $58,000) - Customer count: 86 active (prior quarter 79) </inputs> <task> Build a self-contained HTML page with four KPI cards (metric, current value, target, trend arrow vs prior quarter) across the top, and a short narrative below explaining that DSO improved meaningfully but is still above target, and gross margin is trending toward target. </task> <constraints> - Use an up or down arrow (or clear plus or minus label) matching whether each metric moved favorably or unfavorably, not just direction of the number - Keep the narrative to 3 short paragraphs - Inline CSS only, no external assets </constraints> <format> A complete self-contained HTML document with KPI cards in a row and a narrative section below, suitable as a live artifact. </format>

You are an advisory accountant comparing a client's performance to industry benchmarks. <context> Harbor & Vine Bistro's owner wants to know how their numbers stack up against typical full-service restaurants. </context> <inputs> - Client gross margin: 60%, industry typical range: 65 to 70% - Client labor cost as percent of revenue: 34%, industry typical range: 28 to 32% - Client food cost as percent of revenue: 31%, industry typical range: 28 to 32% - Client net margin: 16.7%, industry typical range: 3 to 9% (unusually strong) </inputs> <task> Build a benchmarking table comparing each metric to the industry range and flagging whether the client is inside, above, or below the typical range. Write two sentences on the labor cost gap being the clearest area to investigate, and one sentence noting the strong net margin is worth understanding since it's well above typical (could mean real strength or a bookkeeping timing issue worth double-checking). </task> <constraints> - Use only the ranges given, don't cite external benchmark sources you can't verify - Treat the unusually strong net margin as something to verify, not just celebrate - Keep commentary to 3 sentences total </constraints> <format> A markdown table (Metric, Client, Industry Range, Status) followed by a short commentary paragraph. </format>

You are an advisory accountant analyzing which parts of a client's business actually make money. <context> Meridian Landscaping LLC runs three service lines and the owner wants to know which one to grow. </context> <inputs> - Lawn maintenance: revenue $612,000, direct costs $398,000 - Landscape design and install: revenue $340,000, direct costs $265,000 - Snow removal: revenue $148,000, direct costs $96,000 - Allocated overhead (rent, admin, insurance): $180,000 total, allocate proportionally to revenue </inputs> <task> Build a profitability table by service line showing direct margin, allocated overhead (proportional to each line's share of total revenue), and fully-loaded net margin per line. Recommend which line has the best fully-loaded margin and which has the weakest, based only on the numbers given. </task> <constraints> - Allocate the $180,000 overhead proportionally by each line's share of the $1,100,000 total revenue, show the allocation percentage used - Calculate fully-loaded margin as revenue minus direct costs minus allocated overhead, divided by revenue - State the recommendation in one sentence, don't pad it with caveats </constraints> <format> A markdown table: Service Line, Revenue, Direct Costs, Direct Margin %, Allocated Overhead, Net Margin %, followed by a one-line recommendation. </format>

You are an advisory accountant flagging a specific budget variance worth a client conversation. <context> Nova Ridge Construction's marketing line ran well over budget this quarter and you need to raise it with the owner constructively. </context> <inputs> - Marketing budget: $18,000 per quarter, actual: $41,500 - Driver: owner approved a $28,000 trade show sponsorship mid-quarter that wasn't in the original budget - Resulting new leads tracked from the trade show: 34, of which 6 have converted to signed contracts worth $612,000 combined </inputs> <task> Write a short advisory memo that presents the variance factually, connects it to the specific decision that caused it, and reframes the conversation around return on the spend (34 leads, 6 signed contracts worth $612,000) rather than just the overage. End with one question for the owner about whether to budget for another trade show next quarter. </task> <constraints> - Don't scold or imply the overspend was a mistake, the ROI data suggests it worked - State the variance number plainly before pivoting to ROI - Keep it to one page </constraints> <format> A short memo: variance stated up front, ROI context in the middle, one closing question. </format>

You are a CPA drafting an engagement letter for a new accounting client. <context> Your firm just won Fairview Plaza Property Group as a new monthly bookkeeping and quarterly tax planning client and needs an engagement letter defining scope and fees. </context> <inputs> - Firm: Alder & Pine CPAs - Client: Fairview Plaza Property Group - Scope: monthly bookkeeping, quarterly financial statements, quarterly tax planning check-in, annual tax return preparation - Fee: $1,450 per month for bookkeeping and quarterly statements, $2,800 flat for the annual return, tax planning check-ins billed hourly at $220 per hour - Start date: September 1, 2026 - Out of scope: audit representation, payroll processing (client uses a separate payroll provider) </inputs> <task> Draft an engagement letter covering scope of services, explicit out-of-scope items, fee structure, start date, and standard responsibilities of both parties (client provides timely documents, firm delivers on agreed timelines). Include a signature block for both parties. </task> <constraints> - List out-of-scope items explicitly so there's no ambiguity later - State fees exactly as given, don't round or restructure them - Keep the tone professional but not overly legalistic, this should be readable by a non-accountant </constraints> <format> A formatted letter document with numbered sections (Scope, Out of Scope, Fees, Term, Responsibilities, Signatures). </format>

You are a firm owner announcing a fee increase to existing clients. <context> Alder & Pine CPAs is raising monthly bookkeeping fees by 8% starting next quarter due to rising staff costs, and needs a client-facing email that doesn't sound apologetic or defensive. </context> <inputs> - Current fee example: Meridian Landscaping LLC pays $650 per month, increasing to $702 per month - Effective date: October 1, 2026 - Reason to mention briefly: rising team costs and expanded service quality (faster turnaround added this year) - Tone goal: confident, brief, no over-explaining </inputs> <task> Write a short email announcing the fee increase for this specific client, stating the new amount and effective date clearly in the first two sentences, giving one brief reason, and closing with an offer to discuss if they have questions. </task> <constraints> - State the new dollar amount and effective date in the first two sentences, don't bury it - Keep the reason to one sentence, don't over-justify - No apologetic language (avoid phrases like "we're sorry to inform you") </constraints> <format> A short email with subject line, 3 short paragraphs, and a sign-off. </format>

You are an accounting firm's billing coordinator following up on an overdue client invoice. <context> Crestline Dental Group has an invoice 35 days past due and hasn't responded to the first reminder. You need a 3-email sequence escalating from friendly to firm. </context> <inputs> - Invoice: #2214, $2,800, due date June 15, 2026, today's date July 20, 2026 - Prior contact: one automated reminder sent on day 15, no response - Relationship: 3-year client, generally reliable, this appears to be an oversight rather than a dispute </inputs> <task> Write 3 emails: Email 1 (day 20 overdue, friendly check-in assuming it's an oversight), Email 2 (day 30 overdue, firmer, references the invoice number and amount directly), Email 3 (day 45 overdue, states that services may pause if not resolved by a specific date). Space the escalation in tone clearly across the three. </task> <constraints> - Each email must reference the exact invoice number and amount - Escalate tone gradually, email 1 should not sound like a warning - Email 3 must state a specific consequence and date, not a vague threat </constraints> <format> Three labeled emails (Email 1, Email 2, Email 3), each with subject line and body. </format>

You are an accountant requesting outstanding documents from a client ahead of close. <context> Blue Anchor Marine Supply hasn't sent a few items needed to close June, and close is due in 3 days. </context> <inputs> - Missing items: May credit card statement (last one on file is April), receipts for two purchases over $500 (a $1,200 forklift part and a $780 software renewal), confirmation of the new part-time employee's start date for payroll setup - Deadline: need everything by end of day Thursday to hit the close deadline </inputs> <task> Write an email listing exactly what's needed, why each item matters (briefly), and the deadline stated once clearly, not repeated nervously throughout. </task> <constraints> - List items as a checklist, not a paragraph - State the deadline once, in the opening or closing line, not both - Keep the "why" notes to a few words each, not full sentences </constraints> <format> A short email with a checklist of the 3 missing items and one clear deadline line. </format>

You are an accountant sending a recap after an advisory meeting with a client. <context> You just finished a quarterly check-in call with Nova Ridge Construction's owner and need to send a recap with clear action items and owners. </context> <inputs> - Discussed: Q2 variance report, decision to budget for one more trade show next quarter ($25,000 approved), decision to hire a part-time estimator starting September, open question on whether to lease or buy a new excavator (owner will decide by August 15) - Action items: firm to update Q3 budget with the trade show and estimator hire, owner to send lease vs buy decision by August 15, firm to run a lease vs buy cash flow comparison once the decision direction is known </inputs> <task> Write a recap email summarizing the three decisions made and listing action items in a table with owner and due date for each. </task> <constraints> - Separate "decisions made" from "action items", don't blend them into one list - Every action item must have a named owner (firm or client) and a date - Keep the decisions summary to one line each </constraints> <format> An email with a "Decisions" bulleted list and an "Action Items" table (Item, Owner, Due Date). </format>

You are a firm operations lead writing the standard onboarding procedure for new accounting clients. <context> Alder & Pine CPAs onboards a new client every few weeks and wants a repeatable SOP so nothing gets missed between signing the engagement letter and the first close. </context> <inputs> - Steps currently done inconsistently: collect prior year financials, set up accounting software access, request bank feed connections, collect W-9 and entity documents, schedule kickoff call, set up client in practice management system, assign staff - Staff roles: onboarding coordinator (Dana), assigned staff accountant (varies by client) - Target: fully onboarded within 10 business days of signed engagement letter </inputs> <task> Build a step-by-step SOP with each step, responsible role, and target day within the 10-day window, ordered so dependent steps happen in the right sequence (software access before bank feed connections, for example). </task> <constraints> - Order steps by actual dependency, not just alphabetically or randomly - Assign every step to a role (Dana or "assigned staff accountant"), none left unowned - Fit within the 10 business day target </constraints> <format> A numbered SOP document with columns or fields for Step, Owner, Target Day. </format>

You are a firm manager planning staff capacity through busy season. <context> Alder & Pine CPAs has 3 staff accountants covering both monthly close work and looming tax season, and you need to see who's overloaded before it becomes a problem. </context> <inputs> - Priya: 14 monthly close clients (avg 4 hours each, 56 hours per month), plus assigned to prep 6 tax returns in March (est. 8 hours each, 48 hours) - Marcus: 10 monthly close clients (avg 5 hours each, 50 hours per month), plus 9 tax returns in March (est. 8 hours each, 72 hours) - Dana: 8 monthly close clients (avg 4 hours, 32 hours per month), plus client delivery and admin work est. 25 hours per month - Standard capacity: 160 hours per month per person </inputs> <task> Build a capacity table for March specifically (close work plus tax return hours) showing total hours committed vs the 160-hour capacity for each person, and flag whoever is over capacity. </task> <constraints> - Add close hours and March-specific tax hours together for the March total, don't just show monthly close hours alone - Flag anyone over 160 hours clearly, and by how much - Don't reassign work yourself, just surface the numbers for the manager to decide </constraints> <format> A markdown table: Staff, Close Hours, Tax Hours, Total March Hours, Capacity, Over/Under. </format>

You are an accountant formalizing added scope for an existing client. <context> Harbor & Vine Bistro asked for monthly cash flow forecasting to be added to their existing bookkeeping engagement, and it needs to be documented as a change to the original agreement rather than done informally for free. </context> <inputs> - Original engagement: monthly bookkeeping and quarterly statements, $950 per month - Added scope: monthly 13-week cash flow forecast update - Additional fee: $250 per month - Effective date: next billing cycle, August 1, 2026 </inputs> <task> Draft a short change order referencing the original engagement, describing the added scope precisely, stating the new combined monthly fee, and requiring a signature to confirm acceptance. </task> <constraints> - State both the added fee and the new total combined fee ($1,200), not just the delta - Reference the original engagement so the change order reads as an amendment, not a new contract - Keep it to half a page </constraints> <format> A short change order document with sections: Reference to Original Engagement, Added Scope, Fee Change, Effective Date, Signature line. </format>

You are a firm operations lead auditing which tools the firm actually pays for and uses. <context> Alder & Pine CPAs has accumulated software subscriptions over several years and wants an audit checklist to review before the annual renewal cycle. </context> <inputs> - Current tools: QuickBooks Online Accountant, a practice management system, a document portal, a separate e-signature tool, a tax prep software, a time tracking app, a second document storage tool that overlaps with the portal - Known issue: the second document storage tool was added by a former staff member and its ongoing use is unclear </inputs> <task> Build an audit checklist with each tool, its stated purpose, an "in active use" yes, no, or unclear column, and a recommended action (keep, investigate, cancel) with the overlapping document storage tool flagged for investigation given the known issue. </task> <constraints> - Flag the overlapping tool as "investigate", not an automatic "cancel", since usage is unclear - Every tool needs a stated purpose, even a one-line guess if the purpose isn't given - Keep recommendations to the three categories given (keep, investigate, cancel) </constraints> <format> A markdown table: Tool, Purpose, In Active Use, Recommended Action. </format>

You are a firm owner reviewing which clients are actually profitable to serve. <context> Alder & Pine CPAs wants an annual review ranking clients by realized profitability to spot underpriced engagements before renewal conversations. </context> <inputs> - Client A (Meridian Landscaping): billed $7,800 per year, estimated hours spent 42, target realization $150 per hour - Client B (Harbor & Vine Bistro): billed $11,400 per year, estimated hours spent 58, target realization $150 per hour - Client C (Blue Anchor Marine Supply): billed $6,200 per year, estimated hours spent 61, target realization $150 per hour - Client D (Crestline Dental Group): billed $14,800 per year, estimated hours spent 74, target realization $150 per hour </inputs> <task> Build a table calculating effective realized rate (billed divided by hours) for each client, compare to the $150 per hour target, and rank clients from most to least profitable. Flag any client realizing below $120 per hour as a renewal conversation candidate. </task> <constraints> - Calculate realized rate precisely from the numbers given, don't estimate - Rank clients in the table itself, don't just list them in input order - Flag only clients below $120 per hour, not everyone below the $150 target </constraints> <format> A markdown table ranked by realized rate: Client, Billed, Hours, Realized Rate, Flag, followed by a one-line summary of which client(s) need a renewal conversation. </format>