2092703 - G/L Account Balance Varies in General Ledger Accounts View and Tax - Trial Balance Report (FINTAXU03_Q0001)

The amount of G/L Account Service Input Tax Deferred differs in General Ledger Accounts view and Tax - Trial Balance report (Report ID FINTAXU03_Q0001).

SAP Business ByDesign

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:

1. Go to General Ledger Work Center.
2. Go to General Ledger Accounts View.
3. Search With All Accounts.
4. Choose Advance Search.
5. Enter General Ledger Account, Corresponding Company ID, Set of Books, Period, Fiscal Year.

Observe that the G/L Account balance for G/L Account Service Input Tax Deferred is XXX.

In order to check the Balance amount of the G/L Account Service Input Tax Deferred in Tax - Trial Balance report, follow the below steps:

1. Go to Business Analytics work Center.
2. Go to Design Reports View.
3. Open the Tax - Trial Balance report (Report ID FINTAXU03_Q0001).
4. Enter corresponding Company ID, Set of Books, Accounting Period and G/L Account.
5. Run the report.

Observe that the G/L Account balance for G/L Account Service Input Tax Deferred in Trial balance is YYY.

Most likely Balance Carry Forward has not been done for previous Fiscal year and hence the G/L Account balances are not similar.

If Balance Carry Forward has been done, the Journal Entry type and Sub ledger Account Line Item type for the Journal entries corresponding to the GL Account can be checked.

Follow the below two options to resolve the issue:

1. Balance Carry Forward for previous Fiscal year has not been done. Run the Balance Carry Forward for the previous year and run the report again.

2. In case Balance Carry Forward run has been done and differences in GL Account Balances are still observed, check the Journal Entry Type and Sub Ledger Account Line Item Type for the journal entries corresponding to the G/L Account through the following steps:

1. Go to General Ledger Work Center.
2. Go to Reports view.
3. Go to List Sub view.
4. Search with G/L Accounts-Line items.
5. Here for the G/L Account XYZ, 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 a difference in the Tax - Trial Balance report is seen. It's needed to manually add the tax items posted in the general ledger and data migration into the return forms for submission to the tax authority.

G/L Account Service Input Tax Deferred; Tax - Trial Balance report; FINTAXU03_Q0001; Balance Carry Forward; bcf; General Ledger Accounts , KBA , SRD-FIN-GL , General Ledger , How To