Breaking

Search This Website

30/12/2018

How to Prepare & File Form GSTR-9C from Tally?

Did you like this article. Hit the like button
Friends today we discuss how to get data to prepare GSTR 9C from Tally. Last date of filing of GSTR 9C extend by department to 30th June 2018. This is basic tips to get the data to reconcile / prepare your Annual Return Form 9C.

So lets Start!

Use the transactional data from Tally.ERP 9 to file GST annual returns Form GSTR-9C. The information from return forms GSTR-1, GSTR-2, GSTR-3B, GSTR-9 and other registers provided in Tally.ERP 9 will help you to compute the values for GSTR-9C. Find the steps to extract this information and compute the value for annual returns given below:
To start with keep all the information on hand before initiating the filing process.

To get GSTR-1 details
  1. Go to Gateway of Tally - Display - Statutory Reports - GST - GSTR-1.
  2. Click F2: Period and change the period to 01-07-2017 to 31-03-2018.
  3. Resolve exceptions of all the transactions listed under Incomplete/Mismatch in information (to be resolved).
  4. Click F12: Configure and enable the option Show tax types in separate columns. This will display CGST, SGST, and IGST tax amounts in separate columns instead of combined value in a single column.
  5. Press Ctrl+E and select the option Excel GSTR-1 (Spreadsheet) in the Format field.
  6. Retain all other fields.
  7. Select the option All Vouchers in the Allow Export of field.
  8. Press Enter to export.
To get GSTR-2 details
  1. Go to Gateway of Tally - Display - Statutory Reports - GST - GSTR-2.
  2. Click F2: Period and change the period to 01-07-2017 to 31-03-2018.
  3. Resolve exceptions of all the transactions listed under Incomplete/Mismatch in information (to be resolved).
  4. Click F12: Configure and enable the option Show tax types in separate columns. This will display CGST, SGST, and IGST tax amounts in separate columns instead of combined value in a single column.
  5. Press Enter to view the report with new added columns.
To get GSTR-3B details
  1. Go to Gateway of Tally - Display - Statutory Reports - GST - GSTR-3B.
  2. Click F2: Period and change the period to 01-07-2017 to 31-03-2018.
  3. Resolve exceptions of all the transactions listed under Incomplete/Mismatch in information (to be resolved).
  4. Click F12: Configure and enable the option Show tax types in separate columns. This will display CGST, SGST, and IGST tax amounts in separate columns instead of combined value in a single column.
  5. Press Enter to view the report with new added columns.

To file GSTR-9 (Following is education purpose steps Form 9C -  Form 9 Not yet provided by Department till now)

  1. Log in to the GST portal.
  2. Click the Annual Returns option.
Different sections in GSTR-9 and the information recorded in them is described below:


Form GSTR-9C

Pt. I Basic Details


Field
Particulars
1
Financial Year
Displays the financial period for which the returns are being filed. It is 01-07-2017 to 31-03-2018.
2
GSTIN
Displays the GSTIN of the regular taxable person filing the annual returns. The GSTIN is recorded in the GSTIN/UIN field in the Company GST Details screen (F11 - F3 Set/alter GST details?).
3A
Legal Name
Displays the legal name of the company. This value is pre-filled on the portal.
3B
Trade Name (if any)
Displays the trade name of the company, if any. This value is pre-filled on the portal.
4
Are you liable to audit under any Act?
In case you are liable to be audited under income tax/statutory audit/ or of any other form of audit, set this field to Yes.

 

Pt. II Reconciliation of turnover declared in audited Annual Financial Statement with turnover declared in Annual Return (GSTR9)




