Symptom
You have observed that amount for G/L Account Service Input Tax Deferred differs in General ledger accounts view and Tax Trial Balance Report.
Reproducing the Issue
In order to check the Balance amount of the G/L Account Service Input Tax Deferred in General Ledger work Center, follow the below steps:
- Go to General Ledger Work Center.
- Go to General Ledger Accounts View.
- Search With All Accounts.
- Choose Advance Search.
- Enter General Ledger Account, Corresponding Company ID, Set of Books, Period, Fiscal Year.
You will observe that the GL Account balance for G/L Account Service Input Tax Deferred is XXX.
In order to check the Balance amount of the GL Account Service Input Tax Deferred in Tax-Trial balance Report, follow the below steps:
- Go to Business Analytics work Center.
- Go to Design Reports View.
- Open the Tax Trial Balance Report
- Enter Corresponding Company ID, Set of Books. Accounting Period and GL Account.
- Run the report.
You will observe that the GL Account balance for GL Account Service Input Tax Deferred in Trial balance is YYY.
Cause
Most likely Balance Carry Forward has not been done for previous Fiscal year and hence the GL Account balances are not similar.
If Balance Carry Forward has been done, you can check the Journal Entry type and Sub ledger Account Line Item type for the Journal entries corresponding to the GL Account.
Resolution
You can follow the below two options to resolve the issue:
1. Balance Carry Forward for previous Fiscal year has not been done. Please run the Balance Carry Forward for the previous year and run the Report.
2. In case Balance Carry Forward run has been done and you still observe difference in GL Account Balances, you can check the Journal Entry Type and Sub Ledger Account Line Item Type for the Journal entries corresponding to the GL Account through the following steps:
- Go to General Ledger Work Center.
- Go to Reports view.
- Go to List Sub view.
- Search with G/L Accounts-Line items
- Here for the G/L Account XYZ, you can add the following characteristics: Sub Ledger Account Line item Type: Manual Entered Account and Journal Entry Type is Data Migration.
Any manual posting tax entries directly in the General Ledger work center/ Data Migration entries entered will not be recognized by the tax register hence you see a difference in the trail balance report. You would have to manually add the tax items posted in the general ledger & data migration into the return forms for submission to the tax authority.
Keywords
KBA , SRD-FIN-GL , General Ledger , How To