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
Kim Deere
shared this idea
-
Aileen Asche
commented
I accidentally flagged this an inappropriate but that was by accident! I think this is very important to be able to import into Xero without having it hit the bank reconciliation lines. I want to be able to import all the payroll checks that were issued by paper check (entering as spend money transactions) without having to put in one by one. Then when the checks clear they would match to the bank feed or imported statement line. We can import so many other things... why not spend/receive money transactions?
-
Katja Curtis
commented
This is important in order to be able to import pre-payments from customers prior to conversion date. Currently I need to process these pre-payments manually in order for my Accounts Receivable conversion balance to be correct!
-
David Fowle
commented
Just to confirm Kim - the product idea here is to be able to import / bulk create ledger transactions in Xero? If so I whole heartedly agree and am surpirsed this is not already possible.
My use case: (we are a charity) If I have a receipt bank statement line of £10 this can be made up of multiple donations to different funds. Each of these donations can be extracted from Stripe or the donations software as a CSV - so I'd like to import that CSV into Xero to create the underlying transactions and thereby keep the fund balances correct but currently I have to manually create each transaction in Xero and then rec. -
Zev Hershkowitz
commented
This is very important for bank transactions that have to be split into multiple accounts.
I'm losing faith in Xero. Suddenly QuickBooks pricing seems justified.