Particulars
5
Reconciliation of Gross Turnover
A
Turnover (including exports) as per audited financial statements for the State / UT (For multi-GSTIN units under same PAN the turnover shall be derived from the audited Annual Financial Statement)
Displays the turnover as per the audited annual financial statements. To get this value go to Profit Loss A/c report in Tally.ERP 9 and change the period to April '17 to March '18. Add the values of Sales Accounts groups and Direct/indirect Income groups. Enter the sum of these values here.
Ensure that the value matches with the audited financial statement.
B
Unbilled revenue at the beginning of Financial Year
Displays the unbilled revenue in the last financial year books create on accrual basis and carried forward to current year.
To get this value go to Profit Loss A/c report in Tally.ERP 9 and change the period to April '17 to March '18. Select the ledger account created for unbilled revenue and press Enter to drill down. In the Ledger Monthly Summary screen, get the grand total of the Debit column.
C
Unadjusted advances at the end of the Financial Year
Displays the value of advances for which GST was paid but were not recognized as revenue during audit Financial Statement.
To get this value go to GSTR-1 report in Tally.ERP 9 and change the period to April '17 to March '18. Click View Return Format (if Summary View is displayed) to display the report in return format. Go to Amount unadjusted against supplies under Advance Receipts and drill down. Enter the total value of the column Unadjusted Advance in the Advance Receipts Summary report.
D
Deemed Supply under Schedule I
Displays the aggregate deemed supplies as per schedule I that are not included in the audited financial statement.
Get the sum of the values in the following:
a) Credit balance of fixed asset ledger for the return period.
b) Sales and income ledger transactions of account created for related party. Go to the ledger voucher report of this part, click F8: Columnar and select sales and income ledgers under Name of Account. Record values displayed for sales group ledgers and income group ledgers in the columnar report.
c) Value from transactions such as material out, stock transfer to third party godown, delivery note (not billed) recorded for transfer of material without consideration is recorded here.
In case the value is already reported in 5A, the same need not be reported here.
E
Credit Notes issued after the end of the financial year but reflected in the annual return
Displays the aggregate value of credit notes issued post 31st March for supplies from previous financial year. These credit notes should have been reflected in annual return Form GSTR-9.
You can get this value in two different ways:
First method, go to GSTR -1 report in Tally.ERP 9 and change the period to April '18 to September '18. Export the report to the GSTR-1 excel template. Open the exported data, check the sheets cdnr and cdnur. Filter for in the Document Type column. From the filtered list, identify the invoices with original invoice date from previous financial year. Enter the sum of invoice totals of all the credits identified.
If there are amendments to these transactions the value from the amended invoice should be considered. You will get the amendment details in the filed GSTR-1.
Second method, go to Gateway of Tally Display -Account Books Journal Register Credit Note Register. Drill down from any month and change the period to April '18 to September '18. Click F5: Columnar and enable the option Show voucher reference and date. In the columnar report, check the Voucher Ref. and Date column and identify the invoices with date from previous financial year. Enter the sum of gross total of all the identified credit notes.
F
Trade Discounts accounted for in the audited Annual Financial Statement but are not permissible under GST
Displays the trade discount accounted for in the audited financial statement, on which GST was leviable (being not permissible).
To get this value, go to Profit - Loss A/c in Tally.ERP 9 and change the period to Apr '17 to Mar '18. Identify the accounts created for trade discount and post-sale discount under the direct /indirect expense groups on which GST has not been reversed.
G
Turnover from April 2017 to June 2017
Displays the turnover included in the audited financial statement for April '17 to June '17.
Go to Profit - Loss A/c and change the period to Apr '17 to Jun '17. Identify all the accounts under Sales Accounts and Direct/indirect income groups. Enter the sum of closing balances of these groups.
H
Unbilled revenue at the end of Financial Year
Displays the unbilled revenue recorded in the books as per accrual basis in previous financial year and GST not payable in the same year.
To get this value, go to Profit - Loss A/c report in Tally.ERP 9 and change the period to Apr '17 to Mar '18. Select the account created for unbilled revenue and drill down. From the Ledger Monthly Summary report, enter the grand total of Credit column.
I
Unadjusted Advances at the beginning of the Financial Year
Displays the value of advances for which GST has not been paid but recognized as revenue in audited financial statement.
To get this value, go to Balance Sheet report in Tally.ERP 9 and change period to previous financial year. Check the groups Current Liabilities and Current Assets and identify the transactions recorded for advance receipt but does not have a corresponding sale. Enter the sum of values of all such advance receipts.
J
Credit notes accounted for in the audited Annual Financial Statement but are not permissible under GST
Displays the credit notes that are part of financial statement but not permitted under GST.
To get this value, go to Credit Note Register and change the period to return period. Identify transactions in which GST is not charged and entre the sum of these transactions.
K
Adjustments on account of supply of goods by SEZ units to DTA Units
Displays the aggregate value of supplies made by SEZs to Domestic Tariff Area (DTA) units for which bill of entry was filed by the buyer.
If you are a SEZ unit get this value from Sales Register. In the sales register identify the transactions made to DTA that have bill of entry details. Enter the sum of invoice totals of all such invoices.
L
Turnover for the period under composition scheme
Displays the turnover for which GST was paid by composition dealer at the time of opting out of composition scheme.
To get this value, go to Profit - Loss A/c and change the period to the time when registration type was Composition. Select Sales Accounts and Direct/Indirect Incomes groups. Enter the sum of the closing balances these groups.
This value should match the audited annual financial statement."
M
Adjustments in turnover under section 15 and rules thereunder
Displays the difference in turnover in annual returns (GSTR 9) and audited annual financial statement due to difference in valuation of supplies.
You have to compute this value manually, or get the value from Tally.ERP 9 if you have marked transactions with modifications using Narration or any other identifier. Enter the sum of values in such transactions.
Alternatively, go to GSTR-1 report and press Ctrl+A (Vch. Accepted as Valid).  Select Vouchers accepted with original values and drill down. In the Vouchers Accepted with Original Values report, press F12: Configure and select the options Taxable Value Modified and Taxable value/Rate modified in the Filter the vouchers by potential reason. Enter the sum of the values of the filtered transactions."
N
Adjustments in turnover due to foreign exchange fluctuations
Displays the forex gain/loss adjusted to the turnover in the return period. Get the forex gain/loss from the Profit - Loss A/c in Tally.ERP 9.
O
Adjustments in turnover due to reasons not listed above
Displays the difference in turnover in annual returns (GSTR 9) and audited annual financial statement due to reasons not listed above.
You have to compute this value manually, or get the value from Tally.ERP 9 if you have marked transactions such transactions using Narration or any other identifier.
P
Annual turnover after adjustments as above
Displays auto computed value.
Q
Turnover as declared in Annual Return (GSTR9)
Displays the annual turnover as displayed in annual return form GSTR-9. The turnover is recorded from 5N, 10 and 11 in the annual returns.
R
Un-Reconciled turnover (Q - P)
Displays auto computed value as the difference between Q and P.


