Managing Funds

Available in Classic/VPC.

In the Manage Funds menu, you can add company accounts, or integrate with WORKPLACE and banks and register the account information to be managed if you're using Finance services. You can also view the transaction history and balance by bank account, and register the account information of each employee.

Manage Account

In the Manage Account menu, you can register and manage the company's account information. You can register an account by adding them individually or uploading information in bulk. After adding accounts, you can enter the account balance information by creating slips. You can also view the account balance entered or transaction history of the account.

The Manage Account page is laid out as follows.

Add New Bank Account

The following describes how to add an account.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Account menus, in that order.
3. Click the [Add] button.
4. Enter the account information.
   • Business Place: Select the business place of the account to add.
   • Account Type: Select the account type.
   • Deposit/Installment Savings Type: Select the account's deposit/installment savings type.
   • Bank: Select the bank. The option is available for selection if there are vendor(s) registered as "Bank" in the Manage Vendor menu. If there's no bank registered, then add one in Manage Vendor first.
   • Account Number: Enter the account information.
   • Currency: Select the currency.
   • Use Status: Set whether or not to use the account.
   • Enter the account's purpose, contract amount, interest rate, date opened, and remarks if necessary.
5. Click the [Save] button.

Delete Account

You can delete an account as follows.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Account menus, in that order.
3. Select the account information to delete, and then click the [Delete] button.
4. Click the [Save] button.

Account Bulk Upload

The following describes how to add accounts in bulk.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Account menus, in that order.
3. Click the [Upload] button.
4. Click the [Download Template File] button to download the template.
   • The downloaded template is saved as dpoSample.xlsx in the Download folder.
5. Fill out the template and save.
6. Click the [Attach File] button to upload the filled-in file.
7. Click the [Save] button.

Download Account Information.

The following describes how to download the account list as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Account menus, in that order.
3. If necessary, enter the conditions to search in the search window, and click the [Search] button.
   • You can view the account list that matches the entered conditions.
4. Click the [Download] button.
   • The downloaded file is saved as Manage Account_YYYYMMDD_hhmmss.xlsx in the Download folder.

Integrate with Bank/Account

In the Manage Standard Information > Manage Vendors menu, you can integrate the banks registered as vendors and enter the account information. You can scrape and read the deposit/withdrawal details, transaction history, and account data by integrating banks. The read data is displayed in the Link Finance Account menu when using the Finance services.

The Link Bank/Account page is laid out as follows.

Integrate with Bank

You can set for the data to be scraped in integration with banks. Bank integration is completed through the method of ID/password login authentication or the certification method. To use the certification method, see Manage Certificate and register the certification for finance accounts on WORKPLACE first.

The following describes how to integrate with banks for the data to be read.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.

2. Click the Manage Funds > Link Bank/Account menus, in that order.

3. Click the business place where the bank for integration belongs to, and then click the bank to be integrated.

   • Click the [Add Bank] button to add the bank to be integrated by specifying the vendor type as Bank in the Manage Vendors menu. (See Register Vendor)

4. Click Linkage Status to enable it.

5. Choose one of the following methods to proceed with integration.

   • ID/Password Method: Select ID/Password from Linkage Method, and then enter the ID and password of the bank login account.
   • Certification Method: Select Certification from Linkage Method, and then select the authentication for finance accounts to be used for integration (automatic selection when there is one authentication).
   Note

   A integration error may occur if the effective period of a authentication has expired or if it has been reissued. Check if the registered certification is valid, and then register it again in Admin > Manage Business Place > [Manage Certificate].

6. Click the [Link] button, and then click the [Yes] button in the Save pop-up window.

   • The integration settings are completed. You can add an account to the integrated bank and integrate the account with import data. (See Link Account)

Remove Bank Integration

The following describes how to remove the set integration.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > Link Bank/Account menus, in that order.
3. Click the business place to which the bank for integration belongs, and then click the bank to be removed from integration.
4. Click Linkage Status that is enabled, and then click the [Yes] button in the Save Linkage Removal pop-up window.
   • The integration of the applicable bank is removed.

Integrate with Account

You can add account information to the integrated bank and integrated with the added account. The transaction history is scraped and imported once the account is integrated.

The following describes how to add and integrate with account information.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > Link Bank/Account menus, in that order.
3. Click the business place where the integrated bank belongs to, and then click the bank for adding an account.
4. Click the [Add] button.
5. Enter the account information, purpose, contract amount, interest rate, and opening date.
6. Select Yes for the integration status, and then select Use for the use status.
7. Click the [Save] button, and then click the [Yes] button in the Notification pop-up window.
   • The account is added and the Linkage Status column is changed to Validity Test Required.
8. Select the added account, click the [Validity Test] button, and then click the [Yes] button in the notification pop-up window.
   • Use the entered authentication information of the finance account (ID/password, certification) to check the validity of the finance account to be integrated.
   • When the validity test is conducted, deposit/withdrawal details and balance information from 30 days before the current date to the present are scraped and provided.
   • Integration is completed after the validity test is performed. Deposit/withdrawal details, transaction history, and balance information are imported to WORKPLACE twice a day from the integrated bank account. You can view these details in the Accounting Service > Link Finance Account menus.
   • Bank Login Failed is displayed when you can't log in to a bank using the entered ID/password information or certification. In this case, check the ID/password or certification.

