search

aerele / reconciler

Reconciliation tool for GSTR 2B and Purchase Register
Other
15 stars 21 forks source link

readme

Reconciler

Reconciliation tool for GSTR 2B and Purchase Register (PR) includes Purchase Invoice and CDN

Installation

Navigate to your bench folder

cd frappe-bench

Install Reconciler App For Frappe Version 12 and 13 

bench get-app reconciler https://github.com/aerele/reconciler.git --branch=master
bench --site [site-name] install-app reconciler

Install Reconciler App For Frappe Version 14

bench get-app reconciler https://github.com/aerele/reconciler.git --branch=version-14
bench --site [site-name] install-app reconciler

Features

**Initial implementation is done only for B2B Transactions.

JSON Upload Tool

  1. Select appropriate fields and upload GSTR-2B JSON file which is downloaded from GST portal.

  2. After creation, for individual transactions in json - 2B entries are automatically generated with the best match of PR.

  3. At the end, you will get overall uploaded and matching summary.

    photo_2021-04-21_21-43-26 photo_2021-04-21_21-43-20

    2B Entry

  4. This is auto-generated entry, where you can find transaction and linked PR matching informations.

  5. Here you have options like Rematch Results, Link Supplier, Create Invoice , Unlink PR

  6. Account freezing option also given in settings.

    2bentry

    Matching Tool

  7. In this report, you can reconcile the 2B entries with the linked PR's by moving the status from pending to accepted state or viceversa based on match status (Both Bulk and individual update actions are applicable).

  8. Link/unlink PR with the corresponding 2B entry.

  9. Create new invoice if no PR matched with 2B Entry.

  10. Click on view option to see differentiate view of the linked entries.

  11. You can only filter entries based on document date range or by return period.

  12. View Type: Supplier view - Supplier wise (tax difference, total pending document, total 2B and PR entry) will be shown. Document view - (** By default it will show all supplier documents. You can also view documents by applying supplier or gstin filters, otherwise just click on supplier or gstin in supplier view rows to auto apply filters)

    1. Rows with Match status Exact Match will be highlighted with blue, Accepted state in green.

    report_filters photo_2021-04-21_21-40-39 document_view

    Summary Report

    Here you can find tax account head wise summary photo_2021-04-21_21-43-49

Dependencies

  1. Frappe
  2. ERPNext
  3. Additional dependencies - V14: India Compliance)

TODO

  1. Next Iteration Fixes
  2. Known Issues

Show some ❤️ by starring :star: :arrow_up: our repo!