Guide8 min read

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: March 2026.

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 to look up the NBS exchange rate for that specific date. Then you realize you've been tracking the wrong date (payment date instead of service date). Then you forget to update the rolling 12-month total and don't notice you're approaching the 8M PDV limit until your accountant mentions it in passing.

Spreadsheets are powerful general-purpose tools. But paušal compliance has specific, rule-bound requirements that spreadsheets handle poorly — not because they can't, but because they depend entirely on you remembering every rule, every formula, every edge case, every time.

This article compares managing your paušal obligations manually (spreadsheets, bank statements, mental checklists) versus using Preduzmi, a purpose-built tool for Serbian paušalci.


Feature-by-feature comparison

CapabilityExcel / Google SheetsPreduzmi
Invoice recordingManual entry: type invoice number, date, amount, client name. Copy-paste from your invoice document.Upload PDF/DOCX — AI extracts all fields automatically. Review and confirm. Batch upload supported.
KPO knjiga generationBuild your own KPO template. Manually number entries. Hope you maintain chronological order.Auto-generated from confirmed invoices. Sequential numbering enforced. Chronological order guaranteed. Exportable.
Currency conversionLook up NBS middle rate on nbs.rs for each invoice date. Copy the rate. Multiply manually. Hope you used the right date.Auto-fetches NBS rate for the service date. Shows it to you for confirmation. Calculates RSD amount automatically.
6M calendar-year limitWrite a SUMIFS formula filtering by year. Remember to use service date, not issue date or payment date. Update formula if you add columns.Real-time calculation displayed on dashboard. Color-coded progress bar. Includes draft invoices.
8M rolling 12-month limitComplex formula: sum all invoices where service date falls within the last 365 days. Recalculates only when you open the sheet. Easy to get wrong.Calculated on every page load. Updates in real time as invoices are added or modified. Alert banner when approaching threshold.
Limit warningsYou notice when you happen to look at the number and do the mental math. No alerts.Automatic color-coded warnings: green → yellow → orange → red. Persistent alert banner when above 85% of either limit.
Tax payment trackingSeparate sheet or mental checklist. Manually check bank statement each month for four payments.Upload bank statements — auto-categorizes tax payments by treasury account number. Monthly compliance table shows paid/unpaid status per payment type.
Tax payment remindersCalendar reminder on your phone. You set it up once and hope it keeps working.Dashboard shows current month's payment status. Alerts if past the 15th deadline with unfound payments.
Bank transaction importDownload CSV/XML from bank. Open in Excel. Manually scan for relevant transactions.Upload XML (Raiffeisen) or CSV (any bank). AI-assisted column mapping for CSV. Deduplication prevents double-counting.
Transaction deduplicationEntirely your problem. Upload the same file twice — double entries. Overlapping date ranges — duplicates.Automatic deduplication by reference number (primary) or date+amount (fallback). Duplicates flagged, never silently added.
Invoice-payment matchingManual: scroll through bank transactions, find the one that matches the invoice amount, mentally link them.Manual linking in UI (click invoice → select matching transaction). Invoice status auto-updates to PAID.
Rešenje data managementRemember the four monthly amounts. Update them in January. Keep the PDF somewhere you can find it.Upload rešenje PDF — AI extracts amounts, BOP, treasury accounts. Stored per year. Historical amounts preserved.
Multi-year historyGrows unwieldy. Separate tabs per year. Formulas break when you restructure.All data in one place. Filter by year. Rolling calculations span years automatically.
Sharing with accountantEmail the spreadsheet. Version confusion. "Which file is current?"Export data or grant read access. Single source of truth.
Mobile accessGoogle Sheets works on mobile but is painful to use for data entry.Responsive web app. Check dashboard status from your phone in 10 seconds.
Data securityGoogle Sheet — anyone with the link can view (if sharing settings are wrong). Local Excel file — no backup unless you set it up.Per-user data isolation enforced at database level. Your data is never visible to other users.
Setup time2–4 hours to build a decent template with formulas. Then ongoing maintenance.Register, fill business profile (10 minutes or upload rešenje for auto-fill), start uploading invoices.
CostFree (if using Google Sheets) or Excel license you already have.Subscription (see pricing page).

Where spreadsheets actually work fine

Let's be fair. For certain paušalci, a spreadsheet is genuinely sufficient:

