Solved

General Ledger Normal vs Reversed

  • 19 January 2021
  • 4 replies
  • 86 views

Badge

We are used to “reversed” GL where liability and income accounts are shown as a negative and always thought this was normal.  Can anybody tell me if we change to reversed in GL preferences how we will be affected.  We went live on 11/1/2020 and would like to see reversed (normal to us).

Thanks in advance

 

Brian

icon

Best answer by meganfriesen37 20 January 2021, 00:44

Hi Brian,

One the main areas that this affects is how you import your opening trial balances from your historical system (see the section on Sign of Trial Balance on the GL Preferences help screen if this hasn’t been finalized yet: https://help-2020r2.acumatica.com/(W(12))/Help?ScreenId=ShowWiki&pageid=e4913d06-c511-4258-a0f9-f36c1b854e6b).  

The other thing to consider is your ARM (Financial) reports and how the system picks up these as positive or negative numbers.  See this article under “Formulas and the Sign of the Trial Balance” for more information:  https://help-2020r2.acumatica.com/(W(13))/Help?ScreenId=ShowWiki&pageid=fdb54c27-e494-4cf8-8fd8-7ce09ab7c79b

View original

4 replies

Userlevel 1
Badge +1

Hi Brian,

One the main areas that this affects is how you import your opening trial balances from your historical system (see the section on Sign of Trial Balance on the GL Preferences help screen if this hasn’t been finalized yet: https://help-2020r2.acumatica.com/(W(12))/Help?ScreenId=ShowWiki&pageid=e4913d06-c511-4258-a0f9-f36c1b854e6b).  

The other thing to consider is your ARM (Financial) reports and how the system picks up these as positive or negative numbers.  See this article under “Formulas and the Sign of the Trial Balance” for more information:  https://help-2020r2.acumatica.com/(W(13))/Help?ScreenId=ShowWiki&pageid=fdb54c27-e494-4cf8-8fd8-7ce09ab7c79b

Badge

Thank you Megan.  This was never brought up during implementation.  Implementation people should bring this up with new customers.

Hello Brian,

it is safe to change the sign of the Trial Balance from normal to reversed on the General Ledger Preferences (GL102000). After that, in GL reports and inquiries the credit balances of the liability and income accounts will be displayed as negative numbers. Your ARM reports will not be affected. 

If you have already uploaded the opening balances, you shouldn’t worry about signs you are using on the Trial Balance (GL303010) form.

Badge

Olga,

Thank you for your response.  That helps me.

 

Brian

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 — 2020  Acumatica, Inc. All rights reserved