Settlement/Financial Statements

Available in Classic and VPC

In the Settlement/Financial Statements menu, you can process closing of each month, as well as check various financial statements displayed according to the set form.

Monthly Closing

You can close the designated month of the designated year or reopen a closed month. Once closed, you can't register or edit slips, purchase/sales data, and tax data of the month. You can no longer request business trip expense/family event expense/expense settlement.

The Monthly Closing page is laid out as follows.

Change Monthly Closing Status

The following describes how to change the monthly closing status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Monthly Closing menus, in that order.
3. Change the status of the month for which you want to change the closing status. If you want to change the closing status of all periods for the year, click the [Open All] or the [Close All] button.
4. Click the [Save] button.
5. In the Notification pop-up window, click the [Yes] button.
   • The monthly closing status is changed.

View Settlement Data

You can manage the usage status of the settlement procedure and view the settlement data.

The View Settlement Data page is laid out as follows.

Manage Settlement Procedure

The following describes how to manage settlement procedures.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Manage Settlement Procedure] button at the right of the page.
4. Select the business place from the pop-up window, and set the usage status of the settlement procedure you want to use.
   • Slip status is a settlement procedure that must be used, and its usage status can't be disabled.
5. Click the [Save] button.
   • The selected settlement procedures are displayed as tabs on the View Settlement Data page in order. You can click each tab to view the settlement data.

Slip Status

You can view the monthly number of slips and slip closing status for the specified business place and year.

The following describes how to view the slip status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Slip Status] tab.
4. Select the business place, year, and slip classification to search, and then click the [Search] button.
5. The monthly slip status of the selected business place and year is searched.

Download Slip Status

The following describes how to download slip status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Slip Status] tab.
3. Select the business place, fiscal year, and slip classification, and then click the [Search] button.
4. Click the [Download] button.
   • The slip status is downloaded as an Excel file.

Aggregate Expense

You can view the monthly processing history of accounts for general sales and management expenses based on slips.

The following describes how to view the expense aggregation status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Expense Aggregation] tab.
4. Click the [Manage Aggregation Account] button to set account titles to aggregate. (See Manage Aggregation Account)
5. Select the business place and accounting year and month, and then click the [Search] button.
6. The monthly expense aggregation status of the selected business place and period is searched.

Manage Expense Aggregation Account

The following describes how to manage expense aggregation accounts.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Manage Aggregation Account] button.
4. Click the [Add Aggregation Account] button from the pop-up window, and select account titles to add.
   • Account titles whose classification is "Expense" in the Manage Standard Information > Manage Title menu are displayed.
   • Click to delete account titles you're not using.
5. Click the [Save] button.

Download Expense Aggregation Status

The following describes how to download the expense aggregation status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Expense Aggregation] tab.
3. Select the business place and accounting year and month, and then click the [Search] button.
4. Click the [Download] button.
   • The expense aggregation status is downloaded as an Excel file.

Fixed Asset

You can view the closing and book status of fixed assets.

The following describes how to view the fixed asset status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Fixed Asset] tab.
4. Select the business place and accounting year and month, and then click the [Search] button.
5. The monthly fixed asset closing and book status are searched for the selected business place and period.

Download Fixed Asset Status

The following describes how to download the fixed asset status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Fixed Asset] tab.
3. Select the business place and accounting year and month, and then click the [Search] button.
4. Click the [Download] button of the content you want to download.
   • The fixed asset status is downloaded as an Excel file.

Aggregate Sales

You can aggregate and view the sales status.

The following describes how to view the sales aggregation status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Sales Aggregation] tab.
4. Click the [Manage Aggregation Account] button to set account titles to aggregate. (See Manage Sales Aggregation Account)
5. Select the business place, fiscal year and month, and classification, and click the [Search] button.
6. The monthly sales aggregation status of the selected business place and period is searched.

Manage Sales Aggregation Account

The following describes how to manage sales aggregation accounts.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Manage Aggregation Account] button.
4. Click the [Add Aggregation Account] button from the pop-up window, and select account titles to add.
   • Titles whose classification is "Expense" or "Purchase" in the Manage Standard Information > Manage Account Title menu are displayed.
   • Click to delete account titles you're not using.
5. Click the [Save] button.

Download Sales Aggregation Status

