Can I make my own report with only the columns I need and download it into a spreadsheet?
General QuestionsCan I make my own report with only the columns I need and download it into a spreadsheet?
Can I make my own report with only the columns I need and download it into a spreadsheet?
Yes, in most setups you can decide what a report shows and download it as a spreadsheet, although how much you can change depends on your plan. Alongside the standard sales, payment and booking reports, there is normally a way to set your own date range, filter the results by branch, staff member, supplier, booking status or destination, and then add or remove columns so the report shows only what you care about. Once you are happy with a layout you can usually save it and run it again next month without setting it all up from scratch, and export it to Excel or CSV to hand to your accountant or your own analyst.
The honest limit is that a report can only show information the system actually holds. Details that arrive from a supplier through an API appear in your report only if that supplier sends them, so a full fare breakdown or a room level cost may be available for some suppliers and simply not there for others. Anything your staff have typed into a free text note is also much harder to report on than a proper field, which is why it is worth capturing the things you want to measure as real fields from the start.
Very large exports covering long date ranges can be slow, and on some plans they are queued and sent to you when ready rather than downloading straight away. Custom report building is also not always included at every level, so on a smaller plan you may be working with the ready made reports and their filters instead.
The next step is to write down the exact columns you and your accountant need, then run a sample export for one past month and check it line by line against your own records, and ask which of those columns depend on supplier data.