Open topic with navigation

Export Accounting Entries to an Excel File

Complete the following procedure to export a daily posting to an Excel file for use with a linked or unlinked accounting program.

Note: If an error message like the one shown below appears while completing this procedure, one or more associated items have not been mapped to corresponding QuickBooks accounts.

Complete the following procedure to correct this issue before proceeding:
1. Note the unmapped element(s).
2. Click the Continue button to close the error message window.
3. Complete the appropriate portions of the Set Up Accounting Links and Features procedure to map the unmapped element(s) to the corresponding QuickBooks account(s).

1. Navigate to the GL Postings screen.

   1. If the screen will be used to post to linked accounting software (i.e., QuickBooks), complete the following procedure before continuing:

      Note: If the screen will be used to export to an Excel file (or the store's Accounting Package Type is set to "None"), proceed to the next step.

      1. If it is open, close the Data Center application.
      2. Make sure all other users are logged out of the QuickBooks application.
      3. Log in to the QuickBooks application with Administrator rights.

   2. Log In to the Data Center Application to display the Data Center ribbon menu.

      

   3. Select Accounting > GL Postings from the main menu to display the GL Postings screen.

   

2. Complete any combination of the following to determine which entries will display on the screen:
   • Enter the desired starting and ending dates in the Date Range fields.

   • Select a type (status) from the Type drop-down field.

     Note: If the store's Accounting Package Type is set to "None," this feature may not be available.

3. Click the Submit button to display all entries matching the selection criteria.

4. Click the entry’s Preview button to display the entry preview window.

   

5. Click the Export to Excel (Table) button to export the data to an Excel file.
6. Click the Close button to close the entry preview window.
7. Click the tab's Close button to close the screen.