Export Tickets, Articles & Spent Time to ODS/XLSX for Accounting (Znuny & OTRS)

Summary: The Znuny & OTRS “Export to ODS/XLSX for Accounting” extension creates accounting-ready spreadsheets from your tickets, articles, and spent time. Finance teams get clean data for billing, SLAs, and cost-center reporting in LibreOffice Calc (ODS) or Microsoft Excel (XLSX)—without manual copy/paste.

Why This Extension Matters

Support work generates revenue and costs—but the data often lives inside the help desk, not in finance. The Export to ODS/XLSX extension bridges that gap by giving you clean, well-structured exports that drop straight into accounting workflows.

• Faster billing cycles
  turn time logs into invoice lines in minutes
• Reliable reporting
  consistent columns for SLAs, KPIs, and audits
• No reformatting
  directly usable in Calc/Excel, Power Query, and Pivot Tables
• Lower risk
  eliminate manual transcription errors and missing hours

What Does the Export Extension Offer?

Export tickets, articles, and spent time with flexible filters and accounting-friendly columns.

• ticket export with IDs, states, queues, priorities, owners, customers, and custom fields
• article export including timestamps, channel (email/phone/note), sender/agent, and subjects
• allows exporting on timespans, e.g. for weekly or monthly reports, where recurring tickets may occur in multiple timespans
• time export with agent, activity date, minutes/hours, rate keys, and optional cost center
• filters for date ranges, queues, customers, services/SLAs, tags, and agents
• output formats: ODS (LibreOffice) and XLSX (Excel)

Key Features:

• Accounting-ready columns
  pre-mapped fields for invoice references, PO numbers, and cost centers
• Pivot-friendly design
  normalized rows for easy aggregation by customer, queue, SLA, or agent
• Time precision
  exports minutes and HH:MM with optional rounding rules
• Role-based access
  limit who can export what (e.g., finance vs. team leads)
• UTF-8 & locale aware
  safe for EU decimal separators and diacritics

Why Use ODS/XLSX Exports?

Because finance needs structured data, not screenshots. With this extension you ensure:

• Clean invoicing
  map time to contracts, SLAs, and cost centers with confidence
• Auditability
  retain a transparent trail from ticket to invoice line
• Operational insights
  spot effort drivers by queue, customer, or category
• Tool freedom
  works with LibreOffice, Excel, Power BI, and most ERPs

Typical Columns (Examples)

• Tickets: TicketID, Number, Created, Closed, Customer, Queue, Owner, State, Priority, SLA, Service, Tags
• Articles: TicketID, ArticleID, CreatedAt, Channel, From/Agent, Subject, Visibility
• Spent Time: TicketID, Agent, ActivityDate, Minutes, Hours(HH:MM), ActivityType, CostCenter, Contract/SLA

Conclusion

The Export to ODS/XLSX for Accounting extension turns your Znuny/OTRS data into spreadsheets that finance teams actually want. Faster billing, better KPIs, and fewer errors—without leaving your service desk.

Get started today and streamline your accounting handover from Znuny & OTRS.

FAQ

Can I choose which fields to export?

Yes. You can include/exclude columns and save presets for recurring exports (e.g., monthly invoicing).

Does it support date and queue filters?

Yes. Filter by date range, queues, customers, services/SLAs, tags, and agents to narrow the dataset.

Will the files open in LibreOffice and Excel?

Yes. Exports are available as ODS and XLSX for Calc and Excel compatibility.

Can I use the export in Power Query or BI tools?

Yes. The normalized layout is designed for Power Query, Pivot Tables, and BI dashboards.

Is time rounding supported?

Optional rounding (e.g., 5/10/15 minutes) can be applied to align with billing rules.

Is this compatible with Znuny and OTRS?

Yes. It is designed for Web – Znuny / OTRS environments and avoids risky core changes.