Reports guide

Workadu reports and their fields

A practical guide to documents, finance, customers, products, bookings and resources.

What this guide covers

28 reports and exports organised by subject, with field tables, available filters and useful notes. Includes Excel exports for invoices, products, customers and customer statements.

Available options and final columns depend on the installation, company customisations, business type and subscription plan. Resource labels may vary by business type, such as vehicle, room or available resource.

Where to find the reports: Workadu Reports. Excel exports are also available from the invoice, product and customer lists and each customer’s statement.

Contents

CategoryReports and exports
1. InvoicesInvoice list Excel export
Income and expenses by month
Total Sales from Invoices by Month
Fiscalization Overview
2. Finance, VAT and taxesGross Profit Breakdown
Taxes by VAT
OSS VAT / Taxes by VAT
3. Customers and balancesNew Customers Report
Customers by Country
New Customers Over Time
Accounts Receivable Aging
Customer Balances
Customer list Excel export
Customer statement Excel export
4. Products and inventoryGoods & Services
Inventory Report
Products by Dates Inventory Remaining
Total Sales from Invoices by Product
Product Sales Journal
Product list Excel export
5. Bookings and ordersPerformance
Annual Income
Categories income
Daily Report
Sales Report (Dynamic)
6. Resources and fleetResource Insights
Resources Ending Dates
Resources Income-Expenses
7. Custom reportsCreate a report with us

1. Invoices

Invoice list Excel export

Exports the document list to Excel (.xlsx) for accounting, transaction review and further analysis. Available on the Invoices page, even when it is not listed under Reports.

Where to find it: Invoices → Excel export.

Fields / information
#Field / information
1Document — series and number
2Issue date
3Customer country
4Contact / customer
5Contact email
6Customer tags
7Total / payable amount
8Revenue amount
9Net revenue amount
10Revenue VAT
11Expense amount
12Net expense amount
13Expense VAT
14VAT breakdown by rate, including OSS where applicable
15Separate amount column for each configured tax / withholding type
16Document status
17Customer VAT number
18Customer tax office
19Document tags
20Currency
21Payment method
22AADE / myDATA MARK
Filters and export scope

Creation date range and issue dates, document series, branch, currency, customer country, services, revenue / expenses, payment method, payment status and document status. myDATA status where AADE integration is enabled.

Useful note

Uses the list filters. Up to 1,000 documents are downloaded directly; larger exports are generated in the background and sent by email. MARK is populated when an AADE record exists.

Income and expenses by month

Monthly totals from revenue and expense documents.

Fields / information
#Field / information
1Month
2Document count
3Net revenue
4Revenue VAT
5Total revenue
6Net expenses
7Expense VAT
8Total expenses
9Total / difference
Useful note

Includes revenue, expense and difference totals at the end of the table.

Total Sales from Invoices by Month

Aggregated sales and VAT based on documents.

Fields / information
#Field / information
1Date / month
2Net sales
3VAT 24%
4VAT group 13% / 17%
5VAT group 6% / 9% / 4%
6Other VAT
7Total VAT
8Taxes and fees
9Gross total
Filters and export scope

Date range, with preset periods or custom start and end dates.

Useful note

Short periods are grouped by day; longer periods by month. The table does not include a transaction count.

Fiscalization Overview

Aggregated financial information from documents.

Fields / information
#Field / information
1Date / month
2Revenue
3Expenses
4Payable VAT
5Taxes and fees
6Profit
Filters and export scope

Date range, with preset periods or custom start and end dates.

Useful note

The final fields depend on the installed template.

2. Finance, VAT and taxes

Gross Profit Breakdown

Revenue, expenses and calculated profit by period.

Fields / information
#Field / information
1Date / month
2Revenue
3Expenses
4Payable VAT
5Taxes and fees
6Profit
Filters and export scope

Date range, with preset periods or custom start and end dates.

Taxes by VAT

Aggregated amounts by VAT rate.

Fields / information
#Field / information
1VAT rate
2Total VAT amount
3Net amount
Filters and export scope

Date range, with preset periods or custom start and end dates.

OSS VAT / Taxes by VAT

OSS tax lines grouped by country and tax description.

Fields / information
#Field / information
1Country
2Tax description
3OSS VAT amount
4Related net amount
Filters and export scope

Date range, with preset periods or custom start and end dates.

3. Customers and balances

New Customers Report

New customer counts grouped by registration date.

Fields / information
#Field / information
1Join date
2New customer count
Filters and export scope

