Contracts, quotes and documents from templates, filled in from your data.
Document automation means that a quote, contract, order, power of attorney or handover report is filled in by the system with data you already have in your CRM, a spreadsheet or a public register, and saved as a PDF ready to sign and send. You edit the template yourself in Word or Google Docs, so changing one clause of a contract doesn't need a programmer.
I build document generation as a full-stack developer from Košice, Slovakia, for small and mid-sized companies that put their quotes and contracts together by copying old files.
Ing. Patrik Krajňák, Full-stack developer, Košice
Which documents are worth generating from a template
Any document is worth generating if it's created again and again and what changes is mainly the customer, the items, the prices and the dates. If someone makes it today by opening the last one and overwriting it, sooner or later the previous customer's name or an old price will be left in it. Examples from different industries:
- Quotes: a repair quote based on the labour and parts price list in a service business, a price list for a new customer with their discount at a wholesaler
- Contracts: a contract for work in manufacturing, a service contract, a framework agreement with a customer or a bookkeeping agreement at an accounting firm
- Purchase orders to suppliers, for example when material stock drops below the minimum
- Powers of attorney, for example for a tax or accounting firm representing clients before the authorities
- Handover reports when delivering a machine, a finished job or a repaired device, including photos taken on a phone
- Delivery notes and shipping documents in logistics
- Onboarding documents for a new employee, such as the employment contract and a confirmation that work equipment was handed over
How it works
From data to a signed document
- 1
Data
The salesperson picks the customer and items or just enters the company ID.
- 2
Template
The system fills in the Word or Google Docs template and creates a PDF.
- 3
Check
Rules confirm nothing is missing, and a manager approves documents above a set amount.
- 4
Signature and sending
The document goes out for signature or by email from your inbox.
- 5
Archive
The PDF is filed with the client together with the template version it came from.
Templates in Word or Google Docs that you edit yourself
A template is an ordinary Word or Google Docs document with placeholders instead of specific details, for example {{company_name}} or {{quote_valid_until}}. When generating, the system replaces them with data and turns the result into a PDF. Your logo, fonts and formatting stay exactly as you set them, and when your lawyer changes the clause on contractual penalties, they change it in Word as before.
In Microsoft 365 the template sits in SharePoint or OneDrive and the finished document is converted to PDF through Microsoft Graph, Microsoft's interface for working with files. In Google Workspace the system makes a copy of the template in Google Drive, replaces the placeholders through the Google Docs API and saves it as a PDF. If the document should look like your website, or you create many of them at once, I can also generate it directly in the system without Word.
A template can do more than fill in a name:
- A table of items with quantities, prices, the VAT base and VAT per rate, where the total is calculated and nobody retypes it
- Clauses that appear only sometimes, for example the deposit clause only when you agreed on a deposit
- The same contract in several languages if you have customers abroad
- Document numbers that follow your own number series, with no two quotes sharing a number
Company details from public registers by ID number
For a new customer, the company ID number (IČO) is enough. For Slovak companies the system fills in the name, registered address, legal form and statutory body from the public API of the Slovak Register of Legal Entities, which also covers sole traders. For Czech companies it uses ARES, the Czech register of economic entities. For a larger deal I can also pull a Slovak company's financial statements from the Slovak Register of Financial Statements, so you can see how big the company is before you sign a contract with it.
I can check whether a foreign customer's VAT number is valid in the European Commission's VIES system. If a customer gave you details that differ from the register, such as a different delivery address, the system won't quietly overwrite them and leaves the decision to the salesperson.
All other data comes from where you already keep it: the CRM, the stock or accounting software, a form on your website or a shared spreadsheet. If you don't yet have one place where clients and jobs come together, documents are usually part of a custom CRM.
Electronic signatures: which one is enough and when you need a qualified one
I fit the electronic signature into the process according to the document being signed. Under Article 25 of the eIDAS Regulation, a qualified electronic signature has the same legal effect as a handwritten signature. In Slovakia, for example, you can create one with a chip ID card that holds a qualified certificate.
Which signature a particular document needs is for your lawyer to decide. For some acts the law requires a specific form, such as an officially certified signature, and automation doesn't change that. My part is technical: I prepare the document, send it for signature and file the signed version with the client.
Most often it's one of these routes:
- The customer accepts a quote through a link in an email and the system records who accepted it and when
- The contract goes out through an e-signature service of your choice, if it offers an API, and the signed copy comes back to the archive
- With a qualified signature, the system prepares the PDF and stores the signed file with the contract
Sending from your inbox, archive and versions
The finished document is emailed from your company mailbox in Microsoft 365 or Google Workspace. The customer replies directly to the salesperson who sent the quote, and a copy stays in their sent mail like any other email.
Every document is filed with the client: in SharePoint, Google Drive or the system's database. The record shows who created it, when it went out, whether it has been signed and which version of the template it came from. When you change your terms and conditions, new contracts use the new version, and for the old ones it stays clear what the customer signed.
Reminders can be tied to the archive. A quote the customer hasn't responded to within a week shows up in the salesperson's tasks, and for a contract nearing its end the system reminds you about renewal a month ahead. An accepted quote or order can go straight into POHODA or Money as a document through their import or API, as described on the page about connecting systems.
Where AI helps and where it doesn't
AI doesn't write the text of your contracts. The contract comes from a template your lawyer approved, and the system takes the figures from the price list and the job data. I use a language model one step earlier: it reads the customer's inquiry from an email or an attachment and suggests the quote items. Fixed rules check that the items exist in the price list and that the prices match, and a person approves the quote before it goes out.
Everything I build with AI works on the same principle: the language model reads and suggests, rules check, and a person decides the unclear cases. I process data in the EU wherever possible and call models through business APIs, which under the providers' terms are not used for training by default. You'll find more about agents that read emails and attachments on the page about AI agents for business.
When Word, an off-the-shelf tool or your CRM is enough
You don't need a custom solution if you produce a few contracts a month and only the name and amount change. Mail merge in Word, which fills a template from an Excel sheet, or a template in Google Docs will do. If you issue quotes from your accounting or invoicing software and you're happy with how they look, keep them there. If you're considering Odoo, it has quotes with online signature built into its sales module.
Custom document generation pays off when at least one of these applies:
- The data for the document sits in several systems, for example the customer in the CRM, prices in the stock software and terms in a spreadsheet
- The contract has many variants and conditional clauses and people make mistakes putting it together
- Documents above a certain amount must be approved by a manager or director before they go out
- You want one flow from quote through signature and archive to a document in your accounting software
- Many documents are created every day and each one has to be sent and filed in the right place
What document generation from templates costs
Automating one type of document, for example a quote from the CRM to a PDF sent from your inbox, usually takes a few days of work and starts at €500. The price goes up with the number of templates and conditional clauses, the number of systems the data comes from, and an e-signature integration. If documents are part of a system the company runs on every day, such as a CRM or client portal, the price depends on the scope of the whole system. Running costs come to tens or a low few hundred euros a month.
The consultation is free, and after the first call you get a specific price and date. The quote is split into parts. Once you agree to it or to some of its parts, I'll build a free prototype that fills in your real template, so you can check that it will work before you make the final decision. You pay 20% of the price when you order and the rest on handover.
By default I run the system on my own accounts for a monthly fee that covers hosting, backups and updates, and I always fix bugs in it free of charge. Contracts and quotes contain personal data, so before launch we sign a data processing agreement under Article 28 of the GDPR. Other processes around documents that can be automated are listed in the overview of business process automation.
To get started, tell me in the form below which documents you make by hand today and where the data for them comes from. You're welcome to send sample documents with the personal data blacked out.
Sources
- Google Workspace: Merge text into a document (Google Docs API)
- Microsoft Graph: converting a OneDrive or SharePoint file to PDF
- Slovak Register of Legal Entities: public REST API documentation
- Slovak Register of Financial Statements: RÚZ Open API
- Czech Ministry of Finance: ARES, Administrative Register of Economic Entities
Common questions
Do we have to stop using Word?
No, the templates stay in Word or Google Docs and you edit them as before. The system only fills them with data and saves them as PDFs, so a change to the contract wording is made by your own people without a programmer.
Is an electronically signed contract valid?
Under Article 25 of the eIDAS Regulation, a qualified electronic signature has the same legal effect as a handwritten signature throughout the EU. For other types of electronic signature, and for documents where the law requires a specific form, your lawyer should decide on the right method. I make sure the document goes out for signature and the signed copy is filed in the archive.
Where does the system get the customer's details?
From wherever you already keep them: the CRM, the accounting or stock software, a form on your website or a spreadsheet. For a new company the ID number is enough, and the system fills in the name, address, legal form and statutory body from the Slovak Register of Legal Entities or the Czech ARES. Details that differ from the register are never overwritten without a person confirming it.
Can an accepted quote become a document in POHODA or Money straight away?
Yes, if your software offers an import or an API. POHODA accepts documents via XML and Money S3, S4 and S5 have an API module, so an accepted quote or order can become a document without retyping. For other software I check the route in the vendor's documentation before I send you a quote.
How much does automated contract and quote generation cost?
One type of document with PDF generation and sending usually starts at €500 and takes a few days of work. If documents are part of a CRM or client portal, the price depends on the scope of the system, with running costs of tens to a low few hundred euros a month. You get a specific price and date after the first call.
More services and projects
- Service Business process automation Business process automation for small and mid-sized companies: invoices, documents, quotes, orders, stock, attendance and reports. One process from €500.
- Service Custom CRM A custom CRM puts clients, quotes and contracts in one database. For the tax firm DAU, I wrote the CRM's security layer and rebuilt its client portal.
- Service System integration I connect your website, online store, CRM and inventory to Pohoda, Money, KROS or ABRA Flexi, with retries, logs and error alerts. Usually from €500.
- Service AI agents for business Custom AI agents process emails, orders and documents using fixed rules, and a person approves any step involving money. The consultation is free.
Contact
Tell me what you still do by hand.
A few lines about the process that slows you down or the system you need are enough. Within eight hours I'll get back to you on whether and how it can be built, and if it makes sense, we'll set up a short call.
Prefer email or phone?
patrik.krajnak.dev@gmail.com +421 950 625 466
I reply within 8 hours. Based in Košice, Slovakia (CET), working remotely
Calls on Google Meet: Monday to Thursday 7:00 to 20:00, Friday until 18:00. Weekends by arrangement.
I use your details only to reply and to arrange the call. Privacy policy