Modify Integrated Account

You can modify the information of an added account, change the integration status and use status, or delete the account.

The following describes how to view a integrated account and modify its details.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > Link Bank/Account menus, in that order.
3. Click the business place where the integrated bank belongs to, and then click the bank for modifying an account.
4. Perform the necessary tasks below in the list of accounts.
   • Modify Contents: Modify the necessary area of the account information.
   • Remove Integration: Change the Linkage Status to No.
   • Set as Not Use: Change the use status to Not Use.
   • Delete: Select the account to be deleted, click the [Delete] button, and then click the [Yes] button in the confirmation pop-up window.
5. Click the [Save] button.
   • The modifications are reflected.

View Transactions by Account

In the View Transactions by Account menu, you can check the transaction history, transaction slips, and total transaction amounts by account based on the deposit/withdrawal slip details approved on WORKPLACE.

The View Transactions by Account page is laid out as follows.

Download Transactions by Account

The following describes how to download the transaction history by account as an Excel file.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > View Transactions by Account menus, in that order.
3. If necessary, enter the transaction history conditions to be searched in the search window, and then click the [Search] button.
   • You can view the transactions that match the entered conditions.
4. Click the [Download] button.
   • The transaction history by account is downloaded as an Excel file.

View Balance by Account

You can check the balance of the previous day, balance of the day, and deposit/withdrawal details by account based on the deposit/withdrawal slip details approved on WORKPLACE.

The View Balance by Account page is laid out as follows.

Download Balance History by Account

The following describes how to download the balance history by account as an Excel file.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > View Balance by Account menus, in that order.
3. If necessary, enter the bank account conditions to be searched in the search window, and then click the [Search] button.
   • You can view the account balance that applies to the entered conditions.
4. Click the [Download] button.
   • The balance history by account is downloaded as an Excel file.

Manage Employee Account

In the Manage Employee Account menu, you can register the account information of each employee based on the employee information registered in the Member Service > Member > Manage Employees menus.

The Manage Employee Account page is laid out as follows.

Add Employee Accounts in Bulk

The following describes how to add the employee account information in bulk.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > Manage Employee Account menus, in that order.
3. Click the [Upload] button.
4. See the below and upload the employee list file in the Upload pop-up window.
   • [Download All Employees] Button: Downloads the information of all employees as a list.
   • [Download Unregistered Employees] Button: Downloads as a list only the employee information for which the bank or account information was not registered.
5. Enter the bank and account number in the Settlement Bank column and the Payment Account No. column, respectively, and then save the file.
   Caution

   Do not edit columns other than the Settlement Bank column and the Payment Account No. column.

6. Click the [Upload] button in the Upload pop-up window, and then upload the composed file.
7. Click the [OK] button, and then click the [OK] button in the notification pop-up window.
8. Click the [Refresh] button on the Manage Employee Account screen.

Download List of Employee Accounts

The following describes how to download the list of employee accounts.

1. In the WORKPLACE PC web page, click the [All Services] > [Accounting] button.
2. Click the Manage Funds > Manage Employee Account menus, in that order.
3. If necessary, enter the employee account conditions to be searched in the search window, and then click the [Search] button.
   • You can view the employee account information that matches the entered conditions.
4. Click the [Download] button.
   • The list of employee accounts is downloaded as an Excel file.

Daily/monthly Report on Funds

In the Daily/Monthly Report on Funds menu, you can view the company's funds status, such as cash, deposits, and savings balances as well as deposit/withdrawal history, on a daily or monthly basis.

The Daily/Monthly Report on Funds page is laid out as follows.

View Monthly Report

The following describes how to view the monthly report of the funds status by business place.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Daily/Monthly Report on Funds menus, in that order.
3. Select the business place and base month to be searched in the search window, and then click the [Search] button.
   • You can view the funds status that corresponds to the entered conditions.
4. Click the [View Monthly Report] button.
   
5. You can view the detailed cash holdings, deposit and installment savings account status, borrowings, and loans for the selected business place and base month.

View Daily Report

The following describes how to view the daily report of the funds status for the base month by business place.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Manage Daily/Monthly Report on Funds menus, in that order.
3. Select the business place and base month to be searched in the search window, and then click the [Search] button.
   • You can view the funds status that corresponds to the entered conditions.
4. From the date you want to view, click the [View] button of the Daily Report on Funds item.
   
5. You can view the detailed cash holdings for the day, deposit and installment savings account status, and the status of any withdrawals (scheduled) to be made that day.

Download Funds Status

The following describes how to download the list of employee accounts.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Manage Funds > Daily/Monthly Report on Funds menus, in that order.
3. Select the business place and base month to be searched in the search window, and then click the [Search] button.
   • You can view the funds status information that corresponds to the entered conditions.
4. Click the [Download] button.
   • The searched funds status list is downloaded as an Excel file.