Automatic bank reconciliation beta

2 results found

1. Additonal source data upload for JAX

   Hi Xero team,

   I’m currently participating in the JAX Auto Bank Reconciliation beta and wanted to provide a use case that I would be very interested in working with the product team on.

   We operate caravan parks using Newbook as our property management system and Xero for accounting. Each day, Newbook produces transaction data representing the other side of the transactions that subsequently appear through our Xero bank feeds.

   The opportunity I see for JAX is to allow us to upload this Newbook transaction data and have JAX use it as an additional source when reconciling the bank feed.

   At the moment, the matching is not always a simple 1:1 relationship. A single bank transaction can relate to multiple Newbook transactions, and there can also be differences in descriptions, references and timing. As a result, a person currently needs to review the Newbook data and determine which transactions make up the amount appearing in the bank feed.

   This seems particularly well suited to JAX. Ideally, the workflow would be:

   Upload the day's Newbook transaction data into Xero.
   JAX considers that dataset alongside the bank-feed transactions.
   It identifies likely matches using amounts, dates, references/descriptions and previous reconciliation behaviour.
   Where a bank transaction comprises multiple Newbook transactions, JAX proposes the combination/allocation that reconciles to the bank amount.
   The user reviews and approves the proposed allocation, particularly where confidence is lower.

   In our case, this could potentially remove a significant amount of repetitive daily reconciliation work.

   I can provide anonymised examples containing the Newbook transaction data alongside the corresponding bank-feed transactions and the allocations we ultimately make in Xero. This could provide a useful real-world dataset for testing more complex matching and allocation scenarios.

   As I'm already participating in the beta, I'd be very happy to work directly with someone from the JAX/Auto Bank Reconciliation product team, provide examples and test iterations of this functionality if it is something you are currently developing.

   Please let me know the best way to get the examples to the appropriate product team.

   Regards,

   Stephen

   Hi Xero team,

   I’m currently participating in the JAX Auto Bank Reconciliation beta and wanted to provide a use case that I would be very interested in working with the product team on.

   We operate caravan parks using Newbook as our property management system and Xero for accounting. Each day, Newbook produces transaction data representing the other side of the transactions that subsequently appear through our Xero bank feeds.

   The opportunity I see for JAX is to allow us to upload this Newbook transaction data and have JAX use it as an additional source when reconciling the bank feed.

   At… more

   1 vote

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

2. Drag and upload remittances to match unreconciled payments instead of entering every invoice number into match payments.

   Our CRM has 2 way integration with Xero, was one of the reasons we chose that specific CRM.
   We received remittance advices for multiple payments all on the one invoice. Then manually have to match the invoice numbers for bulk payments.
   It would be useful to upload the remittance advice to that match payment and then auto select and match the invoices to the bulk payment

   1 vote

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