By using this website, you agree to our Terms of Use (click here)
Prior to Acumatica in excel I was able to report the P&L by department i.e. operation, administration, finance etc. Also, I was able to report by location/segment on the same report. Currently, the sub account structure does include unique location and department numbers. I am able to generate the P&L by location, but I have to run it separtely using the start/end sub account parameters, but I will like these on the same report, and I am not able to create a report by department.
Any assistance is appreciated.
I agree with Shawn. Seeing an example built in Excel would be helpful. Sounds like maybe you want to see each department as a separate column?
Yes, I need separate columns by location, and rows by departments. Please see the format attached.
PL-by-location-and-department.xlsx
I agree with Bodonna that a Unit Set might be useful here.
But I'm still a little confused about your Account and Subaccount structure, especially the part that you wrote above where "the sub account structure does include unique location and department numbers."
Are the Location and Department built into the Subaccount?
Again somewhat disappointed with "out-the-box" reporting of Acumatica. Danita clearly has worked in the Finance Department and what is requested is normal standard reporting. Basically there are two views of a trail balance that rolls up into P&L & Balance Sheet
1) A view where you have a separate column for each department, and the totals of all the departments adds up to the total for the Company / Branch. Each line below is Sales, Cost of Sales, Expenses, Taxes etc. This will help gauge the performance of each department especially in terms of costs as some departments won't necessarily have a Sales and Cost of Sales line.
2) The second view is where you would be able to select a department, and then across each column heading have the main product groups, again with a total column that balances back to the Branch / Company Total Trial Balance and P&L & Balance sheet (but limited to that Department only). Each line below would again be Sales, Cost of Sales, Expenses, taxes etc. This will gauge the performance of the selected department in terms of its performance for various Product Group Lines.
I also would need these kinds of reports and I'm allowed 2 days (in budget) to develop such reports - otherwise it becomes unaffordable for the client. _ an Impossible task because of Acumatica's "incompleteness" (has great width, but no depth), and customisations that are required for most workable solutions (which should be standard). The costs of many customisations should be brought into account when purchasing Acumatica, because with these costs I'm not so sure that Acumatica is as affordable or priced competitively where other solutions already have these kinds of reports "out-of-the-box".
I think that the Sub account which Danita should have would be a department Code (3 characters) and perhaps a product group code (the next 3 characters).
Anyway - any ideas how to achieve these basic kinds of reports would be highly appreciated.
@jpvdg agreed. Sage Intacct handles financial reporting better than Acumatica. I think that's one reason why Velixo Reports is such a popular add-on.
Hi,
I was just on here looking for Company Group suggestions on report and thought I would answer this query.
If I'm not missing the context, I think this type Branch and Department reporting could be handled in the Rows section. You can use partial subaccount segment using '????' as wildcards. This is if you have the departments set up as sub-accounts though.
It then means you can Operating Expenses totals per Department in the rows area. I'm not sure if this is what is meant, however I thought I would comment.
Unit Sets are great but it means it wouldn't be on one report. I agree, doing this in other reporting addons is probably easier, but it's worth a try in ARM.
i need a report looks like above mentioned but i am using subaccount as department for p&l into a consolidated pnl. The below is sample of the excel file. How do we use Acumatica ARM to develop the report.
Appreciate to help me on this, the report look in such format.
.