Most document management systems allow an individual or the system to set a default expiration – like 90 days – and then they send an email reminder to the doc owner that their documents are about to expire – can SharePoint do this?
Yes, there is an information management policy setting that you can bind with a document library. Inside information management policy, you can set retention policies where expirationfor documents can be set for a particluar period.
The policy can be set to delete all the documents if it reaches the particular period or a workflow can be started, where an email can be triggered to particular users, may be the person who has created the document itself.
You can find detailed implementaion with screenshots from the following blogs -