Solved

How to generate financial statements for different branches?

  • 10 November 2022
  • 6 replies
  • 257 views

Userlevel 4
Badge

Hi guys, 

I’ve configured my company with the type of “with branches requiring balancing”, as this is supposed to be the setting that allows each branch to have its own financial statements. But how can I generate BS and P&L report based on different branches? Here I could only choose a ledger.

Besides, is there any reports based on different subaccounts? If I use subaccounts to reflect departments and I want to see how much income every department generates, how should I do that? Thanks!

 

icon

Best answer by Laura02 11 November 2022, 15:30

View original

6 replies

Userlevel 7
Badge +16

HI @shuang57 

You would need to create a report for each Branch. Under Report Definitions, you can select which report and subaccount you want. You can create as many P&L and Balance Sheets as you need using the report definitions. 

 

Here is also the help on that:

https://help-2022r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=3ab2cb25-bcec-4a3e-b095-e4ce351875b5

Badge +18

Hello,

Consider using a Unit Set with your Balance Sheet. With the Unit Set, you can define the branch & company roll-ups, ownership -- what is reported separately and then rolled up together.

Unit Sets can also help you report by subaccounts.  I have answered the same question below in this community:

Good luck!

Userlevel 4
Badge

Thanks a lot @kbeatty21 @laura01 , now I know how to generate reports filtering branches and subaccounts. Another question about the report: it requires me to choose one and only one ledger. Is there any way I can choose more than one ledger and generate the combined financial statements of these 2 ledgers? For exemple, I’d llike to generate a Balance Sheet of the actual ledger and a statistical ledger, how do I do that?

Or an alternative solution could be: every time when I record a transaction in the actual ledger, the system automatically records it into a statistical ledger as well. But when I record a transaction in this statistical ledger, it won’t be recorded into the actual ledger. Is there any way to achieve this?

Thank you!

Badge +18

Hello,

You ask two questions, one is about reporting different ledgers and I’m answering that here. My recommendation for your second question about duplicating transactions in different ledgers is to start a new post.

I think reviewing the training on financial report design will help you.  We use DATA SOURCE to select a Ledger in a Row Set, in a Column Set, in a Unit Set, and/or in a Report.  You need to decide if you want a different Ledger row by row (then can be added together), or different ledger in each column (then can be added together in a new column), or different reports (which can roll up to be added together). Financial report is design is very flexible. 

 

Badge +18

@shuang57 ,

I’m connecting your Idea here so future  Acumaticans can find the response from Acumatica.

 

 

Userlevel 4
Badge

Thanks @laura01 , I tested your solution of reporting different ledgers and it worked perfect.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved