3.5 Reports section
Common Buttons and Options on Receivable Reports
When to use: Receivable reports are used for customer receivable monitoring, collection progress tracking, sales invoice review, and output VAT verification. The user must select the correct period, account, and customer before reconciliation.
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 receivable account to view, e.g., 131, 136, 138.
All / By Customer: View all customers or filter by a specific customer.
Function Buttons:
View Grid: Load report data based on filter conditions.
Print: Print the report using template.
Export Excel: Export data for reconciliation or archiving.
Close: Exit the report screen.
Operational Notes:
Reconcile the receivable report against AR invoices and receipts before finalizing balances.
If due dates are incorrect, verify the invoice date, payment terms, and allocated receipts.
System validations on report viewing: Date range and filter conditions must be valid. Reports only reflect accurate data when invoices and receipts have been fully posted.
Summary Ledger 131-138
When to use: To view summary balances and transactions of receivable accounts (131 — Customer Receivable, 136 — Internal Receivable, 138 — Other Receivables...) within a period.
Example: View total Debit balance of account 131 at end of Jan/2026 to determine the current total customer receivable.
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 receivable account group.
Click View Grid to display the report.
Customer Detailed Payment Ledger
When to use: To view detailed transactions for each customer — for receivable reconciliation, balance confirmation with customers, and collection progress monitoring.
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 customers or filter By Customer.
Click View Grid to display the report.
Receivable Aging Report
When to use: To monitor customer receivables approaching or past due — for collection follow-up, cash flow management, and bad debt risk assessment.
Example: View customer invoices due/overdue as of 31/01/2026, classified by number of days overdue for collection prioritization.
To view the report, the user proceeds as follows:
Enter the tracking date for due/overdue receivables, select Currency.
Choose All customers or filter By Customer.
Click View Grid to display the report.
Output VAT Declaration Schedule
When to use: To generate the output VAT declaration schedule as required by tax regulations — summarizing all sales 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.
Customer List
When to use: To print or export the complete list of customers managed in the system — for audit purposes or record keeping.
Print Accounting Vouchers
When to use: To print accounting vouchers (posting documents) of the Accounts Receivable 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