Solved

General Ledger Normal vs Reversed

  • 19 January 2021
  • 5 replies
  • 438 views

Userlevel 2
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

View original

5 replies

Userlevel 3
Badge +1

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.

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

Userlevel 7
Badge +10

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

Userlevel 2
Badge

Olga,

Thank you for your response.  That helps me.

 

Brian

Userlevel 2
Badge

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

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