Data Backup and Recovery Checklist
A quarterly program that an accounting firm's IT lead and managing partner run to verify client-data backups, test disaster recovery, and keep the WISP current with IRS Pub 4557 and FTC Safeguards Rule expectations.
Backup Strategy and WISP Alignment
-
Inventory client data and tax software systems
List every system that holds client data — tax prep (UltraTax, Lacerte, ProSystem fx, Drake), GL (QuickBooks Online, Xero, Sage Intacct), document management (SmartVault, TaxDome, ShareFile, Liscio), and payroll (Gusto, ADP, Paychex). Note where each stores SSNs, EINs, and bank account numbers; this classification drives the WISP and the encryption requirements downstream.
-
Map retention to IRS Pub 4557 requirements
IRS Publication 4557 and the FTC Safeguards Rule require paid preparers to retain and protect client records. Most firms hold 7 years for federal returns and longer for fixed-asset basis schedules and shareholder basis (Form 7203). Cross-check state-board retention rules and any engagement-letter commitments before setting expiration policies.
-
Set RPO and RTO targets per system
RPO (recovery point objective) caps tolerable data loss; RTO (recovery time objective) caps tolerable downtime. During tax season, tax-software RPO/RTO should be tighter (1 hour / 4 hours) than off-season. Document targets per system so the backup schedule is driven by a number, not a guess.
-
Choose backup methods and storage media
Pick the mix per system: full weekly plus incremental nightly is common for GL data; image-level backups protect tax workstations against ransomware. Cloud-only is cheaper but check egress costs and confirm the provider's SOC 2 Type II coverage period before committing client data.
Backup Execution and Verification
-
Schedule nightly backups of tax and GL platforms
Configure tax and GL platforms for off-hours backup. UltraTax and Lacerte have built-in backup utilities; QBO Advanced has native backup, lower tiers do not. For QuickBooks Desktop, schedule QBB backups outside business hours and confirm they aren't blocked by company-file locks left open by overnight users.
-
Verify backup integrity with a sample restore
Pull a random recent backup and restore it to a sandbox. A backup that runs nightly without errors but can't restore is the most common DR failure mode — corrupt files, missing media, expired credentials. Log the test result before moving on.
Collects list -
Catalog backups with engagement and period tags
Tag backups by client engagement (or firm-wide system), period (monthly close, quarterly, year-end), and retention class. During an IRS examination or a client audit response, you need to pull a specific period's backup quickly — not scroll through 400 unlabeled archive files.
Off-Site Storage and Encryption
-
Encrypt backups before transfer off-site
Use AES-256 at rest and TLS 1.2+ in transit. The FTC Safeguards Rule requires encryption of customer information, and state laws (MA 201 CMR 17.00, NY SHIELD Act, TX BC §521) layer additional standards on top. Store keys in a separate vault from the backup itself — encryption is meaningless if the key sits next to the ciphertext.
-
Replicate to a geographically separate region
Off-site means a different metro area or cloud region — a NAS in the same building as the office is not off-site. Common patterns are AWS S3 cross-region replication, Backblaze B2 with geographic redundancy, or a paid Datto/Axcient image-replication service.
-
Review the storage provider's SOC 2 Type II report
Request the provider's most recent SOC 2 Type II. Check the coverage period (must not be expired), the trust services criteria included (Security at minimum; Confidentiality if you store returns), and any qualified opinions or carve-outs of subservice organizations. File the report with the WISP supporting documentation.
Collects file
Disaster Recovery Planning
-
Document recovery procedures by system
Write a per-system runbook: how to restore UltraTax client files from backup, how to recover a QBO company from a backup, how to rehydrate a SmartVault portal. Reference exact menu paths; keep credentials in the password vault and reference the vault entry, never the password itself.
-
Assign DR roles to partners and IT lead
Name a recovery coordinator (usually the managing partner or IT director), a tax software lead, a GL/bookkeeping lead, and a client communications lead. During tax season the coordinator role should rotate to a backup if the managing partner is mid-return on April 14.
-
Run a tabletop exercise with a tax-season scenario
Walk the team through a realistic incident — ransomware on a tax workstation March 1, or a flooded server closet April 10. Time how long each role takes to execute their part of the runbook. Capture gaps so they can be fixed before the live test or the next tax season.
Collects list Collects paragraph -
Decide whether a live restore test is required
A tabletop is cheaper but doesn't catch corrupted backups, expired service-account credentials, or broken integrations. Plan a live restore at least annually, or after any major system upgrade or vendor change. Mark Yes to trigger the live-restore steps; otherwise the tabletop is this quarter's test of record.
Collects list
Recovery Execution
-
Restore a sample backup to a sandbox
Spin up an isolated VM or cloud sandbox. Restore the most recent backup of the largest tax-software dataset and confirm clients open without error. Never test against production — a botched restore can overwrite live engagement data mid-season.
-
Validate restored data against the source system
Reconcile a sample of restored returns or trial balances against production. For tax data, compare e-file confirmations and refund amounts on three sampled returns; for GL data, compare trial balance totals at a known prior month-end. Attach the validation workpaper.
Collects file -
Document the recovery timeline and gaps
Record wall-clock time from restore start to validated data — that's your real RTO, not the planned one. Note gaps: missing backups, expired service-account passwords, broken third-party integrations (bank feeds, Avalara connector). Feed the gap list into the WISP update step.
Post-Recovery Review
-
Analyze root cause and contributing factors
For a tabletop or test, identify what would have failed in a real incident. For an actual incident, run a 5-Whys against the failure mode. Keep the review no-blame so staff surface the real causes — it's the only way the WISP improves.
-
Determine whether client notification is required
State breach-notification laws (MA 93H, NY SHIELD, CA CCPA, TX BC §521 — roughly all 50 states) trigger when client PII is accessed without authorization. Even if the backup itself wasn't breached, a recovered system that was compromised pre-backup may have already exposed SSNs. Consult counsel before deciding.
Collects list -
Notify affected clients per state breach laws
Send notice within the state-specific window — typically 30 to 60 days from discovery. Include what data was affected, when, and remediation offered (credit monitoring is standard for SSN exposure). Many states also require notice to the state Attorney General and the three consumer reporting agencies above defined thresholds.
-
Update the WISP and DR plan with findings
Revise the WISP to reflect any changes in systems, vendors, or controls discovered during the test. IRS Pub 5708 expects the WISP to be a living document, reviewed at least annually. File the updated version with firm compliance records and re-train staff on any changed procedures.
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Data Backup and Recovery Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.