Reconciler

Reconciliation tool for GSTR 2B and Purchase Register

Install Reconciler

bench get-app https://github.com/aerele/reconciler

Add the Frappe Gems badge to your README

Maintain Reconciler? Paste this into your README:

[![Listed on Frappe Gems](https://frappegems.com/api/method/frappe_gems.seo.badge?app=aerele%2Freconciler)](https://frappegems.com/gems/apps/aerele/reconciler)

About Reconciler

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!

Related Localization apps for Frappe & ERPNext

  • Wiki — Free and Open Source Wiki built on top of Frappe
  • India Compliance — Simple, yet powerful compliance solutions for Indian businesses
  • Nepal Compliance — Open source ERP for Nepal with HR, Payroll & Accounting compliance, based on ERPNext by Frappe Technologies.
  • Erpnextswiss — ERPNext application for Switzerland-specific use cases
  • Erpnext Germany — ERPNext customizations for German companies
  • Ksa Compliance — KSA Compliance App for KSA E-invoice
  • Zatca Erpgulf — Implementation of Zatca Phase-2 E-Invoicing - for FrappeCLoud
  • Kenya Compliance — KRA eTIMS Tax Compliance Integration This app works to integrate ERPNext with KRA's eTIMS via the Online Sales Control Unit (OSCU) to allow for the sharing of information with the revenue authority.via OSCU with ERPNext