Ask HN: How do you manage client projects which need lots of copy and images

For our current way of working, we share an Excel sheet which states what assets (i.e. images and copy) are needed and what's been delivered. The client will drop the files into a Dropbox folder and update the Excel spreadsheet. I'm finding this way of working inefficient because a good number of times, files are just dropped into folders with no organization, no context and no update of the Excel spreadsheet. Tons of emails still need to be sent to know what's happening in the Dropbox folder.

Does anyone have a better way to manage the sharing of assets between client and vendor for projects.