The following describes how to download the sales aggregation status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Sales Aggregation] tab.
3. Select the business place, fiscal year and month, and classification, and then click the [Search] button.
4. Click the [Download] button of the content you want to download.
   • The sales aggregation status is downloaded as an Excel file.

Receivable/Payable

You can view the receivable/payable aggregation history and create bad debt expense slips in the payable history.

The following describes how to view the receivable or payable aggregation status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > View Settlement Data menus, in that order.
3. Click the [Receivable/Payable] tab.
4. Click the [Manage Aggregation Account] button in the Receivable or Payable area to set account titles to aggregate. (See Manage Receivable/Payable Aggregation Account)
5. Select the business place and accounting year and month, and then click the [Search] button.
6. The occurrence history, clearing history, and balance of receivables and payables for the selected business place and period are searched.
   • You can create bad debt expense slips for the payable history. Click the [Create Bad Debt Expense Slip] button. (Create Bad Debt Expense Slip)
     • When searching closed periods, the [Create Bad Debt Expense Slip] button is deactivated, and only viewing is available.

Manage Receivable/Payable Aggregation Account

The following describes how to manage receivable/payable aggregation accounts.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Receivable/Payable] tab.
3. Click the [Manage Aggregation Account] button.
4. From the pop-up window, click the [Add Aggregation Account] button in the receivable/payable aggregation account management area, and select account titles to add.
   • Titles whose classification is "Receivable" or "Payable" in the Manage Standard Information > Manage Account Title menu are displayed.
   • Click to delete account titles you're not using.
5. Click the [Save] button.

Download Receivable/Payable Aggregation Status

The following describes how to download the receivable/payable aggregation status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Receivable/Payable] tab.
3. Select the business place and accounting year and month, and then click the [Search] button.
4. Click the [Download] button of the content you want to download.
   • The receivable/payable aggregation status is downloaded as an Excel file.

Create Bad Debt Expense Slip

The following describes how to create a bad debt expense slip.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Receivable/Payable] tab.
3. Select the business place and fiscal year and month, and then click the [Search] button.
4. Click the [Create Bad Debt Expense Slip] button in the receivables summary area.
5. Enter the content in the Create Bad Debt Expense Slip pop-up window, and then click the [Save] button.
   • Business Place: The selected business place is displayed.
   • Slip Date: Select the slip date.
   • Vendor: Select the vendor.
   • Debit (Bad Debt Expense)/Credit (Bad Debt Allowance): Enter the amounts.
   • Note: Enter notes.
6. Click the [Create Slip] button.
   • You can check the bad debt expense slip number from the receivables list. Also, created slips can be viewed from the Manage Slip > Create/View Slip page.

Other Adjustments

You can view the open slip processing status and create adjustment slips for the open history.

View Open Status

The following describes how to view the open slip status.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Other Adjustments] tab.
3. Select the business place and fiscal year and month, and then click the [Search] button.
4. The open slip status is searched.
   • You can click the number of open slips by account title to view open slips.

Other Settlement Adjustments

The following describes how to create an adjustment slip for other settlement history.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Other Adjustments] tab.
3. Click the [Manage Settlement Adjustment] button to add an adjustment account, and click the [Save] button.
   
   • From the Manage Settlement Adjustment pop-up window, click the [Add Adjustment Account] button.
   • Specify the account classification, debit, and credit for the adjustment slip you want to create.
   • Click to delete account titles you're not using.
4. You can view the slips aggregated for the debit/credit of the created adjustment account.
   • You can click the number of slips to view slips.
5. You can click the [Create Slip] button of the adjustment slip item to create a slip with the specified debit/credit. Enter the following fields in the pop-up window, and then click the [Create Slip] button.
   • Business Place: The selected business place is displayed.
   • Slip Date: Select the slip date.
   • Debit/Credit: Enter the amounts.
   • Enter notes. (E.g., 2022 settlement adjustment slip)

Download Other Adjustment Status

The following describes how to download other adjustment status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. From the Settlement/Financial Statements > View Settlement Data menu, click the [Other Adjustments] tab.
3. Select the business place and fiscal year and month, and then click the [Search] button.
4. Click the [Download] button above the list you want to download.
   • The open slip summary or other settlement adjustment summary is downloaded as an Excel file.

