Question

GL balance analysis differ from gl voucher rows analysis

  • 24 November 2023
  • 3 replies
  • 153 views
A
Rank
Badge +3
  • akna
  • Do Gooder (Employee)
  • 2 replies

I have an issue when reconciling Gl balance analysis with gl voucher rows analysis in 0 period.

Assume that, 

First perform finacial year end process and update gl vouchers

1. Goto GL balance analysis
2. Filter Account as 1470 & Code C as 1016 From Year 2023 To Year 2023 From Period 13 to period 13 Search
3. You can see balance as "63000" which is correct
4.In GL VOUCHER row analysis sum is "63000" which is correct (use same filters)

5.Now again go to gl balance analysis
6.Filter Account as 1470 & Code C as 1016 From Year 2024To Year 2024 From Period 0 to period 0 Search
7. Balance is 126000 which incorrect
8. If you use the same filters as previous step and go gl voucher rows analysis you can see balance as -63000 which is correct

So issue iswhen closing the accounting period period 13 will be carried forward to next year period 0 by double amount in gl balance analysis

3 replies

F
Rank
Userlevel 6
Badge +19

Hello,

There could be number of reasons GL balance is not matching GL voucher rows. And most of them are application design, if not a bug.

First thing come to my mind is final year end method you are using. If you complete final year end with option Transfer Year End Balances in this case IFS will update GL balance window for opening and closing periods. However, you will not have GL voucher rows created. If you want to have GL voucher rows created then you must select option Create Year End Vouchers.

 

 

The other option is Preliminary Year End. This will only update GL balance window but no transaction is created after this. 

One of the other option is archived vouchers. If you archive old vouchers they will be moved from GL voucher rows to Archived GL voucher rows window without any balance change to GL balance analysis.

Hope this helps

https://superp.solutions/
A
Rank
Badge +3

customer has rolled back closing accounting entries. but rolled back transactions has fetched by double amount. Do yo have any idea how to rectify it?

F
Rank
Userlevel 6
Badge +19

Hello @akna 

After rolling back year close, did you run preliminary year end? If not, please run it. After that balances should be corrected.

When you close the accounting year, select Create Year End Vouchers option and create closing vouchers. Once vouchers are created, update GL vouchers for both accounting years. 

 

https://superp.solutions/

Reply


Terms & ConditionsCookie settings