Date range, with preset periods or custom start and end dates.

Useful note

The default report shows totals rather than a list of customer contact details.

Customers by Country

Customer counts and financial amounts grouped by country.

Fields / information
#Field / information
1Country
2Customer count
3Net sales
4VAT 24%
5VAT 17%
6VAT 13%
7VAT 9%
8VAT 6%
9VAT 4%
10VAT 0%
11Gross total
Filters and export scope

Date range, with preset periods or custom start and end dates.

Useful note

The date range applies to customer creation dates.

New Customers Over Time

Compares new registrations in the selected and previous periods.

Fields / information
#Field / information
1Date / month
2New customers in current period
3New customers in previous period
Filters and export scope

Date range, with preset periods or custom start and end dates.

Accounts Receivable Aging

Outstanding positive customer balances grouped by age.

Fields / information
#Field / information
1Country
2Customer
3Total balance
40–30 days
531–60 days
661–90 days
791–180 days
8Over 180 days
Filters and export scope

End date — reference date for the aging analysis.

Customer Balances

The current default layout includes financial totals by date.

Fields / information
#Field / information
1Date
2Revenue
3Expenses
4Revenue VAT
5Expense VAT
6Payable VAT 24%
7Payable VAT 13% / 17%
8Payable VAT 6% / 9% / 4%
9Payable VAT 0%
10Other payable VAT
11Total payable VAT
12Taxes and fees
13Profit
Filters and export scope

Date range, with preset periods or custom start and end dates. Balance type — all, zero, negative or positive.

Customer list Excel export

Exports the customer list to Excel (.xlsx), including contact details, financial totals, tags and notes.

Where to find it: Customers → Excel export.

Fields / information
#Field / information
1Customer ID
2VAT number
3Full name / company name
4Email
5Phone
6Phone 2
7Country
8Address
9City
10County / region
11Postal code
12Booking count
13Document amount
14Payment amount
15Balance
16Currency
17Created at
18Title
19Business activity
20Customer type
21Contact person
22Contact phone
23URL
24Assigned user email
25Tag 1
26Tag 2
27Tag 3
28All tags
29Secondary tags
30Note title 1
31Note content 1
32Note title 2
33Note content 2
34Note title 3
35Note content 3
36Note title 4
37Note content 4
38Note title 5
39Note content 5
Filters and export scope

Search, customer type, balance — all, positive, negative or zero — recent updates, customer groups and country.

Useful note

Includes all customers matching the filters. Up to 1,000 customers are downloaded directly; larger exports are generated in the background and sent by email.

Customer statement Excel export

Detailed export of a customer’s documents and payments, including changes in their balance.

Where to find it: Customer statement → Excel export.

Fields / information
#Field / information
1Issue date
2Document — series and number
3Transaction type — debit or credit
4Total amount
5Currency
6Comments / reason
7Running balance after the transaction
8Created at
9Customer
Filters and export scope

Selected customer, start and end dates, branch, revenue / expenses and search within transactions.

Useful note

Includes opening and closing balances. Open the required customer’s statement and select Excel. The link shows customer 811923 as an example.

4. Products and inventory

Goods & Services

Document line items grouped by product or service.

Fields / information
#Field / information
1Product / service — group of lines
2Document, series and number
3Revenue / expense and paid indicators
4Issue date
5Contact / customer
6Product / service sales value
7Purchase value
8Sales quantity
9Purchase quantity
Filters and export scope

Start and end dates, contact / customer.

Useful note

Includes totals per item and, where available, tags, recurring-document and email-sent indicators.

Inventory Report

Stock quantities and values as of the preview date.

Fields / information
#Field / information
1Code
2SKU
3Item description
4Category
5Measurement unit
6Stock
7Purchase price
8Inventory value
Filters and export scope

Preview date, item categories and stock status — all, positive, zero or negative.

Products by Dates Inventory Remaining

Products with positive stock and related sales values.

Fields / information
#Field / information
1Product
2Stock
3Sales value
Filters and export scope

Date range, with preset periods or custom start and end dates. Item categories.

Useful note

The default report shows up to 100 products. The date range applies to product creation dates rather than sales dates.

Total Sales from Invoices by Product

Total sales value grouped by product description.

Fields / information
#Field / information
1Product
2Total sales value
Filters and export scope

Date range, with preset periods or custom start and end dates. Item categories.

Product Sales Journal

Detailed product sales lines from documents.

