List the suppliers that matter
Start with the suppliers the assistant contacts in normal work. Include the ones that send invoices, deliver materials, provide software, or handle a client service. Add the suppliers that are contacted only during an incident. A short list of real names is more useful than a directory of every vendor.
Record the service and the client each supplier supports. A supplier may serve several clients with different contacts and terms. The same company name can have a different account manager for each relationship. The sheet should show the relationship, not only the company.
Mark the suppliers that can change a payment, a delivery, or a client commitment. These need a stronger verification step. A stationery supplier is lower risk than a payment processor. The risk level helps the assistant decide when to pause and confirm. Put the highest-risk suppliers at the top of the sheet so they are reviewed first.
Record the role, not just the name
A contact entry should include the person, the role, the company, and the reason to contact them. A name alone becomes useless when the person changes role. The role helps the assistant find the right replacement. Add the account number or reference where the supplier uses one.
Record the preferred channel and the hours the contact is available. An email address that is never read is not a working channel. Add the backup channel for urgent issues. The sheet should tell the assistant how to reach someone, not only who to name. Note the time zone so a message sent at the end of the day does not wait unnoticed.
Keep the personal details to what the work needs. A direct phone number may be appropriate for an account manager, while a personal address is not. Limit the sheet to business contact information. The record should be useful without becoming a privacy liability. Review the fields each year and remove anything the team has never used.
Verify the channel before use
Confirm the contact through a known source rather than a message that arrives unannounced. A supplier change notice can be legitimate or fraudulent. Call the number on the existing contract or the supplier's official site. Do not use the number in the suspicious message.
Record the date and the method of the last verification. A contact that was confirmed a year ago may have changed. Add the next verification date. The record should show that someone checked, not only that the entry exists.
Check the domain and the reply address on email. A display name can be spoofed while the domain is different. Teach the assistant to compare the full address with the verified entry. A payment instruction that arrives from a new address should always be confirmed by a second channel.
Add escalation and a backup
Name the escalation contact for each critical supplier. The account manager may be the first contact, but the escalation path should reach a supervisor or a service desk. Add the hours and the expected response time. An escalation that reaches voicemail is not a path.
Record a backup contact for planned absences. The backup may be a different person or a general support line. Test the backup before it is needed. A name on a sheet is not proof that the channel works.
Write what the assistant may do without approval. A delivery reschedule may be within scope, while a bank detail change is not. Put the limit beside the contact. The assistant should know when to pause and ask the account owner.
Review after every change
Update the sheet when a supplier changes a contact, a bank detail, or a service. These changes are the most common source of lost time and fraud. Add the source of the update and the person who verified it. A change that is not verified should stay pending.
Review the sheet with the client at the quarterly check-in. The client may know about a new contact before the assistant does. A short confirmation prevents the team from using an old name. The review also gives the client a chance to correct a wrong entry.
Check the sheet against the invoices and the contract records. A contact that appears on an invoice should match the verified entry. A mismatch is a reason to pause, not a reason to update the sheet from the invoice. Verify first, then record.
Test the sheet with a live request
Pick one routine supplier request and follow the sheet from start to finish. Time how long it takes to find the contact, open the channel, and get a response. Record any step that required a guess. The test shows whether the sheet works in practice.
Ask the assistant to explain the escalation path for a failed delivery. A vague answer means the path is unclear or the sheet is hard to use. Fix the wording or the layout. The test should be simple enough to repeat each quarter.
Review the result with the supplier owner and change one entry or one step. A sheet that is never tested becomes a list of names that may or may not be current. The test is the control that keeps the record honest. Add the test date to the sheet so the next reviewer knows when it was last proven.
Sources
Open the original publisher and confirm the current version, definition, and scope before using a source for a business decision.
Turn the reading into a role brief
Bring the recurring tasks, tools, schedule, access limits, and owner-only decisions. Start with one work sample and one clear review path.
Plan a Philippines-based role