the independent online community for xero users

RUNNING BALANCE ON BANK TRANSACTIONS & ACCOUNT TRANSACTIONS REPORT REQUIRED.

Hi there

I can't find or see a way to get a list of the bank transactions with a running balance. Does anyone know a way to generate this type of report.

Whilst writing I also think that adding a runnning balance to the 'account transactions' report would be very helpful.

Any help any where would be appreciated.

Thanks

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Cassandra Scott on January 24, 2012 at 23:03

Hi J

Have you looked at Bank Account>Bank Reconciliation?

When you run this report, you have 3 tabs of information available

Bank Reconciliation Summary
Bank Statement
Statement Exceptions

If you select "Bank Statement", and set your date range, you will get a list of all bank transactions with a running balance.

Hope that helps

Cass

▶ Reply

Permalink Reply by J Moore on January 25, 2012 at 9:50

Thanks for the info, but the only info provided under this bank statements tab, includes the lines of imported date showing, start date: end date: start balance: end balance: . But the start balance and end balance are zero.

Am I doing this correctly?

Kind Regards

▶ Reply

Permalink Reply by Cassandra Scott on January 27, 2012 at 0:03

Hi J

hopefully this image will help you a little. If you click into the reconciliation report (as highlighted), there are three tab options. One of those is "Bank Statement", where you can get the information you are after.

▶ Reply

Permalink Reply by J Moore on January 27, 2012 at 10:02

Hi there,

Thanks for the info, this is very helpful. But as always I'm trying to do something not quite 'in the box' The above works on the normal bank account where I have imported a statement from the bank and is showing the info listed on that bank statement. I'm trying to reconcile a very old credit card bank account which appears to have gone wrong sometime last year!! I only have limited info from the client and need a running balance on the credit card account. However no statements have been imported so the method above doesn't work. Do you have any other ideas? Thanks for your kind help.