Total expenses per financial year

SQL query for FortNox

Calculate the total expenses for each financial year.

SELECT financialyears.year, SUM(expenses.amount) AS total_expenses FROM expenses JOIN financialyears ON expenses.year_id = financialyears.id GROUP BY financialyears.year

FortNox data model

Table Financialyears

Table Absencetransactions

Table Attendancetransactions

Table Accounts

Table Articles

Table Company Information

Table Contracts

Table Currencies

Table Customers

Table Costcenters

Table Employees

Table Expenses

Table Incominggoods

Table Invoices

Table Invoice Details

Table Invoiceaccruals

Table Invoicepayments

Table Locked Period

Table Labels

Table Modesofpayments

Table Offers

Table Orders

Table Pricelists

Table Prices

Table Productionorders

Table Projects

Table Purchaseorders

Table Salarytransactions

Table Stockbalance

Table Stockpoints

Table Stocktaking

Table Suppliers

Table Supplierinvoices

Table Supplierinvoiceaccruals

Table Supplierinvoicefileconnections

Table Wayofdeliveries

Table Vouchers

Table Voucher Rows

Table Voucherseries

Magical SQL for FortNox with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.