Skip to content

How do I print or export what I see in accounting?

All accounting views can be produced as a PDF for printing or saving, and as a CSV to open in a spreadsheet. What is exported is always what is on screen, with the filters you have set.

Where are the buttons?

On each screen, next to the result. There are two:

ScreenWhat comes outWhere the button is
Trial balanceEach account with its debit, credit and balance, and the period totalsAt the top, below the filters
AccountsThe *financial year*’s chart of accounts with each account’s balanceAt the top, next to New account
Account record > General ledger / StatementThe account’s movements with the running balanceNext to View
Annual accountsThe calculated report with its comparative columnNext to the balance check badge
Notes to the accountsThe generated notes, with their figures already filled inNext to Generate
JournalThe journal entries in the filter, journal line by journal lineIn the screen’s button bar

What exactly is exported?

What you are seeing. If you have calculated the trial balance from January to June broken down by group, that is what comes out: not the whole year or the detail by sub-account.

That is why the buttons produce nothing until you calculate (in the trial balance they are visible from the start, but switched off until there is a result). If you change a filter and don’t click Calculate or View again, what is exported is still the result on screen, not the half-set new filter.

The balance sheet and the profit and loss account come out as on screen: without the line items at zero, with the titles and totals in bold (the titles also in blue) and the Financial year N and Financial year N-1 columns (see Why don’t all the line items in the model appear?).

There is one exception, and it is on purpose: in Accounts, the PDF comes out with the complete chart of accounts of the financial year, even if you have typed something in the search box. A chart of accounts is the whole catalogue, and one cut down by a search would be handed over in the belief that all the accounts are there.

What does the PDF have that the CSV doesn’t?

The PDF has a letterhead: your company’s name, the Tax ID (NIF), the filters applied and the date of issue. It also splits the content into pages and repeats the header on each one.

The CSV has none of that: its first line is the column names and below come the data. It is what a spreadsheet needs to cross-reference it with something else; four lines of letterhead before the data just get in the way.

What warnings are printed?

The paper says three things worth looking at before taking a report as good:

WhereWarningWhat it means
Trial balanceBalance check: Balanced or IMBALANCE of …If the period’s debit and credit don’t match, some journal entry is wrong
JournalWarning: N UNBALANCED journal entry(ies)Those journal entries don’t balance and need correcting
Annual accountsBalance sheet checkAssets don’t match equity plus liabilities
Notes to the accountsExpressions: N WITH ERRORS — do not submitSome placeholder in the template couldn’t be resolved

They are printed on purpose. An imbalance that is only seen on screen slips through onto the paper that someone hands over.

How do I read the journal report?

It comes out one line per journal line, not one per journal entry. The date and the number are only written on the first line of each journal entry, so that each block can be told apart at a glance.

At the end come the debit and credit totals of everything listed.

When the report covers more than one month, each month ends with its own subtotal in bold (‘Total August’), just before the next one starts. That is what lets you reconcile in parts: if the totals at the end don’t balance, the subtotals tell you in which month the problem starts. With a single month it isn’t added, because it would be the final total written twice. If the report crosses into another year, the subtotal also carries the year (‘Total December 2025’).

And when it takes up several sheets, at the foot of each one (except the last) Carried forward appears with the debit and credit added up so far up to that sheet. It doesn’t appear on the last one: the totals are already there.

Excel or CSV?

If you are going to do calculations, Excel: the amounts are already numbers and the header says which company it came from and with which filters. The CSV is for loading the data into another program.

Can I open the CSV in Excel?

Yes, with a double-click. The file uses the semicolon as separator and carries a UTF-8 marker, which is what a spreadsheet set up in Spanish expects: accents come out right and amounts go in as numbers, not as text.

If your Excel is in English, the separator it expects is the comma. In that case open it with Data > Get Data > From Text/CSV and choose the semicolon as separator.

Names that contain the separator —‘Banks; current account’— come out in quotes and don’t split the row.

If something goes wrong

What you seeWhat has happenedWhat to do
The buttons don’t appearYou haven’t calculated or viewed anything yetClick Calculate or View first
‘The PDF … came out empty’The document couldn’t be laid outCalculate again; if it persists, tell support
Nothing downloads and ‘check the download blocker’ appearsThe browser blocked the downloadAllow downloads from this page in the browser
The CSV appears in a single column in ExcelYour Excel expects a commaImport it with From Text/CSV choosing the semicolon
The PDF doesn’t have the company nameThe company record couldn’t be readThe report is still valid; check the record in Company

See also: Produce the balance sheet and profit and loss account · View an account’s general ledger · Find and correct journal entries

More about Accounting