Mapping Company Paid Credit Cards to Journal Entry (Intacct)

Nexonia can export Company Paid credit card expenses to Intacct to create a Journal Entry.

Configuring the Company Paid Journal Entry Settings

To locate this setting, please navigate to (in Nexonia) Intacct* >> Integration Setup >> select "Edit Parameters" in the Configuration Data section.  

*May be labelled differently in your Nexonia instance

1. Depending on how the reimbursable expenses are being exported to Intacct, the setting to enable Company Paid transactions to be exported as Journal Entries will be in a different place:
   1. If exporting Expenses as Expenses Reports: go to the Expenses tab and switch Enable Export Cards as Journal Entry to "Yes"
   2. If exporting Expenses as Vendor Bills: go to the Expenses tab and switch Enable Export Cards as Journal Entry to "Yes"
   3. If exporting Expenses as Journal Entries: go to the Expenses as Journal Entry tab and switch Export Corporate Credit Card to "Yes"
2. Navigate to the Cards As Journal Entry tab
3. The following are the key settings:
   1. Journal Entry ID = enter the Journal Entry ID from Intacct. This may be listed as the "symbol" identifying the GL in Intacct
   2. Description = Journal Entry description. By default, this will be populated with the Nexonia expense report number and the expense item memo - other values can be placed here if needed
   3. Entry Memo = Journal Entry line item memo. By defaul,t this will be populated with the Nexonia expense report number and the expense item memo - other values can be placed here if needed
   4. Creation Date - your options are:
      • Transaction Date (default)
      • Posted Date
      • Statement Date
      • Export Date
   5. Send Account Payable - your options are:
      • Single Account - enter the GL number for the AP account that the expenses will hit (note that they will also hit the individual GL accounts picked on the item level)
      • Per Source - this will allow you to assign different AP accounts for each card source
   6. Line Item Details - for each line item dimension, you'll choose whether the value is:
      • No = no value will be exported
      • Item = the exported value is the same as the one in the expense report
      • Fixed = the exported value is different from the one in the expense report
   7. Exported - your options are:
      • per Source = this gives you a separate export drop-down for each card source. I.e. if you have three card sources, you have separate export options for each card source
      • per Source, per Region = this gives you a separate export drop-down for each card source for each region. I.e. if you have three card sources and three regions, you have separate export options for each card source for each region

4. If per Source, per Region is selected, another tab named Cards As Journal Entry (per Source, per Region) will appear at the top. In that tab, the following options are displayed for each card source:

   • Exported - all cards associated with the card source as exported
   • Not Exported - none of the cards associated with the card source are exported
   • Exported Per Card - all cards associated with the card source have their own Exported drop-down, giving you the option to choose which cards to export/not export (this option is only applicable if the card source contains multiple cards)
5. If Send Account Payable was set to Per Source, you'll see an Account Payable option for each card source; this has to be filled out in order to map the card source to an AP account
6. Click OK to save your settings

You have now mapped your Company Paid charges to Journal Entries in Intacct.

Adding the Company Paid Journal Entry Export

You'll want to create a separate, dedicated export for the company paid transaction to export to Intacct.

To do so in Nexonia, please navigate to Intacct* >> Integration Setup >> select "Add Data Integration".

Set the Data Type to "Expenses". 

Once complete, you will see a window for the Data Integration. The following settings will appear:

1. Name: enter the name for this export, i.e. "Company Paid Export"
2. Export Receipts Using: if a PDF/Receipt export has been added to the data integrations, select it here to allow attachments to be exported to the Journal Entries
3. Send Errors To: enter the email address for whomever should be alerted if there's an export error
4. Active: check mark "Active" to enable this export
5. Scheduling: to enable a scheduled automated export, click the Edit option. This can be set as one of the following:
   • Overnight (most common) - it can be set to export every night, or just specific days of the week by unchecking Everyday
   • Hourly
6. Integration Type: choose "Intacct". This will add two new tabs along the top of the Data Integration Settings:
   • Filtering - allows you to filter which transactions should be included in this export. To ensure that only the company paid charges are included, select "Item Types" and check mark the Company Paid and Company Card types
   • Parameters - Under Type, select Cards as Journal Entry. 

Click the OK to the settings.

You will now have a new export available under the Expense Reports tab for company paid Journal Entries.