Budget: 20000 UAH Deadline: 14 days
Good day.
The task is essentially similar to building a separate service that aggregates payments from various sources and centrally performs matching with orders.
I suggest constructing the logic not around the amount, but through unique identifiers: order number in the destination, external payment id, or additional payment reference. If necessary, a layer with invoices can be added to make the matching as accurate as possible.
Regarding architecture:
a separate backend service for collecting and normalizing payments via API and statements (nestjs)
a processing queue to protect against duplicates
flexible matching rules based on several parameters
an interface for unmatched payments with manual linking (react)
synchronization of statuses between SalesDrive and 1C
I propose to discuss the implementation details, timelines, and costs in private messages.