The difference between manual invoice tracking (Excel, email archive, hand calculation) and software-based reconciliation isn't just speed; is evident in terms of error risk, scalability, and audit trail. For free consumer subscribers, the unit price and reactive penalty limits (33%/20% or 20%/15%) calculated with the formula (PTF+YEKDEM)×KBK are easily bypassed in the manual process. This paper compares the two approaches along four dimensions.
Which one is more advantageous in terms of cost?
There are no direct software licensing costs in the manual process; but the hidden cost is staff time. Monthly reconciliation for a single site takes approximately a few hours; In a portfolio of ten facilities, this period extends for days. Software licensing automates this effort, lowering the total cost of ownership (TCO). In the industry, where the share of energy expenses varies between 5-20% on a facility basis, even a one-time detection of unit price deviation can amortize the software investment.
Where is the risk of error higher?
Period drift, formula error, and incorrect contract strength reference are the most common errors in the manual Excel process. Rate error is common when reactive penalty limits (9 kW exemption, 33%/20% below 30 kW) are calculated manually. Software-based reconciliation automatically matches OSOS data and invoice items; Generates an alarm when the deviation threshold is exceeded. The limits in our Reactive Energy and Reactive Cost guide are defined as parameters in the software — if not updated in the manual table, the old limit will be applied.
At what point does scalability break?
The manual process can be managed in 1–5 installations; The number of Excel files on 10 facilities, version confusion, and information loss due to change of responsible person create operational risks. Software-based reconciliation scales with subscriber inventory; When a new branch is added, registration to the panel is sufficient. The portfolio structure is detailed in our multi-site invoice consolidation guide. The SKTT limit (industrial 15,000 kWh/year) is one of the metrics that must be monitored on an installation-by-installation basis — it is easily overlooked in the manual list.
How are audit trail and regulatory compliance affected?
An audit trail is a record of which invoice was checked when, by whom, and with what data. In the manual process, this trail is dispersed across Excel file versions and email chains; It becomes difficult to provide evidence in an ISO 50001 or EIVER audit. The software-based process logs each reconciliation step; The reporting module automatically produces the annual consumption summary. This trace is required for the obligations in our Energy Audit and EIVER guide.
| Size | Manual (Excel) | Software reconciliation | winner |
|---|---|---|---|
| direct cost | Low (no software) | license fee | Manual (short term) |
| labor cost | High (increases with scale) | Low (auto) | software |
| Risk of error | High (formula, period) | Low (auto-match) | software |
| scale | 1–5 facilities | 10–500+ facilities | software |
| audit trail | Weak (file messy) | Powerful (log + archive) | software |
| Reactive early warning | None (after invoice) | Live OSOS alarm | software |
| Unit price control | manual calculation | Automatic (PTF+YEKDEM) | software |
| Installation time | immediately | Integration required | Manual |
(PTF+YEKDEM)×KBK
SKTT formula
Manual account risk
≤ 9kW
Reagent exemption
Can be skipped manually
15,000 kWh/year
Industry SKTT limit
Based on installation
In what cases is the manual process sufficient?
The manual process may remain adequate under three conditions: (1) single installation, low consumption (reactive exemption below 9 kW); (2) national tariff subscriber, fixed unit price — no SKTT risk; (3) There are expert personnel who can spare a few hours a month. As these conditions grow — new branch, free consumer transition, SPP commissioning — the manual process reaches its breaking point. Use this table as a scoring matrix in your transition decision.
What should be considered when switching to software?
Three criteria are prioritized when moving to software: OSOS integration (live data), invoice verification (item-based variance) and multi-site support (portfolio scale). During the pilot phase, a 30-day live test must be carried out with at least one real installation. These tests can be run in a demo environment on the electricity bill tracking platform. When OSOS is evaluated together with consumption monitoring, reactive alarm and demand profile should also be included in the pilot scope.
When making your decision, look at the cost of staff hours, risk of errors, and potential for missed deviations/penalties, not just the software license fee. A total cost of ownership (TCO) table is the most reliable way to numerically compare two approaches. The three-year projection nets out the net difference in most portfolios.
How to configure an Excel-based manual process?
The Excel-based manual process uses a separate sheet or file for each installation; columns: period, kWh, unit price, reactive rate, demand, total TL. Formulas should be kept in separate cells for SKTT formula (PTF+YEKDEM)×KBK and reagent limits (33%/20%). Version control (year-month in the file name) and responsible person assignment are mandatory. This structure can be managed over five facilities; Over ten facilities the error rate increases exponentially.
Which modules should be together in software reconciliation?
Effective software reconciliation combines three modules: invoice archive and parse, OSOS consumption comparison, deviation alarm and reporting. Tools that only archive invoices do not offer live reactive monitoring; Only the OSOS panel does not control unit prices. The integrated platform combines these modules into a single flow. In the pilot evaluation, it is essential to test all three modules with real plant data — do not judge by demo data.
How long does the transition process take?
Manual to software migration is typically completed in four phases: (1) subscriber inventory transfer (1–2 weeks), (2) OSOS connection setup (2–4 weeks, subject to distribution approval), (3) historical invoice archive upload (1 week), (4) parallel work period—one month reconciliation comparison with both Excel and software. The parallel period captures formula errors and missing items. After full migration, Excel files are stored as read-only archives.
Who should stay in the manual process and who should switch?
The profile that makes sense to remain in the manual process: single installation, reactive exemption below 9 kW, national tariff, annual consumption is well below the SKTT limit. Profile that needs to be implemented into the software: eligible consumer, multi-site portfolio, reactive penalty history, EİVER/ISO 50001 obligation, SPP+ consumption co-management. Intermediate profile (3–5 sites, low reactive risk): hybrid — Excel + OSOS portal; however, as the scale grows, the transition must be planned.
Cost example: five-site portfolio
In a five-site portfolio, manual reconciliation takes approximately 8–12 hours of staff time per month; With the software, this time is reduced to 1–2 hours. The annual labor savings can exceed the mid-level license cost. The addition of reactive penalty prevention and unit price deviation detection further increases ROI. In facilities whose energy cost share is in the range of 5-20%, even a single correctly identified deviation can amortize the annual license.
Conclusion
Manual invoice tracking is sufficient to get started with small and simple portfolios; software-based reconciliation is superior in terms of scale, risk of error, and audit trail. The decision should be made according to the number of facilities, eligible consumer status and regulatory liability. Score the “winner” column in this table for your own portfolio; For dimensions that remain uncertain, a 30-day pilot is recommended.