Cash daybook, Bank daybook, General ledgerCash daybook, Bank daybook, General ledger
The Cash daybook outputs, by accounting category, the amounts and balances of the special accounting categories of bank deposits and cash, as standard amounts and as entry currencies.
The Bank daybook outputs the amounts and balances of the special types of bank deposits, by accounting category.
The general ledger organizes matching accounts, amounts, and balances of input data vouchers and outputs the standard amounts and matching currency, by category, and by chronological order.
It is possible to confirm the total amounts, balances, and postings of the journal entries.
For multi-currency accounting, this module outputs the amount in both Amt (SC) and the specified entry currency. After entering the conditions, click the " Start" button and a dialog box will appear for confirmation . Choose to output the data either as an Excel file or as a CSV file.
→To Operation Procedure
Screen Transition
[General Accounting Module]
[Output Condition] [Output Options] [Buttons]
↓
[Forms]
↓
[Cash Daybook], [Bank Daybook] or [General Ledger]
↓
[Cash daybook] screen, [Bank daybook] screen or [General ledger] screen
"Start" button → [Output destination] screen
Designating Output Condition
Enter the accounting categories (summary objects) that are to be included in the total. It is possible to include an accounting group in your entry.
Enter the sub accounts (summary objects) that are to be included in the total.
Choose one of the following: "None", "Department", "Correspondent", "Project code 1", "Project code", "Accounting analysis code 1", "Accounting analysis code 2", and "Description". Set the range of the item for each field that is input.
Select which order you want the sub total to be calculated by choosing either "Sub/Item" or "Item/Sub".
Selecting "Sub/Item" will result in totals by sub account and by items.
Selecting "Item/Sub" will result in totals by item and by sub accounts.
When no item is selected, the sub total is calculated by sub accounts.
Select this topic to specify the Journal data that are accounted in a selected currency as the summary object to be totaled. Selecting " All currency" will result in all currencies being totaled and output.
This function checks the data level of summary object.
When outputting data, if you want to use macros of
Microsoft Excel, you should specify the macro file and macro names.
Mark a check here if you want to include any unapproved vouchers as summary objects.
Mark a check here if you do not want to output the description.
If you click this button when you are selecting the name of a macro file, the file names will appear in tree format.
Click " Start" to open the [Output destination] screen. Click either " Excel Output" or " Create CSV" button to select the format for exporting the data.