Skip to main content
Solved

Consolidation int the same tenant - 2 Ledgers in one within the same tenant


Hello !

My client use two differents ledgers.

The first one is for accounting and official purpose.

The second one is for estimation and subledgers corrections.  It doesn’t need to be published fot accounting autorities. 

 

I need to consolidate both into a third that would give the real position of the subaccount.

(Users would like to keep using the standard screens like GL401000 & GL404000 wich very convenient).

At first, I thought use consolidation feature but is there any possibilies to make it work within only only one tenant ? 

 

Thank for your help. 

Cécile

Best answer by Laura02

Hi,

I feel certain none of the standard screens combines figures from two Ledgers.

Velix o is likely another good option (Excel) - though not a free option.

Laura

View original
Did this topic help you find an answer to your question?

4 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • May 6, 2024

Hello,

To report ledgers summed together, try using ARM Financial Reports to create Balance Sheet, Income Statement/Profit & Loss, and/or Trial Balance style reports.

Financial Reports may have different ledgers in each column, with a Total column so you can see Accounting entries plus Estimations/Corrections = Real Position.

 

Your second and third columns will represent the Accounting and Estimation Ledgers. The last column will calculate the Total.

Laura


  • Author
  • Freshman II
  • 6 replies
  • May 7, 2024

Thanks @Laura02  for replying

 

I hipped avoiding to create special ARM and keep users in standards screen such as balance.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • May 7, 2024

Hi,

I feel certain none of the standard screens combines figures from two Ledgers.

Velix o is likely another good option (Excel) - though not a free option.

Laura


Forum|alt.badge.img
  • Freshman II
  • 44 replies
  • September 19, 2024

@Laura02 In relation to the subject above, I seek your advice. My client has one tenant and one company. They have created a reporting ledger and need to transfer all transactions from the actual ledger to the reporting ledger, specifically for the period from 08-2022 to 08-2023.

I attempted to use the consolidation feature by setting the reporting ledger as the consolidation ledger and the actual ledger as the source. I specified the start and end periods, then processed the "Import Consolidation Data." However, it returned with "no records to process."

Could you please guide me on how to correctly perform this transfer or identify what might have been missed in the process


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