Enhanced Journal Entry Report/ General Ledger Detail with Line-Level VAT Detail
Currently, VAT amounts from different line items are often consolidated into a single journal entry line. While this offers a simplified view, it makes it difficult to trace the origin of each VAT component—particularly when multiple expense categories are involved in a single transaction.
Although detailed VAT information can be sourced from the Sales Tax Report, Receivable Invoice Detail Report, and Payable Invoice Detail Report, it would be beneficial to have a report—or an optional view—within the General Ledger Detail that displays VAT on a line-by-line basis. This is especially relevant as VAT may also be recorded through manual journal entries, which are not captured in the invoice-based reports.
The current General Ledger Detail provides a wide range of filterable columns and is excellent for reporting purposes. However, its key limitation is that all VAT amounts are summed into a single line, which:
Obscures the link between VAT and specific transaction lines
Leads to inaccurate transaction counts
Makes reconciliation and audit review more complex
Introducing a more detailed VAT view in the General Ledger would also provide stronger support for jurisdictions that impose different VAT rates across categories, where accurate allocation and traceability are critical.
Gilbert Tan Chia Yong
shared this idea
Hi 👋 your idea is being looked into by our Community team. We will be in touch soon to update you once your idea has been reviewed.
