Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. General Ledger Detailed report - Include vat rate instead of %

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    submitted  ·  1 comment  ·  For small businesses » Accounting features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    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.

    Gilbert Tan Chia Yong supported this idea  ·