The Consolidated Accounting Export page is your interface to export financial information for an individual store, all stores in your organization or all stores in an area*, in a format that can be read by your accounting package.

TO EXPORT FINANCIAL INFORMATION FROM CLEARVIEW TO YOUR ACCOUNTING PACKAGE:

Your accounting package and general ledger definitions must be configured before you export financial information to your accounting package.

  • Click here to learn how to select your Accounting Package.

  • Click here to learn how to map elements from CLEARVIEW to the accounting package in Accounting GL Definitions.

  1. Open the Consolidated Accounting Export page.

  2. Select the Area* and Store(s) for which you want to export the financial information.

  3. Select the Period for which you want to export the financial information.

  4. Select the specifics of the period* (Date*, Year*, Week Ending*, Month*, From*, To*) from the drop-down list(s).

  5. Select if you'd like to Combine Days from the drop-down list:

    • Yes will provide the consolidated amount for each element for the entire period selected.

    • No will provide the total amounts for each element for each day in the period selected.

  6. Click on the Go button.

  7. Verify that the information you want to export is in the table(s) displayed on the page.

  8. Click on the Create Extract File for Accounting Package button (where Accounting Package is the name of the accounting package used by your organization).

  9. Follow the instructions in the save dialog box to save the file to a convenient location.

  10. Import the file into your accounting package.

The following information is displayed on the page for the Area*, Store and Period selected:

Use the Show Results filter Drop-down boxes that let you select from the options available. to select which stores to include in the export:

  • All displays all the stores selected while generating the report.

  • Show Balanced displays only the stores for which the total debit matches the total credit.

  • Show Errors displays only the stores for which the total debit does not match the total credit.

  • Show Missing displays only the stores for which the data for one or more days in the period selected is not available.

  • Store: The name of the store.

  • Debit: The total of all debit transactions for the store.

  • Credit: The total of all credit transactions for the store.

  • Status:

    • Balanced indicates that the total debit match the total credit.

    • Warning: OUT OF BALANCE indicates that the total debit does not match the total credit.

    • Warning: Day does not Exist indicates that the data for one or more days in the period selected is not available.

Report links:

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.