ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Bank Transaction Reconciliation Question - Version 13

Context: I currently do all my accounts in Quickbooks Online because it has seamless bank synchronisation and more importantly I can reconcile my bank account entries to invoices or expenses/bills from the bank transaction list. I don’t have to make a separate, manual payment entry for any transaction or open another form, browser tab or link to do so. I would rather use ERPNext for all my business management including the accounts. However, I cannot work out how my imported bank transactions relate to outstanding invoices.

After importing my bank transactions and having to open every transaction manually there is a section in the bank transaction form as below:

This above section of the bank transaction does not seem to create a payment entry for the outstanding invoice. When I look at the invoice in question it is still outstanding.

Q1: What does that section of the bank transaction form actually do?
Q2: I hesitate to even ask this question; do I have to manually add a payment entry for every invoice that I have already imported a bank transaction and reconciled?
Q3. This follows from Q2 and it is; do I have to actually manually make a payment entry of type “receive” before I can reconcile a simple expense without an account with the supplier? (I have no accounts with suppliers and I don’t write purchase orders, I just talk to my suppliers and pay by debit card or cash.)

The documentation for version 13 is not available and I’m most likely missing something really obvious.

Some further info …

I have just read the latest ERPNext blog regarding Bank Reconciliation and have to ask where does the following screen appear in ERPNext 13?

The bank reconciliation tool screen on my install looks like the following even after importing a bank statement successfully.

Any ideas appreciated?

enter the opening and closing amount, upload the statement and click save.

1 Like

Thanks Snogha.

What I found was that for the items to come up in the list in the Bank Reconciliation Tool we have to have the amount of the bank transaction “unallocated” in the Bank Transaction Item. The bank transaction will then have a status of “unreconciled” after saving and submitting.

To achieve this we need to do more work that erpnext could actually do by default which is to fill in the “unallocated” field in the bank transaction item. Steps are:

  • Open the bank transaction item;
  • Scroll down to the field ‘Unallocated Amount’;
  • Enter the transaction amount as a positive number whether it is a Deposit or Withdrawal;
  • Save and Submit the tranaction;

You have to do this with every bank transaction item. Good luck keeping your admin wages down with this system! Is this a bug that I should report on Github?

What I seem to have done wrong is I had added what I will call the pseudo “Payment Entry” into the bank transaction item. This “allocated” the amount and therefor it is not available to be allocated in the Bank Reconciliation Tool.

However, one of my issues stands which is: What does adding the payment entry into the bank transaction item actually do? It does not create a payment entry against the associated invoice/expense.

Hi

Unallocated amount should be filled automatically. Thanks for reporting. When you upload a bank statement the unallocated amount is automatically made equal to the transaction amount and the allocated amount is made 0. Can you please tell what steps did you take to add this bank transaction which resulted in wrong allocated/ unallocated amount? It will help solve the issue.

You can go to the bank reconciliation tool and then find the bank transaction that you want to add into Erpnext. You can either create a new payment entry or match the bank transaction to an existing payment entry

When you either match or add a payment entry into the bank transaction it updates the clearance date in the corresponding payment entry.

Hi @Mohammad_Hasnain, query, were you able to make a complete process with the new Reconciliation tool?

I could not make a complete process, there is no way to cache the vouchers, among several errors both to create the vouchers and in the import process (it is only working with .xls .csv, with sheet gives a template error that is impossible).

There is not much documentation other than the presentation blog article.

I don’t see many people consulting either, I think it’s because the tool is hidden (they didn’t put it in a default workspace, and I want to believe it’s because it’s not polished).

Hey,

Yes I was able to do it

I think there are errors that are raised when creating vouchers that come from the actual voucher validation, can you share the ones that you’re facing here? They could be fixed by someone

So caching at the time of adding and matching? Can you please elaborate on this

This should be fixed here - PR

Does anyone know if the issue of reconciling internal transfers has been addressed? I can reconcile in one account (PayPal) but can’t use the same payment entry to reconcile on the flip side (Bank).