Accounting Export

The Accounting Export page is your interface to export financial information for your store in a format that can be read by your accounting package.

The following information is displayed in the Transaction Details* table on the page for the Area*, Store and Period selected or in the Transaction Details for date* table(s) (where date is each day in the Period selected) for the Area* and Store selected:

The Transaction Details table is displayed if the Consolidate information into one transaction, in the filters Drop-down boxes that let you select from the options available. at the top of the page, is set to Yes.
The Transaction Details for date table(s) are displayed if the Consolidate information into one transaction, in the filters Drop-down boxes that let you select from the options available. at the top of the page, is set to No.

Source: The type of report under which the element appears.
Element: The element to be exported.
Account: The corresponding general ledger account code on your accounting software.
Debit: The total amount for the period, if the element is a debit transaction.
Credit: The total amount for the period, if the element is a credit transaction.
TRANSACTION TOTALS: The total of the Debit and Credit columns.

OUT OF BALANCE indicates that the total of the Debit column does not match the total of the Credit column. Click here to learn more.

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.

Open the Accounting Export page.
Select the Area* and Store for which you want to export the financial information.
Select the Period for which you want to export the financial information.
Select the specifics of the period* (Date*, Year*, Week Ending*, Month*, From*, To*) from the drop-down list(s).
Select if you'd like to Consolidate information into one transaction 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.
Click on the Go button.
Verify that the information you want to export is in the table(s) displayed on the page.
Click on the Create Extract File for Accounting Package button (where Accounting Package is the name of the accounting package used by your organization).
Follow the instructions in the save dialog box to save the file to a convenient location.
Import the file into your accounting package.

Associated Settings

Accounting Package controls the accounting software used by your organization.
Accounting GL Definitions controls how each element is mapped in the accounting package.

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