Report

This feature is available after applying for WORKS Finance.

You can view the consolidated settlement amount according to budgets and expense plans and check the expense trends by period as a chart. You can also check the usage status of corporate cards and verify the settlement status according to each classification standard.

View Consolidated Status of Expenses

You can check the settlement amount by budget item and settlement amount compared to the expense plan, verify settlement details, and inquire violation of audit items.

The View Consolidated Status of Expenses page is laid out as follows.

Area Description
① Search Window Search the expense status by expense attribution and period
② Download Download the list of expense status as an Excel file (See Download List of Consolidated Status of Expenses)
③ Expense status list Check the expense status in a list

  • Click ‘Affiliated’ in each row to check the organization chart and detailed information of employees
  • Click ‘Plan’ in each row to check the expense plan document
  • Click ‘Total’ in each row to check the expense settlement document
  • Click Audit Violations of Self Check in each row to go to the ‘Audit Item Violation > Expense Settlement Request’ tab. Click Request Explanation/Complete to go to the Manage Violations/Explanations menu to view details (See Manage Violations/Explanations)
  • Budget: It displays the allocated budget amount for the period and the value compared to the previous period (<Example> Increase or decrease compared to the previous month when viewing monthly)
  • Plan: It displays the expense plan amount requested and the value compared to the period (<Example> Increase or decrease compared to the previous month when viewing monthly)
  • Paid: Amount processed as paid in Accounting
  • If the budget usage or expense plan usage status is set to ‘N’ in the ‘Expense > Settings > Expense Settings’ menu, the budget column is not displayed in the View Consolidated Expense Status page.
  • An empty budget amount means there is no budget allocated.
  • If you enter a period to view, the comparison value (indicated as positive/negative) is not displayed because of difficulty in comparing with the past.

Download List of Consolidated Expense Status

The following describes how to download the list of consolidated expense status as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > View Consolidated Expense Status' from the menu.
  4. If necessary, enter the consolidated expense status condition to be viewed in the search window, and then click ‘Search’.
    • You can view the consolidated expense status that corresponds to the entered condition.
  5. Click 'Download'.
    • The list of consolidated expense status is downloaded as an Excel file.
The downloaded file is saved as TotalStcList.xlsx in the Download folder.

Expense Trends by Period

You can check the budget, expense plan, and settlement amount trends through charts and check the settlement trends according to the expense item.

The Expense Trends by Period page is laid out as follows.

Area Description
① Search Window Search expense trend charts by expense attribution and period
② Yearly Expense Amount It displays the yearly budget, expense plan, and settlement amount by monthly or quarterly charts

  • The month display follows the accounting settlement type value. If the settlement in December, months from January to December are displayed
  • If the budget is not used, the budget graph is not displayed
  • If the expense plan is not used, the plan graph is not displayed
③ Settlement Trends by Expense Item It displays the settlement amount of each expense item for each month

Integrated Card Usage Status

You can search and view the integrated card usage status by condition. You can check the monthly amount approved, settled, excluded from settlement, unsettled, and unavailable for settlement at a glance. You can also download the list of integrated card usage status as an Excel file.

The Integrated Card Usage Status page is laid out as follows. Select Year for period and search to check the status through View by Month or View by Quarter.

Area Description
① Amount Total It displays the total amount approved, settled, excluded from settlement, unsettled, and unavailable for settlement for the current month
② Search Window Search the corporate card usage history by card number and period

  • Select Year for the period and search to display the monthly card usage status
③ Download Download the list of corporate card usage status as an Excel file (See Download List of Integrated Card Usage Status)
④ List of Integrated Card Usage Status Check the monthly or quarterly corporate card usage status as a list

  • Click each amount to check the settlement document
  • Click the credit card company name to access the Manage Card menu
  • If a settlement history for a card deleted exists in the ‘Expense > Settings > Manage Card’ menu, the history is included, but the card is indicated as Deleted
  • If a settlement history for a card set to Not Use exists in the ‘Expense > Settings > Manage Card’ menu, the history is included, but the card is indicated as Not Used
If you set credit card company integration to ‘N’ in the ‘Expense > Settings > Expense Settings’ menu, this menu is not displayed.

Download List of Integrated Card Usage Status

The following describes how to download the list of integrated card usage status as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > Integrated Card Usage Status' from the menu.
  4. If necessary, enter the integrated card usage status to be viewed in the search window, and then click ‘Search’
    • You can view the integrated card usage status that corresponds to the entered condition.
  5. Click 'Download'.
    • The list of integrated card usage status is downloaded as an Excel file.
The downloaded file is saved as CardStcList.xlsx in the Download folder.

Settlement Status by Expense Item

You can search and view the settlement status by expense item according to condition. You can download the list of settlements by expense item as an Excel file.

The Settlement Status by Expense Item page is laid out as follows. Select ‘Year’ for the period and search to check the monthly or quarterly status. The Settlement Trends by Expense Item chart is displayed together.

Area Description
① Search Window Search the settlement history by expense item and period

  • Select Year for the period and search to display the monthly settlement status
② Download Download the list of settlements by expense item as an Excel file (See Download List of Settlements by Expense Item)
③ Settlement Trends by Expense Item It displays the settlement amount of each expense item for each month or quarter
④ List of settlements by expense item Check the settlement status of each expense item during the selected period as a list

  • Click each amount to check the expense settlement document

