​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.

Features

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

Select company, dates and bank account

View all reports related to banking in one place

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

Search unreconciled transactions for the given time period

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

Match transactions to entries in the system

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.

Split transactions using "Bank 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")

Create Payment Entry using "Record Payment"

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)

Transfer money using "Internal Transfer"

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.

Undo actions on transactions

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.

Reconcile transactions in bulk

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.

Create rules for automatic classification

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.

Translations

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)

Bank Logos

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.

License

AGPLv3