General Ledger Detailed report - Include vat rate instead of %
It would be very useful to include on the General Ledger Detailed Report the VAT Rate instead of or as well as the VAT %. Then it would be possible to identify items that should be included in box 6 of the VAT return that have been entered with a No VAT code.
Matthew Ivey
shared this idea
-
Gilbert Tan Chia Yong
commented
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.