Account Code List Report

Account Code List Report

Account Code List Report

The Account Code is a fixed-digit field used to classify financial activities and balances within the General Ledger (a set of numbered accounts that is used to keep track of financial transactions and also to prepare financial reports). 
The "Account Code List Report" gives the option to review assigned general ledger accounting codes for all areas of the system.

1. Reaching the "Account Code List Report" 

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

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 A. 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.

                                                                                             Figure A

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 B.

                                                                                     Figure B

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 C.     

                                                                                                           Figure C

Fields:
The codes are configured in Point of Sale>>Maintenance>>Departments.
  1. Department Name: This column gives the department name. See Figure D.
  2. Department #: This column defines the department number that is fetched from the departments assigned to the UPC of the item sold. See Figure D.
                                                                                                                                                                                                                                                   Figure D
  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 E below. 
  2. COGS Account: The assigned general ledger Cost of Goods Sold Account codes. See Figure E 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 E below.
  4. Returns Account: Here, the assigned general ledger Return Account codes are mentioned. See Figure E below. 
  5. Shrink Account: Enter the Shrink Account number. The stock discrepancies that occurred in this department, will be synchronized with your shrink accounting system.
  6. Adjustments Account: This column defines the assigned general ledger Adjustment Account codes. See Figure E below.
  7. Excise Account: Here, the assigned general ledger Excise Tax Account codes are mentioned. See Figure E below.                                                                                                                                                                                                                                                    Figure E

3. Report Type:

3.1: Department Codes: This report type displays the account with respect to department codes.
See Figure C above.
3.2: Vendor Codes: This report type shows the account # in relation to vendor codes. See Figure F.
                                                                                                                                                                               Figure F
3.3: Buydown Codes: This report type will show the account # in relation to the buydown codes.

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

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

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

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

                                                                       Figure K

4. Code Filters

                                                                                                                                                                                                                                                                            Figure L
  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 M below.


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

    • Related Articles

    • House Account Balance Report

      House Account Balance Report Overview Reports -> Sales Reports -> "House Account Balance" Regular customers who repeatedly buy products from the store but need to pay the total balance at the end of the month or at a specific time interval can be ...
    • Department Group List Report

      Department Group List Report Reports -> List Reports -> "Department Group List Report" Department groups are a collection of the different departments put into one group. This list report will bring the list of the department groups with assigned ...
    • Vendors List Report

      Vendors List Report Overview Vendors need to be set up in the system (Control Center) to order and receive items. This report lists all vendors and contact information. 1. Reaching the Vendors List Report To reach the Vendors List Report, follow the ...
    • Employee List Report

      Employee List Report Overview The "Employee List Report" shows the list of All, Active, and Former employees and other basic information that is needed to keep the employees' records in the system. You can also fetch an employee list report for a ...
    • Commission Items List Report

      Commission Items List Report Overview Commissions are a great way of adding a spiff to the specific item(s) and tracking it via reports and on the leaderboards within the point of sale. The "Commission Items List Report" shows all items on commission ...