Consolidating Multiple Reports for Individual Branch

Hello,

I don’t think we can link multiple reports together, such as Balance Sheet followed by Income Statement followed by Cash Flow.

We can add a Unit Set containing all branches/roll-ups to a report and then use the Groups button to expand the Unit Set to the left side, and then Print All Branches at the same time.

Laura

Hello Brandon,

Absolutely, Acumatica offers robust functionalities for handling financial reports, including the capability to combine multiple financial statements for various entities like branches within a company. You can leverage the Report Designer and the Financial Report Writer in Acumatica to create, customize, and consolidate financial reports as per your requirement.  Remember, while setting this up, it’s crucial to have a clear understanding of the financial structure of your branches and how they roll up into the company’s overall financials. This ensures that the reports are not only well-organized but also accurately represent the financial performance and position of your branches as well as your company as a whole.

Here’s some more details on this topic:

1. Define Your Financial Reports:

   • First, ensure that each of your financial reports for the individual branches is defined and set up correctly in the system.  You can find more information on Report Definitions here: https://help-2022r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=3ab2cb25-bcec-4a3e-b095-e4ce351875b5
   • You can use the Financial Report Writer to customize these reports, including balance sheets, income statements, cash flow statements, etc., tailored to each branch.
     • Visit the Acumatica Open University to learn how to write Analytical reports: 
       https://openuni.acumatica.com/courses/reporting/f350-financials-analytical-reports/ 
       And for Report Designer:
       https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/

2. Consolidation Feature:

   • Acumatica provides a consolidation feature where you can combine financial data from multiple branches.
   • You can set up a consolidation unit for each branch and then consolidate these units into a single parent unit.
   • The system allows for adjustments and eliminations typically needed during consolidation.

3. Create a Report Packet:

   • Once your individual reports are ready and you have your consolidated figures, you can use the Report Designer to bundle these reports into a single packet.
   • Acumatica allows you to define a report set where you can include multiple reports. You can specify the order of the reports and set up the criteria for when each report should be included. We refer to these as sub-reports.
   • This packet can then be run with a single click, generating all the included reports in the sequence you’ve set. 

4. Automate and Distribute:

   • You can schedule these report packets to be generated at regular intervals automatically.
   • Furthermore, Acumatica supports distribution of reports via email or by saving them to a specific location in a format of your choice.

5. Security and Access Control:

   • Acumatica allows you to control who has access to these reports or packets, ensuring that sensitive financial data is only visible to authorized personnel.

6. Utilize Templates if Available:

   • Check if there are predefined templates in Acumatica that closely match your reporting needs. Templates or out of the box reports can significantly reduce the time required to set up your customized financial reports.

Here’s some other examples to your question from the community:
ARM Reports - Unit set by sub account Segment

Consolidated Financial Statements

If you need more detailed guidance or have specific requirements, I would recommend reaching out to your Acumatica support representative or a certified Acumatica consultant who can provide tailored assistance based on your business structure and reporting needs.

Feel free to ask if you have more questions or need further assistance!

Regards,

James

Quickest and easiest (but still not simple) if you want them emailed would be to use a Scheduled Business Event and add them to the Reports Attached by Report ID section of the email template. 

This way multiple reports would run and send as PDFs, this can be a little challenging to get all the parameters right and reports to look organized in a PDF. 

You can add various reports, ARM report and reports from the report designer.  

If they can all be built in report designer, then finding some kind of header table, such as Financial Period, then several sub reports as mentioned in #3 of James post.

If you want to organize them in groups, you can place them in multiple workspaces using the Site Map. 

So for example add a Workspace called Reports, then add a Section for each of your bundles or groups of reports. 

bryanb39 wrote:

Quickest and easiest (but still not simple) if you want them emailed would be to use a Scheduled Business Event and add them to the Reports Attached by Report ID section of the email template. 

This way multiple reports would run and send as PDFs, this can be a little challenging to get all the parameters right and reports to look organized in a PDF. 

You can add various reports, ARM report and reports from the report designer.  

If they can all be built in report designer, then finding some kind of header table, such as Financial Period, then several sub reports as mentioned in #3 of James post.

If you want to organize them in groups, you can place them in multiple workspaces using the Site Map. 

So for example add a Workspace called Reports, then add a Section for each of your bundles or groups of reports. 

 

I’m glad @bryanb39 jumped on here. He’s the go-to report guy for our company when anyone gets stuck and designed most of the reports we have at Redmond.  Scheduling these reports is a great tip. Another thought that Bryan may be able to expand more on is extracting the data from Acumatica and consolidating it into another tool like PowerBI… But that may be outside the scope of your original question. 😉 

Thank you for all the responses, it is great to be apart of a community that is willing to spend time to assist one and another! 

Please allow me to clarify my ask to better get to the root of the solution that I am looking for. I am trying to create a report group that pulls in the Balance Sheet, Income Statement, Trial Balance, and a Summary Trial Balance report for an individual branch. I would then need to run this “binder” for the 30+ branches. I did not see this feature within my business event scheduler, is there a path that you could provide that I can follow to be able to do this?

Warm regards,

Brandon McIlhargey

Hi @brandonm were you able to find a solution? Thank you!

Hello Chris,

I unfortunately did not find the solution that I was looking for and am still running 5+ different reports for all branches and them manually combining the PDFs. I put together this style of packet/binder for each individual branch. I was looking for a solution that would allow me to combine these reports and run them individually for all branches.      

Regards,

Brandon McIlhargey