Bank reconciliation - Import spend & receive money transactions
An import template for importing bank spend and receive money transactions. Now that Datadear is longer available for Xero clients as an app there is no way to import bank transactions

Hi everyone, we appreciate the support we've received through this idea. Without beating around the bush we don't have any short term plans for enabling the import of spend and receive money transactions. This may be something we look into further down the track so we'll continue to track and review the idea here.
For Xero Partners you could look to use the Conversion toolbox to import bank transactions for your clients.
-
Megan Giles commented
This would be very useful.
-
Alex Batty commented
Would be very useful and seriously improve efficiency.
-
Barry Conlon commented
This would be very useful.
-
Kyle Maitland commented
Very important
-
Laura Jackson commented
This would save a lot of time and make the use of Xero so much more efficient
-
Tony Ferguson commented
Very Important
-
Emma Hind commented
Very important
-
Natalie Bolton commented
Very useful for particular clients
-
Judith Story commented
We require the ability to import spend money transactions into Xero. We currently have these as a csv file from another piece of software but are unable to import these transactions. The transactions are a mixture of cheque and BACS payments and can be up to 120 per day. Please can this be added asap. As there are a number of cheques it is important that they are added at the date processed rather than the date they go through the bank account.
-
Susan McCraw commented
Most of the receive money bank transactions we receive; all get posted to the one account and we do not have invoices in Xero for them. It would be great if we could import a CSV file from our booking site into Xero for the receive money transactions.
-
Lydia Ng commented
We've many cash sales but no invoice is issued. It's time-saving if we can import the cash receipts as "receive money" transaction in bulk with csv file.
-
David Protheroe commented
We have cash sales on-line, which are converted outside Xero into .csv files. Currently I import them as invoices, even though the customer won't see the invoices, and then match them to the payment. It would be more efficient to import them as receive money transactions.
-
Oliver Yap commented
This would save countless hours and make the use of Xero so much more efficient
-
David Benady commented
It will really help to streamline postings, especially as when entering from the bank statement you cant easily enter a reference
-
Accounts Sister commented
Being able to import a spend money or recieve money would extremely helpful and save a lot of time. This feature is available on sage accounting, it should also be available in Xero.
-
Andrew Syme commented
There is and has been for many years an import tool for Spend / Receive Money in the Xero Conversion Toolbox.
https://conversiontoolbox.xero.com/Tool/ImportTransactions/ommdp
-
Kate Lawton commented
Exactly the same as other users. This would save 100s of hours of manual work for donations that we receive.
-
Stephen Briggs commented
This would save hundreds of hours of time.
We get thousands of donations monthly and currently manual data entry is the only thing that works given our reporting conditions for audit.
Please implement this!
-
Robert Gale commented
Seems a fundamental gap in capability of Xero.
Please add "Import Spend / Receive Money transactions with multiple lines into Xero" to list of requested product enhancements.
It would save a huge amount of work for a lot of people.
Thanks
-
Jannie Viljoen commented
It is critical as I did not import bank balance at the strart