VAT summary sheet by taxable type, VAT detailed sheet by taxable type
The VAT summary sheet by taxable type outputs VAT trading journals with the summary by taxable type for the selected term. On the other hand, the VAT detailed sheet by taxable type outputs VAT trading journals with the summary by taxable type and detail for the selected term. For multi-currency accounting, the VAT summary sheet by taxable type and the VAT detailed sheet by taxable type output the balances in both Amt (SC) and entry currency. After entering your preferences, click the " Start" button and a dialog box will appear for confirmation. Choose to output the data either an Excel file or as a CSV file.
→To Operation Procedure
Screen Transition
[General Accounting Module]
↓
[Forms]
↓
[VAT Summary Sheet by Taxable Type] or [VAT Detailed Sheet by Taxable Type]
↓
[VAT summary sheet by taxable type] screen or [VAT detailed sheet by
taxable type] screen
"Start" button → [Output
destination] screen
Output Conditions Specification
[Output Conditions]
- Entry Date
- Output Object
Mark a check here if you want to include any unapproved vouchers as summary objects.
- Summary by Correspondent (shown only for VAT Summary Sheet by Taxable Type)
Mark a check here if you want to summarize taxes by correspondent.
- Currency (shown only in Multi-Currency Accounting)
Select a currency if you want to summarize the entered VAT tradings for the specified currency. By selecting "All Currencies", you can output the data in all currencies. Mark a check here if you want to see the tax summary by correspondent.
- Sub Total by Currency (shown only in Multi-Currency Accounting)
Mark a check here if you want to summarize sub total of tax by currency.
- Sort Order (shown only for VAT Detailed Sheet by Taxable Type)
Choose one of the following: "Entry Date", "A/C", or "Correspondent".
- 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 Export" or " Create CSV" button to select the format for exporting the data.
- Clear
- Exit