Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Contacts - Supplier Statement "Detailed Ledger" (Running Balance Statement)

    29 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

    10 comments  ·  Purchase orders, bills & inventory » Paying bills  ·  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
    Gaining Support  ·  AdminSonal Pamnani (Admin, Xero) responded

    Hi Jasmine, thanks for sharing this idea with us. We can see why this would be helpful for some users. Currently, Xero offers the Supplier bill activity report and the contacts Activity statement. While this information is available on the account transaction report,it is not available in a Statement format. We've moved this idea to Gaining support so that other users who want this idea implemented can vote for it as well. You may share this idea with your colleagues to get more traction!

    An error occurred while saving the comment
    Ronald Miranda commented  · 

    Dear Xero Support Team,

    I would like to raise an important concern regarding the customer and supplier ledger reports in Xero.

    I find it quite difficult to reconcile customer and supplier accounts in Xero because the ledger does not provide a proper accounting format showing the **Debit, Credit, and Running Balance** columns. These details are very important for reconciling individual customer and supplier accounts with their monthly Statements of Account (SOA).

    At present, I am spending a considerable amount of time exporting or preparing separate customer and supplier ledgers in Excel in order to perform the reconciliation with the respective SOAs. This creates additional work and defeats the purpose of having an accounting system that should provide these basic ledger details directly.

    I kindly request Xero to consider providing a proper "Customer Ledger and Supplier Ledger" report with the following columns:

    * Date
    * Description
    * Reference / Invoice Number
    * Original Currency
    * Debit
    * Credit
    * Running Balance

    The report should ideally allow users to select a particular customer or supplier and a specific period, and then generate the complete ledger in a standard accounting format.

    This functionality would be extremely helpful for accountants and finance teams, particularly for monthly reconciliations, and would save a significant amount of time and manual Excel work.

    I request Xero to please review this matter and consider improving the reporting functionality by providing a proper customer and supplier ledger with detailed debit, credit, and running balance columns.

    I look forward to your response and hope Xero will consider implementing this useful feature.

    Thank you for your attention and support.

    Kind regards,
    Ronald Miranda