Compound Trial Balance

Through the compound trial balance, you can check the total debit and balance, and total credit and balance by amount classification. You can also check whether the total debit and total credit match up.

The Trial Balance Sheet of Total Balance page is laid out as follows.

Reaggregate Account Balance

The following describes how to reaggregate the account balance of the compound trial balance.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Compound Trial Balance menus, in that order.
3. Click the [Reaggregate Account Balance] button.
   • The account balance from reaggregation of the slips at the current point in time is displayed.

Download Compound Trial Balance

The following describes how to download the trial balance sheet of total balance as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Trial Balance Sheet of Total Balance menus, in that order.
3. Select the business place and accounting year and month, and then click the [Search] button.
4. Click the [Download] button.
   • The trial balance sheet of total balance is downloaded as an Excel file.

Statement of Financial Position

You can check the company's balance sheet. An external form to register in an external DART system and an internal form for internal accounting tasks are provided.

Check Statement of Financial Position for External Use

The following describes how to check the statement of financial position using the external form to register in an external DART system.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of Financial Position menus, in that order.
3. Select For External Use for type, select the business place and accounting year and month, and then click the [Search] button.

The Statement of Financial Position for External Use page is laid out as follows.

Carry Over Account Balance to Next Term

The following describes how to carry over the account balance of the statement of financial position to the next term.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of Financial Position menus, in that order.
3. Select For External Use from the type.
4. Click the [Carry Over to Next Term] button.
   • Select the fiscal year and month and business place in the Financial Statement Carry Over to Next Term pop-up window.
   • Click the [Confirm] button.
     • The account balance is carried over to the next term.
     • Once carryover to the next term is completed, you can view the statement of financial position for the next year, and the carried over account balance is displayed.

Check Statement of Financial Position for Internal Use

The following describes how to check the statement of financial position using the internal form for accounting tasks.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of Financial Position menus, in that order.
3. Select For Internal Use for type, select the business place, period, and accounting year and month, and then click the [Search] button.

The Statement of Financial Position for Internal Use page is laid out as follows.

Download Statement of Financial Position

The following describes how to download the statement of financial position as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of Financial Position menus, in that order.
3. Select For Internal Use or For External Use, enter the conditions of the statement of financial position to be displayed, and then click the [Search] button.
4. Click the [Download] button.
   • The statement of financial position is downloaded as an Excel file.

Income Statement

You can check and compare the profit and loss for the fiscal year selected through the income statement and the profit and loss for the same time of the previous year. An external form to register in an external DART system and an internal form for internal accounting tasks are provided.

Check Income Statement for External Use

The following describes how to check the income statement using the external form to register in an external DART system.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Income Statement menus, in that order.
3. Select For External Use for type, select the business place and accounting year and month, and then click the [Search] button.

The Income Statement for External Use page is laid out as follows.

Confirm Income Statement

The following describes how to finalize the income statement.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Income Statement menus, in that order.
3. Select For External Use from the type and select the business place and fiscal year and month, and then click the [Search] button.
4. Click the [Confirm Income Statement] button.
5. Check details in the confirmation pop-up window, and click the [OK] button.
   • Fiscal Year and Month: Select the fiscal year to be finalized in the income statement.
   • Business Place: Select the business place to be finalized in the income statement.

Check Income Statement for Internal Use

The following describes how to check the income statement using the internal form for accounting tasks.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Income Statement menus, in that order.
3. Select For Internal Use for type, select the business place, period, and accounting year and month, and then click the [Search] button.

The Income Statement for Internal Use page is laid out as follows.

Download Income Statement

The following describes how to download the income statement as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Income Statement menus, in that order.
3. Select For Internal Use or For External Use, enter the conditions of the income statement to be displayed, and then click the [Search] button.
4. Click the [Download] button.
   • The income statement is downloaded as an Excel file.

Statement of Changes in Equity

You can view the statement of changes in equity and create settlement slips.

Create Settlement Slip

The following describes how to create an retained earnings settlement slip for the current year.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of changes in equity menus, in that order.
3. Enter the conditions of retained earnings to be displayed and click the [Search] button.
4. Click the [Create Settlement Slip] button.
   • You can create the settlement slip after finalizing the income statement of the current year.
   • Once the settlement slip creation is completed, the settlement slip number, creation date and time, and the admin who created it are displayed at the top.
   • You can check the slip details by clicking the slip number.

