Help center
Getting started

Filter and export a list

1 min read Journal entries, Invoices, Bank, Due dates
Download as PDF

Here you filter a list, save the view and export what is shown.

How to

  1. Pick the period at the top right, for example « Fiscal year 2026 ».
  2. Filter the list, for example Status « Draft ».
  3. Click « Export », then CSV or Excel (.xlsx).
  4. To keep the filters: « Views », a name, then « Save ».
Learn more

At the top right of every book page, the period selector (« October 2026 », « Q3 2026 », « Fiscal year 2026 » or a custom range) applies to the whole book: lists, statements and the dashboard follow it. Under the key figures, the Journal entries, Invoices, Bank and Due dates lists share the same bar: a search, filters (Dates, Journal, Status, Supplier or Customer depending on the list), the « Views » button and « Export ».

The filters

The « Dates » filter follows the book period; pick « This month », « This quarter » or « All » to change this list only. Each active filter shows under the bar with a cross to remove it, and « Reset » removes them all. Filters are in the page address: copy it to share exactly the same view, and Back or a reload brings it back.

Export to CSV or Excel

« Export » offers CSV and Excel (.xlsx). The file holds exactly the lines shown, with the current filters, every line and not only the screen. Amounts are numbers and the currency has its own column; dates are real dates in Excel. The CSV is UTF-8 with a « ; » separator so Excel reads accents and decimals. The file name gives the page, the book and today's date.

Preview and going back

A click on a journal entry, invoice, statement or third-party line opens a preview on the right without leaving the list; « Open full screen » goes to the full page (Ctrl+click opens it in a new tab). Approval always happens at the bottom of the entry's full page. From the trial balance or a statement, each amount leads to the account's ledger, then to the entry: the trail at the top of the page shows the path and takes you back to the filtered view you started from.

Saved views

A view keeps the combination of filters under a name, for example « Drafts this month ». It belongs to your browser: a colleague does not see it. To share a view, send the page address instead.

Act on several rows at once

On Journal entries and on invoices, tick the rows (the header box ticks every row shown). A bar appears at the bottom of the screen: « Approve », « Post » and « Attach a document » on Journal entries, « Match » and « Attach a document » on invoices, and « Export » for the selection only. Each row goes through the same checks as on its own (period, rights, segregation of duties): the message says how many went through and why the others did not. « Match » needs the invoices of one third party: their lines are already ticked, add the payment. After a matching without a difference or an attached document, the message offers « Undo » for a few seconds.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support