Data mapping collection · Keep it, then remove it
The DPDP Act does not give one deletion period for all personal data. It asks you to erase data when its purpose is served or consent is withdrawn, unless a law requires you to keep it. This guide shows how to map that for your own business: what starts the clock, how long you keep each kind of data, where the copies sit, who deletes them and what proof you keep. It includes a worked example and a free Excel register, sent after a short form.
In short
Retention and erasure mapping links every kind of personal data to a reason for keeping it, a trigger that starts the clock, a period, the places where copies sit, the way they are deleted and the proof that it happened. Retention decides when data should go. Erasure is how it goes. You cannot design the second without the first, so map them together. The Act sets no single period for everything, so each rule in your register must come from your own purpose or from a named law.
The basics
Retention is the decision to keep personal data for a stated reason and for a stated time. Erasure is the act of removing it, including from every copy and from every Data Processor that holds it. Mapping means writing both decisions down for each kind of data, so that deletion happens on purpose and not by accident.
These terms are not defined separately in the Act, so this guide uses them in their everyday sense. Section 2 of the Act does list “erasure” among the operations that count as processing, and it defines a “specified purpose” as the purpose mentioned in the notice given to the Data Principal. That second definition matters most, because the erasure duty in Section 8(7) is tied to it.
| Term | Meaning here | Example |
|---|---|---|
| Retention rule | A written decision on how long one kind of data is kept, why, and what starts the clock. | Keep support tickets until 12 months after the ticket is closed (illustrative). |
| Retention trigger | The event or date that starts the clock. | Account closure, invoice date, ticket closed. |
| Retention driver | The reason the data is still kept: purpose still served, law requires it, dispute or hold, or security log. | Law requires retention of invoices. |
| Deletion trigger | The event that starts the erasure workflow. | Retention period ended, consent withdrawn, erasure request. |
| Erasure | Removing the personal data from every place it sits, or making it impossible to link to a person. | Database row deleted, backup expired, vendor copy deleted. |
| Erasure evidence | A record showing what was erased, when, by whom, and how you know. | Job report, vendor confirmation, ticket. |
Retention and erasure are the last two stages of the data flow in the data flow and processor mapping guide. The activity, purpose and applicable basis come from your personal data inventory. This page turns those two stages into rules you can run. For the whole collection, start at the complete data mapping guide.
The basics
Every retention rule should follow one chain: purpose or requirement, retention trigger, retention period, system or location, deletion trigger, deletion mechanism, evidence. If a link is empty, the rule cannot be run. The most common empty links are the trigger and the evidence.
| Link | Customer account | Invoice record | Server log |
|---|---|---|---|
| 1 Purpose or requirement | Run the account, show past orders | Keep accounts, as a law requires (law to be named) | Detect unauthorised access (Rule 6(1)(e)) |
| 2 Retention trigger | Account closure | Invoice date | Date of the log entry |
| 3 Retention period | A set time after closure, plus any hold | The period the named law sets | At least one year |
| 4 System or location | Order database, search index, analytics, backup, helpdesk, email exports | Order database, finance spreadsheet | Log archive, cloud host |
| 5 Deletion trigger | Retention period ended | Retention period ended | Retention period ended |
| 6 Deletion mechanism | Scheduled job, vendor deletion, manual clean-up | Annual purge, manual deletion | Rotation job |
| 7 Evidence | Job report, vendor email, ticket | Purge report, finance sign-off | Rotation report |
The basics
Mapping turns “we delete when we can” into rules that people can run, check and explain. It is not an express requirement of the Act. It is practical compliance infrastructure that helps you meet the erasure duties the Act does contain.
| Problem without a map | What it looks like | What the map gives you |
|---|---|---|
| Data kept with no reason | Old customer and applicant data sits in systems nobody reviews. | A stated driver for every rule, so keeping has a reason. |
| Data deleted too soon | A team deletes records that a law requires you to keep. | A named legal source for any rule that says “law requires retention”. |
| Partial erasure | The main database is cleared, but the search index, spreadsheets, email and vendors still hold copies. | A location list, so every copy has an owner and a method. |
| Vendor copies forgotten | A Data Processor still holds data after you have deleted yours. | Processor IDs on each rule and a confirmation column. |
| No proof | Someone asks what was deleted and when, and nobody can say. | An erasure log with dates and evidence references. |
There is also a plain security benefit. Data you no longer hold cannot be leaked. The Act itself does not make this argument, but it is the reason many security teams push for tidy retention.
The basics
The Act ties erasure to the purpose and to consent, not to a calendar. Section 8(7) tells you to erase when consent is withdrawn or the specified purpose is no longer served, unless law requires retention. Rules 6 and 8 add a one-year log rule and a three-year inactivity rule for named classes. Nothing we found sets one period for all data.
The table below is a short paraphrase. It is not a quotation, and it is not legal advice. Read the exact words in the Act and the Rules before relying on any row, and check the current Third and Seventh Schedules for Rule 8.
| Provision | What it says, in short | What it means for the register |
|---|---|---|
| Section 2 | Defines “Data Processor”, “processing” (which includes erasure) and “specified purpose” (the purpose in the notice). | The purpose column must match the notice. |
| Section 6(4) and 6(6) | Withdrawing consent must be as easy as giving it. After withdrawal, the Data Fiduciary must cease, and cause its Data Processors to cease, processing within a reasonable time, unless the Act, the Rules or another law requires or authorises it. | Withdrawal starts a stop-processing step and an erasure check. |
| Section 8(1) and 8(2) | The Data Fiduciary stays responsible for processing done on its behalf. A Data Processor engaged for activities related to offering goods or services needs a valid contract. | Vendor deletion is your responsibility, so it needs a contract term and a confirmation. |
| Section 8(7)(a) | Erase personal data when the Data Principal withdraws consent, or as soon as it is reasonable to assume the specified purpose is no longer served, whichever is earlier, unless retention is necessary for compliance with law. | The core duty. The trigger, driver and legal source columns come from it. |
| Section 8(7)(b) | Cause the Data Processor to erase personal data that was made available to it. | The processor IDs and confirmation columns. |
| Section 8(8) and Rule 8(1) and 8(2) | The purpose is deemed no longer served if the Data Principal neither approaches the Data Fiduciary for it nor exercises rights for a prescribed period. The Rules prescribe three years from the last approach or exercise of rights, for the classes in the Third Schedule (e-commerce, online gaming and social media entities, within the stated thresholds), unless a law requires retention. The Data Fiduciary must give notice at least 48 hours before erasing. | Applies only to those named classes. Do not copy it into rules for other businesses. |
| Rule 6(1)(e) | Reasonable security safeguards include keeping logs and personal data for one year for the purposes the clause lists, unless a law requires otherwise. | A security-log rule with a one-year minimum. |
| Rule 6(1)(f) | Appropriate security provisions in the contract with a Data Processor. | Where deletion terms can sit in the vendor contract. |
| Rule 8(3) | A minimum of one year for personal data, traffic data and logs, for the purposes in the Seventh Schedule, after which the data is erased unless a law requires longer. | A second route to a one-year minimum for logs. |
| Section 12(3) | A Data Principal who has asked for erasure can have it erased, unless retention is necessary for the specified purpose or for compliance with law. Section 12 rights are framed around processing based on consent, including consent under Section 7(a). | An erasure-request trigger with a hold check. |
| Section 17(4) | Exempts certain State processing from the Section 8(7) erasure duty and from Section 12(3). | Check only if you are a State instrumentality. |
| Rule 15 | A Data Fiduciary must meet requirements the Government specifies by order about making personal data available to a foreign State or its agencies. | Relevant if any retained copy is held abroad. |
The only fixed periods we found are narrow: one year for the log rules, and three years of inactivity for the named classes in Rule 8. Everything else is your own rule, justified by your own purpose or by a named law. The periods in this guide's examples are placeholders.
Decide the rules
A retention trigger is a dated event that already exists in a system, such as an account closure date, an invoice date or a ticket close date. A period such as “one year” means nothing until you say one year from what. If the date is not stored anywhere, a deletion job cannot find it.
| Trigger type | Examples | Where the date usually sits | Watch for |
|---|---|---|---|
| End of a relationship | Account closed, contract ended, employee exit, subscription cancelled. | CRM, billing system, HR system. | Accounts that are never formally closed. Add an inactivity rule. |
| Completion of a task | Order delivered, ticket closed, claim settled, hiring decision made. | Order system, helpdesk, applicant tracker. | Records left open for years. Add a stale-record rule. |
| A record date | Invoice date, date of a log entry, date of a form. | The record itself. | Dates held only in free text or PDF files. |
| Consent withdrawn | Unsubscribe, withdrawal through a preference centre or by email. | Consent records, email platform. | Withdrawals made by phone or chat that never reach the record. |
| An erasure request | A Data Principal asks you to erase their data. | Request log, grievance system. | Requests sent to the wrong inbox. |
| Inactivity | No login, no purchase, no contact for a set period. | Last-activity fields. | Rule 8 sets a three-year inactivity period only for the named classes. For others, the period is yours to justify. |
| A hold | Dispute, investigation, audit, legal claim, or a regulator’s direction. | Legal or compliance team. | A hold must pause the clock. Record who placed it and when it ends. |
If you cannot find a trigger, that is a finding. Write “No retention trigger” in the gap column of the register and ask the system owner to add the field.
Decide the rules
Keep personal data only while one of three reasons applies: the specified purpose is still being served, a named law requires you to keep it, or a dispute or hold needs it. If none applies, the data is a candidate for deletion. Ask the questions below in order and write the answer in the register.
| Outcome | When it fits | Care needed |
|---|---|---|
| Keep in use | The specified purpose is still being served. | Re-check at each review. Purposes end. |
| Keep, with restricted access | A law requires you to keep it, or a hold applies, but the data is no longer needed for day-to-day work. | Move it out of everyday systems. Limit who can open it. Use it only for the retention reason. |
| Anonymise | You want to keep statistics but not the person. | If the data can still be linked to a person, it is still personal data. Test whether re-identification is possible before you rely on this. |
| Delete | No purpose, law or hold remains. | Delete from every location in the register, including vendors. |
The Act does not list the other laws that may require you to keep records. Their periods differ by law and sector, and they change, so this guide does not list periods. Ask your finance, legal and HR advisers to confirm the law and the section for each category. Areas that usually need a check:
In the register, a rule marked “Law requires retention” with no named law is flagged as “Legal source missing”. This stops “the law says so” from becoming a reason to keep everything.
Decide the rules
Write each rule in one sentence: delete [data] [time] after [trigger], unless [hold]. Set one rule per category and purpose, not one rule per system. The period comes from the purpose or from a named law. The table shows how to reach a period for common categories, without suggesting one.
This table shows how to decide, not what to decide. Any number you see in an example is a placeholder. Your period must come from your own purpose and the laws that apply to you.
| Category | Typical purpose | Typical trigger | How to reach the period |
|---|---|---|---|
| Customer account data | Run the account, show past orders | Account closure or an inactivity point | Ask how long the purpose really lasts after closure. Add a hold for disputes. Check Rule 8 if you are in a named class. |
| Order and invoice records | Deliver the order, keep accounts | Invoice date | Ask Finance which tax and accounting laws apply. Use the longest requirement that applies. Name the law. |
| Marketing subscribers | Send the newsletter or offers | Consent withdrawn, or an inactivity point | Keep until withdrawal. Set a stale-subscriber rule you can justify under the notice. |
| Support tickets | Answer the query | Ticket closed | Ask how long a ticket stays useful for follow-up or disputes. Do not keep ticket text for longer than that. |
| Job applicants | Assess candidates for a role | Hiring decision | Keep for the hiring purpose. Keep for future roles only if the candidate has agreed. |
| Employee records | Employment, payroll, statutory returns | Employee exit | Ask HR which labour and tax laws apply. Name each law. |
| Security logs | Detect and investigate unauthorised access | Date of the log entry | Apply the one-year minimum in Rule 6(1)(e) and Rule 8(3), and any longer period another law sets. |
| Children’s data | As stated in the notice | Purpose served | Read Section 9 first. Verifiable parental consent and limits on tracking affect what you may keep and why. |
Delete the customer account data 30 days after account closure, unless a dispute or a legal hold is open. If a hold is open, delete 30 days after it ends. Source: purpose in the notice. Placeholder period.
The same rule in register terms has a trigger (account closure), a driver (purpose still served), a period (30 days after trigger, paused by hold), a method (delete) and evidence (job report). Notice that the sentence names its own exception. Every rule needs one.
When two reasons apply to the same data, the longer one usually wins, but only for the data the law covers. For example, if a tax law requires the invoice and not the customer’s phone number, you can delete the phone number on the account rule and keep the invoice on the legal rule. Split the categories so each rule keeps only what its reason covers.
Map the deletion
An erasure workflow has six steps: detect the trigger, check for a hold, list every copy, delete or anonymise each one, get confirmation from vendors, and record the result. Write one workflow per trigger type, not one per system. The Act sets no fixed number of days for finishing erasure under Section 8(7), so set your own internal target and write it down.
| Deletion trigger | What starts it | Hold check | Main owner | Evidence |
|---|---|---|---|---|
| Retention period ended | A scheduled job finds records past their date. | Automatic hold flag, plus a monthly legal check. | System owner | Job report. |
| Account closed | The customer closes the account, or you close it. | Check open orders, disputes and legal requirements. | Operations | Closure ticket and job report. |
| Consent withdrawn | A withdrawal arrives through any channel. | Check whether another purpose or law still needs the data. | Privacy lead | Withdrawal record and deletion record. |
| Erasure request | A Data Principal asks you to erase their data. | Check Section 12(3) conditions: purpose and law. | Privacy lead | Request log and reply. |
| Purpose served | The activity ends, for example a campaign closes or a hiring round ends. | Check disputes and legal needs. | Business owner | Closure note and job report. |
| Inactivity period ended | No contact or use for the set period. Rule 8 gives three years for named classes only. | Check legal needs. Give the 48-hour notice if Rule 8 applies. | Privacy lead | Notice copy and job report. |
Deleting removes the data. Anonymising keeps a version that cannot be linked to a person. Archiving with restricted access keeps the data for a reason such as a legal requirement, and should be used only for that reason. These are different outcomes, so the register has a method column and asks you to pick one. Do not describe archiving as deletion in a report.
If a person asks you to erase their data and part of it must stay for a legal reason, delete the rest and tell them what stays and why. Record both in the log. A half-done erasure with no note looks the same as a failed one.
Map the deletion
Personal data usually lives in more places than the system you think of as the source. A location sheet lists every place a copy rests, who can delete from it, how it goes and how long it takes. The longest time on the sheet is your real erasure time.
| Location | Why it gets missed | Practical approach |
|---|---|---|
| Production database | It is the obvious one, so it is done first and the rest are forgotten. | Scheduled delete or anonymise by trigger date. Keep the job report. |
| Replicas, caches and search indexes | They are rebuilt from production, so people assume they follow. | Confirm the index drops the record. Record the rebuild time. |
| Analytics and data warehouse | Copies are loaded in bulk and live for years. | Remove identifiers before loading, or delete by key on a schedule. |
| Test and development copies | Teams copy production data for testing. | Mask data in test, or add the copies to the location sheet. |
| Backups | They are designed to keep data. Deleting one record from a backup is often not possible. | See the backup note below. |
| Logs and monitoring tools | They hold IP addresses and user IDs, and are kept for security. | Apply the one-year minimum where it applies, then rotate out. |
| Spreadsheets and exports | Finance, sales and HR keep their own files. | Name an owner for each file. Ask for a regular clean-up. |
| Email, chat and attachments | Reports, forms and CVs travel by email and sit in inboxes. | Set a mailbox clean-up step. Store the original in the system, not in email. |
| Laptops, phones and removable media | Downloads and local copies are not tracked. | Ask staff to delete downloads. Use managed storage where possible. |
| Paper | Forms and files sit in cabinets. | Set a shredding date and a witness or record. |
| Processor systems | You cannot see inside them. | See the vendor section below. |
We found no provision in the Act or the Rules that says how backups should be treated when erasure is due. That gap is real, and a clear written approach is the sensible way to cover it. This is good practice, not a legal requirement:
How far a backup must be cleared after erasure is a legal question without a clear answer in the text we reviewed. Get advice from a lawyer, and review it if the Board or a court gives guidance.
Map the deletion
Section 8(7)(b) requires you to cause your Data Processor to erase personal data you made available to it, so vendor deletion is part of your own erasure workflow. Add every processor that holds a copy to the rule, record how erasure is requested, and file the vendor’s confirmation.
| Question | Why ask it | Where to record the answer |
|---|---|---|
| 1. Which of our data do you hold? | You cannot request deletion of what you have not listed. | Processor ID on the register row. |
| 2. How do we ask you to erase it? | Some vendors offer an interface, others need a ticket or an email. | Deletion method on the location row. |
| 3. How long until it is gone? | This sets the lag you report. | Time to disappear. |
| 4. What about your backups? | Backups are the usual gap. | Backup handling on the register row. |
| 5. Who do you pass it to? | Sub-contractors may hold copies. We found no provision in the Act that names sub-processors, but Section 8(1) keeps you responsible. | Sub-processors known, in the processor register. |
| 6. How do you confirm? | You need proof, not an assumption. | How you confirm, and the confirmation date in the log. |
| 7. What happens when the contract ends? | Data must not stay behind after you leave. | Processor contract terms. |
Section 8(7)(b) speaks of a Data Processor. A recipient that decides its own purposes may be a Data Fiduciary in its own right, and your arrangement with it depends on the facts. Classify each recipient first using the five-question test in the data flow and processor mapping guide, and take legal advice if the role is unclear.
Map the deletion
Consent withdrawal, an erasure request, the end of a purpose, inactivity and the end of a retention period each have their own source and their own checks. Withdrawal and the end of a purpose are duties under Section 8(7)(a). An erasure request is a right under Section 12(3). Inactivity is a deemed end of purpose that the Rules define only for named classes.
| Event | Source | What you must do | When you may keep the data |
|---|---|---|---|
| Consent withdrawn | Sections 6(4), 6(6) and 8(7)(a) | Make withdrawal as easy as giving consent. Cease processing, and cause processors to cease, within a reasonable time. Erase. | Where law requires or authorises the processing, or retention is necessary for compliance with law. |
| Erasure request | Section 12(3) | Erase the data when the Data Principal asks. | Where retention is necessary for the specified purpose or for compliance with law. |
| Purpose no longer served | Section 8(7)(a) | Erase as soon as it is reasonable to assume the purpose is no longer served. | Where retention is necessary for compliance with law. |
| Inactivity period ended | Section 8(8) and Rule 8(1), 8(2) | For named classes only: treat the purpose as no longer served after the prescribed inactivity period, and give notice at least 48 hours before erasing. | Where a law requires retention. |
| Retention period ended | Your own register | Run the deletion job and record the result. | Where a hold has been placed. |
A customer who withdraws consent for marketing has not asked you to close their account. Stop the marketing, erase what only the marketing purpose needed, and keep what the account purpose still needs. If you have mapped each purpose in the inventory, you can see which rows each withdrawal touches. Section 6 also says that withdrawal does not make earlier lawful processing unlawful, so you need not undo what was done before.
On withdrawal, two things happen: processing stops, and erasure follows unless something requires retention. Record both in the log, with a date for each. Our consent withdrawal guide covers the design of the withdrawal channel.
The three-year inactivity rule applies only to the classes named in the Third Schedule, with their own purposes and thresholds. It is not a general rule for all businesses. If you are outside those classes, you still need to decide when a purpose ends, and justify the choice under Section 8(7)(a).
Build and use it
The register is three linked sheets: a register of rules, a list of locations and a log of erasure events. The Excel file below contains all three, a filled example, gap flags and a summary. Enter your details on the download page to get the link.
Excel (.xlsx), about 30 KB. Sheets: Start here, Register (40 rows), Locations (60 rows), Erasure log (60 rows), Example, Summary, Lists. Gap flags are formulas. The example data and all periods in it are fictional placeholders.
The register uses the same activity IDs as the Data Inventory Workbook and the same processor IDs as the Data Flow and Processor Worksheet. You can also copy the columns below into any spreadsheet.
| Field | What to enter | Why it matters |
|---|---|---|
| Register ID | A unique ID such as R-001. | Lets you point to one retention rule in a gap log or an erasure record. |
| Activity ID | The processing activity ID from your personal data inventory, such as PA-002. | Joins the register to the inventory and the flow map. |
| Data category | The group of data this rule covers, for example account details or order records. | Different categories often need different rules. |
| Specified purpose | The purpose in your notice, in the same words as the inventory. | Section 8(7)(a) ties erasure to the specified purpose no longer being served. |
| Applicable basis | Consent, a Section 7 legitimate use, or To confirm. | Consent withdrawal is an erasure trigger under Section 8(7)(a). Other uses end with their own conditions. |
| Retention trigger | The event that starts the clock, for example account closure, invoice date, or last contact. | A period without a trigger cannot be applied. Most failed schedules skip this. |
| Retention driver | Why the data is still kept: purpose still served, law requires retention, dispute or legal hold, security log, or To confirm. | Section 8(7) allows retention only where the purpose is still served or retention is necessary for compliance with law. |
| Legal source | If a law requires retention, name the law and the section. Otherwise write None. | A claim that "the law requires it" needs a named source. This column forces that. |
| Retention rule or period | The rule in plain words, for example "30 days after account closure unless a hold applies". | This is the rule your deletion job will run on. |
| Approved by | The person who approved the rule. | Someone must own the decision to keep or delete. |
| Where copies rest | The location IDs from the Locations sheet, or a short list. | Production, backups, spreadsheets and email all hold copies. |
| Deletion trigger | What starts erasure: account closed, consent withdrawn, purpose served, erasure request, inactivity period ended, or retention period ended. | Connects the rule to the workflow that acts on it. |
| Deletion method | Delete, Anonymise, Archive with restricted access, or To decide. | Anonymising and archiving are different outcomes. Record which one you use. |
| Processor IDs | The processor register IDs of vendors that hold this data. | Section 8(7)(b) requires you to cause the Data Processor to erase data you made available to it. |
| Processors told and confirmed | Yes, No, Unknown, or Not applicable. | Shows whether vendor deletion is proven or only assumed. |
| Backup handling | How backups age out, and how you stop erased data returning after a restore. | We found no provision that sets a backup rule. Write down what you do. |
| Deletion evidence | The record that proves it: job report, ticket, vendor confirmation. | Lets you show what was deleted, when, and by whom. |
| Last verified | The date someone last checked the rule against the real system. | Shows how fresh the register is. |
| Field | What to enter | Why it matters |
|---|---|---|
| Location ID | A unique ID such as L-001. | Lets the register and the erasure log point to one place. |
| Register ID | The retention rule this copy follows. | Joins the location to a rule. |
| Location | The system, file, mailbox or place, for example order database or finance spreadsheet. | One row per place a copy rests. |
| Type | Production database, replica or search index, analytics store, backup, log, spreadsheet or export, email or chat, paper, laptop or phone, processor system, other. | Backups and spreadsheets behave differently from production data. |
| Owner | The person who can delete from this place. | A copy with no owner is never deleted. |
| Processor ID | The processor register ID if a vendor runs this place. | Joins the location to the vendor. |
| Deletion method here | How the copy goes: delete, overwrite on cycle, vendor deletion, anonymise, shred. | The method differs by location. |
| Time to disappear | How long after the trigger the copy is gone. | The longest lag is your real erasure time. |
| How you confirm | The check that shows the copy is gone: job report, screenshot, vendor email. | Evidence has to come from somewhere. |
| Last verified | The date this location was last checked. | Shows how fresh the row is. |
| Field | What to enter | Why it matters |
|---|---|---|
| Log ID | A unique ID such as E-001. | One row per erasure event. |
| Register ID | The retention rule that applied. | Joins the event to the rule. |
| Trigger | Account closed, consent withdrawn, purpose served, erasure request, inactivity period ended, retention period ended, or other. | Shows why the erasure ran. |
| Trigger date | The date the trigger happened. | Starts your measure of how quickly you acted. |
| Hold checked | Yes or No. Did someone check for a legal hold or required retention before deleting? | Section 8(7) allows retention where necessary for compliance with law. |
| Systems cleared | The location IDs cleared. | Shows which copies were handled. |
| Processors told | The processor IDs that were told to erase. | Section 8(7)(b). |
| Processor confirmation date | The date the vendor confirmed. | Shows vendor deletion is proven. |
| Completed date | The date the last copy was cleared. | Closes the event. |
| Done by | The person who completed it. | Names who did the work. |
| Evidence reference | Ticket number, report name or file location. | Lets you find the proof later. |
| Field | R-001 | R-002 | R-006 |
|---|---|---|---|
| Register ID | R-001 | R-002 | R-006 |
| Activity ID | PA-002 | PA-001 | PA-006 |
| Data category | Customer account: name, email, phone, address | Order and invoice records: items, amount, billing address | Server access logs: IP address, user ID, time |
| Specified purpose | Run the customer account and show past orders | Deliver the order and keep accounts | Detect and investigate unauthorised access |
| Applicable basis | Consent | Consent | To confirm |
| Retention trigger | Account closure (customer closes it, or we close it after inactivity) | Invoice date | Date of the log entry |
| Retention driver | Purpose still served | Law requires retention | Security log |
| Legal source | None | Tax law, section to be confirmed by Finance | DPDP Rules, Rule 6(1)(e) and Rule 8(3): minimum one year |
| Retention rule or period | Delete 30 days after account closure unless a hold applies (illustrative) | Period set by Finance after legal check (placeholder) | At least one year from the log date, then delete unless another law requires longer |
| Approved by | Head of Operations | (blank) | Head of IT |
| Where copies rest | L-001 to L-007 | L-001, L-006 | L-009 |
| Deletion trigger | Account closed | Retention period ended | Retention period ended |
| Deletion method | Delete | Delete | Delete |
| Processor IDs | P-001, P-003 | P-001 | P-001 |
| Processors told and confirmed | Unknown | Yes | Yes |
| Backup handling | Backups age out on a 35-day cycle (placeholder). Deletion log is re-applied after any restore. | Backups age out on a 35-day cycle (placeholder). | Log archive ages out with the same rule. |
| Deletion evidence | Deletion job report and ticket | Annual purge report | Log rotation report |
| Last verified | 2026-09-30 | 2026-09-30 | 2026-09-30 |
| Gap flag | Processor erasure not confirmed | Not approved | None |
A gap flag is a prompt to check, not a finding of non-compliance. A rule is flagged when it has no trigger, no period, an unconfirmed driver, a legal claim with no named source, no deletion method, vendor erasure that is not confirmed, no evidence, no approver or no verification date. A location is flagged when it has no owner, no method, no stated time, a missing processor ID or no verification. An erasure event is flagged when no hold check is recorded, it is not complete, a vendor confirmation is pending, or no evidence reference is given.
Build and use it
Most failed retention programmes have no trigger, no source or no proof. These ten are the usual causes.
| Mistake | Why it hurts | Fix |
|---|---|---|
| 1. Writing “DPDP says delete after X” | The Act gives no universal period, so the claim is wrong. | Base each period on your purpose or a named law. |
| 2. A period with no trigger | Nobody can tell when the clock starts. | Name an event stored in a system. |
| 3. “Law requires it” with no law named | It becomes a reason to keep everything. | Name the law and the section, or remove the claim. |
| 4. One rule for the whole company | Different data has different reasons. | One rule per category and purpose. |
| 5. Clearing production only | Search indexes, analytics, spreadsheets and email still hold copies. | List every location and give each an owner. |
| 6. Ignoring backups | Erased data can return after a restore. | Document the backup cycle and re-apply the deletion log. |
| 7. Assuming vendors delete | Their copies stay unless you ask. | Tell each processor and file the confirmation. |
| 8. Mixing up withdrawal and erasure | You erase too much or too little. | Work at the level of the purpose and use the five-event table. |
| 9. No hold check | You delete data needed for a dispute or a legal requirement. | Make the hold check a step in every workflow. |
| 10. No evidence | You cannot show what was deleted and when. | Keep a log row with a date and a reference. |
Build and use it
List the activities, set trigger, driver and period, name the legal source, record every location, map the workflow and processors, test with one real record, then approve and review. Each step names who is involved and what you should have at the end.
Build and use it
Here is one chain, a customer account at a fictional online store, followed from purpose to proof. The store has seven places that hold the account data and two vendors. In the register, the rule is flagged because vendor erasure is not yet confirmed.
The store, vendors and every period are fictional placeholders, not recommendations. Real periods depend on your own purpose and the laws that apply to you.
| ID | Location | Type | Owner | Deletion method here | Time to disappear | How confirmed | Gap flag |
|---|---|---|---|---|---|---|---|
| L-001 | Order database (cloud host) | Production database | Head of IT | Delete by scheduled job | Next nightly job | Job report | None |
| L-002 | Site search index | Replica or search index | Head of IT | Removed at next re-index | Within 1 day | Re-index log | None |
| L-003 | Analytics warehouse | Analytics store | Data lead | Anonymise before load | Monthly | Pipeline run log | None |
| L-004 | Nightly backup | Backup | Head of IT | Expires on its cycle | 35 days (placeholder) | Host confirms the cycle | Not verified |
| L-005 | Helpdesk software | Processor system | Support lead | Vendor deletion on request | (blank) | Vendor email | Time not stated |
| L-006 | Finance spreadsheet of invoices | Spreadsheet or export | (blank) | Manual deletion | Yearly | Finance sign-off | No owner |
| L-007 | Email exports and attachments | Email or chat | Support lead | Manual deletion | Monthly | Monthly checklist | None |
| L-008 | Email platform subscriber list | Processor system | Marketing lead | Vendor deletion on unsubscribe | Within 7 days | Unsubscribe record | None |
| L-009 | Server log archive | Log | Head of IT | Delete on rotation | At the end of the period | Rotation report | None |
Three locations are flagged: the backup has no verified date, the helpdesk software has no stated time to disappear, and the finance spreadsheet has no owner. The register row for the account rule is flagged too, because vendor erasure is not yet confirmed. The store fixes these before it relies on the rule.
E-001 is complete. E-002 is an erasure request where the data is cleared but the helpdesk has not confirmed, so the event stays open. E-003 is a consent withdrawal with no hold check and no completion date, so it is still open. None of these flags is a finding of non-compliance. Each one is a prompt for the owner to close the gap.
FAQ
We found no provision that sets one period for all personal data. Section 8(7) ties erasure to the specified purpose and to consent withdrawal, unless retention is necessary for compliance with law. Narrow fixed periods exist for security logs (one year) and for inactivity in named classes of Data Fiduciary (three years under Rule 8). Everything else is your own rule, justified by your purpose or a named law.
Under Section 8(7)(a), when the Data Principal withdraws consent or as soon as it is reasonable to assume the specified purpose is no longer served, whichever is earlier, unless retention is necessary for compliance with law. Section 12(3) adds erasure on a Data Principal’s request, subject to its own conditions. Read the exact words in the Act before you rely on this summary.
A retention trigger is the event or date that starts the retention clock, such as account closure, invoice date or the date a ticket is closed. A retention period only makes sense when it is measured from a trigger that is stored in a system.
We found no provision in the Act or the DPDP Rules, 2025 that requires one. A register is practical compliance infrastructure. It helps you meet the erasure duties the Act does contain, and it gives you a record of what you decided and why. See is data mapping mandatory under the DPDP Act.
The Act and the Rules are silent on backups. A sensible written approach is to document each backup cycle, limit access, record deletions and re-apply them after any restore, and to get your host’s written answer on how copies age out. This is good practice, not a stated legal requirement, and it is worth legal advice for sensitive cases.
Section 8(7)(b) requires the Data Fiduciary to cause its Data Processor to erase personal data that was made available to it. In practice, that means the contract should cover deletion, you should tell the vendor when erasure is due, and you should keep a confirmation. Section 8(1) keeps you responsible for processing done on your behalf.
Withdrawal ends the consent for a purpose and starts a stop-processing and erasure duty under Sections 6 and 8(7)(a). An erasure request is a right under Section 12(3) that lets a Data Principal ask you to erase their data, subject to conditions. Both can lead to deletion, but they have different sources and checks, so log them as different triggers.
Section 8(7) allows retention where it is necessary for compliance with law, and Section 12(3) is similar. You should name the law and the section in your register. Keep only the data the law covers, and only for the period it requires, which differs by law. Ask your advisers to confirm each source.
No. Rule 8(1) applies to the classes in the Third Schedule, which name e-commerce, online gaming and social media entities, with their own thresholds and purposes, and some purposes are excluded. It also requires notice at least 48 hours before erasure. Read the Schedule before assuming it applies to you.
Rule 6(1)(e) lists keeping logs and personal data for one year among the security safeguards, and Rule 8(3) sets a minimum of one year for personal data, traffic data and logs for the Seventh Schedule purposes, after which they are erased unless a law requires longer. Check the exact clauses and any sector direction that sets a longer period.
The Act does not set a format. A useful record shows the rule that applied, the trigger and its date, that a hold was checked, which locations and processors were cleared, the completion date, who did it, and a reference such as a job report, a ticket or a vendor email. The erasure log sheet in the free register has these fields.
No. Anonymised data can be kept only if it can no longer be linked to a person. If re-identification is still possible, it is still personal data. Record in the register whether you delete, anonymise or archive, and test for re-identification before you rely on anonymisation.
Related
Go to the full method, the legal text and the practical tools. When you are ready to move from records to working controls, see the DPDP implementation framework.
Sources
Consultant-led and partner-backed.