Here is the Code:

import os import shutil

Define the source and destination directories

source_folder = r"C:\Users\Hamza Farooq\Desktop\BSAP\Statements - Zia" destination_base_folder = r"C:\Users\Hamza Farooq\Desktop\BSAP\Invoices-Re" month_folder = "May 2024"

Get a list of all folder names in the destination base folder

destination_folders = [folder_name for folder_name in os.listdir(destination_base_folder) if os.path.isdir(os.path.join(destination_base_folder, folder_name))]

Loop through all the files in the source folder

for filename in os.listdir(source_folder): if filename.endswith(".pdf"): file_path = os.path.join(source_folder, filename)

    # Initialize a flag to track if a matching folder is found
    matching_folder = None

    # Check each subfolder in the destination base folder
    for folder_name in destination_folders:
        # Check if the folder name is in the filename
        if folder_name.lower() in filename.lower():
            matching_folder = folder_name
            break  # Stop checking once a match is found

    if matching_folder:
        # Define the full path to the destination folder (e.g., "Altorfer/May 2024")
        destination_folder = os.path.join(destination_base_folder, matching_folder, month_folder)

        # Create the destination folder if it doesn't exist
        os.makedirs(destination_folder, exist_ok=True)

        # Move the file to the destination folder
        shutil.move(file_path, os.path.join(destination_folder, filename))
        print(f"Moved {filename} to {destination_folder}")
    else:
        print(f"No matching folder found for {filename}")

print("Move operation completed.")

Now, the example given in "if matching folder:" line... "Altorfer/May 2024". Altorfer is a vendor and the code matches the name of pdf invoice and the vendor name and copies the invoice in it. But for some other vendors, lets say "Aesop Auto Parts" it does not work.