Account Code List Report

1. Reaching the "Account Code List Report" 

To reach the "Account Code List Report," follow the steps below: 

Step 1: Log into Control Center

Step 2: Choose Point of Sale

Step 3: Choose Reports

Step 4: Choose List Reports

Step 5: Choose Account Code List 

See Figure 1.1. You will see many types of list reports that will be useful to your retail business. By clicking the drop-down selection, you will see the different types of list reports.

2. Generating the "Account Code List Report"

When you navigate to the page, you will see the options pre-selected by default. You can generate the Account Code List Report for the selected fields. You will see the "Report Data is Empty" message initially. You need to select the date range to check the Account Code List Report. See Figure 2.1.     

1. From the Report Type dropdown, select Department Codes. 
   
2. From the Code Filter dropdown, select one of the following options: 
   
1. All Records: Displays all department records regardless of whether an account code is assigned or missing. 
   
2. Account Missing Codes: Displays only those department records where the required account code fields are not configured or left blank. 
   
3. Click on "Generate Report." The report will be displayed in the grid below. See Figure 2.1. 
   
4. Using the Print/Export Report option, you can export the report in the following formats: 
   
1. PDF 
   
2. CSV 
   
3. Excel  
   
5. Also, you can print the report and get the exact data in the output with all the columns you see in the generated report.  
   

                                                                             Figure 2.2

The codes are configured in Point of Sale>>Maintenance>>Departments.

1. Department Name: This column gives the department name. See Figure 2.3.
   
2. Department #: This column defines the department number that is fetched from the departments assigned to the UPC of the item sold. See Figure 2.3.

                                                                                                                                                                                                                       

1. Sales Account: This column defines the assigned general ledger Sales Account codes. This is the code that is configured in the "Departments" module and is fetched from there. See Figure 2.4 below. 
2. COGS Account: The assigned general ledger Cost of Goods Sold Account codes. See Figure 2.4 below. 
   
3. INV AP Account: Accounts Payable (AP) is used to describe the money owed to vendors for purchases made on credit. This column defines the assigned general ledger AP Account codes. See Figure 2.4 below.
   
4. Returns Account: Here, the assigned general ledger Return Account codes are mentioned. See Figure 2.4 below. 
   
5. Shrink Account: This column displays the shrink account number assigned to each department. If a value is present, it indicates that shrink transactions for that department will post to that account. If blank, it indicates no shrink account has been configured for that department.
   
6. Personalization+ Account: This column displays the account number assigned for personalization-related transactions within that department. If populated, it indicates that personalization charges will be posted to that account. If blank, it indicates that no personalization-specific account mapping has been configured.
   
7. Adjustments Account: This column defines the assigned general ledger Adjustment Account codes. See Figure 2.4 below.
   
8. Excise Account: Here, the assigned general ledger Excise Tax Account codes are mentioned. See Figure 2.4 below.                 

3. Report Type:

3.1: Department Codes: This report type displays the account with respect to department codes. See Figure 2.1 above.

3.2: Vendor Codes: This report type shows the account # in relation to vendor codes. See Figure 3.1.

                                                                                                                                                                                                                                        Figure 3.1

3.3: Buydown Codes: This report type will show the account # in relation to the buydown codes.

                                                                       Figure 3.2

3.4. Discount Codes: This report type will show the account # in relation to discount codes.

                                                                       Figure 3.3

3.5. Tax Rate Codes: This report type will show the account # in relation to the tax rate codes.

                                                                        Figure 3.4

3.6. Tender Codes: This report type will show the account # in relation to the tender codes.

                                                                                                                                                                                                                                              Figure 3.5

3.7. Location Codes: This report type will show the account # in relation to location codes.

                                                                       Figure 3.6

4. Code Filters

                                                                                                                                                                                                                                                                                                                                     Figure 4.1 

1. All Records: This filter works in correspondence with "Report Type." Depending on what report type is selected, the system will display the records in the report.

1. Accounts Missing Codes: This filter is used to display different account codes that haven't been configured in the department.
   

For example, if you choose the Report Type as Department Codes, then the resultant report will be displayed as Figure 4.2 below.

                                                                                 Figure 4.2

All the reports will be generated in the same way for all the Report Types.