Master in Accounts & high court Advocate
9456 Points
Joined December 2011
You can do reconciliation of both the ledgers as follows.
Copy your data from the GSTR-3B/1-PDF file and paste the same in the sheet given in the file. Provide details as per tally. Enter GST payment details in Cash ledger. Enter Transitional Credit/Refund Claimed in Credit Ledger.