My company has been exploring ERPNext for over a year now. We have found the platform to be very well developed and supported by a great core foundation and active community. The system encompasses nearly all benefits that a company hopes to realize in adaptation of an ERP system. However, one area I find that could use some enhancement is the bank reconciliation.
After review of the forums and documentation it appears that the bank reconciliation process in ERPNext seems somewhat undefined.
Other prominent accounting software such as QuickBooks, Peachtree, Dynamics, etc. follow a similar model that seems to work very well. I believe this framework has been standardized and ERPNext should follow suit.
I’ll use QB as my example. The process of the bank reconciliation consists of two separate steps: setting up the rec and performing the rec.
1. Setting up the Rec
Typically, most recs begin with the user inputting the following information:
- Account to be reconciled
- Bank statement date (month being reconciled)
- Ending balance as per bank statement
The system indicates the last reconciling of the particular account and will also fetch the beginning balance (ending balance from last reconciliation performed).
Once this information has been entered the user clicks continue.
2. Performing the Rec (Clearing Transactions)
The next screen would populate all transactions against the specific bank account that have not yet been cleared on a previous rec. Ideally the transactions are sorted into two categories, “Funds Paid” and “Funds Received” for easy identification.
As the user goes through and updates the clearance date for all transactions on the bank statement, the progress is tracked and updated.
Showing the total items cleared helps the user identify if they are perhaps missing a transaction that needs to be added into the system. Eventually when the difference equals zero the user clicks reconcile and a report is published. This creates a nice clean report for each month the account was reconciled that can be easily accessed and archived.
If the difference is not equal to zero and the user clicks reconcile a message should appear to inform the user of the difference. In order to continue, an adjusting JE will need to be entered to account for the difference.
I’m curious to know if other ERPNext users are having some functionality issues with the bank reconciliation process and have interest in enhancements.
If so, I will post the job on ERPNext’s bounty source and also contribute to the project (monetarily that is, as I have no developer/coding skills).