Skip to main content
Question

How can I set up a consolidated report

  • April 10, 2026
  • 1 reply
  • 25 views

How can I set up a consolidated report to eliminate intercompany transactions between Company A (Branch AA) and Company B? I attempted to use the Consolidation in Acumatica but couldn't get it to work. Any advice on what I might be missing? 

Thank you for your support!

1 reply

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 13, 2026

Hello,

You can configure a Balance Sheet or Income Statement with Eliminations using ARM reports (In Finance - Preferences section):

ARM Report Design screens

 In the Column Set, you will add at least one Eliminations Column.  The Eliminations column will include all Inter-company Due To/Due From Accounts. Alternatively, you could configure one Eliminations Column for Each Company.

Start Account includes all Due To/From Accounts on BS/Intercompany Sales/Expenses on IS)

Eliminations column may print or may be hidden.  Eliminations may be subtracted from the total of previous Columns, to produce a Company-wide balance sheet that does not include eliminations.

I hope this helps you. 

Laura