Hi. I've just joined this user group as my company has recently started using Xero for client book-keeping, with the intention of promoting it more widely to clients, primarily to replace Sage and Quickbooks.
I would like to see a facility to create journal entries that are repeating on, say, a monthly basis. This would be useful if, for example, a business is charged quarterly rent but would want it to feed into the P&L monthly. That would be possible by posting the invoice into a prepayment account and then having a monthly journal to move one third of the cost from the prepayement account to the Rent account in the P&L.
Is this facility in hand?
Tags:
Permalink Reply by David Kime on July 21, 2011 at 18:43
Permalink Reply by Catherine (Xero) on August 10, 2011 at 18:36 Primarily, we use recurring journals to smooth out costs that accrue monthly but may be invoiced irregularly, such as rent, rates, insurance, accountants' charges (where invoiced annually) staff bonuses etc. Given the better functionality of Xero in being able to show month by month profit and loss accounts, it helps to have such costs showing each month instead of every quarter or year. So the way to handle it is to have accrual or prepayment accounts set up for each of these items and to transfer a recurring journal from the accrual or prepayment account to the expense account. That would certainly result in a better reporting outcome, as expenses shown on the profit and loss accounts would be more consistent.
How about the facility to post a reversing journal. i.e flag it as reversing on posting which would mean it would automatically reverse on the 1st day of the next period.
As I understand you have to manually reverse journals now which is time consuming
Since day 1 of month end, reversing journals were used and continue to be used
Permalink Reply by Catherine (Xero) on September 14, 2011 at 1:10 ^ not the most helpful answer if I'm honest
No point in passing it on if its already on the list to do ?
There are many examples of where a recurring journal is extremely helpful...e.g. the above for rent which is paid quarterly, yearly insurance premiums, any payment for an expense which represents more than a month that it is necessary to spread the cost over the year (there are other posts giving examples above)
I hope that principal doesnt need to be explained to your development team Catherine and that someone in that team has worked in a accounting role and done more than one month end.
For those of us that have done more month ends than we care to remember, if we reported results without amortization of expenses to match income we wouldnt have a job
Suggesting to use invoices to achieve this is just daft
I'm pleased to hear that this topic has moved from "not on our radar"to the "to do list".
Your Customer Care team's suggestion wouldn't solve the problem. Taking a quarterly rent payable invoice for example, one would need to enter the invoice in full in order not to breach VAT integrity and one would use the invoice date as the entry date. That would oridnarily take that quarterly cost into the Rent account in P&L in one month, whereas it actually relates to costs over 3 months. You couldn't handle that with extra positive and negative lines in the invoice template as all entries there would have the same dates on them.
Permalink Reply by Catherine (Xero) on September 14, 2011 at 21:03
Permalink Reply by Catherine (Xero) on September 14, 2011 at 21:26 @ Braden - Yes. It's rather large and not something we're publishing as official as it can be rather changeable based on a variety of factors - we don't want to create false expectations and some items we might not do if they're really edge case or way outside the realm of an accounting product.
A good question though. We do track everything internally and we publish a list of a few things we're working on next at each release in the release notes. Also, based on the popularity of UserVoice for customers to record and request API features and integrations we're looking at how we might provide this for the Xero products in general - perhaps via our own forum site that we're working on. I take it you'd be keen to see such a list? Would it be daunting and make Xero look lacking if it was a really long list? Would customers be disappointed if an item was placed on the list a year ago and we hadn't implemented it? Just trying to work through what would be useful and able to be maintained.
Ledgerscope - for accountancy firms
Movemybooks - xero conversion tool
Topaccountants - blog on accountancy & tech
Receipt Bank - expenses management
Nativespace - value web hosting
CapsuleCRM - xero friendly CRM
Squarespace - for easy website creation
Rich Anderson replied to Rich Anderson's discussion Donation and Donor Management for Churches (or other non-profit)© 2012 Created by Adrian Pearson.
