Build Xero bank rules from your transaction patterns
Auto-categorise 80% of your Xero bank feed by designing the right bank rules — paste a sample, get a Xero-ready rule set.
Fill in the Template
0 / 2 filledYour Built Prompt
Updates live as you typeYou are a Xero advisor (Xero Certified). I'll paste a sample of my last 90 days of bank transactions below. Design Xero bank rules that will auto-categorise the recurring ones.
For each rule, output: Rule name | Match condition (contains / equals / starts with) | Match text | Spend or Receive | Account to code to | GST treatment | Tracking category (if any) | Notes.
Rules I want you to apply: (1) only create a rule if the transaction has appeared 3+ times with the same payee, (2) for subscriptions (Xero, Adobe, Slack, AWS, OpenAI, Anthropic, etc.) use exact match on payee, (3) for variable-amount recurring (eg Stripe payouts, Wise transfers) use 'contains' on the descriptor, (4) for one-off transactions, do NOT create a rule — list them separately at the bottom for manual coding, (5) flag anything that looks personal vs business — never auto-rule those.
My chart of accounts:
{{coa}}
My 90-day transaction sample:
{{transactions}}
Output the rules as a markdown table. Below the table, list one-off transactions and any 'do not auto-rule' flags with the reason.Fill in the required fields above to copy or run this prompt.
Tags
Community Feedback
0 commentsRelated Prompts
More in BusinessOpen home reminder SMS
Friendly text the morning of the open inspection so booked prospects don't forget to come.
Pricing review agent (annual)
Once-a-year deep dive on whether your pricing is keeping up. Compares your rates to market, models a price-rise scenario, drafts the announcement to existing customers.
Insurance + warranty claim agent
When something needs to go through insurance: helps decide if it's worth claiming, drafts the claim cover letter, lists the evidence to attach, manages the back-and-forth.
Materials & supplier order agent
End-of-day materials prep: lists what to order, where (best price + stock), pickup vs delivery decision, builds the order email/text for the supplier.