Skip to main content

ChapterAccounting & Financial Statements

Chapter 10 — The accounting statements

Journal, ledgers, balances, comparative balance, consistency checks: each report has its tile on a single page. You set it in its window, then print it as PDF or export it to Excel. Balances can also be read on screen, and a click there opens an account's ledger.

In this chapter

  • The tile page and each report's window
  • Journal, ledgers, balances, comparative balance
  • Reading a balance on screen and opening an account's ledger
  • What a printed report carries
  1. Tile
  2. Settings
  3. PDF
  4. Excel
  5. On screen
Book contents

The Accounting statements page

The page shows one tile per report. Each one carries the PDF and Excel badges; those that can also be read on screen carry Also on screen. Each report covers the fiscal year chosen in the file's bar; the comparative balance and the consistency tests choose their fiscal years in their window.

The “Accounting statements” page: the seven tiles with their PDF, Excel and “Also on screen” badges, then the “Trial balance” window open on top, with its “View on screen”, “Export Excel” and “Print PDF” buttons.
TileWhat it producesOn screen
JournalThe entries by journal and by period, in summary or in detail—
General ledgerThe movements of each general account, with their running balance—
Third-party ledgerThe movements of each customer or supplier—
Trial balanceThe movements and balances of each account, basic or in six columnsYes
Third-party balanceThe movements and balances of each third-party accountYes
Comparative balanceThe balances of two or three fiscal years, account by accountYes
Consistency testsEach control, its verdict, what it found and the recommendationYes

A file without third-party accounts does not have the two third-party tiles. A click on a tile opens its settings window. At the bottom: Close, View on screen (balances and tests), Export Excel and Print PDF. The page remembers each report's last settings: the window takes them up at the next opening.

The journal

Choose the Journal (or All journals), the dates from and to (pre-filled with the fiscal year's limits), then the Layout:

  • Summary by period: the number of entries and the totals by journal and by month;
  • Entry detail: the journal line by line, in date order.

A journal chosen on its own loses the columns that would repeat it. The Excel workbook of the detailed journal holds 1 000 lines at most, the PDF up to 5 000; a message says so.

The ledgers

The General ledger is set by Journal, Account no. (from… to…), Entry date and Matched. The Third-party ledger replaces the accounts with the Third party (from… to…) and adds a General account. For a single account, choose it in both lists: the end list only offers the start account and those after it. A date outside the fiscal year shows a red message and greys the buttons.

Here, Unmatched only sets aside any line that carries a letter, even a lower-case one. The totals only cover the lines kept. To read an account on screen and open its entries, use Account inquiry (chapter 8).

The balances

The Trial balance is set by Journal, Account no. and Entry date, each with a start and an end. The Report type is Basic, or 6 columns (opening balances, movements, closing balances). Hide, in Settled accounts, removes the accounts whose closing balance is zero.

The trial balance on screen: settings, movements, balances and the eye to the ledger (screen in French)
  1. 1. Report type: Basic or 6 columns.
  2. 2. Subtotal level: by class, sub-class or account, on screen.
  3. 3. Settled accounts: show them or hide them.
  4. 4. Show settings: the criteria block at the top of the PDF, or not.
  5. 5. Movements: the fiscal year's debit and credit movements.
  6. 6. Balances: debit and credit.
  7. 7. The eye opens the account's ledger, within the balance's selection.
  8. 8. Print: PDF, Excel or CSV.

On screen, the header takes two rows: Movements (debit, credit) and Balances (debit, credit). At the bottom, Trial balance totals is followed by Balance-sheet accounts result and Income-statement accounts result, in green for a profit, in red for a loss.

Next to an account's balance, the eye opens its ledger in a window, with a search field, sorting and Print. It starts with the Opening balance (entries before the period). A settled account has no eye. A search typed in the table only acts on the screen; the PDF takes the whole selection. Back to accounting statements leads back to the tile page.

The Third-party balance is set in the same way, with Partner no.. On screen, the By type level groups customers, suppliers and others.

The comparative balance

Choose Fiscal year N, Fiscal year N-1 and, if needed, Fiscal year N-2 (optional). Each fiscal year has its debit and credit balances, and the Change compares each fiscal year with the previous one. The file needs at least two fiscal years. For a file taken over mid-way, an imported prior-year balance plays the part of the previous fiscal year (chapter 6).

What a printed report carries

Printed reports carry French titles and headings in every language for now.

ElementContent
Title“Grand Livre Général” (general ledger), “Balance générale” (trial balance), “Journal des écritures” (journal of entries)…
SubtitleThe file and the fiscal year
Critères de sélection (selection criteria)The journal, the accounts, the period, when Show settings is on Yes
FooterThe file, the title, the fiscal year, and the page number “1/12”
Amounts1 234 567,890; a zero amount stays blank
FormatA4, portrait; landscape for the balance in 6 columns, the comparative balance over three fiscal years and the consistency tests

A very long report stops at 5 000 lines and says so. Then narrow the selection: one account, one period. A selection with no movement is not an error: “No movement for this selection: nothing to export.”