> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Migrating Contract Control From a Spreadsheet to a Documental System
- URL: https://blog.jestor.com/migrating-contract-control-spreadsheet-document-system/
- Published: 2026-09-15T20:26:08.000Z
- Updated: 2026-09-15T20:26:08.000Z
- Author: Bruno Bannach

Migrating contract control means the tracking row that used to live in a spreadsheet, with the actual PDF stored somewhere else entirely, becomes one connected record — document and data together. In **Jestor**, **Docs** connect directly to the contract record itself.

Spreadsheet-based contract tracking almost always separates the metadata (dates, values) from the actual document, which forces anyone reviewing a contract to check two different places.

## What separates document and data in spreadsheet tracking

- The spreadsheet holds dates and values; the actual PDF lives in a shared drive somewhere else
- No guarantee the linked file still matches what the spreadsheet row describes
- Manual updates required in two places whenever a contract changes
- No version history connecting a specific document to its corresponding data row

## How migrating to a documental system works

- Upload the contract-tracking spreadsheet as the starting metadata structure
- Attach the actual contract documents directly to their corresponding records
- **Version history** applies to both the document and its associated data together
- Automations can flag contracts approaching renewal, referencing both document and data

## Why Jestor fits this use case

- Document and metadata live in the same record, not split across two systems
- Version history keeps document and data changes synchronized
- Migration starts from the existing spreadsheet, preserving current tracking data
- Reduces the "does this document match this row" uncertainty entirely

| Spreadsheet + separate file storage       | Connected documental record              |
| ----------------------------------------- | ---------------------------------------- |
| Metadata and document in different places | Document attached directly to the record |

## Video Tutorial: See It in Action

🎥 **Video Tutorial:** [Docs integrado ao seu sistema de gestão](https://www.youtube.com/watch?v=yNXXpOPOBTc&ref=blog.jestor.com)

See how documents connect directly to their contract's record.

## Frequently Asked Questions

**Can the existing contract-tracking spreadsheet be uploaded as a starting point?** Yes, as the metadata structure to attach documents to. More at [jestor.com](https://www.jestor.com/?ref=blog.jestor.com).

**Does version history apply to the document itself?** Yes, alongside the metadata it's connected to.

**Does this replace legal review of contracts?** No, it structures the tracking; legal review still applies.

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.