REPORTS | Financial Analysis Reports

Accounting Code

NO CUSTOMIZATION AVAILABLE

DEFINITION: The Accounting Code report displays transaction totals by accounting code during a transaction date range. It also shows the Account Balance payments.   

THIS REPORT SHOWS:

• Activity changes to the Account Receivable Balance.

• Displays detail or summary report views.

• No Customization available.

REPORT FILTER INFORMATION

• Transaction Date Range on or After and Transaction Date Range on or Before - are the date range to pull.

OR

• Includes Transactions On -  If you have placed a date in the above field, then this field request is not necessary, likewise if you choose a value here you must remove the dates from the preceding fields.  By clicking the down-arrow you can choose from the following:

• Request # Days

• Yesterday

• This Week

• Last Week

• This Month

• Last Month

AND

• Accounting Code Owner - your choice of search filter are:  (not all report filters will have all or any of these options)

• • Categories  - accounting codes can be entered for each category (these codes do not filter down the hierarchy structure).

  • Subcategories  - accounting codes can be entered for each subcategory (these codes do not filter down the hierarchy structure).

  • Courses/Course Series - accounting codes can be entered for each course and will filter down to corresponding classes.

  • • If an organization uses 'course series' as an option, Lumens uses the field name Course Series which is equal to Courses.

  • Class/Series Group -  when accounting codes filter down to classes, accounting codes are editable at the class level.

  • • If an organization uses 'course series' as an option, Lumens uses the field name Series Group which is equal to a Class.

  • Locations  - accounting codes can be entered for each location.

  • • The report will list all costs associated with location(s) when accounting code is applied to those costs.

• Accounting Code Owner (Programs)

• Program Section  - this feature is only available with the Lumens Workforce software program.  This feature will not work if found in another Lumen's program.

Accounting Code Owner can only be enabled by a Power User through System Options/Financial Policies

AND

• Report Type - Detail and Summary (samples are shown below)

AND

• Show Payment Method - Yes or No

Order by: these options as displayed below.

At the bottom of the report will be a reconciliation box.

.

Accounting codes are determined at the initial start when using Lumens. This decision is based on the institution's accounting practices. To initiate the accounting codes in Lumens, go to System Options, Financial Policies.  

Accounting codes are used for : Categories, Subcategories, Courses Classes, and Locations. These levels allow you to summarize money taken in (payments) verses money going out (refunds.  These levels allow you to control what levels you want to keep track of Accounting Codes.  Both Accounting Code and Revenue are reports that track accounting codes.

Because Lumens is not accounting software, the Accounting Code report is really designed to track the ‘cash flow’ that is the result of the Open Enrollment registrations and Customized training.  So in a way it equates to a revenue subsidiary journal.

The ‘Revenues/CR’ column represent dollars coming INTO the organization, because a ‘credit’ in a revenue account represents an increase. 

The ‘Expenses/DR’ column represents dollars going OUT of the organization, because a ‘debit’ in a revenue account represents a decrease.  So the Expense column represents dollars that are going out because of refunds, or it represents the ‘transfer out’ portion of a transfer.  It does NOT represent Class Costsl.  We have the ‘class cost’ fields in the software so they can be used in other reports for more in-depth data analysis, but they are not part of any financial reports.