can you share the reproducible steps? i.e which transactions created before the reconciliation, how to do the reconciliation step by step. if it can be reproduced, then there is chance others can help you.
Here are the steps, and the problem we are having:
Create Sales Order for say $50,000
Enter Payment Entry (Advance Payment) for say $20,000
Upload PayPal Bank Account transaction for $19,500 (PayPal charges us as credit card processing fee).
We go to Bank Reconciliation tool and click the Actions button to the right of the $19,500 transaction
On the popup window we select Action: Match Against Voucher, then put a check mark on the Payment Entry box
On the Select Vouchers to Match section below, the $20,000 Payment Entry does not show.
From trial and error we think there’s probably a filter in the code that only shows Payment Entries for amounts equal to or lower than the actual bank transaction amount. Nevertheless this is a problem, since for this use case the tool is not showing us the transaction we need to match against showing us that there is a difference between the amount we expected ($20,000) and the amount we actually received in our bank account ($19,500) for which we would need to account by creating a Journal Entry for the difference.
I have the same problem, e.g. I have two journal entries of
And have imported bank account entries with entry of $5000. But when I click Actions to reconcile the Bank Transaction and select to include ‘Journal Entry’ the entries of $500 and $4500 are not shown in ‘Select Vouchers to Match’ window. So this is reverse case to @DonDowner case.
I have another example, where I have purchase invoice entry of $189.9900 and on the Chart of Accounts on the bank account Credit Entry of $189.996, and this is not showing either. Let’s hope one day @Mohammad_Hasnain will comment / help us!
I wonder if this is something to do how the Bank reconciliation tool refers to the bank account. It perhaps refers to the bank account by name rather than looks the Chart of Accounts number!
I have a feeling that I may have changed the Bank Account name in the Chart of Accounts (the number remains the same) over the time. Or the name in the Bank/Bank Account section. Or both! And the entries that are not found were created before the name change.
How does the Bank Reconciliation tool link the Bank Transaction Entries to the Chart Accounts’ bank account @Mohammad_Hasnain ?
But perhaps the tool actually looks the actual purchase invoices…
For example if I have
Entry of £110 in Sterling on the Sterling Bank Account, that was created from Purchase Invoice in US Dollars
Now if I click actions, I do not see the entry for the $124 USD in the list, perhaps as described by @DonDowner it is beacuse $124 is more than £110 bank transaction if we take the currency rate out of the equation.
look like nobody is using this broken feature… it almost work in v14 but still can’t find payment entries made from customers. If I go manually, I can find and match the transaction but the brank reconciliation tool can’t find it. Work on purchases…
@Samuel_Gervais - yes it is such a shame that we do not get any response to fix the issue. Otherwise the developer/frappe spent several months to develop the feature, and it fails on a simple bug rendering it useless - a real shame.