xerousers.com

the independent online community for xero users

J Moore

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

J.

Views: 29

Reply to This

Replies to This Discussion

Hi J

Have you looked at Bank Account>Bank Reconciliation?

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

  1. Bank Reconciliation Summary
  2. Bank Statement
  3. 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

HI

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

J

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.

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.

J

RSS

Recommended Services

Latest Activity

Profile Icon
Heather Smith replied to Michael's discussion 'Aus Tax Codes: The great No GST vs GST Exempt ambiguity'
Hey thanks to all contributors - yes I to am trying to get my head around No GST vs GST Exempt ... has there been any update from XERO Catherine... I understand copyright issues and using different terminology, but it seems a little bit too…
29 minutes ago
Profile Icon
Profile Icon
Kym replied to Kym's discussion 'Automated overdue invoice reminders and automated late fees'
hi chris "enables this functionality" which are you referring to we are looking for the ability to automatically assing late fees can't see it anywhere on your site that your service does aside from that we are happy wiyh debtor daddy…
3 hours ago
Profile Icon
Chris Hexton replied to Kym's discussion 'Automated overdue invoice reminders and automated late fees'
Hi all, we've launched invc.me which enables this functionality.  You can add invoices simply by signing up and sending them to 'invoices@invc.me'.  We take care of the rest.  It's easy to set automated reminders…
10 hours ago
Profile Icon
ThumbnailThumbnailThumbnailThumbnail
Chris Hexton, Ed Sanford, OrderHarmony Stock Control and 1 more joined xerousers.com 10 hours ago
Profile Icon
Maree Maxfield replied to Tim Wettone's discussion 'Recurring journal entries'
A repeating/reversing journal function is a fairly basic function of an Accounting system.  I would imagine that it will be Accountants rather than final users driving this request.  Accountants need this to provide meaningful management…
17 hours ago
Profile Icon

Fuzzy matching for reconciliation

Our bank (Raiffeisenbank) doesn't have a feed supported by Xero, so I hacked together a script that munges our bank statements (which we receive by email) into .qif files that Xero can import. I've been calculating the amount of each transaction by…See More
Discussion posted by Matthew Gertner 18 hours ago
Profile Icon
Discussions posted by David Kime 20 hours ago

© 2012   Created by Adrian Pearson.

Badges  |  Report an Issue  |  Terms of Service