Better bank reconciliation for ERPNext

Issues · Community & Support · Sponsor Us!

​Mint is an open-source tool to help users of ERPNext reconcile their bank account and credit card statements.

It's built using Frappe Framework with a React based UI (it uses frappe-react-sdk) that can be accessed on the /mint path of your site.

For a complete walkthrough of the features, you can refer to the following YouTube video

This includes Bank Reconciliation Statement, all Bank Transactions, Bank Clearancy Summary and Incorrectly Cleared Entries

This supports fuzzy searching as well as filters for type (Debit/Credit) and amount.

Mint provides visual cues for matching characteristics like amount, date and reference number. It also highlights entries that have a high probability of being the correct match. Simply clicking the "Reconcile" button will match the transaction to the entry.

This will create a new Journal Entry, but of type "Bank Entry" or "Credit Card Entry". The details will all be already filled in.

You can split transactions across multiple accounts. If there's a difference amount, it will be highlighted and you can click on it to add a difference entry. (For credit cards, please go to "Bank Account" and check "Is Credit Card" to record JE's as "Credit Card Entry")

This will create a "Payment Entry" against a party and details will be autofilled.

When you select a party/account, Mint will automatically pull up all unpaid invoices/vouchers against the party. You can select them and it will allocate the amount. You can also add extra charges on this screen.

(Please note that cross-currency payments (e.g. USD invoice, but INR payment) is not supported via the Mint interface as of now. It is recommended to create the Payment Entry in ERPNext and match using Mint)

If you need to record a bank/cash transfer, use the "Transfer" function.

If all bank transactions are loaded on the system, Mint will try to find the corresponding "mirror" transaction in other bank accounts. If it does, it will offer that as a suggestion. On accepting the suggestion, an internal transfer is created and both bank transactions are reconciled at the same time.

Made a mistake while reconciling? When you reconcile, a toast shows up for a few seconds with a button to "Undo". You can click on that to "Unreconcile" a transaction.

If you matched it to an existing voucher, "Undo" will simply unlink the transaction. If you created a new Payment or Journal Entry, "Undo" will cancel the entry. You can "Undo" reconciled transactions from the "Bank Transactions" list as well.

If you want to create Journal or Payment Entries for multiple transactions at once, simply press "Shift" on your keyboard and select multiple unreconciled transactions. Then choose whether you want to create a Bank Entry, Transfer or Payment entry.

You can create "rules" for transactions as they come in. These can be used to suggest actions based on the matching criteria. Click on the "zap" button at the top to get started.

For example, you could create a rule for "Bank Charges" - withdrawals with the word "Bank Charge", and set the action to "Bank Entry" with the account "7005 - Bank Charge".

You could have multiple rules and order them by dragging them.

Some credit cards and banks give credit card statements with amount fields that contain a "CR" or "DR" to denote deposits and withdrawals. The "Mint Bank Transaction Import" doctype can be used to import bank transactions - the string value will be evaluated and classified as "Withdrawal" or "Deposit". We recommend using the child table to import all transactions.

You can also try uploading PDFs in the "file" field and then have Google Cloud's Document AI try to parse it, but we haven't gotten good results with it so we do not recommend it yet.

All strings on the frontend are wrapped in translation functions - and most words are already available in other languages. Please feel free to contribute to translations (you might need to get in touch to set up Crowdin or equivalent)

We have added logos of the most popular banks in India, Europe, and North America. If you want us to add your bank, please create a Github issue. All logos are trademarks of their respective organisations.

AGPLv3