Skip to main content

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

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


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.


Olga,

Thank you for your response.  That helps me.

 

Brian


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