Author- Sonia Dhillon, CPA, MBA

Do you spend hours manually coding recurring transactions? Xero bank rules are the most powerful feature for saving time, boosting data accuracy, and achieving real-time bookkeeping. By creating rules, you tell Xero how to automatically categorize and code transactions from your bank feed that meet specific criteria. This is essential for clean tax preparation and financial analysis.

Create a spend money, receive money, or transfer money bank rule to reconcile regular bank transactions.

Here’s how DhillonMarty CPA Advisory recommends setting up and leveraging bank rules for maximum efficiency.

---

How to Set Up Xero Bank Rules

The bank rules can be set-up during bank reconciliation or cash-coding, or it can be set-up in the drop down menu for bank rules in the Accounting tab. 

A bank rule consists of two main parts: the conditions (what Xero looks for) and the actions (what Xero does).

During bank reconciliation

1. For the relevant bank statement line, click Options, then select Create bank rule.
2. Enter the conditions the bank statement line must meet, then complete the remaining fields to tell Xero what to do with a transaction that meets those conditions.
3. Click Save.
4. To apply the rule, next to the statement line on the bank reconciliation screen, click OK.

From the bank rules screen

1. In the Accounting menu, select Bank rules.
2. Click Create rule, then select the type of rule you want to create.
3. Enter the conditions the bank statement line must meet, then complete the remaining fields to tell Xero what to do with a transaction that meets those conditions. 
4. Click Save.

While cash coding

1. Click the arrow next to any relevant bank statement line, then select Create bank rule.
2. Enter the conditions the bank statement line must meet, then complete the remaining fields to tell Xero what to do with a transaction that meets those conditions.
3. Click Save. Xero will update the relevant fields for all statement lines that match the conditions of the new rule.

Define the Rule Conditions (The “How”)

This tells Xero exactly which transactions to match. Focus on unique identifiers in the bank description.

• Rule Type: Select if the rule is for Spending Money (payments out) or Receiving Money (deposits in).
• Conditions: Define the criteria that all or any must be met.
  • Common Expense Example: For your internet bill, use the condition: Description contains “VERIZON WIRELESS”.
  • Common Income Example: For a payment processor deposit, use: Payee contains “STRIPE PAYOUT”.

Define the Actions (The “What”)

Specify what Xero should automatically populate in the transaction details:

• Account: Select the correct Chart of Accounts code. Example: Code the Verizon bill to 420 – Utilities: Telephone/Internet.
• Tax Rate: Select the appropriate one from the drop down menu.
• Tracking Categories: Assign the correct Tracking Option to enable segmented reporting (e.g., Location: Home Office).
• Allocation (The Split Rule): This is vital for payment processor deposits where fees are deducted:
  • Rule for Receiving Money (Deposit):
    1. Allocate the fee amount/percentage to 615 – Merchant Fees.
    2. Allocate the gross sales amount to 400 – Sales Revenue. This ensures both gross income and expense are recorded correctly.

Finalize and Prioritize

1. Rule Name: Use a clear, descriptive name (e.g., “Monthly Verizon Internet” or “Stripe Deposit Split”).
2. Rule Code: Bank rule conditions and titles can only contain letters and numbers. They can’t include punctuation or special characters.
3. Rule Details: Rule will be applied to which accounts, such as all bank accounts. 
4. Rule Order: Bank rules are applied in order. Ensure highly specific rules (like those for splitting Stripe deposits) are placed higher than general rules.

---

Why Use Xero Bank Rules?

Setting up bank rules is not just a feature; it’s a fundamental shift in efficiency that directly impacts your ability to manage your business’s finances.

1. Massive Time Savings on Data Entry

The primary benefit is speed. By instantly coding dozens of recurring transactions (e.g., Aflac insurance, ADP payroll), bank rules allow you to reconcile 80-90% of your transactions with a single click, eliminating hours of manual, repetitive work every month.

2. Ensure Consistent Tax Readiness

Rules ensure that deductible business expenses are always coded consistently. This is vital for preparing your tax returns (Schedule C, Form 1120, etc.), as the consistent classification of expenses like Office Supplies and Utilities reduces errors and streamlines the process for your tax preparer.

3. Power Granular, Segmented Reporting

When you integrate Tracking Categories (e.g., Project ID) into your bank rules, minor expenses are automatically allocated. This is essential for generating accurate segmented P&L reports required for internal analysis of project profitability.

4. Accurate Income and Expense Recording (The Split Rule)

The ability to automatically split deposits (like those from Square or Stripe) into Gross Revenue and Merchant Fees ensures your revenue is reported accurately, rather than just the net deposit amount. This prevents the understatement of your true sales figures.

---

Partner with DhillonMarty CPA Advisory

We can help you audit your bank feed and create a master set of Xero bank rules tailored to your business operations, ensuring every transaction is coded for maximum efficiency and financial clarity.

We advise clients to prioritize creating rules for such common transactions:

• Fixed Monthly Expenses: Rent, utilities (Con Edison, PG&E), software subscriptions (Adobe, Microsoft 365).
• Credit Card Interest/Fees: Ensure they are consistently coded to the Interest Expense or Bank Fees accounts.
• Payroll Transfers: Rules for transfers to Gusto or Paychex should be coded to a Wages Payable/Clearing Account for later journal entry.

Are you ready to optimize your Xero reconciliation and save valuable time?

Contact Us!