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
    submitted  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi team, appreciate wanting to ensure the accuracy of your bank statements and reconciliations in Xero. While Xero won't automatically delete duplicate statement lines for you, you could run the Duplicate statement lines report to help you identify and remove duplicates. This means you can determine which of the statement lines in your bank account you'd like to keep and reconcile.

    The Statement exceptions report which is part of the Bank Reconciliation report pack will also 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  ·