Reporting

Accounting reporting is provided by three complementary sets of modules:

  • the Dynamic Reports (Account Dynamic Reports), an interactive on-screen report view with folding, filters, comparison, drill-down and XLSX/PDF export. This is where you consult the figures day to day;

  • the printable financial reports (Accounting Financial Reports, Cash Book / Day Book / Bank Book and the XLSX export), which produce a fixed PDF or Excel document from a wizard, for filing and for the auditor;

  • the specialized reports and declarations documented on the pages listed below (tax returns, Intrastat, analytic accounting, budgets).

The dynamic reports

All dynamic reports are available under Accounting ‣ Reporting ‣ Dynamic Reports:

See also

Dynamic Reports — how to filter, fold, compare, annotate, and export a dynamic report.

Trial Balance

The Trial Balance lists every account with its initial balance, the debit and credit of the period, and the closing balance. It is the usual starting point of a period check: the total debit and the total credit must be equal.

Balance Sheet

The Balance Sheet shows a snapshot of your organization’s assets, liabilities, and equity at a particular date.

Profit & Loss

The Profit & Loss report (or Income Statement) shows your company’s net income by deducting expenses from revenue for the reporting period.

Executive Summary

The Executive Summary provides an overview of all the important figures for overseeing your company’s performance.

It includes the following items:

  • Performance:
    • Gross profit margin:

      The contribution of all sales your business makes minus any direct costs needed to make those sales (labor, materials, etc.).

    • Net profit margin:

      The contribution of all sales made by your business minus any direct costs needed to make those sales and fixed overheads your company has (electricity, rent, taxes to be paid as a result of those sales, etc.).

    • Return on investment (per annum):

      The ratio of the net profit to the amount of assets the company used to make those profits.

  • Position:
    • Average debtors days:

      The average number of days it takes your customers to (fully) pay you across all your customer invoices.

    • Average creditors days:

      The average number of days it takes you to (fully) pay your suppliers across all your bills.

    • Short-term cash forecast:

      How much cash is expected in or out of your business in the next month, i.e., the balance of your Sales account for the month minus the balance of your Purchases account for the month.

    • Current assets to liabilities:

      Also referred to as the current ratio, this is the ratio of current assets (assets that could be turned into cash within a year) to the current liabilities (liabilities that will be due in the next year). It is typically used to measure a company’s ability to service its debt.

General Ledger

The General Ledger report shows all transactions from all accounts for a selected date range. The initial summary report shows the totals for each account. To expand an account and view its details, click the (right arrow) on the left. This report is useful for reviewing each transaction that occurred during a specific period.

Partner Ledger

The Partner Ledger shows the same detail as the general ledger, but grouped by customer and vendor instead of by account. Use it to reconstruct what a given partner owes you, or what you owe them, transaction by transaction.

Aged Receivable

The Aged Receivable report shows the sales invoices awaiting payment during a selected month and several months prior.

Aged Payable

The Aged Payable report displays information on individual bills, credit notes, and overpayments you owe and how long these have gone unpaid.

Cash Flow Statement

The Cash Flow Statement shows how changes in balance sheet accounts and income affect cash and cash equivalents and breaks the analysis down to operating, investing, and financing activities.

Tax Report

The Tax Report shows the NET and TAX amounts for all the taxes grouped by type (Sales/Purchases).

Journal Audit

The Journal Audit lists the journal entries of a period journal by journal, with their lines, so that a complete period can be reviewed entry by entry. It is the report auditors usually ask for.

Bank Reconciliation

The Bank Reconciliation report compares, per bank journal, the balance of the bank account in the books with the transactions that have already been reconciled, and lists what is still outstanding. Use it to justify the difference between a bank statement balance and the accounting balance at a given date.

Deferred Expense and Deferred Revenue

The Deferred Expense and Deferred Revenue reports show, period by period, the amounts that have been spread over time from bills and invoices.

EC Sales List

The EC Sales List gathers the intra-Community supplies of goods and services per customer VAT number, as required for the recapitulative statement.

See also

Intrastat