Sub ledger

Sub Ledger outputs the accruals, balances, and match A/C in each sub A/C for the specific period, providing the result of sub/group total by sub A/C. You can confirm transaction details and balances of sub A/C. For multi-currency accounting, the amount will can be output in both Amt (SC) and the specified entry currency. After entering conditions, click the "Start" button and a confirmation dialog box will appear. Choose to output the data either as an Excel file or as a CSV file.
→To Operation Procedure

Screen Transition

[General Accounting Module]
  ↓
[Forms]
  ↓
[Sub Ledger]
  ↓
[Sub ledger] screen
    "Start" button → [Output destination] screen

Output Conditions specification

[Output Conditions]

• Entry Date
  Enter the date range to be output. The data can also be output even you enter a date of the prior year or next accounting year. If you enter a date from the next accounting year in both start date and end date, " Balance Carry-Forward" will be summarized, ranging in the next accounting year.
• A/C//Sub A/C
  Select "A/C" or "Sub A/C" as a summary object.
• A/C
  Enter A/C as summary objects. Only by selecting the " A/C" option button, you can proceed A/C range setting.
• Sub A/C
  Set the range of sub A/C as summary objects. By selecting the " sub A/C" option button, you can proceed the A/C range setting.
• Item1, Item 2
  Choose one of the following: " None" , " Department" , " Correspondent" , " Project Code 1" , " Project Code 2" , " Accounting Analysis Code 1" , " Accounting Analysis Code 2" , or " Detail Description" . In the entry field, set the range of the selected item.
  You cannot specify the same item in item 1 and item 2. Select " Department" or " Correspondent" in item 1 so that you can specify item 2.
  When you select the " Correspondent" item: On some A/C//Sub A/C whose balance setup by correspondent is off in [Register A/C property] , the system only outputs actual amount in a period, not outputting balance carry-forward by correspondent.
  
• Sub Total/Group Total Priority (shown only when the item is specified)
  Select "Sub A/C//Item" or " Item//Sub A/C" to decide the order of the summary displayed for sub total and group total.
  When " Sub A/C//Item" is selected, the system shows the summary of carry-forward balance and sub total by Sub A/C//Item1//Item2.
  When " Item//Sub A/C" is selected, the system shows the summary of carry-forward balance and sub total by Item1//Item2//Sub A/C.
  If any item is not specified, the system shows the summary of carry-forward balance and sub total by Sub A/C.
• Currency (shown only in multi-currency accounting)
  Select a currency if you want to summarize the entered journal data in the specified currency. By selecting " All Currencies" , you can output the date in all currencies.
• Data level
  Mark a check here in a data level as searching objects.
• Macro File, Macro
  If you want to apply macro in Microsoft Excel, specify a macro file and macro.

[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 the " Excel Output" button or the " Create CSV" button to specify output.
• Clear
• Exit