Sponsored Development: Automatic Bank Reconciliation

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Summary

DesignIcon.jpg Designer: Alberto Abudinen ,Fabian Aguilar, Julio Farias.
Develop.png Developer: [Alberto Abudinen, Fabian Aguilar, Julio Farias].
Sponsor smily.png Sponsor: PentaVida, Chile; OFB Consulting.

ADempiere lacks an automatic bank reconciliation function, the current manual reconciliation is a solution for low volume of bank transactions. As ADempiere moves gradually into mid size and large size enterprises, this function becomes a requirement.

Sponsors

  • PentaVida, Chile
  • OFB Consulting

Project Team

  • Alberto Abudinen
  • Fabian Aguilar
  • Julio Farias

Functional Specs

This is a summary, full functional specs available in Spanish

  • Import of bank statements using ADempiere standard import engine
    • Tabular bank statement formats easy to set up using standard import ADempiere funcionality

Select bank statement import format.png

  • Master/detail view of imported bank statements
    • Listing of all bank statements
    • Access of detail view using the detail tab
    • detail view lists all records in bank statement
    • flagging of records not imported due to errors for later action

Imported bank statement master view.png

Imported bank statement detail view.png

  • Automatic bank reconciliation work space
    • Bottom section of window lists all records that were automatically matched for reconciliation
    • Bottom section allows matching fine tuning (Match/cancel match actions)
    • Upper section lists all records from the imported bank statement (left) and bank ADempiere records (right) for manual intervention until fully complete


Automatic bank conciliation window .png

Technical Specs

  • Compatible with ADempiere 3.6/3.7
  • Compatible with Swing UI
  • available in OFB Contributions branch in ADempiere repositories

Future Extensions

  • compatibility with web ui