Skip to main content
Question

Bank reconcilliatioin - Automatic Transaction matching

  • October 10, 2022
  • 4 replies
  • 244 views

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 75 replies

When using the bank statement template/upload function for bank reconciliation, how can I upload a Cust/Supp ID on the bank statement for automatic matching?

4 replies

Forum|alt.badge.img+13
  • Hero (Employee)
  • 150 replies
  • October 11, 2022

hi @SMcLees,

Hope you are using “external file assistant” to upload bank statement. If you are using external file template ‘STDBNKSTAT’ there is column ID called ‘CUST_SUPP_ID’ which you can use to upload customer supplier ID. Refer below screen preview for easier reference.

 

Best Regards

Narmada


Forum|alt.badge.img+7
  • Do Gooder (Partner)
  • 27 replies
  • December 4, 2024

Hi,

Can I please know if automatic matching can perform with customer/Supplier ID ?


Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 5 replies
  • December 4, 2024

Hi ​@Awije,

 

Yes. Its possible to use ‘Customer/Supplier ID’ as an Automatic Matching Attribute in the Bank Reconciliation Process.

 

You can navigate to Payment Institute Page > select the relevant Payment Institute and use the command option ‘’Payment type Grouping per institute’’ and use the command option “Automatic Matching Attributes”. You can enable the Customer/Supplier ID attribute for the relevant Payment Group.

 

Regards,

Lihini.


Forum|alt.badge.img+7
  • Do Gooder (Partner)
  • 27 replies
  • December 5, 2024

Thanks a lot Lihini