Account Mapping and Export

Step

Action

1

Select the desired configuration from your list and click the  icon.

2

From the top menu, click on the Account Mapping link.

3

Under the Account Mapping section complete the following:

1. Select the appropriate CORESense Account from the drop-down.

2. Select the appropriate External Account from the drop-down.

3. Click the Add button.

Note: Multiple CORESense Accounts can be mapped to a single External Account, but you cannot map a CORESense Account to multiple External Accounts.

4

From the Account Mapping List,  click on the  icon to edit a mapping. This is used to correct a mistake or if you make a change to a QuickBooks Account Name, add a new Product Type or Merchandise Hierarchy value, or make a change to an existing Product Type or Merchandise Hierarchy value.

Important: The Account Name in the export must match exactly the corresponding Account Name in QuickBooks. There cannot be any extra spaces or characters. If the Account Names do not match, you will receive an error message from Transaction Pro Importer 4.0 to that effect and the import into QuickBooks will fail.

5

Click on the   icon to delete a mapping.

Step

Action

1

Select the desired configuration from your list and click the  icon.

2

From the top menu, click on the Export link.

3

Enter the Start Date and End Date. The Start Date and End Date correspond to the revenue recognition date under accrual based accounting.

4

Click the Export button.

6

You can  export PO receiver information into QuickBooks (via Transaction Pro) for accounts payable. (for file format and process instructions, reference http://blog.baystateconsulting.com/index.php/2012/01/20/import-bills-into-quickbooks-using-transaction-pro-importer-5-0/.).

• When Export PO Receiver Data button is clicked, it exports CSV file of PO Receivers that have not been previously exported.

• Export includes one row per receiver and the following data fields (columns):
• • Vendor Name
  • RefNumber = PO Number
  • Memo = Warehouse name and Order # if PO has associated order, if no associated order to the PO only the warehouse name is exported.
  • Items Item = Receiver ID
  • Items Cost = total of receiver
  • Items Description = Channel:(originating channel) if PO has associated order.
  • Items Class =Originating brand name if PO has associated order

6

You will be prompted by your browser to view or download the file.  You can then download the file to you local disk.

Sample export