Trial balance sheet

The Trial balance sheet outputs, by the specified term or item, accruals and balances in a journal. It allows you to confirm the Dr/Cr balances of the last day of the selected term and the previous date. You can also confirm the accuracy of journals and posted contents (in general ledgers). For multi-currency accounting, the Trial balance sheet outputs the balances in both Amt (SC) and the specified entry currency. After entering the conditions, click the " Start" button and a confirmation dialog box will appear. Choose to output the data either an Excel file or as a CSV file.
→To Operation Procedure

Screen Transition

[General Accounting Module]
  ↓
[Forms]
  ↓
[Trial Balance Sheet]
  ↓
[Trial balance sheet] screen
    "Start" button → [Output destination] screen

Designating Output Conditions

[Output Conditions]

• Entry Date
• Items
  Choose one of the following: None, Select one from "None", "Department", "Correspondent", "Project Code 1", "Project Code", "Accounting Analysis Code 1", "Accounting Analysis Code 2", or "Detail Description". In the entry field, set the range of the selected item.
• Output Object: Include Unapproved
  Mark a check here if you want to include any unapproved vouchers as summary objects.
• Output Object: Output Sub A/C
  Mark a check here if you want to include sub A/C as summary objects.
• Std Currency, By Currency (shown only in Multi-Currency Accounting)
  Select an output object from "Std Currency" or "By Currency".
• Data Level
  Mark a check here in a data level as searching objects.
• Macro File, Macro
  When outputting data, if you want to use macros of Microsoft Excel, you should specify the macro file and macro names.

[Output Options]

• Include Unapproved
  Mark a check here if you want to include unapproved vouchers as summary objects.
• No Description
  Mark a check here if you do not need to output contents of description.

[Buttons]

• Browse
  If you click this button when you are selecting the name of a macro file, the file names will appear in tree format.
• Start
  Click " Start" to open the [Output Destination] screen. Click either " Excel Output" or " Create CSV" button to select the format for outputting the data.
• Clear
• Exit