image16.gif

 


 

 

Account Mapping and Export

 

Account Mapping

The Account Mapping section is used to map CORESense Accounts to imported QuickBooks Charts of Accounts.

 

 

Step

Action

1

Select the desired configuration from your list and click thehammer-wrench.png  icon.

JE_-_edit2.png

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.

JE_-_mapping.png

notes.gif 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 hammer-wrench.png  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.

ecxclamation.PNG 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 theicon-checkbox.png   icon to delete a mapping.

 

 

 

Export

The Exports section is used to generate the export file.

 

Step

Action

1

Select the desired configuration from your list and click thehammer-wrench.png  icon.

JE_-_edit2.png

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.

JE_-_export.png

 

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.

QB_-_rec_export.jpg

 

  • 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

 

 

 

See Also

 

 

 

© 2015 CORESense · 1-866-229-2804 · info@coresense.com · 125 High Rock Avenue, Saratoga Springs, NY 12866