元帳の照会

このコンテンツは日本語をサポートしていません。

Available in Classic/VPC.

In the View Ledger menu, you can check the various ledgers for accounting work and download them as Excel files.

Journal

You can view the details of journal entries from transactions by business place.

The Ledger screen is laid out as follows.

Download List of Journal Entries

The following describes how to download the list of journal entries as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Ledger menus, in that order.
3. If necessary, enter the journal entry conditions to be searched in the search window, and then click the [Search] button.
   • You can view the list of journal entries that match the entered conditions.
4. Click the [Download] button.
   • The list of journal entries is downloaded as an Excel file.

Daily Trial Balance

You can view the transaction history by period based on the approved slip records. When you specify and search the business place and slip date, the debit and credit amounts of the applicable period are displayed by account title.

The Daily Trial Balance screen is laid out as follows.

Download List of Transaction History

The following describes how to download the list of transaction history records as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Daily Trial Balance 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 list of transaction history records that match the entered conditions.
4. Click the [Download] button.
   • The list of transaction history records is downloaded as an Excel file.

General Ledger

The general ledger includes items such as the income and expenditure of all accounts related to corporate accounting. In the General Ledger menu, you can create a general ledger to check the debit/credit amounts, balance, and accumulated amount of the accounting account title for the current year. The list of account titles is displayed when you search by specifying the business place, account title, and slip date. You can click each account title to check the amount.

The General Ledger screen is laid out as follows.

Download List of Amounts by Account Title

The following describes how to download the list of amounts by account title as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > General Ledger menus, in that order.
3. Enter the conditions of amounts by account title to be searched in the search window, and then click the [Search] button.
4. Click the account title for which the list will be downloaded.
5. Click the [Download] button.
   • The list of amounts by account title is downloaded as an Excel file.

Ledger by Account

You can view the transaction history by account title. The transaction history by account is displayed when you search by specifying the business place, account title, and slip date.

The Ledger by Account page is laid out as follows.

Download List of Transaction History by Account Title

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

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Ledger by Account menus, in that order.
3. Enter the conditions of transaction history by account title to be searched in the search window, and then click the [Search] button.
4. Click the [Download] button.
   • The list of transaction history records by account title is downloaded as an Excel file.

Ledger by Vendor

You can view the transaction history by vendor. The transaction history by account is displayed when you search by specifying the business place, slip date, and vendor.

The Ledger by Vendor screen is laid out as follows.

Download List of Transaction History by Vendor

The following describes how to download the list of transaction history records by vendor as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Ledger by Vendor menus, in that order.
3. Enter the conditions of transaction history by vendor to be searched in the search window, and then click the [Search] button.
4. Click the [Download] button.
   • The list of transaction history records by vendor is downloaded as an Excel file.

Account Balance by Vendor

You can view the debit/credit amounts, opening balance, and ending balance of each vendor by classifying them into account titles.

The Account Balance by Vendor screen is laid out as follows.

Download List of Account Balances by Vendor

The following describes how to download the list of account balances by vendor as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Account Balance by Vendor menus, in that order.
3. Enter the conditions of account balances by vendor to be searched in the search window, and then click the [Search] button.
4. Click the [Download] button.
   • The list of account balances by vendor is downloaded as an Excel file.

Statement by Management Item

You can view the journal entries by slip management item.

The Statement by Management Item screen is laid out as follows.

Download List of Journal Entries by Management Item

The following describes how to download the list of journal entries by management item as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Statement by Management Item menus, in that order.
3. If necessary, enter the conditions of journal entries by management item to be searched in the search window, and then click the [Search] button.
   • You can view the list of journal entries, by management item, that match the entered conditions.
4. Click the [Download] button.
   • The list of journal entries by management item is downloaded as an Excel file.

Status of Possessed Notes

You can view the notes owned by the company and edit the notes information. All account titles with the Info Page item set as Notes are displayed in addition to the note account provided by default on WORKPLACE.

The Status of Possessed Notes screen is laid out as follows.

Edit Notes Information

You can view the details of possessed notes and edit the note status, issuance date and issuer, maturity date, and remarks information.

The following describes how to edit the notes information.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Status of Possessed Notes menus, in that order.
3. Click the note number of the note to edit its information.
4. Change the note status by referring to the below.
   • Stored: notes that are stored without being replaced by cash and cash equivalents
   • Dishonored: notes that were processed as dishonored because they can't be received
   • Completed: notes that have been replaced by cash and cash equivalents, or dishonored notes that were processed as bad debt expense
5. Edit the issuance date, issuer, maturity date, and remarks information.
6. Click the [Save] button.

Download List of Possessed Notes

The following describes how to download the list of possessed notes as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Status of Possessed Notes menus, in that order.
3. If necessary, enter the possessed note conditions to be searched in the search window, and then click the [Search] button.
   • You can view the list of possessed notes that match the entered conditions.
4. Click the [Download] button.
   • The list of possessed notes is downloaded as an Excel file.

Receivables/Payables Status

You can view the receivables/payables status of the company based on the accounting slips registered with the receivable and payable account titles.

The Receivables/Payables Status screen is laid out as follows.

Download List of Receivables/Payables History

The following describes how to download the list of receivables/payables history records as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Receivables/Payables Status menus, in that order.
3. If necessary, enter the receivables/payables history to be searched in the search window, and then click the [Search] button.
   • You can view the list of receivables/payables history records that match the entered conditions.
4. Click the [Download] button.
   • The list of receivables/payables history records is downloaded as an Excel file.

Budget Usage Status

You can view the status of budgets used in the Accounting service.

This menu is displayed if you're using the Budget service and have set the budget usage status in the Accounting > Settings menu to Use.

The Budget Usage Status page is laid out as follows.

Download Budget Usage Status

The following describes how to download the budget usage status as an Excel file.

1. In the WORKPLACE PC web page, click the [Service Menu] > [Accounting] button.
2. Click the View Ledger > Budget Usage Status menus, in that order.
3. If necessary, enter the budget usage status history to be viewed in the search window, and then click the [Search] button.
   • You can view the budget usage status history that matches the entered condition.
4. Click the [Download] button.
   • The list of budget usage status is downloaded as an Excel file.