Skip to main content
Solved

General Ledger Normal vs Reversed

  • January 19, 2021
  • 5 replies
  • 607 views

Forum|alt.badge.img

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

Best answer by meganfriesen37

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
Did this topic help you find an answer to your question?

5 replies

meganfriesen37
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 590 replies
  • Answer
  • January 19, 2021

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • January 21, 2021

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


Olga Anisimovich
Acumatica Moderator
Forum|alt.badge.img+1
  • Acumatica Product Manager
  • 35 replies
  • February 1, 2021

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.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • February 1, 2021

Olga,

Thank you for your response.  That helps me.

 

Brian


  • Freshman I
  • 6 replies
  • September 8, 2023

Hi,

I am not sure if this was answered

  1. Normal = displays Income and Liabilities as negative where the balance of these are positive. And displays positive where balance of these are negative. Therefore the Trial Balance report will NEVER balance. This is incorrect for South African auditors.
  2. Reversed = displays all balances as positive and negative (report for Income and Liabilities multiples by -1). This provides a balanced trial balance report.
  3. This is only applicable for the 4 Trial Balance reports, nothing else. The database and ARM reports are not affected by the Reverse setting. 

Good luck


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings