Gap Analysis Template

Compare where each business area is today with where it needs to be, and plan the actions that close the gap.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Project Management

Tables

Gaps

Fields

13

Views

grid, kanban, calendar, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Gaps

13 fields · 6 sample rows

  • All gaps (Grid)
  • Status board (Kanban)
  • Target dates (Calendar)
  • Gap overview (Dashboard)
AreaTextCategorySingle selectCurrent StateLong textDesired StateLong textCurrent ScoreRatingTarget ScoreRatingGapFormulaProgress to TargetFormulaAction PlanLong textOwnerTextPrioritySingle selectTarget DateDateStatusSingle select
Customer onboarding timeCustomerOnboarding takes 21 days with manual paperwork.Self-serve onboarding in under 3 days.4/59/5544%Digital KYC, e-sign contracts, welcome email series.Ananya RaoHigh18 Jan 2027In progress
Sales forecastingProcessForecasts built in spreadsheets each month.Weekly pipeline forecast from CRM data.3/58/5538%Standardise pipeline stages; build CRM report.Mark DaviesMedium3 Jan 2027Planning
Cloud cost visibilityTechnologyBills reviewed quarterly, no tagging.Tagged resources with monthly team budgets.2/58/5625%Tagging policy, budget alerts.Rohan GuptaHigh19 Dec 2026Identified
Manager trainingPeopleNo formal training for first-time managers.Every new manager completes a 6-week programme.5/59/5456%Pilot cohort with an external coach.Elena PetrovaMedium17 Feb 2027Planning
Data privacy complianceComplianceDPDP policies drafted; consent logs partial.Full consent records and annual audit.7/510/5370%Consent management tool, staff training.Vikram ShahHigh9 Dec 2026In progress
Invoice collectionFinanceAverage 52 days to collect.Average 30 days to collect.6/58/5275%Automated reminders; UPI payment links.Grace OkaforLow14 Nov 2026Closed
Field details
Area · Text
Category · Single select
People, Process, Technology, Customer, Finance, Compliance
Current State · Long text
Desired State · Long text
Current Score · Rating
Target Score · Rating
Gap · Formula
IF({Target Score}, {Target Score} - {Current Score}, BLANK())
Progress to Target · Formula
IF({Target Score}, {Current Score} / {Target Score}, BLANK())
Action Plan · Long text
Owner · Text
Priority · Single select
High, Medium, Low
Target Date · Date
Status · Single select
Identified, Planning, In progress, Closed

Gap Analysis Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates