Skip to main content

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

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


Thanks @Laura02  for replying

 

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

 


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


@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