Fields / information
#Field / information
1Issue date
2Customer
3Product
4Quantity
5Unit price
6Discount percentage
7Discount value
8Price after discount
9VAT rate
10Net amount
11VAT amount
12Gross amount
13Invoice number
Filters and export scope

Date range, with preset periods or custom start and end dates. Item categories.

Useful note

The default report returns up to 500 lines.

Product list Excel export

Exports the product catalogue to Excel (.xlsx) from the Products page. Includes 42 columns, with one row per product and additional rows for its variants, where applicable.

Where to find it: Products → Excel icon in the list.

Fields / information
#Field / informationExcel column
1Product IDid
2Display ordersort
3Product slugslug
4Product namename
5Descriptiondescription
6SKUsku
7SEO titleseo_title
8SEO descriptionseo_description
9Priceprice
10Compare-at / original pricecompare_at_price
11Stockstock
12Track stocktrack_stock
13Shipping availabilityshipping_availability
14Allow backordersallow_backorders
15Barcodebarcode
16Other codeother_code
17Blocked shipping method IDsblocked_shipping_method_ids
18Categoriescategories
19Tagstags
20Vendorvendor_name
21Image URLsimages
22Physical productis_physical
23Weightweight
24Enable commentsenable_comments
25Variant option name 1variant_option_name_1
26Variant option value 1variant_option_value_1
27Variant option name 2variant_option_name_2
28Variant option value 2variant_option_value_2
29Variant option name 3variant_option_name_3
30Variant option value 3variant_option_value_3
31Attribute name 1attribute_name_1
32Attribute value 1attribute_value_1
33Attribute name 2attribute_name_2
34Attribute value 2attribute_value_2
35Attribute name 3attribute_name_3
36Attribute value 3attribute_value_3
37Attribute name 4attribute_name_4
38Attribute value 4attribute_value_4
39Attribute name 5attribute_name_5
40Attribute value 5attribute_value_5
41Related product slugsrelative_items
42Last purchase pricelast_purchase_price
Filters and export scope

Exports all company products. Search terms and selected rows in the list do not restrict this export.

Useful note

Fewer than 1,000 products are downloaded directly; exports of 1,000 products or more are generated in the background and sent by email.

5. Bookings and orders

Performance

Daily booking activity and resource utilisation.

Fields / information
#Field / information
1Start date
2Booking count
3Occupancy (%)
4Revenue
Useful note

Includes total revenue and a chart comparing performance with the previous year.

Annual Income

Monthly revenue and utilisation of available resources.

Fields / information
#Field / information
1Month
2Bookings / resource usage units
3Occupancy (%)
4REVPARe — revenue per available resource per day
5Revenue
Useful note

Includes total revenue and a comparison chart for the previous year.

Categories income

Monthly performance by resource category.

Fields / information
#Field / information
1Month
2Resource category / group and resource count
3Bookings / resource usage units
4Occupancy (%)
5REVPARe
6Revenue
Useful note

Also displays the corresponding figures for the previous year.

Daily Report

Delivery and return schedule for the selected days.

Fields / information
#Field / information
1Day
2Date
3Delivery / return time
4Status — start or end
5Booking and assignment reference
6Contact / customer
7Service and resource number
8Delivery / return location or GPS position
9Zone
10Route
Filters and export scope

Start and end dates.

Useful note

Includes delivery, return and entry totals. The column labelled “User” displays the location or GPS position.

Sales Report (Dynamic)

Daily totals based on orders.

Fields / information
#Field / information
1Date
2Total revenue / order value
3Order count
Filters and export scope

Date range, with preset periods or custom start and end dates.

6. Resources and fleet

Resource Insights

Resource information grouped by service.

Fields / information
#Field / information
1Service
2Resource number / registration plate
3GPS IMEI
4Insurance expiry
5Service date
6Last operation
7Assignment status
8Related assignment link

Resources Ending Dates

Important resource dates grouped by month.

Fields / information
#Field / information
1Month
2Important date category
3Related resource count
4Service
5Resource number / registration plate
6Displayed date
7Related cost, where recorded

Resources Income-Expenses

Revenue and expenses by resource for the selected period.

Fields / information
#Field / information
1Resource / registration plate
2Assignment count
3Revenue
4Expenses
5Balance
6Service
Filters and export scope

Start and end dates.

7. Custom reports

If the reports above do not meet your needs, contact us so we can create a custom report together, tailored to your business.

Related posts