Chart of Accounts Import

The Chart of Accounts Import section is used to import a Chart of Accounts that is used to map your CORESense Journal Entry configuration to QuickBooks account or generic account. Once mapped, data are exported and analyzed as necessary for your business needs.

The table below lists what type of data are exported from CORESense.

Exported	Not Exported
Merchandise Sales and COGS Shipping Sales and Costs Gift Certificates and Values Cards Sales Tax Payments Accounts Receivable (net amount, not itemized)	Purchasing Accounts Payable

QuickBooks Steps

Follow the steps below to export your data from QuickBooks.

Step	Action
1	Export your chart of accounts out of QuickBooks as a .cvs file. In QuickBooks select Lists > Chart of Accounts.
2	Click on the Reports button and select Account Listing.
3	Click on the Export… button.
4	In the Basics tab, select the a comma separated values (.csv) file option.
5	Click the Export button.
6	You will be prompted to name and save the file to your local disk.
7	After you save the file, open the file and the remove the Account Type column from the exported file so that there is only a header row and a column of Account names. Save the edited file.

Generic Account Steps

Follow the steps below to create an import file using your accounts.

Step	Action
1	Create a spreadsheet with a single column that lists all of your accounts, i.e., 100, 110, 120. If you want to include the descriptive labels, you can, for example 110, Inventory:Apparel.
2	Save the spreadsheet in a .CSV format.
3	Follow CORESense import steps below.

CORESense Steps

Follow the steps below to import your data into CORESense.

Step	Action
1	Select the configuration the Chart of Accounts is to be imported into and click the icon.
2	From the top menu, click on the Chart of Accounts link.
3	Browse to the saved chart of accounts file and verify that the file includes a header row and check the Header Row checkbox. Important : If the import format was not correct or there was some other error in the import, the only way to correct it is to create a new export configuration.
4	Click on the Upload button.