بوابة العملاء لمكاتب المحاسبة

Build a client portal for my accounting practice.

Create a shared database with four tables: clients (business name, entity type, engagement partner, assigned preparer, primary client contact, contact email), engagements (linked to a client, engagement type, period, due date, engagement status of Awaiting client / In review / Signed off, signed off by, signed off at), document requests (linked to an engagement, document name, period, requested date, due date, status of Outstanding / Received / Overdue, carried over from prior year yes or no) and source documents (linked to a document request, file attachment, uploaded by, uploaded at).

Give each client a login. A client only ever sees their own engagements, their own request list and their own source documents — never another client's file, and never our internal review notes. Give staff three roles: a junior preparer who only sees the clients assigned to them, a senior reviewer who sees their review queue, and a partner who sees the whole client book and can sign off.

Build a client view of what is still outstanding and when it is due, a preparer view of my assigned engagements, and a partner view of every engagement by status with overdue requests first. Keep an access log on each client file recording who opened, uploaded, downloaded or changed a status, and when.