Finance account integration

Available in Classic and VPC

In the Integrate Financial Account menu, you can view the deposit/withdrawal details, transaction history, and account balance of the bank that has been integrated through the Accounting Service > Manage Funds > Integrate Bank/Account menu. You can also view the details of errors from integration failure. Data of the integrated bank is imported through scraping and displayed in each menu.

Deposit Integration History

In Deposit Integration History, you can view the deposit history of integrated bank accounts. Deposits are specified as the Suspense receipt account by default, and you can manually select the account title. You can create a deposit slip with the deposit integration history, or map a related slip that already exists. Once created as a suspense receipt account, the deposit slip is cleared with accounts receivable. You can view it in the Accounting Service > Manage Receivable/Payable > Deposit Clearing menu.

The Deposit Integration History page is laid out as follows.

Bulk Specify Account Titles

You can bulk specify account titles by selecting integrated deposit history for which no deposit slips have been created.

The following describes how to bulk specify an account title.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Deposit Integration History menus in that order.
3. After selecting deposit history to which you want to bulk specify an account title, click the [Bulk Specify Account Title] button.
4. Select an account title you want to specify in bulk in the pop-up window, and click the [OK] button.
5. Click the [Save] button.
   • The account tile for the selected deposit integration history is specified in bulk.

Create Integrated Deposit Slip

The following describes how to create a new slip with integrated deposit history.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Deposit Integration History menus in that order.
3. Select the deposit history to creating a slip for, and then click the [Create Slip] button.
4. In the notification pop-up window, click the [Yes] button.
   • A slip is created for the applicable deposit integration history.

Map Existing Slip to Deposit History

The following describes how to map an existing related deposit slip to deposit details.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Deposit Integration History menus in that order.
3. Select the deposit details for mapping an accounting slip, and then click of the [Slip Number] column.
4. In the pop-up window for View Related Accounting Slips, set the slip date and other conditions to search for related deposit accounting slips.
5. Select an existing deposit slip to be mapped, and then click the [Save] button.
6. In the notification pop-up window, click the [Yes] button.
   • The existing slip is mapped to the applicable deposit integration history.

Download Deposit Integration History

The following describes how to download the deposit integration history as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Deposit Integration History menus in that order.
3. If necessary, enter the deposit integration conditions to be searched in the search window, and then click the [Search] button.
   • You can view the deposit integration history that applies to the entered conditions.
4. Click the [Download] button.
   • The deposit integration history is downloaded as an Excel file.

Withdrawal Integration History

In the Withdrawal Integration History menu, you can view the withdrawal details of an integrated bank account and map if there is a related withdrawal accounting slip.

The Withdrawal Integration History page is laid out as follows.

Map Existing Slip to Withdrawal History

The following describes how to map an existing related withdrawal slip to withdrawal history.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Withdrawal Integration History menus in that order.
3. Select the withdrawal details for mapping an accounting slip, and then click of the [Slip Number] column.
4. In the pop-up window for View Related Accounting Slips, set the slip date and other conditions to search for related withdrawal accounting slips.
5. Select an existing withdrawal slip to be mapped, and then click the [Save] button.
6. In the notification pop-up window, click the [OK] button.

Download Withdrawal Integration History

The following describes how to download the withdrawal integration history as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Withdrawal Integration History menus in that order.
3. If necessary, enter the withdrawal integration conditions to be searched in the search window, and then click the [Search] button.
   • You can view the withdrawal integration history that applies to the entered conditions.
4. Click the [Download] button.
   • The withdrawal integration history is downloaded as an Excel file.

View Transaction History of Integrated Account

In the View Transaction History of Integrated Account menu, you can view the deposit and withdrawal details of integrated bank accounts on one page.

The View Transaction History of Integrated Account page is laid out as follows.

Download Deposit and Withdrawal History

The following describes how to download the deposit and withdrawal history as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > View Transaction History of Integrated Accounts menus in that order.
3. If necessary, enter the transaction conditions to be searched in the search window, and then click the [Search] button.
   • You can view the deposit and withdrawal history that apply to the entered conditions.
4. Click the [Download] button.
   • The deposit and withdrawal history is downloaded as an Excel file.

Compare Account Balance

In the Compare Account Balance menu, you can view the account balance and slip balance of each integrated bank account as well as view the difference between balances.

The Compare Account Balance page is laid out as follows.

Download Account Balance History

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

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Compare Account Balance 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 account balance history is downloaded as an Excel file.

Integration Error Status

In the Integration Error Status menu, you can view the details of errors that occurred in the process of integrating with banks.

The Integration Error Status page is laid out as follows.

Download Integration Error List

The following describes how to download the list of integration errors as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the Integrate Financial Account > Integration Error Status menus in that order.
3. If necessary, enter the error conditions to be searched in the search window, and then click the [Search] button.
   • You can view the details of integration errors that apply to the entered conditions.
4. Click the [Download] button.
   • The list of integration errors is downloaded as an Excel file.