Workpapers - Option to split P&L into specific category workpapers
Profit distribution accounts might have an EXP in the report code (and Xero might force us to use Expenses as the account type in Xero).. but they're not expenses.
Xero has split Revenue, COGS and Expenses across three workpapers.. but still lumped profit distribution accounts in Expenses.
Sam Gray
shared this idea
Hi everyone, we appreciate the interest in the idea here.
We get how separating categories such as Revenue, COGS and Expenses could better support your practices review process.
This capability is now available in Workpapers Plus which is currently in early access. You can find out more and register your interest through our Xero Central page.
With Workpapers Plus you can create or edit a template, group relevant report codes into the categories your firm uses, and apply the template to new workpaper packs. Existing packs can be refreshed to apply updated mappings - See more on this here.
I'll round back to confirm once Workpapers Plus is fully released to all practices.
-
Stephen Healy
commented
If you're going to separate out the P&L into 5 different workpapers:
Revenue
Cost of Goods Sold
Expenses
Motor Vehicle Expenses
WagesPerhaps it might be better doing it this way:
Trading Statement - this includes trading revenue and cost of goods sold and showing a gross profit
Profit & Loss - this includes everything other then the trading statement and shows a Net Profit - perhaps with the gross profit included as a formula entry from the trading statement. So it might show other revenue that is not included in the trading statement (interest, profit on sale of assets etc)
I'm not sure what the purpose is of separating out something like Wages actually is - I suppose it's probably so you can have a separate checklist?
At the moment these workpapers are purely an indexing system as you don't have any actual workpapers in them - we are providing our own reconciled workpapers to attach or hyperlink too.
Until you have actual workpaper templates for us to use - separating out things like wages or motor vehicle expenses doesn't give us much.
I assume you've separated them out as these workpaper templates are being developed.