Particulars
6
Reasons for Un - Reconciled difference in Annual Gross Turnover
A
Reason 1
Displays reason for mismatch between the annual turnover declared in the audited annual financial statement and turnover as declared in the annual return GSTR-9.
The reason should be towards the value in table 5R.
B
Reason 2
Displays another reason for mismatch between the annual turnover declared in the audited annual financial statement and turnover as declared in the annual return GSTR-9.
The reason should be towards the value in table 5R.
C
Reason 3
Displays another reason for mismatch between the annual turnover declared in the audited annual financial statement and turnover as declared in the annual return GSTR-9.
The reason should be towards the value in table 5R.


Particulars
7
Reconciliation of Taxable Turnover
A
Annual turnover after adjustments (from 5P above)
Displays the auto computed value and should be equal to 5P.
B
Value of Exempted, Nil Rated, Non-GST supplies, No-Supply turnover
Displays the net turnover of exempt, nil rated, non-GST and no-supply transactions.
To get this value, go to GSTR-1 report in Tally.ERP 9 and change the period to Jul '17 to Mar '18. Ensure that all exceptions are cleared. Click V: View Return Format to display the report in return format. Get the value from the table Nil Rated Invoices - 8A, 8B, 8C, 8D. Check if the invoices comprising the value have any amendments in the form of credit or debit notes. Enter the net value after considering the amendments.
C
Zero rated supplies without payment of tax
Displays the net value of zero rated supply, including supplies to SEZ, on which tax is not paid.
To get this value, go to the GSTR-1 excel template to which returns data was exported from Tally.ERP 9. In the b2b sheet, filter for SEZ without payment in the Invoice Type column. Check if there are any amendments to the list of transactions. Get the sum of aggregate values after considering amendments.
Also, in the exp sheet, filter for WOPAY in the Export type column. Check if there are any amendments to the list of filtered transaction. Get the sum of aggregate value after considering the amendments.
Enter the sum of the values computed in these two sheets.
D
Supplies on which tax is to be paid by the recipient on reverse charge basis
Displays the net value of reverse charge supplies on which tax is paid by the recipient.
To get this value, go to GSTR-1 excel template to which data was exported from Tally.ERP 9. Go to b2b sheet and filter for reverse charge transactions. Now, go to the cdnr sheet, compare the transactions with the original in b2b sheet. Enter the sum of the aggregate Taxable Value from the filtered reverse charge transactions.
E
Taxable turnover as per adjustments above (A-B-C-D)
Displays the difference between the annual turnover after adjustment declared in 7A and the sum of exempt, nil rated, non-gst, and reverse charge invoices declared in 7B, 7C, and 7D.
F
Taxable turnover as per liability declared in Annual Return (GSTR9)
Displays the annual turnover declared in annual returns table 4N.
G
Unreconciled taxable turnover (F-E)
Displays the auto calculated value, the difference between 7F and 7E.


