Reconciliation of GSTR 2B and Books invoices in excel - Most simple excel tool | Made by CS K K Agrawal

Discount

For first 50 orders Rs. 199 off.

Why you should buy it?

This is the simplest tool for reconciliation of purchase invoices appearing in GSTR 2B and in Books. Just past the data and it shall generate two reports.

1. Invoices missing in GSTR 2B. Inform your vendor to update GSTR 1 or IFF.
2. Invoices missing in books. Inform your accounts department.
3. Matched invoices and differences in their invoice value. If there is differences in invoice value search around to know the why's of differences.

About this reconciliation sheet

1   It can handle total 5000 invoices   

2   It shall generate following reports   

   a   Missed Invoices

   b   Matched Invoices

3   How to use this sheet   

   a   Copy paste GSTR 2B data in sheet "1 Paste GSTR B2B"

   b   Enter books invoices details in "2 Paste Books"

Watch the video