Create a creation rule for journal entries

Automatically create journal entries in Sage Intacct based on incoming bank data from an import file or bank feed. Newly created journal entries automatically match to the corresponding bank transaction for reconciliation.

You can set up a creation rule to create draft journal entries. Draft journal entries have a reconciliation status of Draft matched when you view them during reconciliation. After you approve a draft journal entry, transactions match for reconciliation.

If you create a rule to account for a transfer of funds between entities, an inter-entity transaction will be created. The source entity owns the bank account from which the funds are drawn. This might override the location specified on the journal entry transaction template.

1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

2. In the Type dropdown list select Create rule.

3. Enter an ID and a Name.

   Learn best practices for Name and ID creation.

4. Create a filter for the bank transaction posting date.

   This filter is required for all creation rules to prevent creating duplicate transactions.

   1. In the Data source dropdown list select Bank transactions.
   2. In the Field dropdown list select Posting date.
   3. In the Operator dropdown list select Is greater than.
   4. In the Value field enter the date on which to begin creating transactions.

5. Add any other filters as needed.

   If you select Equals in the Operator dropdown list the Value field is case sensitive, otherwise it's not case sensitive.

   See examples.

6. Optionally, group Bank transactions by Document number or Posting date.

   For example, you might have multiple bank transactions with the same posting date that correspond to one credit card transaction in Sage Intacct.

7. In the Define transaction to create section, select Journal entry as the Transaction type.

8. Select a Transaction template.

   Transaction templates define how to create new transactions. Learn how to create a transaction template.

9. Select Save.

Next step: After you create the rule, create a rule set to contain it. Make sure that the creation rule runs last. Then, apply the rule set to an account.

When you reconcile, import a bank file, or refresh a bank feed for an account, matching rules run first. Then, creation rules run and create additional transactions from any remaining bank transactions.