QuickBooks HelpQuickBooksHelpIntuit

Import existing bank rules in QuickBooks Online

by Intuit Updated 2 days ago

If you set up bank rules on a QuickBooks Online company file, you can export them, then import them to a new company file. This can save you time and create consistency. 

To import existing bank rules, follow these steps.

Export rules

  1. Sign in to the company file you want to export the bank rules from.
  2. Go to Accounting, then select Rules (Take me there).
  3. Select the New rule ▼ dropdown and then Export rules.
  4. Save the export file in Excel.
  5. Sign out.

Import rules

  1. Sign in to the company file you want to import the rules into.
  2. Go to Accounting, then select Rules (Take me there).
  3. Select the New rule ▼ dropdown and then Import rules.
  4. Select Browse and find the Excel file you exported.
  5. Select the rules and details you want to import.
  6. Follow the prompts to finish the import.

Next step 

Learn how to set up auto-post so that specific transactions are automatically accepted into your books.

Bill.com AppDocuSign eSignature Connector AppHubSpot AppLeanLaw AppQuickBooks Accountant Desktop PlusQuickBooks Bill Pay BasicQuickBooks Bill Pay EliteQuickBooks Bill Pay PremiumQuickBooks CapitalQuickBooks CheckingQuickBooks Desktop Enterprise AccountantQuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Mac PlusQuickBooks Desktop Payroll AssistedQuickBooks Desktop Payroll BasicQuickBooks Desktop Payroll EnhancedQuickBooks Desktop Payroll StandardQuickBooks Desktop Premier PlusQuickBooks Desktop Pro PlusQuickBooks GoPaymentQuickBooks LedgerQuickBooks Live Assisted BookkeepingQuickBooks Live Full Service Bookkeeping CleanupQuickBooks Live Full Service Bookkeeping MonthlyQuickBooks Live Full Service TaxQuickBooks Live One Time SetupQuickBooks MoneyQuickBooks Online AccountantQuickBooks Online AdvancedQuickBooks Online App for AndroidQuickBooks Online App for MacQuickBooks Online App for iOSQuickBooks Online EssentialsQuickBooks Online Payroll CoreQuickBooks Online Payroll EliteQuickBooks Online Payroll PremiumQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Payments for DesktopQuickBooks Payments for OnlineQuickBooks Payroll, HR & Benefits AppQuickBooks ProAdvisorQuickBooks Self-EmployedQuickBooks Self-Employed Mobile for AndroidQuickBooks Self-Employed Mobile for iOSQuickBooks SolopreneurQuickBooks Time EliteQuickBooks Time PremiumQuickBooks WorkforceSalesforce Connector App

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.