You might not need Preduzmi if:

  • You issue fewer than 3–4 invoices per month, all in RSD, to Serbian clients
  • Your revenue is well below 4M RSD and nowhere near either limit
  • You have a single bank account with simple transactions
  • You're comfortable with formulas and enjoy maintaining your spreadsheet
  • You already have a working system and zero compliance concerns

In these cases, the marginal benefit of a dedicated tool may not justify the cost. A well-maintained Google Sheet with correct formulas does the job.

Track your paušal obligations automatically

Revenue limits, tax payments, KPO entries — all in one dashboard.

Try Preduzmi free

The spreadsheet breaks down when:

  • You invoice in multiple currencies and need accurate NBS conversion per invoice
  • Your revenue is in the 4–7M RSD range where limit tracking is critical
  • You have transactions from multiple sources or banks
  • You want to verify tax payments against bank statements automatically
  • You've ever forgotten to update a formula after changing your spreadsheet structure
  • You've ever discovered a calculation error months after the fact

The hidden cost of spreadsheet errors

Spreadsheet compliance has a failure mode that purpose-built tools don't: silent errors. A broken formula, a wrong cell reference, a filter that excludes a row — these don't announce themselves. You discover them when:

  • The Tax Authority sends an inquiry because your KPO total doesn't match their records
  • You realize in November that you've been tracking issue dates instead of service dates, and your limit calculation is wrong
  • You find a duplicate entry that inflated your revenue tracking, causing unnecessary stress about limits
  • Your rolling 12-month calculation was using 12 calendar months instead of 365 days, and the actual figure is higher than you thought

Each of these scenarios has appeared in paušalci community forums. They're not hypothetical — they're the predictable result of relying on manual processes for rule-bound calculations. The financial cost ranges from minor (penalty interest) to severe (unexpected PDV registration obligation discovered after the fact).

A dedicated tool doesn't eliminate all risk, but it eliminates the category of risk that comes from building and maintaining your own compliance system.


What Preduzmi doesn't replace

Preduzmi is a tracking and compliance tool, not a full accounting system or a substitute for professional advice:

  • It doesn't replace an accountant for complex situations (switching to knjigaš, annual income tax obligations, independence test assessment)
  • It doesn't file taxes for you — you still make the four monthly bank transfers yourself
  • It doesn't generate legally valid invoices (in the first version) — you create invoices in your own tool/template and upload them to Preduzmi for tracking
  • It doesn't provide legal advice — when a situation requires interpretation of tax law, consult a professional

Think of it as the tool that handles the routine 95% — accurate tracking, limit monitoring, payment verification, KPO generation — so that you and your accountant can focus on the 5% that actually requires judgment.


Migration from spreadsheet to Preduzmi

If you've been using a spreadsheet and want to switch:

  1. Export your existing invoices from the spreadsheet
  2. Upload invoice files (PDFs/DOCXs) to Preduzmi — the AI parser will extract the data, and you verify it matches your spreadsheet records
  3. For invoices without files, create them manually in Preduzmi using the data from your spreadsheet
  4. Upload bank statements to populate your transaction history
  5. Verify totals — your Preduzmi dashboard totals should match your spreadsheet. If they don't, you've likely found an error in one system or the other (and now you can fix it).

The migration is a one-time effort. Once your historical data is in Preduzmi, ongoing maintenance is uploading new invoices and bank statements as they occur.


Key takeaways

  1. Spreadsheets work for simple cases — few invoices, single currency, revenue well below limits. If that's you, keep your spreadsheet.
  2. Spreadsheets break down at scale and complexity — multiple currencies, limit-adjacent revenue, multi-bank transactions, and the cumulative risk of formula errors.
  3. The core advantage of a dedicated tool is eliminating silent errors — wrong dates, broken formulas, missed conversions, duplicate entries. These are the errors that cause real compliance problems.
  4. Preduzmi handles the routine compliance (KPO, limits, currency conversion, tax payment tracking) so you can focus on your actual business.
  5. The cost comparison isn't just subscription vs free — it's subscription vs the time spent maintaining formulas, the risk of undetected errors, and the potential cost of compliance failures.
E

Written by Evgeny Smirnov — paušalni preduzetnik since 2022, with the help of AI.

This article is for informational purposes only and does not constitute legal, tax, or financial advice. Consult a qualified professional for guidance specific to your situation.