Skip to main content
Question

Process Bank Transactions - Matching Transactions from a Bank Feed


We have a client that issues approx 6000 checks per month for lease payments.   Most of these checks are for the same dollar amounts (ie. 3000 checks for $ 1000 and 3000 checks for $ 1500).  When the Bank Feed comes in the Bank Feed writes the Check Number to the Tran. Desc field.  Acumatica seems to ignore the Tran. Desc field and suggests matches displaying 3000 checks all for $ 1000.  Acumatica Tech Support told me that it only matches based on Amount and Transaction Date which doesn’t make sense to me since Ref. Nbr. Weight as well as Doc. Payee Weight are part of the Relevance Calculation.  What fields does Acumatica read to match  Ref. Nbr. Weight & Payee Weight ?

4 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 230 replies
  • October 19, 2023

@schase17 This is the description of logic behind the two fields in question in Acumatica:

Doc.Payee weight = The relative weight of the evaluated difference between the names of the customer (or vendor) on the bank transaction and the cash transaction.

 

Ref.Nbr.Weight = The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction
 

  • Author
  • Freshman I
  • 5 replies
  • October 19, 2023

Hi Sam,

But that does not explain what field Acumatica is reading to calculate the relevance.   For Ref. Nbr. Weight it is the difference between the reference number of the bank transaction -what field is Acumatica reading to find the reference number of the bank transaction?   Is it reading the Ext Ref. Nbr field because it is obviously not reading the Tran Desc field.  Thanks.


Forum|alt.badge.img
  • Freshman I
  • 22 replies
  • November 9, 2023
schase17 wrote:

Hi Sam,

But that does not explain what field Acumatica is reading to calculate the relevance.   For Ref. Nbr. Weight it is the difference between the reference number of the bank transaction -what field is Acumatica reading to find the reference number of the bank transaction?   Is it reading the Ext Ref. Nbr field because it is obviously not reading the Tran Desc field.  Thanks.

I am also interested in the answer to this, because we have a client who is having a very low rate of matches resulting in a high number of manual matches instead of automatic matches.


  • Freshman I
  • 11 replies
  • April 24, 2025

I’m with you on this.  The fields that come in from our various banking institutions do not seem to match the generic fields that Acumatica has assigned for mapping.  Making the match settings pretty ridiculous to work with.  Also our credits in GL entries that don’t have a business account listed are being calculated as a perfect match to the payee field.  The ref. nbr. field is not comparing the correct field on the incoming feed and as rendered useless.  In many cases that only leaves date matching.  I see no match settings to adjust or weight based on the amount, which would be super helpful.  I love the concept of bank feeds but the matching function needs serious work.  We are currently on Acumatica 2024R1.  Can anyone tell me if Acumatica has made improvements to bank feed matching in the 2 more recent releases?  Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings