What are the Summary Sheet to be Prepare in GST Audit ? 

It is time now to get prepare for the GST audit notices from department. It is big challenge to the accountant to provide the necessary documents with summary sheet and it should tally with your financials.

To prepare the summary sheet it is big task, Accountant has to plan the to prepare the summary sheet. Following knowledge must have to prepare the summary sheet in excel to avoid the multiple times preparation of summary report.

Accountants must have command over the MS-Excel and following advance level tools he must know to smoothening the process  of complete the audit process.

• Some basic Formulas like V-Lookup, Match, Index
• Power Query
• Power Pivot
• Excel Pivot Table

Summary sheet to be prepare with help of above mentioned excel tools

• Master Sales Register ( Sales Register + Debit Note+ Credit Note Register) Full year
• Master Purchase Register ( Input ledgers like CGST Ledger, SGST Ledger and IGST Ledger) Full year
• Reconciliation statement of GSTR2 A with Books
• Reconciliation statement of GSTR1 vs Books, GSTR3B vs Books , GSTR3B vs GSTR-2A

if you prepare the above reports you can prepare the Month-wise Sales summary, purchase summary and many report with the help of 'Pivot Table' Option.

Accountants must have good command over excel else it is very difficult for account to complete the audit. Refer my Article 

if you want to learn the Excel please comment me.

Share this article with your friends.