Preduzmi vs Excel: Why Spreadsheets Break Down for Paušal Compliance
Feature-by-feature comparison of managing paušal obligations with spreadsheets versus Preduzmi. Learn where manual tracking fails and when a dedicated tool makes the difference.
Last updated: October 2026. Product behaviour described as of this date.
Most paušalci start with a spreadsheet. A Google Sheet with a few columns — invoice number, date, amount, running total. It works fine for the first few months. Then you issue an invoice in EUR and need the NBS middle rate for that date. Then you realise you have been summing payment dates instead of service dates. Then the rolling 12-month total goes stale and you only notice how close you are to the 8,000,000 RSD VAT threshold when someone else mentions it.
Spreadsheets are powerful general-purpose tools. Paušal compliance has specific, rule-bound requirements that a spreadsheet handles only as well as you remember every rule, every formula and every edge case, every time.
This article compares managing paušal obligations by hand (spreadsheets, bank statements, mental checklists) with Preduzmi, a tool built for Serbian paušalci. The Preduzmi column describes what the product does today, including where it stops.
Feature-by-feature comparison
| Capability | Excel / Google Sheets | Preduzmi |
|---|---|---|
| Invoice recording | Manual entry: invoice number, date, amount, client. Copy-paste from your invoice document. | Upload PDF, DOCX or an image; AI extracts the fields; you review and confirm. Several files can be uploaded at once. Manual entry is also available. |
| Invoice documents | Your own Word or Sheets template. | Generates an invoice as PDF or DOCX from the invoice form, in English, Serbian or both. It does not send e-invoices through SEF. |
| KPO knjiga | Build your own KPO template, number the rows and keep them in order yourself. | PDF or DOCX of the year's confirmed and paid income invoices, in service-date order. Warns when unconfirmed income invoices would be left out. |
| Currency conversion | Look up the NBS middle rate on nbs.rs for each invoice, copy it, multiply. | Fetches the NBS middle rate for the invoice's service date (EUR and USD) and calculates the RSD amount. The rate is shown on the invoice. |
| 6M calendar-year limit | A SUMIFS formula filtered by year and by service date. Breaks when the sheet changes shape. | Sums income invoices by service date for the calendar year. Drafts are included by default, with a toggle to exclude them. A second tab computes the same from incoming bank payments. |
| 8M rolling 12-month limit | A date-window formula that you must keep current. | Sums all income invoices with a service date in the last 12 months (or all incoming payments, on the transactions tab), recalculated each time the dashboard loads. |
| Limit warnings | You notice when you look at the number. | Colour bands on both bars and a banner across the app from 85% of either limit, and a separate one at 100%. |
| Tax payment tracking | A separate sheet, checked against the bank statement each month. | Recognises the four payments in imported statements by treasury account and BOP reference. A monthly table shows paid, partial or overdue per category. Tracking is cumulative, so an early or combined payment counts. Bank fees are excluded. |
| Payment deadlines | A phone reminder you set up once. | No reminders are sent (no email or push). The dashboard shows the next payment with a countdown and the amounts. The table flags a month once its deadline passes without a matching payment. |
| Bank statement import | Download a CSV or XML from the bank and read through it. | Raiffeisen XML, Alta Banka XLS (web and desktop exports, detected automatically) or CSV from any bank, with a manual column-mapping dialog. Export steps: Raiffeisen, Alta. |
| Duplicates | Upload the same statement twice and every row is doubled. | Transactions already imported are skipped by bank reference, or by date, amount and payee account where there is no reference. The skipped count is shown. |
| Invoice-payment matching | Scroll through transactions and link them in your head. | Suggests the best-matching transactions by date and amount; you confirm the link. The invoice moves to Paid and takes the payment date from the bank. A difference in amount is recorded with a reason. |
| Rešenje data | Remember four monthly amounts and update them in January. | Upload the rešenje; AI extracts the four amounts, the BOP and the treasury accounts; you review them. Stored per year, with a "valid from" month for mid-year changes. |
| Multi-year history | Separate tabs per year. Formulas break on restructuring. | One place, with a year selector. The rolling limit spans the year boundary on its own. |
| Working with an accountant | Email the spreadsheet; argue about which version is current. | No shared access: each account belongs to one user. You can download the KPO (PDF or DOCX), the invoice files and a CSV of transactions and send them. |
| Mobile | Google Sheets works on a phone, awkwardly. | A responsive web app; there is no native mobile app. |
| Data handling | Depends on your sharing settings and backups. | Each user's data is isolated by database-level access policies. Uploaded invoices and rešenja are sent to an AI provider for parsing; CSV statements are processed without third parties. |
| Setup | Build and test the template, then maintain it. | Register and fill the business profile by hand or from an uploaded rešenje, then add invoices. |
| Cost | Free (Google Sheets) or the Excel licence you already have. | Annual subscription: $30/year at the time of writing (October 2026), with a 14-day trial. |
Where spreadsheets actually work fine
For some paušalci, a spreadsheet is genuinely enough.
You might not need Preduzmi if:
- You issue a few invoices a month, all in RSD, to Serbian clients
- Your revenue sits far below both limits
- You have a single bank account with simple transactions
- You are comfortable with formulas and maintain the sheet carefully
- You already have a system that works
In these cases a dedicated tool may not be worth the cost. A well-kept Google Sheet with correct formulas does the job.
Keep track of your paušal obligations
Revenue limits, tax payments, KPO entries — all in one dashboard.
The spreadsheet starts to strain when:
- You invoice in foreign currency and need the NBS rate for every invoice
- Your revenue gets close enough to either limit that the exact total matters
- Payments arrive in more than one account or bank
- You want to check the four monthly payments against the bank statement every month
- You have ever changed the sheet's structure and forgotten a formula
- You have ever found a calculation error months later
The hidden cost of spreadsheet errors
Spreadsheet compliance fails silently. A broken formula, a wrong cell reference or a filter that hides a row does not announce itself. Typical ways it surfaces:
- You realise in November that the sheet summed issue dates instead of service dates, and the limit total was wrong all year
- A duplicated row inflated the revenue total, and you worried about a limit you were not near
- A missed row deflated it, and you were nearer the limit than you thought
The rules behind the two totals are in revenue limits: the 6,000,000 RSD paušal ceiling (ZPDG čl. 40 st. 2 t. 4) and the 8,000,000 RSD VAT threshold (ZPDV čl. 33 st. 1). A tool does not remove every risk, but it removes the risk of building and maintaining the calculation yourself. Its results are still yours to check.
What Preduzmi doesn't do
Preduzmi is a tracking tool, not an accounting system and not a substitute for professional advice:
- It doesn't replace an accountant in complex cases: moving to bookkeeping (knjigaš), entering the VAT system, the annual income tax, an independence-test question
- It doesn't submit anything for you. Nothing goes to the Poreska uprava, ePorezi, SEF or your local tax administration; you make the four monthly payments yourself
- It doesn't check that an invoice is legally complete. The generated document is a template filled from your data; the required elements are yours to verify
- It isn't built for a DOO, a knjigaš or trade in goods
- It doesn't give legal or tax advice. When a situation needs interpretation of the law, ask a professional
What it does is put the routine in one place: statement import, the KPO and invoice-payment reconciliation in a single tool, so that the questions left for you and your accountant are the ones that need judgment. We cover whether a paušalac needs an accountant in a separate guide.
Migration from spreadsheet to Preduzmi
If you have been using a spreadsheet and want to switch:
- Collect your invoice files (PDF, DOCX or images) for the year
- Upload them — the parser extracts the data, and you check each invoice against your spreadsheet before confirming it
- For invoices without a file, enter them by hand from your spreadsheet
- Import your bank statements to build the transaction history
- Compare the totals with your spreadsheet. If they differ, one of the two has an error, and now you can find it
The migration is a one-time effort. After it, the ongoing work is adding new invoices and statements as they come. KPO vs bank statement explains why the two totals rarely match exactly.
Key takeaways
- Spreadsheets work for simple cases — few invoices, one currency, revenue far below the limits. If that is you, keep your spreadsheet.
- Spreadsheets strain with complexity — foreign currency, revenue near a limit, several accounts, and formula errors that accumulate silently.
- A dedicated tool's real advantage is fewer silent errors — wrong dates, broken formulas, missed conversions, duplicate rows.
- Preduzmi puts statement import, the KPO and reconciliation in one tool. It tracks; it does not file, and it does not replace an accountant in complex cases.
- The comparison isn't only subscription vs free — it is also the time spent maintaining formulas and the cost of an error found late.
Written by Evgeny Smirnov — paušalni preduzetnik since 2022, with the help of AI.
Also read
KPO Knjiga in Serbia: The Paušal Turnover Book
What the KPO knjiga is for a Serbian paušal (flat-rate) entrepreneur: the five columns under Pravilnik čl. 7, overa, electronic keeping, retention and fines.
6 Million vs 8 Million: The Complete Guide to Serbian Paušal Revenue Limits
Understand the two revenue thresholds for Serbian paušal entrepreneurs: the 6M calendar-year limit and the 8M rolling 12-month PDV limit. Learn how each is calculated and what happens if you exceed them.
How to Pay Your Paušal Taxes: 4 Payments, 4 Accounts, and Reference Numbers
Step-by-step guide to making monthly paušal tax payments in Serbia: treasury accounts, BOP reference numbers, payment codes, and how to fix errors.
KPO Knjiga vs Bank Statement: Why the Two Totals Differ
Your KPO knjiga and your bank statement measure different things. The eight legitimate reasons the totals differ, why the 6,000,000 RSD limit counts invoices issued rather than payments received, and how to reconcile.