Reports section

Once accounting data is processed in accounting modules, the user may be able to export the following reports:

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

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

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…)

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

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

Cash Flow:

Choose the required accounting period (From date…To date…)
Click “print” button to print and view the Report.

Chart of Account:

Click “Print” button to print the established chart of Account
Click Export to export chart of Account to excel file.

Daily Trial Balance:

Choose required period (From date…To date…)
Click “print” to print and view the Report.

Particulars of Manufacturing Cost Statement:

Choose the required accounting period (From date…To date…)
Click “print” to print and view the Report.

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.

General Journal

Choose the required accounting period (From date…To date…)
Click “print” to print and view the Report.

Print Voucher Accounting

Choose the required accounting period (From date…To date…)
Click print” button to print and view Report.

Daily Cash Balance

Choose the required accounting period (From date…To date…)
Choose the options
Click print” button to print and view Report.

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.

SmartBooks Windows Guideline