Exporting reports: CSV, Excel and PDF
Get your report data out of Keyio in the format you (or your accountant) actually need.
Exporting a report
Every report in Keyio has a download button at the top right. What you download is what you have on screen: the year and the properties you have chosen. Pick the format by what you will do with it — Excel or CSV to work with the figures, PDF to print or send.
- 1Open Finance › Reports and choose the tab: Performance, Tax or Buy to sell.
- 2Choose the year and, in Performance, the properties to include.
- 3Click the download button and pick the format.
What each file contains
Performance — Excel: three sheets, Summary (income, expenses, net, nights rented, ADR, RevPAR, occupancy, expense ratio, break-even days), Monthly (income, expenses, net, bookings and occupancy per month) and By property. PDF: the same three blocks on one document. CSV: the monthly table only, the easiest to paste into another spreadsheet.
Tax — the PDF is the income tax workbook ("cuaderno de la renta"): every property of the owner in one report, at their ownership share, ready to print or keep. The CSV has one row per property and concept, which is what a tax adviser usually asks for.
Buy to sell — each operation's costs can be exported from its Sale tab as CSV, Excel or PDF for your adviser; the invoice breakdown columns (tax base, VAT, withholding) appear only when you use them.
Sending figures to your tax adviser? The Tax tab's CSV is usually the best start: one line per property and concept, nothing to retype.
Common questions
Why is the Tax download greyed out? That year has nothing to report yet — no income or expenses recorded for the owner.
Does the file include the comparison year? No. The comparison is a view on screen; the file has the year you chose.
Is the tax report what I file? It is a working document with the figures Keyio has. Check it with your tax adviser before filing.