Can my travel agency software show me a report of how my sales are going and which trips sell best?

Yes, reporting is a standard part of travel agency software, and you can normally see your sales for a chosen period broken down in several ways without having to build a spreadsheet yourself.

The reports most agencies use day to day look at the same booking data from different angles. You can usually see what was sold in a date range, split by product such as flights, hotels or packages, by the member of staff who made the sale, by supplier, and by destination. Because your own markup is held against each booking, the reports can show you gross sales and what you actually earned on them, so you can tell the difference between a busy month and a profitable one. Most systems also let you pick a period and compare it with the same period last year.

There are honest limits. A report can only show what is recorded in the system, so bookings you made directly with a supplier and never entered will not appear, and refunds or amendments only show correctly once they have been processed rather than just agreed on the phone. How far back you can look, and whether you can design your own report layouts or only use the ready made ones, can depend on your plan.

A good next step is to decide the two or three questions you want answered every month, then check that the reports available to you answer them before you change how you record anything.