Particulars
8
Reason for Un-Reconciled difference in taxable turnover
A
Reason 1
Displays the reason for the unreconciled taxable turnover declared in 7G.
B
Reason 2
Displays another reason for the unreconciled taxable turnover declared in 7G.
C
Reason 3
Displays further reason for the unreconciled taxable turnover declared in 7G.

Pt. III Reconciliation of tax paid


Particulars
9
Reconciliation of rate wise liability and amount payable thereon
A
5%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 5% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 5%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 5%.
B
5%(RC)
Displays the reconciliation of reverse charge tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 5% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Go to Reverse Charge Supplies section and enter the Taxable Value from the sales taxable at 5%.
Integrate tax, Central tax, State/UT tax, and Cess: From GSTR-1 report for the return period, go to Reverse Charge Supplies section and record the value from respective tax type column for sales taxable at 5%.
C
12%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 12% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 12%.
Integrate taxCentral taxState/UT tax and Cess : From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 12%.
D
12%(RC)
Displays the reconciliation of reverse charge tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 12% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Go to Reverse Charge Supplies section and record the Taxable Value from the sales taxable at 12%.
Integrate taxCentral taxState/UT tax and Cess : From GSTR-1 report for the return period, go to Reverse Charge Supplies section and record the value from respective tax type column for sales taxable at 12%.
E
18%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 18% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 18%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 18%.
F
18%(RC)
Displays the reconciliation of reverse charge tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 18% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Go to Reverse Charge Supplies section and record the Taxable Value from the sales taxable at 18%.
Integrate tax, Central tax, State/UT tax, and Cess: From GSTR-1 report for the return period, go to Reverse Charge Supplies section and record the value from respective tax type column for sales taxable at 18%.
G
28%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 28% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 28%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, record the value from respective tax type column for sales taxable at 28%.
H
28%(RC)
Displays the reconciliation of reverse charge tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 28% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Go to Reverse Charge Supplies section and enter the Taxable Value from the sales taxable at 28%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, go to Reverse Charge Supplies section and enter the value from respective tax type column for sales taxable at 28%.
I
3%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 3% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 3%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 3%.
J
0.25%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 0.25% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 0.25%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 0.25%.
K
0.10%
Displays the reconciliation of tax paid in reconciliation statement and tax paid as declared in annual return GSTR-9 for 0.10% tax rate.
Taxable Value: To get this value, go to GSTR-1 report and change the period to Jul '17 and Mar '18. Click V: View Summary to view the report in summary mode and click F1: Detailed. Enter the Taxable Value from the sales taxable at 0.10%.
Integrate taxCentral taxState/UT taxand Cess: From GSTR-1 report for the return period, enter the value from respective tax type column for sales taxable at 0.10%.
L
Interest
Displays the interest paid for each tax type for the annual period.
To get this value, identify the payment transactions recorded for tax paid to the department. Filter the transactions with ledger created for interest on tax payable. Enter the sum of such transactions tax type wise.
M
Late Fee
Displays the late fee paid for each tax type for the annual period.
To get this value, identify the payment transactions recorded for tax paid to the department. Filter the transactions with ledger created for late fee on tax payable. Enter the sum of such transactions tax type wise.
N
Penalty
Displays the penalty paid for each tax type for the annual period.
To get this value, identify the payment transactions recorded for tax paid to the department. Filter the transactions with ledger created for penalty on tax payable. Enter the sum of such transactions tax type wise.
O
Others
Displays the any other payment made to department for each tax type for the annual period.
To get this value, identify the payment transactions recorded for tax paid to the department. Filter the transactions with ledger created for any other payment made to department. Enter the sum of such transactions tax type wise.
P
Total amount to be paid as per tables above
Displays the auto calculated values as the sum of values from 9A to 9O.
Q
Total amount paid as declared in Annual Return (GSTR 9)
Displays the amount of tax payable as declared in table 9 of annual returns. It also includes the differential tax paid shown in table 10 and 11 of annual returns.
R
Un-reconciled payment of amount
Displays auto calculated value as the difference in amounts shown in Q - P.

