Table 1 to 3

GSTIN/Name/Turnover

Auto-populated by GST system and visible on Login

Table 4A

B2B inward supplies (non-RCM)

Auto-populated in Table 3A (for invoices) and Table 4 (for debit/credit notes and amendments) of GSTR-4A

Table 4B  

B2B Inward supplies (RCM)

Auto-populated in Table 3B (for invoices) and Table 4 (for debit/credit notes and amendments) of GSTR-4A

Table 4C

Inward supplies from unregistered dealers

To be derived from Tally using steps detailed below

Table 4D

Import of Services

To be derived from Tally using steps below

Table 6

Liability from outward supplies and inward RCM

To be derived from Tally using steps below

Table 7

TDS / TCS Credit received

Auto-populated in Table 5 of GSTR-4A

Table 8

Tax /Interest /Late fee payable and paid

Tax amount auto-populated, Interest/late fee to be declared

Table 9

Refund claimed from E-Cash Ledger

To be declared in case of any claim

Table  5  

Liability from outward supplies and inward RCM as per filed CMP-08

Auto-populated by GST system

1. GSTN

Auto populated on GSTN portal

2. (a) Legal name of the registered person

Auto populated on GSTN portal

2. (b) Trade name, if any

Auto populated on GSTN portal

3. (a) Aggregate turnover in the preceding Financial Year (Auto populated)

Auto populated on GSTN portal

3. (b) ARN

Auto populated on GSTN portal

3. (c) Date of ARN

Auto populated on GSTN portal

4. Inward supplies including supplies on which tax is to be paid on reverse charge

4A. Inward supplies received from a registered supplier (other than supplies attracting reverse charge)

Get the list of inward supplies from registered dealers, to do so;

1. Gateway of Tally > Display More Reports More Reports> Accounts Books > Ledger > select the Registered party ledger ( for B2B Purchases)  and press Enter to view the Ledger Voucher report.
2. Press F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
3. Press Alt+F12 (Range), to filter the report by choosing Voucher having Voucher Type with Name containing Purchase and accept the screen. All purchase transaction of the party are displayed in the report.
   

   Note: Similarly you can filter for all purchase nature of transactions made through Payment or Journal Voucher or Credit/Debit note voucher types.

4. Press F8 (Columnar), and in Columnar Register Alteration screen set Show party’s GSTIN/UIN option to Yes and save.
5. Press Alt+F5 (Detailed) to view the vouchers in detailed mode. The name of stock items in each voucher are displayed below the party name.
6. Now that you have filtered to get all the purchase transactions for registered supplier, enter the following details. In case the invoice has items with different tax rates, they have to be recorded in a different row.

• • GSTIN of Supplier: Get this from GSTIN/UIN column in the report.
  • Rate, Taxable Value and Amount of tax: You can open each voucher in alteration mode and extract rate-wise taxable value and tax amount from every voucher, total the values and enter the details manually in respective columns (Rate, Taxable Value and Amount of tax) in the GSTN portal.
  • Place of Supply (Name of State/UT): Enter company state/UT name.

Similarly, enter the details for all registered dealers with inward supplies.

4B. Inward supplies received from a registered supplier (attracting reverse charge)

Get the list of inward supplies from registered dealers, to do so;

1. Gateway of Tally > Display More Reports More Reports > Statutory Reports > GST > Returns > GST CMP-08.
2. Press Alt+F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
3. Under Particulars, go to Inward Supplies on Which Tax is Payable.
4. Place the cursor on any rate-wise purchased ledger under Registered Dealer Purchases Liable for Reverse Charge and press Enter to drill down to Voucher Register with list of vouchers for the ledger.
5. Now that you have list of vouchers, enter the following details.

• • GSTIN of Supplier: Get this from GSTIN/UIN column in the report.
  • Rate, Taxable Value and Amount of tax: When there are multiple vouchers having with, Specific party and GSTIN OR different party with same GSTIN
  • Drill down from Specific purchase ledger of X rate will list all the vouchers of that rate.
  • Manually extract rate-wise taxable value and tax amount for a GSTIN and sum it up then enter the details in GSTN portal.
  • Place of Supply (Name of State/UT): Enter company state/UT name.

Similarly, enter the details for all rates of purchases from registered dealer.

4C. Inward supplies received from an unregistered supplier

Get the list of inward supplies from unregistered suppliers, to do so;

1. Gateway of Tally > Display More Reports > Accounts Books > Ledger > select the Unregistered party ledger or cash (for B2C Purchases) and press Enter to view the Ledger Voucher report.
2. Press Alt+F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
3. Press Alt+F12 (Range), to filter the report by choosing Voucher having Voucher Type with Name containing Purchase and accept the screen. All purchase transaction of the party are displayed in the report.

   Note: Similarly you can filter for all purchase nature of transactions made through Payment or Journal Voucher or Credit/Debit note voucher types.

