Skip to content
Finances

Reports and exports: Excel, CSV and PDF

To export your finances to Excel on Pro or Team, switch to Professional mode and click “Export” (up to 50,000 rows). Simple mode only has “Download CSV”.

3 min read

In this article

To export your finances to Excel on Pro or Team, switch to Professional mode and click “Export” (up to 50,000 rows). Simple mode only has “Download CSV”.

Who can use it and on which plan

Finance is open to the owner and to team members with “Full access”. “Download CSV” in Analytics is on every plan. The Export menu and the reports are part of Professional mode, on Pro and Team. The payroll report (accrued and paid) is on the Team plan only.

How to do it

In Simple mode

  1. Open “Finance” → “Analytics” and pick a period.
  2. Click “Download CSV”: your browser downloads the file.

In Professional mode

  1. Switch Finance to Professional: see Simple and Professional modes in Finance.
  2. Open the operations journal, the change log, expenses, a report or payroll, and set the period and filters.
  3. Click Export and choose “Excel (.xlsx)”, CSV or PDF: while the file is being built, the button says “Preparing the file…”.

The file holds exactly what you see: the same period, the same filters and every page, not just the visible one. Each export is recorded in the Change log.

Available reports

  • Profit and loss: money in, money out and the result. You can compare it with the previous period or the same period last year.
  • Money in by payment method: what came in and what was refunded for each payment method.
  • Breakdown: the money by services, service categories, team members, clients, client sources or expense categories.
  • Client debts by age: unpaid visits that are 0-30, 31-60, 61-90 or over 90 days old.
  • Payroll: what’s accrued and what’s paid, on the Team plan only.

If something doesn’t work

“Too many rows for a PDF…” or “Too many rows for CSV…”

Excel and CSV hold up to 50,000 rows, a PDF up to 500. Narrow the period or the filters, and for a large report choose Excel instead of PDF.

It says the period columns don’t fit on a PDF page

The report has too many columns for one PDF page. Choose quarters or years in the “Columns” menu, or export to Excel or CSV.

“Another file is being prepared” or “Too many exports in a minute”

Bookly prepares one file at a time for each business, and only so many exports a minute. Wait as many seconds as the message says and try again.

“The file took too long to prepare” or “Couldn’t export the file”

  • “The file took too long to prepare. Narrow the period or the filters.” The file didn’t finish in time: a shorter period or tighter filters give it fewer rows.
  • “Files are exported from the CRM itself. Reload the page and try again.” Reload the CRM page and click Export again.
  • “No connection: the file didn’t download. Try again.” Check your internet connection.
  • “Couldn’t export the file. Try again.” Try again, and if it keeps happening, write to us.

“The period is too long” or “The period starts after it ends”

  • “The period is too long: no more than 10 years.” Pick a shorter period.
  • “The period starts after it ends.” Swap the From and To dates.
  • “The period is too long to show by days or weeks: choose months.” Choose months in the “Columns” menu.

Don’t see your situation here? Contact support. Write any time. We reply during working hours.

Still have a question? Write any time. We reply during working hours.

Other articles in this section

  • Specialist pay and rates (Team plan)

    On the Team plan, you set each specialist’s percent, fixed amount or salary in “Finance” → “Team”, and Bookly calculates their pay on its own.

    4 min read

  • Changing currency: amounts are not converted

    To change the currency in the CRM, open “Business” → “General” → “Currency” and pick the new one. Amounts aren’t converted: prices keep the same numbers.

    2 min read

  • Simple and Professional modes in Finance

    To turn on Professional mode in Finance, choose “Professional” under the “Finance” heading. It’s on Pro and Team and adds a journal, reports and exports.

    3 min read

(4.9/5)

50+ businesses already run on Bookly

Fewer midnight DMs.

More

booked clients.

Link in bio, online booking and a CRM in one place. Bookly takes the routine off your plate: confirmations, reminders, your schedule. Free plan forever. No card needed.

Try for free