Generating Auto-Create Rules
When you create and manually match an account transaction to an imported bank line, you can check the Make Auto-Create Rule From Selected Transactions box.
An auto-create rule can only be applied to a single account.
NetSuite can generate auto-create rules from matches on the Match Bank Data page when these criteria are met:
-
You have the Matching Rules for Online Banking permission, with create-level access at a minimum.
-
You are performing a one-to-one match of a Check, Deposit, Credit Card Charge, or Credit Card Refund.
-
Your imported bank line contains a Payer/Payee or Memo.
-
The transaction amount is not zero.
-
The match difference is zero.
-
The account transaction contains only one line item.
Note:Deposits must have a single Other Deposits line item. All other transactions must have a single Expenses line item.
-
The account transaction doesn't contain a tax code.
Note:Auto-create rules are not currently compatible with tax codes.
If these criteria are met, the box becomes active. If you check the box, NetSuite generates an auto-create rule after you submit the match.
The Intelligent Transaction Matching feature runs this auto-create rule, along with other matching rules, on future imports. For details, see Running an Auto-Create Rule.
You can add more conditions to the rule and define its action. For more information, see Editing Auto-Create Rules.
To generate an auto-create rule:
-
If you haven't already, do the following:
-
Import bank or credit card data into your account in NetSuite. See Bank Data Import.
-
Go to Transactions > Bank > Bank Matching and Reconciliation > Match Bank Data.
-
From the Account list, select the bank or credit card account.
If NetSuite failed to import data for the account, a popup displays the most recent error. For more error details, go to Transactions > Bank > Banking Import History. See Banking Import History.
-
-
On the Transactions to Match subtab, create or select an account transaction to match with an imported bank line.
To add an account transaction directly on the Match Bank Data page, see Adding New Charges During Matching, Adding New Deposits During Matching, or Adding New Credit Card Refunds During Matching.
If you can't add the transaction on the Match Bank Data page because it contains additional required fields, create one using a transaction entry form. See Making Deposits, Writing Checks, or Entering Company Credit Card Charges.
-
Select the newly created or existing account transaction and the corresponding imported bank line.
If you created the transaction on the Match Bank Data page without first selecting an imported bank line, select an imported bank line now.
Note:Dimmed transactions are still processing. You can't select them until processing is complete. To check the status, refresh the imported bank data.
-
When the Difference field is zero, check the Make Auto-Create Rule From Selected Transactions box. If the box isn't active, the criteria for an auto-create rule aren't met.
Note:The box is cleared by default. You must check it every time you generate an auto-create rule.
-
Click Match and Submit.
NetSuite generates an auto-create rule from the transaction match and submits the match for reconciliation. If NetSuite can't generate an auto-create rule, see Troubleshooting Automatic Transaction Creation Rules.
-
To see the newly generated rule, go to the Reconciliation Rules page. To run the rule, see Running an Auto-Create Rule.