4. Press F8 (Columnar), and in Columnar Register Alteration screen enable the required option and save.
5. Press Alt+F5 (Detailed) to view the vouchers in detailed mode. The name of stock items in each voucher are displayed below the party name.
6. Choose the B2C cash purchase transaction for which GSTIN column is blank. Refer these transactions and enter the details below:  

• • Rate, Taxable Value and Amount of tax: You can open each voucher in alteration mode and extract rate-wise taxable value and tax amount from every voucher, total the values and enter the details manually in respective columns (Rate, Taxable Value and Amount of tax) in the GSTN portal.
  • Place of Supply (Name of State/UT): Enter company state/UT name.

Similarly, enter details for all unregistered dealers.

4D. Import of service

As per Government format, IMPS details are to be reported invoice-wise. In case it is to be reported as summary values can be obtained from CMP-08 by opening for 12 months and referring the section Import of service for rate-wise breakup. POS to be given as company state.

Get the list of services imported, to do so;

1. Gateway of Tally > Display More Reports > Statutory Reports > GST > Returns > GST CMP-08.
2. Press Alt+F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
3. Under Particular, go to Inward Supplies on Which Tax is Payable.
4. Select Import of Service and click on Alt+F5 (Detailed) to view rate-wise breakup information.
5. Place the cursor on any rate-wise import ledger and press Enter to drill down to Voucher Register with list of vouchers for the ledger.
6. GSTIN of Supplier: Get this from GSTIN/UIN column in the report.

• • Invoice No., Invoice Date and Invoice Value: Enter the Invoice No., Invoice Date, and Invoice Value of each transaction in the Voucher Register screen in a separate row.
  • Rate: Enter the GST rate of the selected purchase import ledger
  • Taxable Value: Enter the Taxable Value in the Voucher Register for each transaction.
  • Amount of tax: Enter the tax amount from the Voucher Register report in respective tax type columns.
  • Place of Supply (Name of State/UT): Enter company state/UT name.

Similarly, enter the details for all rates of imports.

5. Summary of self-assessed liability as per FORM GST CMP-08

(Net of advances, credit and debit notes and any other adjustment due to amendments etc.)

1. Outward supplies (including exempt supplies)

The values of this section will be auto-populated in GSTN portal.

For comparison of books v/s GSTN portal, follow below steps:

1. Open GST CMP-08 report, press Alt+F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
2. Press F12: Configure and enable the option Show break-up of nett values.
3. Press Alt+F5 (Detailed) to view the breakup of sales, RCM purchase and the corresponding returns under Particulars.
4. Refer the values under Outward Supplies and compare the consolidated net sales taxable value of below:

• • Taxable Sales
  • Exempted Sales
  • Nil Rated Sales

2. Inward supplies attracting reverse charge including import of services

The values of this section will be auto-populated in GSTN portal.

For comparison of books v/s GSTN portal, follow below steps:

1. Open GST CMP-08 report, press Alt+F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
2. Press F12: Configure, enable the option Show break-up of nett values.
3. Press Alt+F5: Detailed to view the breakup of sales, RCM purchase and the corresponding returns under particulars.
4. Refer the values under particular section of Inward Supplies on Which Tax is Payable and compare the net consolidated taxable values for below:

• • Registered Dealer Purchases Liable for Reverse Charge
  • Unregistered Dealer Purchases Liable for Reverse Charge
  • Import of Service
  • Advance Payments

3. Tax paid (1+2)

The sum of 1+2 of auto populated taxable value will be auto-populated here. The sum of 1+2 of auto populated Integrated Tax, Central Tax, State/UT Tax and Cess amount will be filled here.

4. Interest paid, if any

The taxable value on which interest is paid will be auto-populated here. The Integrated Tax, Central Tax, State/UT Tax and Cess amount on which interest is paid is auto-populated here.

Enter as Outward or Inward based on the type of supply

Enter the rate of tax

For outward supply value,

1. Open GST CMP-08 report, press F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
2. Press F12: Configure and enable the option Show break-up of nett values.
3. Press Alt+F5 (Detailed) to view the breakup of sales, RCM purchase and the corresponding returns under Particulars.
4. Refer the values under Outward Supplies and compare the consolidated net sales taxable value of below:

• • Taxable Sales
  • Exempted Sales
  • Nil Rated Sales

For inward supply value,

1. Open GST CMP-08 report, press F2 and change the report period as 01-Apr-2019 to 31-Mar-2020.
2. Press F12: Configure, enable the option Show break-up of nett values.
3. Press Alt+F5: Detailed to view the breakup of sales, RCM purchase and the corresponding returns under particulars.
4. Refer the values under particular section of Inward Supplies on Which Tax is Payable and compare the net consolidated taxable values for below:

• • Registered Dealer Purchases Liable for Reverse Charge
  • Unregistered Dealer Purchases Liable for Reverse Charge
  • Import of Service
  • Advance Payments

The amount of tax with tax type wise break is auto populated.