Hi everyone,
I’m looking for support in building an automation in Make.com that can assign receipts/invoices to payments using comparison criteria. If anyone has done something similar or could help me set this up from scratch, I’d really appreciate your help!
The Goal is to automate the assignment of receipts and payments from various sources using defined comparison logic, so that the process no longer has to be done manually.
PayPal (connected automatically): provides payment data
N26 account (manual CSV import): provides payment data
Further evidence (uploaded manually as CSV/PDF/JPG/PNG)
Matching logic:
All incoming data should be processed through Make.com and compared using the following fields:
- Name - Date - Amount - Delivery address
For a successful assignment to take place, at least three of these criteria must match. If a match is found, the data is moved to the “assigned” section. If no match is found, it goes into the “unassigned” section, where retries happen.
Retry process:
Unassigned receipts/payments will go through up to three assignment attempts, each separated by 31 days. If the receipt/payment cannot be assigned after the third attempt, it remains in the unassigned section permanently.
Output:
There are two separate output folders/sections:
Assigned receipts/invoices
CSV export (bulk-ready for DATEV, each assignment must be identifiable and traceable)
Individual PDF files (each assignment must be downloadable and readable)
Unassigned receipts/invoices
CSV export (with all data)
Individual PDF files (with all available information)
I’ve also attached a diagram to help visualize this. It might be clearer with the diagram.
Hello @Andrea_Phleps, welcome to the make Hire a pro section , I would love to work with you on this, you can book a call Here to discuss the project requirements and you can checkout my upwork profile Here
How often do you upload the CSV and how many rows does it include? I think maybe Airtable document upload and data extraction would work also for you, since this can work like one place to store your data, and AI can do the match easily. However, to be more sure of the best approach for your case, I would need to investigate further.
Building the solution only on make you have to get familiar with arrays and the make tools, which actually will complete the task.
I am doing co-building sessions where we work live together on your project. In this way you get the solution done during the session while you get to know how to manage and update your own automation by yourself.
Yes, I can help you build this automation in Make.com from scratch. I have experience setting up workflows that handle data from multiple sources, apply matching logic, and generate structured outputs like CSVs and PDFs. I’ll make sure the entire process is smooth, accurate, and fully automated as per your requirements.
Feel free to book a 30-minute call here: [https://calendly.com/farhan-aviary1103]
You can also check out my Upwork profile: [https://www.upwork.com/freelancers/farhana401]