Particulars
10
Reasons for un-reconciled payment of amount
A
Reason 1
Displays the reason for mismatch in tax shown the 9R.
B
Reason 2
Displays another reason for mismatch in tax shown the 9R.
C
Reason 3
Displays further reason for mismatch in tax shown the 9R.

Particulars
11
Additional amount payable but not paid (due to reasons specified under Tables 6,8 and 10 above)
5%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 5% rate.
12%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 12% rate.
18%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 18% rate.
28%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 28% rate.
3%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 3% rate.
0.25%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 0.25% rate.
0.10%
Displays the tax payable due to difference in audited financial statement and form GSTR-9 as per the reasons recorded in the sections 6, 8, and 10. Enter the Taxable Value and tax amount tax type wise for 0.10% rate.
Interest
Displays the interest payable due to difference in audited financial statement and GSTR-9.
Late Fee
Displays the late fee payable due to difference in audited financial statement and GSTR-9.
Penalty
Displays the penalty payable due to difference in audited financial statement and GSTR-9.
Others (please specify)
Displays the any other payable due to difference in audited financial statement and GSTR-9.

Pt. IV Reconciliation of Input Tax Credit (ITC)


Particulars
12
Reconciliation of Net Input Tax Credit (ITC)
A
ITC availed as per audited Annual Financial Statement for the State/UT (For multi-GSTIN units under same PAN this should be derived from books of accounts
Displays the ITC availed (after reversals) as per the audited Annual Financial Statement for all registrations under the PAN.
To get this value, identify tax ledger with debit balance in the audited financial statement. From this debit value, remove tax payments, reversal and other adjustments. Enter the balance as the ITC availed.
B
ITC booked in earlier Financial Years claimed in current Financial Year
Displays the ITC booked in the audited annual financial statement of previous year but availed in the ITC ledger in the current year. This includes transitional credit which was booked in past years but availed during the reporting period.
In Tally.ERP 9, go to ledger register of tax ledger (Gateway of Tally Display Account Books Ledger - select the tax ledger), filter for journal vouchers recorded with Transitional Credit journal flag or filter for vouchers using other identifier such as Tran-I in Narration field, if recorded. Enter the sum of credit values in the filtered transactions.
Alternatively, you can get these values from GSTN Portal. Login to the portal, go to Ledgers section and select Electronic Credit Ledger. Select the transactions with description as Transitional Cenvat /VAT Credit. Enter the value from these transactions.
C
ITC booked in current Financial Year to be claimed in subsequent Financial Years
Displays the return period ITC claimed in current year.
To get this value, go to Profit - Loss A/c and drill down from Purchases group to the Voucher Register lever for each ledger in the group. Change the period to return period, identify the transactions for which ITC was not claimed and it was availed in current year. Similarly, get the values for all ledgers in Expenses group. Enter the sum of ITC from all such transactions.
D
ITC availed as per audited financial statements or books of account
Displays the auto calculated value based on the values declared in 12A, 12B and 12C.
E
ITC claimed in Annual Return (GSTR9)
Displays the net ITC available as declared in annual returns GSTR-9.
F
Un-reconciled ITC
Displays auto calculated value as the difference of values in E - D.

Particulars
13
Reasons for un-reconciled difference in ITC
A
Reason 1
Displays the reason for mismatch in ITC as per audited annual statements of the reporting period as declared in 12F.
B
Reason 2
Displays another reason for mismatch in ITC as per audited annual statements of the reporting period as declared in 12F.
C
Reason 3
Displays further reason for mismatch in ITC as per audited annual statements of the reporting period as declared in 12F.


Particulars
14
Reconciliation of ITC declared in Annual Return (GSTR9) with ITC availed on expenses as per audited Annual Financial Statement or books of account
A
Purchases
Displays reconciliation of ITC declared in the annual return GSTR-9 against the expenses booked in the audited annual financial statement.
Value: To get this value go to Profit - Loss A/c in Tally.ERP 9 and change the period to Apr '17 and Mar '18. Select the groups Purchases, Direct Expenses, and Indirect Expenses. Drill down from a selected group and get the sum of closing balances of all the sub-groups and ledgers under it. Exclude the values from purchase of non-GST supplies. Similarly, get the values for remaining groups. Enter the sum of values calculated for all groups.
Amount of Total ITC: To get this value, drill down to Voucher Register level from Purchase, Direct Expenses and Indirect Expenses groups in the Profit - Loss A/c. Click F8: Columnar to enable columns. In the columnar report, get the grand total of the tax columns. Enter sum of tax values for all GST transactions under these groups.
Amount of eligible ITC availed: To get this value, compare the actual tax with eligible ITC, if the both are some, enter the same value as in column Amount of Total ITC here. If not, enter the difference value.
B
Freight / Carriage
Displays the transaction value, ITC and ITC availed values for the particular expense type.
C
Power and Fuel
Displays the transaction value, ITC and ITC availed values for the particular expense type.
D
Imported goods (Including received from SEZs)
Displays the transaction value, ITC and ITC availed values for the particular expense type.
E
Rent and Insurance
Displays the transaction value, ITC and ITC availed values for the particular expense type.
F
Goods lost, stolen, destroyed, written off or disposed of by way of gift or free samples
Displays the transaction value, ITC and ITC availed values for the particular expense type.
G
Royalties
Displays the transaction value, ITC and ITC availed values for the particular expense type.
H
Employees' Cost (Salaries, wages, Bonus etc.)
Displays the transaction value, ITC and ITC availed values for the particular expense type.
I
Conveyance charges
Displays the transaction value, ITC and ITC availed values for the particular expense type.
J
Bank Charges
Displays the transaction value, ITC and ITC availed values for the particular expense type.
K
Entertainment charges
Displays the transaction value, ITC and ITC availed values for the particular expense type.
L
Stationery Expenses (including postage etc.)
Displays the transaction value, ITC and ITC availed values for the particular expense type.
M
Repair and Maintenance
Displays the transaction value, ITC and ITC availed values for the particular expense type.
N
Other Miscellaneous expenses
Displays the transaction value, ITC and ITC availed values for the particular expense type.
O
Capital goods
Displays the transaction value, ITC and ITC availed values for the particular expense type.
P
Any other expense 1
Displays the transaction value, ITC and ITC availed values for the any other expense.
Q
Any other expense 2
Displays the transaction value, ITC and ITC availed values for the any other expense.
R
Total amount of eligible ITC availed
Displays auto calculated value as declared in 14A to 14Q.
S
ITC claimed in Annual Return (GSTR9)
Displays the net ITC availed in the annual returns GSTR-9. Get this value from 7J in annual return GSTR-9.
T
Un-reconciled ITC
Displays the auto calculated difference in values from 14S and 14R.


Particulars
15
Reasons for un-reconciled difference in ITC
A
Reason 1
Displays the reason for the mismatch in ITC value as shown in 14T.
B
Reason 2
Displays the reason for the mismatch in ITC value as shown in 14T.
C
Reason 3
Displays the reason for the mismatch in ITC value as shown in 14T.


Particulars
16
Tax payable on un-reconciled difference in ITC (due to reasons specified in 13 and 15 above)
Central Tax
Displays the amount of central tax payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.
State/UT Tax
Displays the amount of state/UT tax payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.
Integrated Tax
Displays the amount of integrated tax payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.
Cess
Displays the amount of cess payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.
Interest
Displays the amount of interest payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.
Penalty
Displays the amount of penalty payable due difference in financial statements and annual returns GSTR - 9 for the reasons specified in sections 13 and 15.



Pt. V Auditor's recommendation on additional Liability due to non-reconciliation

Field
Particulars
5%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 5% tax rate.
Central taxState/UT taxIntegrated tax, and Cess : Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 5% tax rate.
12%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Record the taxable value applicable on additional liability for 12% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 12% tax rate.
18%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 18% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 18% tax rate.
28%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 28% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 28% tax rate.
3%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 3% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 3% tax rate.
0.25%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 0.25% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 0.25% tax rate.
0.10%
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of turnover. Enter the taxable value applicable on additional liability for 0.10% tax rate.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation on turnover. Enter the amount in respective tax type columns for 0.10% tax rate.
Input Tax Credit
Value: Displays the amount of taxable value associated with additional liability on tax payer as recommended by the auditor for non-reconciliation of input tax credit. Enter the taxable value applicable for mismatch in input tax credit.
Central taxState/UT taxIntegrated tax, and Cess: Displays the tax amount for additional liability recommended by the auditor for non-reconciliation of input tax credit. Enter the amount in respective tax type columns.
Interest
Value: Displays the amount of taxable value associated with interest to be paid for additional liability recommended by the auditor.
Central tax, State/UT taxIntegrated tax, and Cess: Displays the interest amount payable for different tax types due additional liability recommended by the auditor.
Late Fee
Value: Displays the amount of taxable value associated with late fee to be paid for additional liability recommended by the auditor.
Central taxState/UT taxIntegrated tax, and Cess: Displays the late fee payable for different tax types due additional liability recommended by the auditor.
Penalty
Value: Displays the amount of taxable value associated with penalty to be paid for additional liability recommended by the auditor.
Central taxState/UT taxIntegrated tax, and Cess: Displays the penalty payable for different tax types due additional liability recommended by the auditor.
Any other amount paid for supplies not included in Annual Return (GSTR 9)
Value: Displays the amount of taxable value for supplies not included in annual return as identified by the auditor.
Central taxState/UT taxIntegrated tax, and Cess: Displays liability tax type wise for supplies not included in annual return.
Erroneous refund to be paid back
Value: Displays the amount of taxable value associated with erroneous refund identified by the auditor.
Central taxState/UTIntegrated tax, and Cess: Displays liability tax type wise for erroneous refunds identified the auditor.
Outstanding demands to be settled
Value: Displays the amount of taxable value associated with any other outstanding demands to be settled as recommended by the auditor.
Central taxState/UT taxIntegrated tax, and Cess: Displays liability tax type wise for any other outstanding demands to be settled as recommended by the auditor.
Other (Pl. specify)
Value: Displays the amount of taxable value associated with any other liability to be payable as recommended by the auditor.
Central taxState/UT taxIntegrated tax, and Cess: Displays liability tax type wise for any other liability to be payable as recommended by the auditor.


No comments:

Post a Comment

Thanks for Visit! Please Visit Again