Question

Trial Balance Difference

IniNaadiJ
Rank
Userlevel 2
Badge +7

There is trial balance difference of 238,845.60 as at 1st April 2022. But as per 31st march 2022 TB is tallying. Auditors found few vouchers which tallies to the difference amount from the bank accounts.

 

Following scenarios were tested.

  • The doubtful vouchers correctly posted to the ledger.
  • Back end query executed for manual vouchers- It wont affect the difference
  • No transactions in  hold table 
  • Executed the preliminary year end and unable to complete it.
  • Back end query executed for difference in the voucher date and payment date for the cash account balance report and the GL balance report.- No transactions could find which has gone to wrong GL account.
  • Checked the summation of the GL balance analysis -Considered all the transaction types.

Please suggest me solution to find the difference.

 

11 replies

N
Rank
Userlevel 6
Badge +13

@IniNaadiJ 

Sorry -- it is a little difficult to understand issue based on information supplied. 

 

You mention preliminary year end -- so is 4/1/2022 1st period of the new year?   If so -- have you run the clear cost revenue? 

 

You mention:  Auditors found few vouchers which tallies to the difference amount --- assume these vouchers are posted to GL -- so not sure if they are really finding the difference.  

 

Have you run a query on GL voucher Rows for April to confirm net change equals balance analysis? 

 

You may need to log this as a support case so they can connect to the customer and review

 

R
Rank
Userlevel 1
Badge +3

 

 

R
Rank
Userlevel 1
Badge +3

 

 

IniNaadiJ
Rank
Userlevel 2
Badge +7

Hi Nancy,

Thanks for your reply. Yes, I did all the testing as mentioned above and yes TB balance difference is derived from the system not from any other source. 

Yes we run the GL balance and voucher analysis and did the investigation too.

Even preliminary year end process runs smoothly but there is no error message appears but voucher is not generating.

Any other way we can check to eliminate this TB difference. From march 31st to 1st April 2022 closing and opening balances not tallying. 

 

Regards

Naadira

A
Rank
Userlevel 7
Badge +16

Hello, 
If April 1st, 2022 is first day of your accounting year 2022 and final year end was not done yet, you can do analysis per account number in Balance analysis window:

  1. Do balance analysis by account only - for entire year 2021 - export to Excel. Check if total balance is zero
  2. Do balance analysis by account only - for period 0 year 2022 - export to Excel. Total balance is not zero, as per your message

Now in Excel you can compare balances. Most probably you will find account with balance in 2021 missing in period 0 of 2022 - of account type Cost, Revenue or Statistic. 

If problem is in cost or Revenue account - redo of Clearing Revenue/Cost Balances procedure followed by preliminary year end process will do the job.

In case of Statistic account, you should reclassify the balance with manual voucher to Assets or Liabilities.

Regards, Adam
IniNaadiJ
Rank
Userlevel 2
Badge +7

Dear Adam,

 

Thanks for the reply. Appreciate alot.

We did  this working and found out  2 bank Ac amounts not tallying. There is a difference between the Cash account balance analysis and GL balance analysis. So we investigated following things

  • The vouchers in different payment date and voucher dates
  • The doubtful vouchers correctly posted to the ledger.(Dr and Cr)
  • Back end query executed for manual vouchers- It wont affect the difference
  • No transactions in  hold table 
  • Executed the preliminary year end and unable to complete it.
  • Back end query executed for difference in the voucher date and payment date for the cash account balance report and the GL balance report.- No transactions could find which has gone to wrong GL account.
  • Checked the summation of the GL balance analysis -Considered all the transaction types.

Any other thing you would suggest?

A
Rank
Userlevel 7
Badge +16

Hello, Nadira,
I am sorry, but from your explanation I am not sure now where the problem is.

Is it discrepancy between Subledger (cash book) and General Ledger only or in GL between Closing Balance of March and Opening balance of April?

In case of the first one - Cash book balance should match cash book transactions, and cash transactions (PP1 postings) should match GL - on cash account no other postings than PP1 are expected.  

If you know SQL - I have prepared queries once comparing cash book balance and cash book transactions, but in my IFS version 7.5 we have Indian local Pack installed, so tax deductions are considered in the query. 

Perhaps you will find them usable.

 

1 Attachment
Regards, Adam
IniNaadiJ
Rank
Userlevel 2
Badge +7

Dear Bereda,

Thank you for your reply. 

Yes there is a difference in TB ( Closing balance not tallying with opening balance) And  we found the reasons as cash book balance and GL balance difference. Executed the above mentioned SQL  quires as well. 

Still couldn't rectify and tally the TB and run the year end that is the main concern. This is IFS app 8.

Is there any bug which prevents from doing the preliminary year end and not generating and error message. 

 

Regards

Naadira

A
Rank
Userlevel 7
Badge +16

Can you share your problem details in e.g. a Word document attached? Showing the difference?  Preliminary Year end transfers only balances of Assets and liabilities, and does not report any error if they are not balancing - this is normal. 
 

Regards, Adam
IniNaadiJ
Rank
Userlevel 2
Badge +7

Dear Bereda,

 

Attached herewith the workings document. Please advise.

 

Thanks for the support.

1 Attachment
A
Rank
Userlevel 7
Badge +16

Hi,
If I understood your document correctly, your cash book matches GL voucher rows (transactions) but you have discrepancy inside GL - between accounting balances and voucher rows - some voucher rows (doubtful vouchers probably) are updated in GL on opposite side (debit entry updated credit balance nd vice versa). 
There’s nothing you can do with that by regular system functions - data repair would be necessary, changing data in accounting_balance_tab to match total of corresponding GL voucher rows.. 
It should be normally subject of support case. 

Regards, Adam

Reply


Terms & ConditionsCookie settings