Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Bank Reconciliation: Automatically recognise and remove duplicate statement lines

    6 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

    2 comments  ·  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
    Not in pipeline  ·  AdminKelly Munro (Community Manager, Xero) responded

    HI everyone, returning to the idea here we're going to move this to Not planned. However, we understand wanting to ensure the accuracy of your bank statements and reconciliations in Xero.

    As mentioned in my last update - Xero won't automatically delete duplicate statement lines for you, however you can run the Duplicate statement lines report to help identify and remove duplicates, so you can choose which of the statement lines in your bank account you'd like to keep and reconcile.

    There is also the Statement exceptions report in the Bank Reconciliation report pack that'll show where statement lines have been deleted in an account due to being a duplicate.

    An error occurred while saving the comment
    Svitlana Blyzniuk commented  · 

    Purpose:
    Remove duplicated transactions fetched from my bank and a paid invoice or Link my books.

    Problem:
    For expenses: every time I receive and invoice in Xero and pay it with my bank card, that is integrated to Xero account, I get transaction duplicated. For income: the same happens if Amazon pays to my bank card and Link My Books sends detailed brake down of this transaction to Xero.
    Then while reconciling such transactions the amount is duplicated, if I match the records and I should create Reconciliation adjustment, which if quite annoying.

    Solution:
    If it's possible, please add the ability to match transactions fetched from bank and Link my books or transaction fetched from bank and invoice paid in the system into one record.

    Svitlana Blyzniuk supported this idea  ·