Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWhen bank rules are exported to excel the result is show in three columns:
Rule Name - each individual rule
Rule condition - Coding for the conditions set, such as "ruleType":10, "ruleType":6, "isAndRule:true
Rule Outputs - Coding for the action to be taken based on the condition such as,
"actionType":5, "actionType":0,"actionType":8,"value":true
An example is attached.
Is there a key that explains the structure of the code that is exported to Excel or what the various "ruleTypes" and "actionTypes" are?
Sending good vibes to you, cgordon9999.
I can provide you with some information about exporting bank rules via QuickBooks Online.
The sensitivity of exporting the bank rules is encrypted. These are the codes used for easy transfer to another QuickBooks Online account.
Since the information is bank related and this kind of information is confidential and we value your privacy. That way, you are assured that your files are protected to the highest and safest level possible. You will get the same information when you import it to the other QuickBooks Online account. However, importing bank rules will override your old rules in QuickBooks.
Here's a recommended article about banking rules: How to set and use banking rules for downloaded transactions.
Keep me posted if you have additional questions about exporting bank rules. Have a good one.
How can I export bank rules to another company file?
Nice to have you joined this thread, Marlene.
You'd be glad to know that importing bank rules in QuickBooks Online (QBO) only takes a few steps. I'll show you how.
You can also check the Import existing bank rules section in this article for more details: Set up bank rules to categorize online banking transactions in QuickBooks Online.
Once you're all set, you might want to check out these resources that can guide you in efficiently matching your accounts:
You can always get back to me if you need more help importing bank rules in QBO or managing your accounts. I'm always here ready to back you up. Keep safe and have a great weekend!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.