Benefits of the LedgerSync Rules Engine

Benefits of the LedgerSync Rules Engine

Overview

The LedgerSync Rules Engine is a firm-wide transaction categorization system that works with QuickBooks Online. Instead of creating rules one client at a time inside QuickBooks, you build rules once in LedgerSync and they apply across every client whose accounts you have mapped to your Global Categories, with the correct account for each client. You review and accept the results before anything is sent to QuickBooks.

Why the Rules Engine Is Better Than Managing Rules in QBO

  • Global Rules apply to all of your mapped clients at once.
  • All Global Rules are listed on a single Global Rules page.
  • Rules are created and edited entirely within LedgerSync.
  • New clients use your existing Global Rules as soon as their accounts are mapped to your Global Categories.
  • Editing one Global Rule updates every client it reaches, for transactions that have not yet been accepted.
  • You review and accept transactions before anything is sent to QuickBooks.

Key Benefits

1. Global Rules: Set Once, Apply Everywhere

Create a rule once and it applies to every client whose accounts are mapped. Each client's own chart of accounts is respected: you map each Global Category to the matching account in each client's chart of accounts, and the rule posts to that client's account. For example, a rule for "Starbucks to Meals & Entertainment" applies to all mapped clients without needing to recreate it for each one.

A Global Rule needs a Global Category. You cannot save a Global Rule without choosing a Global Category, and the rule only categorizes a client's transactions when that Global Category is mapped for that client. If it is not, the transaction shows that the rule matched but the category is not mapped for this client.

Which rule wins. If a transaction is already categorized by one of the client's own rules (the rules on the Client Rules page), Global Rules skip it. Between Global Rules, the rule with the lower priority number keeps its transactions.

2. All Global Rules on One Page

All Global Rules are listed on the Global Rules page. You can filter by Rule State (Active or Inactive), Rule Type and Applied To (Money in, Money out, or Money in or out), or search by keyword. Global Categories and Global Vendors have their own pages under Settings, Global Settings. No need to jump between QuickBooks company files.

What Happens When You Edit, Disable or Enable a Global Rule

  • Editing a rule: when you save changes to a Global Rule, LedgerSync applies the rule again. If you save the rule without changing anything, it is not re-applied.
  • Changing priority: you can change a rule's Priority in its edit window. LedgerSync then re-applies the Global Rules affected by the change.
  • Disabling a rule: turn a rule off with its checkbox in the Global Rules list, or select rules and click Disable Selected. LedgerSync removes the rule's categorization from the transactions it had categorized that are still in For Review. They stay in For Review, uncategorized.
  • Enabling a rule: turn it back on with its checkbox, or select rules and click Enable Selected. LedgerSync applies the rule again.

Re-applying a rule never changes transactions you have already accepted (in Categorized) or already sent to QuickBooks.

3. Auto-Assignment for New Clients

When you add a new client, connect their QuickBooks Online account and map their accounts to your Global Categories, your existing Global Rules automatically evaluate their transactions. This is similar to a VLOOKUP: LedgerSync looks up each transaction against your firm's rule library and categorizes it. You map a client's accounts on the Global Categories page under Settings, Global Settings.

Resetting a client's transactions: the Reset Transactions button at the bottom of the Rules Engine menu (with a client selected) clears the categorization of the client's MasterCard bank transactions that have not been sent to QuickBooks and are not excluded or pending, and moves them back to For Review. It also removes the client's Global Category mappings, and LedgerSync warns you that Global Rules will stop applying to that client until you map its categories to Global Categories again on the Global Categories page.

4. Full Review Before Pushing to QBO

No transactions are sent to QuickBooks until you review and accept them. Transactions categorized by your rules wait in the For Review tab. When you accept them, they move to the Categorized tab. From there, you send the selected transactions to QuickBooks in a single sync action.

5. Rule Change History

Each time a Global Rule is created or edited, LedgerSync records who made the change, when, and what each changed field said before and after. Open the rule and click its Rule History icon to see the full change history of that rule.

6. AI Rule Generation

LedgerSync's AI model can analyze unmatched transactions and generate Global Rules and Global Vendors for you. You can generate a rule for a single transaction or, on the Global Rules + AI page, run bulk AI rule generation across all unassigned transactions at once. AI-generated rule names start with the prefix "AI" so they are easy to identify. AI-generated rules are turned on as soon as they are created, so review them before relying on them.

For full details see: Global Rules Creation Via LedgerSync AI Model and Rules Engine Bulk AI Categorization

7. Rules Engine Audit Log

The Rules Engine Audit page under Settings keeps a searchable record of actions taken in the Rules Engine: rule creation and edits, category changes, and individual transaction actions (accept, undo, exclude). Each entry shows who performed the action and when. You can filter by client, entity type, action or date range, and search by keyword, including a user's name. This gives your firm full accountability and makes it easy to investigate any categorization question.

8. Check Matching in the Rules Engine

When check images are available for a client's account, LedgerSync matches each check image to its corresponding bank transaction. A check icon appears on the matched transaction in the Rules Engine and opens the check image with its details, including the payee (Pay To) and memo. If you correct the check details and click Update, LedgerSync adds the payee to the transaction's description. This gives you richer context when reviewing and categorizing check-based transactions.

9. PDF Bank Statement Upload

If a client's bank cannot be connected electronically, you can upload a bank statement PDF directly into LedgerSync as a data source. Transactions extracted from the PDF appear in the Rules Engine alongside MasterCard and MX transactions, each marked with an icon for its source. The same categorization, accept, exclude and sync actions apply to PDF transactions.

10. Exclude Specific Accounts

If a particular bank account should not go through the Rules Engine (for example, an internal transfer account or a hold account), you can exclude it with Exclude Accounts on the Bank Accounts Mapping page. Transactions from excluded accounts are not shown in the For Review queue (they move to the Excluded tab) and are not processed by any rules.

11. Flexible Rule Direction

Each rule can be set to match Money in, Money out, or Money in or out (both directions in a single rule), while LedgerSync still posts the correct QuickBooks transaction type based on each transaction's actual direction. See: Rule Direction: Money In, Money Out, or Both

12. Class Assignment

Client rules can assign a QuickBooks Class in addition to the category, which helps government entities, nonprofits and multi-location businesses that track at a deeper level. See: Assigning QuickBooks Classes with Rules

Related Articles