xerousers.com

the independent online community for xero users

J Moore

Running balance on bank transactions & account transactions report required.

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.

Views: 40

Reply to This

Replies to This Discussion

Thanks for the suggestion - we've had a couple of queries about running balances so I will take your feedback to the team as well.

Depending on your need, there is one view of the bank account that contains balances,  the 'Bank Statement' tab in the bank account itself or on the Bank Reconciliation screen. This lists all the items that have been imported into Xero from your bank. This doesn't show items you've entered into Xero yourself.

Apologies for doubling up - I didn't realize you also posted this again in another category on this site - thanks to Cassandra for her help there.

Hi Catherine

Thanks for your reply.  It is the running balance on accounts not imported into Xero that are required.  Cassandra posting under the other category has been really kind and helpful, but it didn't resolve my problem.  So I also posted here as a wish list on Xero,  sorry if I wasn't supposed to do that!!

Meanwhile Running balances on account transaction reports is a must in the type of accounting messes I sort out for clients!!  It's a standard feature on the other accounting software I use and  I really miss it here.

At the moment the problem I'm trying to sort out is a error on the credit card bank account from 2011.  It appears the client has paid money from xero  bank into the credit card account that was not due.   I've requested all copy statements iro the credit card, but meantime just wanted to look at a running balance so I could tie down which month this started to go wrong in.

Any suggestions on how to proceed would help.

J

Ah, I see the tangle you're trying to sort out. Do you know if the client used the 'transfer' option to move the money from one account to the other in Xero? Whether a transfer or payment, depending on how they might've referenced it you could try a search in the bank account in Xero, perhaps for 'transfer' or look at the Detailed General Ledger Report in Excel to search and sort on different amounts, payees, references or the bank accounts.

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