Download Statement of Changes in Equity

The following describes how to download the statement of changes in equity as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Statement of Changes in Equity menus, in that order.
3. Enter the business place and year conditions and click the [Search] button.
4. Click the [Download] button.
   • The statement of changes in equity is downloaded as an Excel file.

Manage Financial Statement Form

You can edit the form of each financial statement. You can add new amount classifications for financial statements or edit and delete entered amount classifications for financial statements.

Add Classification

The following describes how to add new classification to be displayed in financial statements.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Manage Financial Statement Form menus, in that order.
3. Click the financial statement tab menu to add the classification from [Statement of Financial Position], [Income Statement], [Compound Trial Balance], and [Statement of Changes in Equity].
4. After selecting the parent classification to be added, click the [Add Classification] button under the Financial Statements tab.
   • A new classification and an input field are created in the selected classification list.
5. Enter details for the new classification as shown below, and then click the [Save] button.
   • Classification Name: Enter the classification name of the item.
     Click the [A] button to enter English, Japanese, or Chinese (Simplified) name.
   • Level: The level to display the classification in the financial statement.
   • Location: Select whether to enter the classification amount in the left column or right column of the financial statement.
   • Emphasize: If selected, the classification name is emphasized in the financial statement.
   • Usage: Select the usage status of the classification.
   • Form Type: Select the form type of the statement of financial position and income statement. Duplicate selection with other classifications is not available.
6. Click the [OK] button in the notification pop-up window, and click the added classification in the refreshed page.
7. Click the [Add] button above the account title list on the right side.
8. See Add Account and enter details of the account title.
9. Click the [Save] button, and then click the [Confirm] button in the notification pop-up window.

Edit Classification

The following describes how to edit classification details to be displayed in financial statements.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Manage Financial Statement Form menus, in that order.
3. Click the financial statement tab menu to be edited from [Statement of Financial Position], [Income Statement], [Compound Trial Balance], and [Statement of Changes in Equity].
4. Select the classification to be edited from the classification list, and edit details. (See Add Classification)
   Caution

   The entered content will disappear if you click another classification while editing.

5. Select the account title to be edited from the account title list on the right side of the classification list, and edit details. (See Add Account)
   • To delete all detailed classifications of the selected classification, see Delete Detailed Classification.
6. Click the [Save] button, and then click the [Confirm] button in the notification pop-up window.

Delete Classification

The following describes how to delete classification details to be displayed in financial statements.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Manage Financial Statement Form menus, in that order.
3. Click the financial statement tab menu to be edited from [Statement of Financial Position], [Income Statement], [Compound Trial Balance], and [Statement of Changes in Equity].
4. Select all classifications to be deleted from the classification list, and then click the [Delete] button.
5. Click the [Save] button, and then click the [Confirm] button in the notification pop-up window.

Add Account

The following describes how to add new classification to be displayed in financial statements.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Manage Financial Statement Form menus, in that order.
3. Click the financial statement tab menu to add the detailed classification from [Statement of Financial Position], [Income Statement], [Compound Trial Balance], and [Statement of Changes in Equity].
4. Click the classification from the classification list on the left.
5. Click the [Add] button from the detailed classification list.
6. Select a formula.
7. Select the account title by searching.
   • Only accounts whose Slip Entry field is selected from the Manage Standard Information > Manage Account Title menu are displayed.
   • Duplicated account titles can't be added.
   • Click the [Account Title Status] button to view the usage status of the account title.
   • [Delete]: To delete the added account title, select and click the [Delete] button.
8. Click the [Save] button.

Delete Detailed Classification

The following describes how to delete detailed classifications to be displayed in financial statements.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Settlement/Financial Statements > Manage Financial Statement Form menus, in that order.
3. Click the financial statement tab menu to be edited from [Statement of Financial Position], [Income Statement], [Compound Trial Balance], and [Statement of Changes in Equity].
4. Click the classification from the classification list.
5. Select all classifications to be deleted from the detailed classification list on the right, and then click the [Delete] button.
6. Click the [Save] button, and then click the [Confirm] button in the notification pop-up window.