AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Analytica...
Report P&L by depar...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Report P&L by department and location/segment using sub accounts

Acumatica Analytical Report Manager (Financial Report Writer)
Last Post by angeline 3 weeks ago
11 Posts
7 Users
2 Likes
2,065 Views
RSS
Danita Nixon
Posts: 13
 Danita Nixon
Topic starter
June 28, 2018 10:02 pm
(@danita-nixon)
Member
Joined: 5 years ago

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.

 

 

 

10 Replies
Shawn P Slavin
 Shawn P Slavin
(@shawn-p-slavin)
Joined: 3 years ago

Member
Posts: 196
June 28, 2018 10:18 pm
Reply toDanita NixonDanita Nixon

Can you provide an example of what you are trying to accomplish? 

Reply
Bodonna
 Bodonna
(@bodonna)
Joined: 5 years ago

Member
Posts: 27
June 29, 2018 10:49 am
Reply toDanita NixonDanita Nixon

Have you tried a unit set?

Reply
Danita Nixon
 Danita Nixon
(@danita-nixon)
Joined: 5 years ago

Member
Posts: 13
June 29, 2018 10:00 pm
Reply toBodonnaBodonna
Danita Nixon

I don't know how to use unit set. What is it all about?

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
June 28, 2018 11:00 pm
(@timrodman)
Member
Joined: 7 years ago

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?

Reply
Danita Nixon
 Danita Nixon
(@danita-nixon)
Joined: 5 years ago

Member
Posts: 13
June 29, 2018 10:06 pm
Reply toTim RodmanTim Rodman

Yes, I need separate columns by location, and rows by departments. Please see the format attached.

PL-by-location-and-department.xlsx

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
July 3, 2018 1:42 am
(@timrodman)
Member
Joined: 7 years ago

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?

Reply
JPvdG
 JPvdG
(@jpvdg)
Joined: 3 years ago

Member
Posts: 12
April 5, 2021 3:09 am
Reply toTim RodmanTim Rodman

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.

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 7 years ago

Member
Posts: 2957
May 15, 2021 7:13 pm
Reply toJPvdGJPvdG
Tim Rodman

@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.

Reply
davidhunter reacted
NickSM
Posts: 46
 NickSM
December 7, 2021 9:20 pm
(@nicksm)
Member
Joined: 3 years ago

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.

image
image

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.

Reply
Tim Rodman reacted
angeline
Posts: 1
 angeline
January 12, 2023 9:17 pm
(@angeline)
Member
Joined: 3 weeks ago

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.

PNLPROJECT BY SUBACCOUNT

.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 8 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×