Supplier TCC compliance sweep

Verify TCC status for every supplier before releasing payments. Half a day of manual portal lookups becomes 60 seconds — and you have a timestamped compliance record.

The problem

Before releasing payments to suppliers, finance and procurement teams must confirm each supplier's Tax Compliance Certificate is valid. Checking 50 suppliers on the KRA portal manually takes half a day — one lookup at a time, results not recorded. With Msharti, one prompt checks all of them and returns a table you can attach to the payment run.

The prompt

Check TCC status for all suppliers in the active_suppliers table in our database. For each supplier, verify their KRA PIN is valid and their TCC is current. Return a table with columns: Supplier Name, KRA PIN, TCC Status, TCC Expiry, Action Required. Flag any supplier whose TCC has expired or expires within 30 days.

If your supplier list is in Google Sheets instead of a database, adjust the prompt:

Read the supplier list from the "Approved Suppliers" tab of the Procurement spreadsheet (columns: Supplier Name, KRA PIN). Check TCC status for each KRA PIN and return: Supplier Name, KRA PIN, TCC Status, Expiry Date, Action Required.

What fires

• run_query (PostgreSQL) — reads the supplier list from your database (or read_range from Sheets)
• validate_kra_pin — confirms each KRA PIN is registered and active
• check_tcc_status — verifies TCC validity and expiry date for each supplier
• The AI compiles results into a compliance table and flags suppliers needing action

What comes back

Variations

• Check TCC status for just the 12 suppliers in this week's payment run: [paste supplier names]
• Which of our suppliers have TCCs expiring in the next 60 days? Pull the list from the Procurement sheet
• Verify KRA PINs for the three new suppliers we onboarded this month and flag any that are inactive