Create a credit card transaction template

Use transaction templates to define how to create transactions in Sage Intacct to match incoming bank transactions. This 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 Credit card transaction.

2.  Enter an ID and a Name.

   Learn best practices for Name and ID creation.

3. Enter an optional Description of the transaction template.

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

4. Enter the name of the Payee associated with the transactions.

   The payee is typically the vendor paid. What you enter here overrides any data from the bank transaction.

5. For companies using the Taxes application and needing to track VAT or GST, 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 None if this template will be used for an entity without a tax solution.

   2. Select the Tax solution.

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

   3. Select the Tax schedule.

   Entity level

   1. The Tax implication is set to Inbound (purchases) inclusive of tax.

   2. The Tax solution defaults from the tax solution defined for the entity.

   3. Select the Tax schedule.

6. Select the account to which to post new transactions.

   This account is typically an expense account.

7. Enter the appropriate Department and Location.

   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.

8. Enter an optional Memo.

   This memo will appear on the line item of the created transaction. If this field is left blank, the description from the bank transaction appears instead.

9. Select Save.

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