How do I get a list of bank transactions in Xero

I need a list of all bank transactions and where these have been booked

Didn't find your answer?

Xero support have advised that it is not possible to produce a report of all bank transactions and where they have been booked.  I need a report which has both sides of the double entry, so every bank transaction together with the account to which the receipt/payment has been reconciled for an accounting period.

Gary - please tell me this is not true, there must be a way to get a report, please would you advise?

Also when you go into bank transactions and a transaction has been reconciled, it says Reconciled next to it but it does not say to which account the transaction has been reconciled. Is there a quick way to check at a glance whether my client is reconciling to the correct accounts?

Thanks

 

Replies (5)

Please login or register to join the discussion.

Teignmouth
By Paul Scholes
03rd Dec 2016 16:05

Hi - Not an expert but I'd use the "Transactions" report, selecting all accounts and then in the Report settings not grouping and making sure the account column is chosen.

This gives you a report of all transactions where bank transactions are easy to ID in Excel.

Thanks (0)
avatar
By Matrix
04th Dec 2016 06:56

Thanks Paul, I must be missing something since I can't find any reports which give both sides of a double entry.

Would accountants who review how their clients have reconciled the bank please advise how they check this.

There must be an easy way to go into the bank and see where each transaction has been booked to check the client's bookings. When I go into the bank it just says Reconciled which is no use to me since I need to know where to.

Thanks (0)
avatar
By JKnight
04th Dec 2016 15:00

On the Bank Account> Account Transactions list if the description is "Payment: contact name" the bank transaction will have been allocated against a sales or purchase invoice. If the description is just "contact name" then these will be direct payments or receipts coded to one or more nominal accounts.

Reconciled means the transaction has been matched against an entry on a bank statement for that particular bank account. Though it is possible to manually flagged transactions as reconciled.

If the client is using bank rules the Cash Coding list will show the automatic postings Xero intends to make to unposted bank statement lines.

As suggested, you could use the Account Transactions report. You can apply a filter for Source to the report and get it to show just "spend money" and "receive money" transaction types. There is also the Cash Summary report which shows income and expenditure by nominal account. However, I don't think that report can be filtered by bank account.

Thanks (3)
avatar
By Matrix
09th Dec 2016 07:33

Thanks but this report does not show the other side of the double entry. How do I get a report of all receive money transactions and where they have been booked?

I have produced a journals report but it has thousands of entries, I just want to be able to readily verify how the receipts have been booked.

Thanks (0)
avatar
By jowest31
22nd Apr 2017 14:16

Yes it is possible to get both double entry for all transactions.Go to Bank Account then Account Transactions list and click Payment , if you then click account transactions there is then a drop down box, click that and your find it listed under double entry

Thanks (0)