Automatic Creation of Account Transactions
Instead of manually creating individual account transactions and matching them to imported bank lines, you can automate both these processes using auto-create rules. Auto-create rules enable you to automatically create and match the following transactions:
-
Deposits and charges for general ledger bank accounts
-
Charges and refunds for general ledger credit card accounts
If you have imported bank lines with corresponding customer payments not recorded in NetSuite, you can use the Automated Cash Application feature to generate those payments. When generated, the payments are automatically applied to open invoices. In addition, the payments are automatically matched, cleared, and ready for reconciliation. See Automated Cash Application.
You can also use auto-create rules to automatically create and match customer payments to existing and future imported bank lines. However, you must manually reconcile these payments and you must manually apply them to invoices.
If you import bank lines with a recurring Payor/Payee or Memo, auto-create rules look for imported bank lines with the transaction type and Payor/Payee specified by the rule. If the imported bank line has no Payor/Payee, the rule looks for the Memo that was specified.
You do not need to manually create an auto-create rule. Instead, you can configure the system to generate an auto-create rule from a transaction match when certain criteria are met. For details, see Generating Auto-Create Rules.
NetSuite does not generate an auto-create rule unless you check the Make Auto-Create Rule From Selected Transactions box on the Match Bank Data page when matching a transaction. This box is cleared by default, so you must check it every time you want to generate an auto-create rule.
When an auto-create rule is generated, it automatically creates new account transactions from subsequent imports with the specified values, and then matches them.
For example, whenever an imported bank line with the payor Ben appears without a matching account transaction, the system automatically creates and matches a corresponding account transaction.
Transactions that are automatically created and matched do not impact your general ledger account until you submit them on the Match Bank Data page. For details on submitting transactions, see Submitting Matched or User-Cleared Transactions.
To edit an auto-create rule, see Editing Auto-Create Rules.
To run an auto-create rule, see Running an Auto-Create Rule.
For troubleshooting information, see Troubleshooting Automatic Transaction Creation Rules.