Download List of Settlements by Expense Item

The following describes how to download the list of settlements by expense item as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > Settlement Status by Expense Item' from the menu.
  4. If necessary, enter the settlement condition by expense item to be viewed in the search window, and then click ‘Search’.
    • You can view the settlement status by expense item that corresponds to the entered condition.
  5. Click 'Download'.
    • The list of settlements by expense item is downloaded as an Excel file.
The downloaded file is saved as itemStcList.xlsx in the Download folder.

Settlement Status by Affiliated Department

You can search and view the settlement status by affiliated department according to condition. You can download the list of settlement status by affiliated department as an Excel file.

The Settlement Status by Affiliated Department page is laid out as follows. Select Year for the period and search to check the monthly or quarterly status. The monthly settlement trends chart is displayed together.

Area Description
① Search Window Search the settlement history by affiliated department, period, and project code

  • Select Year for the period and search to display the monthly settlement status
② Download Download the list of settlements by affiliated department as an Excel file (See Download List of Settlements by Affiliated Department)
③ Settlement Trends by Month It displays the settlement amount of each affiliated department for each month or quarter
④ List of settlements by affiliated department Check the settlement status of each affiliated department during the selected period as a list

  • Click each amount to check the expense settlement document
  • Mark the department with the largest monthly settlement amount with ⑤

Download List of Settlements by Affiliated Department

The following describes how to download the list of settlements by affiliated department as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > Settlement Status by Affiliated Department' from the menu.
  4. If necessary, enter the settlement condition by affiliated department to be viewed in the search window, and then click ’Search’.
    • You can view the list of settlements by affiliated department that corresponds to the entered condition.
  5. Click 'Download'.
    • The list of settlements by affiliated department is downloaded as an Excel file.
      The downloaded file is saved as deptStcList.xlsx in the Download folder.

Settlement Status by Employee

You can check the settlement status of each applicant or participant. You can also search and view the settlement status by condition and download the list of settlement status by employee as an Excel file.

If you set credit card company integration to ‘N’ in the ‘Expense > Settings > Expense Settings’ menu, this menu is not displayed.

The Settlement Status by Employee page is laid out as follows. Select Year for period and search to check the status through View by Month or View by Quarter.

Area Description
① Content Tab Standard for viewing the settlement status by employee

  • Applicant: It displays the settlement status of each settlement applicant
  • Participant: It displays the settlement status of each settlement participant
② Search Window Search the settlement history by employee and period

  • Select Year for the period and search to display the monthly settlement status
③ Download Download the list of settlements by employee as an Excel file (See Download List of Settlement Status by Employee)
④ List of settlement status by employee Check the settlement status of each employee during the selected period in a list

  • Click the settlement applicant or participant name to check the detailed information of the employee
  • Click the total settlement amount to check the expense settlement document
  • When viewing the applicant by entering the period, click violation and explanation status of audit items in the Self Check column to check details (See Manage Violations/Explanations)
  • ⑤ is displayed for the employee with the largest monthly settlement amount
  • When viewing the applicant by year, is displayed for the month with audit violations

Download List of Settlement Status by Employee

The following describes how to download the list of settlement status by employee as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > Settlement Status by Employee' from the menu.
  4. If necessary, enter the settlement condition of each employee to be searched in the search window, and then click ‘Search’.
    • You can view the settlement status by employee that corresponds to the entered condition.
  5. Click 'Download'.
    • The list of settlements by employee is downloaded as an Excel file.
      The downloaded file is saved as prsnWrpList.xlsx in the Download folder.

Settlement Status by Project Code

You can view the settlement status by project and detailed expense item for expense settlements that used project codes. You can also download the list of settlement status by project code as an Excel file.

The Settlement Status by Project Code page is laid out as follows.

Area Description
① Search Window Search the settlement history based on project code, period, and expense item conditions
② Download Download the settlement list by project code as an Excel file (See Download Settlement Status by Project Code)
③ List of settlement status by project code View the settlement status of each project in the selected period in a list

  • Click the project code or code name to view the details and modification history for that project code
  • Click Count or Total settlement amount to view the expense settlement document

Download Settlement Status by Project Code

The following describes how to download the list of settlement status by project code as an Excel file.

  1. Click ‘Admin Menu’ at the top right of the PC web screen, and then click ‘Expense’ in the pop-up window.
  2. Click at the top left of the screen.
  3. Click 'Reports > Settlement Status by Project Code' from the menu.
  4. If necessary, enter the project, period, and settlement condition by expense item to be viewed in the search window, and then click ‘Search’.
    • You can view the settlement status by project code that corresponds to the entered condition.
  5. Click 'Download'.
    • The settlement list by project code is downloaded as an Excel file.
      The downloaded file is saved as StcProjectCode.xlsx in the Download folder.
Was this article helpful?
  • Yes
  • No
Sorry about that! Please tell us why.
  • The information provided in the guide is wrong.
  • The information is difficult to understand.
  • There is insufficient information on specific devices. (e.g. There is no explanation on Mobile.)
  • Other

How can we make it better?

Thank you for your feedback!