What is the purpose of custom rules?
Custom rules allow you to create automations within Puzzle by defining categories for recurring transactions. When you create a rule, the category selected will be automatically applied to all future transactions with designated description. (Although the categories are automatically applied, they will still show up for your review so that you can confirm them.)
Custom rules will apply categories to Transactions. For a deeper dive into the relationship between third-party integrations, Transactions, categories, and the General Ledger, refer to our deep dive on Rules and Categories.
How do I create a custom rule?
Option 1: Individual transaction
On the Transactions page, click a transaction to open its details. Click Create rule to define the rule you want to create.
You can name the rule something that allows you to identify the general mechanics.
You will also have the option to select whether you want to do this for a transaction description that "Contains" or "Equals" the phrase. They will often result in the same outcomes. Choosing "Contains" will result in more possible transactions being captured (i.e. the rule will be applied anything that has the phrase). This is useful for any third party that may apply different strings of numbers to the end of different transactions.
However, you will want to avoid using "Contains" for phrases that may cause ambiguity. For example, you may know that any transaction with the exact description "Subway" should be "Office Meals," but you would not want to include "NYC Subway Fare" as "Office Meals."
Amount and account conditions
You can limit a rule to a minimum and/or maximum amount. These compare the dollar amount of the transaction and ignore whether money came in or went out. For example, a rule with a minimum of $25 matches both a $40 withdrawal and a $40 refund. Rules don't have a money in or money out setting. To narrow a rule, you can also limit it to specific bank accounts or cards.
You will also have the choice to add a Vendor name for any transaction where this rule is applied. This may be useful if you typically modify the default vendor name. For example, if the vendor in the situation above typically showed up as "UTD AIR," you may want to change it to "United Airlines" so that it is more readable.
Furthermore, you will have the ability to choose when to start applying this rule. Regardless, it will not impact transactions that have already been confirmed. If you are familiar with historical versions of transactions that have a different Category or Vendor and have been confirmed, you can change them by unconfirming them and changing the Category or Vendor. Under Apply to, choose Starting on and pick a date (today's date if you only want new transactions), or apply it to all past and future transactions. There's no preview of affected transactions before you save. Saving a rule updates matching unconfirmed transactions in the background, which can take a few minutes. After saving, the Impacted count on the Rules page shows the past transactions the rule touched.
What rules can't do
Confirm transactions. A rule applies the category and vendor, but every transaction it touches still waits for your review.
Override a linked transaction. If a transaction is linked to another one (for example a credit card payment, a transfer, or a payroll withdrawal matched to a payroll run), the link wins over your rule.
Match on who was paid. Rules can't use a recipient's account ID or a Stripe transfer type (transfer, refund, fee or payout). If the description includes the person's name, use "description contains [name]". For the rest, find them with filters and categorize them together: Batch categorize transactions.
Tell deposits from withdrawals. A refund or reversal with the same description can match the same rule. Since rules don't confirm anything, you can catch these when you review.
Option 2: The Rules page
Rather than starting from a specific transaction, click Rules in the sidebar. (You can also open Rules from the Transactions page, as a tab or a toolbar button.) On the Rules page you can create rules directly and see the rules you've already created.
Click New rule and follow the same steps from Option 1 to create a new rule. The only difference is that the category and vendor name will not auto-populate; instead, you will fill out a blank template.
You can also review and change existing rules on this page. If a rule shows "Couldn't load this rule", see this article.
In Advanced view
Accountants and bookkeepers see Advanced view by default. Switch views with View at the bottom of the sidebar. In Advanced view, go to Settings → Accounting → Rules, or open Rules from the Transactions page.


