1. Accounting
  2. Banking
  3. Bank Data Matching and Reconciliation
  4. Reconciling Bank and Credit Card Statements
  5. Matching Bank Data
  6. Adding Account Transactions During the Matching Process
  7. Automatic Creation of Account Transactions

Automatic Creation of Account Transactions

Instead of manually creating and matching account transactions, you can automate these steps using auto-create rules. Auto-create rules let you create and match:

Tip:

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, payments are automatically applied to open invoices and matched, cleared, and ready for reconciliation. See Automated Cash Application.

You can also use auto-create rules to create and match customer payments for both existing and future imported bank lines. However, you need to reconcile these payments and apply them to invoices yourself.

If you import bank lines with a recurring Payor/Payee or Memo, auto-create rules look for lines with the right transaction type and Payor/Payee. If there’s no Payor/Payee, the rules check the Memo instead.

You don't need to manually create an auto-create rule. Instead, you can configure the system to generate one from a transaction match when certain criteria are met. For details, see Generating Auto-Create Rules.

Note:

NetSuite won’t generate an auto-create rule unless you check the Make Auto-Create Rule From Selected Transactions box on the Match Bank Data page. The box is cleared by default, so you need to check it every time you want a new auto-create rule.

When an auto-create rule is generated, it creates new account transactions from future imports with the specified values and matches them.

For example, if you import a bank line with the payor Ben and there’s no matching transaction, the system creates and matches one automatically.

Transactions that are automatically created and matched won’t impact your general ledger 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.

Related Topics

General Notices