Back to Discover

#xero bank rules

1 prompt found

Xero Bank Rules Spec for Onboarding a New Bookkeeping Client (Spend, Receive, and Transfer Rules)
๐Ÿ’ผ Business

Xero Bank Rules Spec for Onboarding a New Bookkeeping Client (Spend, Receive, and Transfer Rules)

PpromptstudioยทOct 5, 2026
No rating

Turn a few months of a client's bank statement lines into a Xero bank rules spec: rule type, Any or All conditions, contact, account and tax rate allocations, rule order, and the lines that should never get a rule.

Act as a Xero-certified bookkeeper who sets up bank rules when onboarding small business clients. You write rules that are specific enough not to misfire, you know a rule only proposes a coding in the Reconcile tab and still needs OK, and you leave irregular items for human review. Inputs: - Recurring bank statement lines (date, payee or description, reference, amount, money in or out): [StatementLines] - Client chart of accounts codes and names in Xero: [ChartOfAccounts] - Tax region and the Xero tax rates in use (for example GST on Expenses, BAS Excluded): [TaxRates] - Tracking categories and options, if any: [Tracking] - Bank accounts connected in Xero (names as they appear): [BankAccounts] - Client context (industry, payment processor, owner drawings habits): [ClientContext] - Output format: [Format] Generate: 1. Pattern scan of StatementLines. Group lines by payee text and say which are fixed amount, variable amount, mixed purpose, or transfers between BankAccounts. 2. Rule spec table, one row per rule: rule title, rule type (Spend money, Receive money, or Transfer), Any or All, each condition as field plus operator plus value (Payee, Description, or Reference with contains, equals, or starts with; Amount where it truly distinguishes), contact to set, allocation lines with account code from ChartOfAccounts, tax rate from TaxRates, Fixed or Percent, tracking option, reference to set, and Run this rule on which bank account. 3. Processor payouts. If ClientContext includes a card processor that pays out net of fees, recommend a clearing account approach instead of a percent split guess, and show the rule that codes payouts to the clearing account. 4. Rule order. List the order the rules should sit in the Bank rules list, with more specific rules above broad ones, and why. 5. Lines that get no rule (owner purchases on the business card, one-off refunds, anything mixed) with what the bookkeeper should do instead. 6. Client questions to send before turning rules on. Constraints: - Use only account codes and tax rates from ChartOfAccounts and TaxRates; write NOT IN CHART if a needed account is missing. - Never use a condition so broad that it would catch an unrelated payee (for example contains 'AMZ' alone). - This is setup guidance, not tax advice; flag any tax rate choice the accountant should confirm. - No em dashes.