Online banking: Renaming rules for payee names
When you download or import transactions, the names of payees in your downloaded transactions may not match the names of payees in QuickBooks. That means you need to go through and match each one with a payee in QuickBooks and that can burn a lot of time you could be doing something more useful. QuickBooks makes this a lot easier with renaming rules.
Tips and advice on setting up your renaming rules
When you create a renaming rule, it applies to transactions currently listed on the Downloaded Transactions window or future transactions you will download.
There's two ways to create a renaming rule. In either case, the first thing you do is choose Banking > Downloaded Transactions and download or import transactions from your financial institution. If QuickBooks recognizes a downloaded payee name that is the same as one of your vendors, it goes ahead and creates a renaming rule.
Note: After you create a renaming rule, you may find it's too strict or maybe not enough. You can always edit a rule if you need to.
One way to create a renaming rule:
- On the Downloaded Transactions window, click the Payee column next to a Downloaded Payee you want to create a rule for.
- In the Payee columen select or enter the name you want to use for the downloaded payee. QuickBooks creates a new rule that renames the downloaded payee.
- If the account is not prefilled for you, select an account for the transaction.
Another way to create a new rule:
- On the Downloaded Transactions window, download or import transactions from your financial institution. If QuickBooks recognizes a downloaded payee name that is the same as one of your vendors, it goes ahead and creates a renaming rule.
- Click Renaming Rules at the top of the window.
- On the Renaming Rules windows, click the + button at the bottom of the window.
- Set up your rule. Think of your rule as an if/then sentence. "If this happens, then I want QuickBooks to do this." Use the first line (the "If" line) to tell QuickBooks what text to look for in the downloaded payee name. So, for the first part of your sentence, pick an action and enter text.
- begins with— Apply the rule to any downloaded payee that begins withthe text you enter.
- contains— Apply the rule to any downloaded payee that containswith the text you enter.
- ends with— Apply the rule to any downloaded payee that ends withthe text you enter.
- exactly matches— Apply the rule to any downloaded payee that exactly matchesthe text you enter.
Note: The text you enter is not case-sensitive, so don't worry about uppercase vs. lowercase.
- Use the second line (the "then" line) to tell QuickBooks what you want to do with transactions that meet the criteria of the first line.
- rename to— Renames the downloaded payee to a vendor name you select. If you don't see the vendor you want, you can just enter the name and QuickBooks will prompt you to set up the vendor.
- don't rename— The downloaded payee stays at it is and is not renamed. This is useful for transactions such as checks. The downloaded name is probably the word "Check" plus a number and you need to choose which payee that check actually went to. You can create a rule that if the downloaded payee name contains "check" then don't rename it. Then you can choose the payee name manually for each check to make sure it's correct. QuickBooks adds a default list of these "don't rename" rules for checks, deposits, and withdrawals automatically.
- Click OK.
Once you create a rule, you can edit it to get make it work just the way you want.
To edit a renaming rule
- Open the rule you want to rename:
- In the Downloaded Transactions window, select a downloaded payee that has the rule applied that you want to change. Then click the arrow next to the name, and click Edit Rule.
-
Click Renaming Rules. On the Renaming Rules windows, double-click the rule you want to edit or select it and click Edit.
- In the Downloaded Transactions window, select a downloaded payee that has the rule applied that you want to change. Then click the arrow next to the name, and click Edit Rule.
- Change the rule, and click OK. (For details, see the previous section on creating a new rule.)