Uploading Your Own Chart of Accounts, Vendors & Bank Accounts to the Rules Engine (No QBO/Zoho Required)

Uploading Your Own Chart of Accounts, Vendors & Bank Accounts to the Rules Engine (No QBO/Zoho Required)

Notes
Overview
You don’t need QuickBooks Online or Zoho Books to use the LedgerSync Rules Engine. If your firm keeps its books in another system — or a client isn’t on a connected accounting platform — you can upload your chart of accounts, vendors, and bank accounts from an Excel template and the Rules Engine will use that data to categorize transactions.

Who This Is For

  • Firms not connected to QuickBooks Online or Zoho Books
  • Clients on a manual/other accounting platform who still need automated categorization
  • Anyone who wants to drive the Rules Engine from their own GL data

What You Upload

Using the provided Excel template, you supply:
  • GL Code — your account code (e.g., 5021)
  • GL Description — the account name (e.g., Office Supplies)
  • Vendor Name — vendors to match against
  • Bank Accounts — the accounts transactions belong to

How to Upload

  1. Go to the Rules Engine / manual upload area
  2. Download the Excel template
  3. Fill in your GL codes, descriptions, vendors, and bank accounts
  4. Upload the completed file
  5. Your categories and vendors now feed into Global Rules — build rules exactly as a QBO/Zoho firm would

InfoThe Global Categories and Vendors used when creating a rule come from your uploaded LedgerSync data, not from QuickBooks. If you’re on Accounting CS specifically, use the dedicated Accounting CS setup instead — see the ACS articles.

After Uploading

  1. Map your Global Categories as usual
  2. Create Global Rules against your uploaded GL codes and vendors
  3. Export categorized transactions in your preferred format (Excel, CSV, OFX)

Need Help?

Contact LedgerSync Support at support@ledgersync.com

Related Articles:

    • Related Articles

    • How to Upload a Bank Statement PDF as a Transaction Source in LedgerSync

      Overview LedgerSync supports uploading bank statement PDFs directly as a live transaction source — alongside your Mastercard and MX bank connections. This is ideal for clients whose banks cannot be connected electronically, or where only a PDF ...

    • Rules Engine — Default Rules & Categories (Pre-Built Starter Set)

      Overview Instead of building every common rule from scratch, LedgerSync offers an opt-in set of Default Global Rules and Default Categories — a pre-built starter library covering the common-sense categorizations most firms need (common vendors, bank ...

    • Rules Engine — AI Rule Generation (Single Transaction & Bulk)

      Overview LedgerSync's AI can automatically create Global Rules and Global Vendors for you — either for a single unmatched transaction or for all unmatched transactions in bulk. This dramatically reduces the time it takes to build out a firm's rule ...

    • Rules Engine — Assigning QuickBooks Classes with Rules

      Overview The Rules Engine can assign a QuickBooks Class in addition to the Category when categorizing transactions. This supports clients — such as government entities, nonprofits, and multi-location businesses — that track expenses at a deeper level ...

    • Rules Engine — Audit Log

      Overview The Rules Engine Audit Log is a complete, searchable record of every action taken inside the LedgerSync Rules Engine — by any user in your firm. It tracks rule changes, category updates, and individual transaction actions so that nothing is ...