Monthy expense by GL/Subaccount

  • 9 August 2023
  • 5 replies

Userlevel 4

Where can I get amonthly GL expense and revenue report. I need it in the following format


Account Subaccount Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
4000 100-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 100
5000 125-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 500




Best answer by dcomerford 9 August 2023, 21:02

View original

5 replies

Userlevel 7
Badge +13

You would need to build a new ARM report you could use the Profit Loss P&L 12 month rolling to get some ideas on how to build it.

Userlevel 4

@dcomerford I’m new to building reports. How do I start and where?

Userlevel 7
Badge +13

There is some good training on the Acumatica site for this

Badge +18


I don’t think account and subaccount numbers can be printed side-by-side on a P & L designed using ARM.  (Acumatica Community, please correct me if I’m wrong.)

Please consider using the V elixo add-on to solve your question.  V elixo is an Excel add-in that reads Acumatica directly. Acumatica’s financial reports built using ARM (financial reports section of GL Preferences in Finance module) meet the needs of perhaps 90% of our clients. For those with more complex reporting needs, we recommend V elixo.


Userlevel 7
Badge +13

You can use the Datasource on the row set line to pick the Account, Group or Sub.and you can put these in the description box. So yes you would not get a column with the Account and Subaccount as they would both be in the column as the description but the monthly column values would be correct

I do agree @Laura02 Velixo is a more flexible tool



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