The template's GL DATA tab pulls an expense general ledger from QuickBooks through Amalgam, with the Class, Location, Customer and Vendor columns turned on. The workbook cleans those transactions, skips split entries that have no single bank account to attach a rule to, and builds a profile of each vendor: the bank account it's usually paid from, the category and class it's booked to, and how consistently it has been coded.
From there it writes a bank rule for every vendor that clears the thresholds you set on the Settings tab, covering minimum transaction count, category consistency, and how reliably the condition text appears in the vendor's bank lines. The condition text is trimmed down to the words that stay the same every time, so order numbers, dates and amounts that change from line to line don't break the match.
The rules are laid out in plain columns on the Rule Fields tab for review, with vendors that have been booked to more than one category highlighted so you can pick the right one or drop the rule. The Rule Import Table then holds the same rules in the format QuickBooks expects, ready to import under Banking > Manage Rules. Nothing posts automatically unless you turn on auto-add.
To run it for another client, re-link the GL DATA tab to a different company in the Amalgam sidebar and run it again. Every formula updates on its own.
