Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Bank Reconciliation: Bulk import recieved payments

    31 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

    19 comments  ·  Banking & chart of accounts » Reconciliation  ·  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  ·  AdminKelly Munro (Community Manager, Xero) responded

    Thanks for sharing your feedback on this idea, everyone.

    We’ve recently introduced a feature that may help with some of the needs raised here, and we’d be really interested to hear whether it’s useful for your workflow.

    Many organisations now have access to Smart Document Capture, with the rollout still continuing across regions. This feature allows you to upload files into Xero, review the extracted information, and create transactions from those documents, including spend and receive money transactions.

    You may also find importing a pre-coded CSV bank statement helpful, particularly if your organisation doesn’t have a bank feed available.

    To be transparent, we don’t currently have plans to support importing received payments. That said, we’d encourage you to try these features and let us know here how they work for you, and whether there are still gaps for your use case.

    An error occurred while saving the comment
    To The Cent commented  · 

    Reading this thread was actually what convinced me to build in this space, so first: thank you all for describing the problem so precisely.

    I'm building ToTheCent, a matcher for exactly this workflow: upload the remittance (CSV, PDF, Excel, or the email itself), it pairs every line against your open AR invoices, including part-payments, item-level lines like Tom described, and the mangled references plan managers produce, shows the reason for every match, and the totals must prove out to the cent before anything would post.

    There are a couple of tools in this space now (Remittance Go posted above, and it looks solid), so here's what I'm offering that's different: I'm validating my matching engine on real-world files before finishing the Xero integration, and I'll do the work for you for free. Email one remittance (please redact names - references and amounts are all I need) plus an export of your open invoices to support@tothecent.app, and I'll send back a report within 48 hours showing exactly what matched, what needs review, and the time it would save. No signup, no obligation - worst case you get a free second opinion on a reconciliation.

    Tricia, if you're still doing 1,500 invoices a month by hand, I'd especially love to try one of yours.