2.5 Reports section
Common Buttons and Options on Payable Reports
When to use: Payable reports are used for vendor payable reconciliation, input VAT verification, and posted AP voucher review. Before printing/exporting, the user must select the correct period, account, and vendor to monitor.
Common Filter Conditions:
From Date / To Date: Date range for data retrieval.
Currency: Select VND or foreign currency; check VND-ALL to convert all amounts to VND.
Account: Select the payable/tax account to view, e.g., 331, 333, 338.
All / By Vendor: View all vendors or filter by a specific vendor.
Function Buttons:
View Grid: Load report data based on filter conditions.
Print: Print the report using template.
Export Excel: Export data for reconciliation, vendor communication, or archiving.
Close: Exit the report screen.
Operational Notes:
Reconcile the payable report against AP vouchers and payments before finalizing balances.
If figures do not match, check the Hold/Released status and accounting period of invoices and payments.
System validations on report viewing: Date range and filter conditions must be valid. Reports only reflect accurate data when vouchers have been fully posted.
Summary Account Ledger 331-338
When to use: To view summary balances and transactions of payable accounts (331 — Vendor Payable, 333 — Tax Payable, 334 — Employee Payable, 338 — Other Payables...) within a period.
Example: View total Debit/Credit balance of account 331 at end of Jan/2026 to determine the current total vendor payable.
To view the report, the user proceeds as follows:
Enter the date range in the From Date / To Date fields.
Select Currency (default VND); check VND-ALL to convert all foreign currency transactions to VND.
Select the Account to view within the payable account group.
Click View Grid to display the report.
Detailed Vendor Payment Ledger
When to use: To view detailed transactions for each vendor — for payable reconciliation and balance confirmation with vendors.
To view the report, the user proceeds as follows:
Enter the date range in the From Date / To Date fields, select Currency, and check VND-ALL to convert to VND.
Select the Account to view, then choose All vendors or filter By Vendor.
Click View Grid to display the report.
Overdue Account Payable Report
When to use: To monitor vendor payables that are past due — for cash flow management, payment prioritization, and avoiding late payment penalties.
Example: View vendor invoices overdue as of 31/01/2026, classified by number of days overdue (0-30, 31-60, 61-90, over 90 days).
To view the report, the user proceeds as follows:
Enter the tracking date for overdue payables, select Currency.
Choose All vendors or filter By Vendor.
Click View Grid to display the report.
Input VAT Declaration Schedule
When to use: To generate the input VAT declaration schedule as required by tax regulations — summarizing all purchase invoices with VAT within the period for tax filing.
To view the report, the user proceeds as follows:
Enter the date range in the From Date / To Date fields.
Click View Grid to display the report.
Vendor List
When to use: To print or export the complete list of vendors managed in the system — for audit purposes or record keeping.
Print Accounting Vouchers
When to use: To print accounting vouchers (posting documents) of the Account Payable module by date range — for accounting record keeping or attachment to source documents.
To print accounting vouchers, the user proceeds as follows:
Enter the date range in the From Date / To Date fields.
Click View Grid to display the report.
Last updated