Create a journal entry transaction template

Use transaction templates to define how to create transactions in Sage Intacct to match incoming bank transactions. This ultimately speeds up your reconciliation process.

Assign your transaction template to a creation rule.

1. Go to Cash Management > Setup > Reconciliation txn templates and select Add (circle) next to Journal entry.

2. Enter an ID and a Name.

   Learn best practices for Name and ID creation.

3. Enter an optional Description for the template.

   This description does not appear on created transactions and is only for your reference.

4. Select to create transactions in a Draft or Posted state.

   Draft transactions appear for reconciliation with a state of Draft matched.

   If you're using allocations, select Posted.

5. Select the Journal to which to post new transactions.

6. For companies using the Taxes application and who need to track VAT or GST taxes, enter information in the Tax information section.

   How you enter information depends on whether you're in a top level or entity level company.

   Top level

   1. Select the Tax implication.

      Select Inbound (purchases) inclusive of tax to record taxes on purchases.

      Select Outbound (sales) inclusive of tax to record taxes on sales.

      Select None if you do not to create journal entries with tax.

   2. Select the Tax solution.

      The tax solution specified on the template needs to match the location of the account in Sage Intacct that will use this template.

   3. Select the Tax schedule.

   4. Optionally, select the Vendor or Customer, depending on whether this is an inbound or outbound tax.

   Entity level

   1. The Tax implication defaults from what's defined on the Entity record.
   2. The Tax solution defaults from the tax solution of the entity.
   3. Select the Tax schedule.
   4. Optionally, select the Vendor or Customer, depending on whether the template is for inbound or outbound tax.

7. Select the Account to which the journal entry will post.

   Make sure to enter only one line item.

8. (Companies enabled for allocations) Select a transaction Allocation template for the line item to distribute the amount across specified dimensions.

   Make sure that the General Ledger option to Enable transaction allocation in journal entry is enabled.

   Allocations are not supported for journal entries that contain tax implications.

   If you’re using an allocation with dimensions, do not specify any of the same dimensions on the transaction template; leave the field blank. For example, if your allocation specifies a department, do not set a department on the transaction template.

   Is your company enabled for inter-entity transfers? If the location defined on the transaction allocation is different from what's defined on the account in Sage Intacct, leave the Location field for the transaction template blank.

   About transaction allocations

   Create a transaction allocation if one does not already exist. This new transaction allocation appears in your list of allocations, and you can select it the next time you allocate an AP supplier invoice, an AR sales invoice, or a journal entry. Intacct automatically applies the distribution that you specified when you created this transaction allocation.
   For more information, see Edit or view transaction allocation definitions.

9. The Location and Department default from your account in Sage Intacct, but you can override those values if you need to here.

   For companies enabled for inter-entity transfers (IETs), if you select a location that's different from the location defined on the bank account in Sage Intacct, an inter-entity transaction is created. However, if the bank account has disabled inter-entity transfers, no IET is created.

   If you're using a transaction allocation with a different location than the bank account, leave the Location field in the transaction template blank.

   Learn more about when IETs are and are not created

   Whether an IET is created depends on if the location on the transaction template differs from the location defined on the bank account. These locations must also be in different entities for an IET to be created.

   IET creation matrix

   Location specified on template?	Location on template differs from location on bank account?	IET enabled?	GL accounts mapped?	IET created?	Location used for journal entry
   Yes	Yes	Yes	Yes	Yes	The location specified on the template.
   Yes, by allocation	Yes	Yes	Yes	Yes, if the location defined on the allocation template is different from the location defined on the bank account.	The location of the transaction allocation.
   No		Yes	Yes	No	The location of the bank account in Sage Intacct.
   No		No	Yes	No	The location of the bank account in Sage Intacct.
   Yes		No	Yes	No	The location specified on the template.
   Yes		Yes	No	No	The location specified on the template. If there's no location specified, the location of the bank account in Sage Intacct is used.

   For companies tracking VAT or GST, if you leave the location blank and the tax solution you selected does not match the tax solution of the bank account's location, no transaction will be created.

10. Select Save.

Next step: Assign the transaction template to a creation rule. Then add the rule to a rule set.