1.5 Reports section
Once accounting data is processed in accounting modules, the user may be able to export the following reports:
a) Trial Balance
Choose the required accounting period (From date…To date…)
Select the currency unit (Currency ID).
Click Export to excel file if the user wishes to have a complete excel file.
Click preview if user wishes to see the sample before printing.
Select “print” button for printing directly
Select “Close” button to exit.
Details of Print Preview
View Trialbalance data on the data grid.
With data grid detail:
With accounts not in Account payable or account receiveable (131,331.) when double click will be show report
With Account payable and Account, receiveable (131,331.) will show summary receivable/ payable debts
Button
Print: Print trail balance
Export Excel: Export with the data grid format
Example: Export to excel with summary 331 ,131 - summary payable debts
1st Step: Double click on 131 Account >> Data grid will show summary payable debts
2nd Step: Click Export Excel button
b) Ledger Account Listing Summary Report
Choose the required accounting period (From date…To date…)
Select the currency unit (Currency ID).
Select accounts required to export (Option)
+ All
+ Account (hit F3 key to select account)
Click preview to check reports before printing.
Choose close to the exit.
Click export Excel button to export to excel file
Export to excel with option all Account
DOCSMAP sheet: List of all account detail reports
Can click into Account to links to sheets
With each detail sheet: click DOCSMAP ( Cell B10 ) to back to DOCSMAP Sheet
c) Ledger Account Listing Detail Report
Choose the required accounting period (From date…To date…)
Select the currency unit (Currency ID).
Select accounts required to export (Option)
+ All
+ Account (hit F3 key to select account)
Click preview to check reports before printing.
Choose close to exit.
Option: VND – USD: print and Export with currency VND and USD together
Click Export Excel button with the option
+ Full Report: Include Accounts detail, Trailbalace, Income statement
Balance sheet
Index sheet: List of Account and link to sheet detail
+ Main Account: Export to excel with main Account (Level 1: 111, 112…)
_ Trail Balance
_ Balance sheet
_ Income Statement
_ General account detail
_ Index DOCSMAP sheet: List of accounts same with General account detail name of sheets
+ VND-USD: Export reports with VNĐ and USD currency together.
+ Main Account: Export to excel with main Account (Level 1: 111, 112…)
d) Balance sheet:
Choose the required accounting period (From date…To date…)
Click export excel button if user wishes to export to excel file.
Click “preview” to check reports before printing.
Click “print” to print the Report.
Preview:
Options:
View Detail: Click “View Detail” button data grid will be changed to Detail with code amount from which account (debit or credit amount)
Export excel: Export to excel with option
Detail: check to checkbox >> export with detail data
Summary: uncheck to checkbox >> Export with normal data
Print: With data in data grid will have two Report
Detail
Summary
e) Income Statement:
Choose the required accounting period (From date…To date…)
Click export excel button if the user wishes to export to excel file.
Click preview to check reports before printing.
Click print to print and view the Report.
Preview:
Options:
View detail: same with the Balance sheet
Click View detail button: data grid will show detail code amount from which accounts Amount.
Export excel: Export to excel with option
Detail: check to checkbox >> export with detail data
Summary: uncheck to checkbox >> Export with normal data
Print: With data in data grid will have two Report
Detail
Summary
f) Cash Flow:
Choose the required accounting period (From date…To date…)
Click “print” button to print and view the Report.
g) Chart of Account:
Click “Print” button to print the established chart of Account
Click Export to export chart of Account to excel file.
h) Daily Trial Balance:
Choose required period (From date…To date…)
Click “print” to print and view the Report.
i) Particulars of Manufacturing Cost Statement:
Choose the required accounting period (From date…To date…)
Click “print” to print and view the Report.
j) Non-Manufacturing Cost Statement:
Choose the required accounting period (From date…To date…)
Choose another period for comparison (From date…To date...)
Click “print” button to print and view the Report.
k) General Journal
Choose the required accounting period (From date…To date…)
Click “print” to print and view the Report.
l) Print Voucher Accounting
Choose the required accounting period (From date…To date…)
Click print” button to print and view Report.
m) Daily Cash Balance
Choose the required accounting period (From date…To date…)
Choose the options
Click print” button to print and view Report.
n) Automatic Closing Entry
Choose the required accounting period to view automatic closing entries (From date…To date…)
Click print” button to print and view Report.
o) Cost of Goods Sold
Choose the required accounting period (From date…To date…)
Choose another period for comparison (From date…To date...)
Click print” button to print and view Report.
p) Business operation results from detail list
Choose the required accounting period (From date…To date...)
Choose another period for comparison (From date…To date...)
Click print” button to print and view Report.
q) Printing payment voucher
Choose from date … to date…
Click print” button to print and view Report.
r) Printing receipt voucher
Choose from date … to date…
Click print” button to print and view Report.
s) Trial Balance by period:
- Choose the required accounting period (From date…To date…)
- Click Export to excel file if the user wishes to have a complete excel file.
- Click preview if user wishes to see the sample before printing.
- Select “Close” button to exit.
t) Balance sheet by period
- Choose the required accounting period (From date…To date…)
- Click export excel button if user wishes to export to excel file.
- Click “preview” to check reports before printing.
- Preview:
Options:
- View detail: same with the Balance sheet
Click View detail button: data grid will show detail code amount from which accounts Amount
Export excel: Export to excel with option
u) Income Statement by period:
- Choose the required accounting period (From date…To date…)
- Click export excel button if the user wishes to export to excel file.
- Click preview to check reports before printing.
- Preview:
Options:
- View detail: same with the Balance sheet
Click View detail button: data grid will show detail code amount from which accounts Amount
Export excel: Export to excel with option.
Last updated