Finance reports

The Finance group of Interactive Reports has five reports about the money side of your jobs:

Report	Answers
Job Profitability	How much did the jobs of a period earn and cost, and how does that compare with their estimates?
Revenue Trend	How much was invoiced each month or week, net of credit notes?
Work Not Invoiced or Billed	Which charges are still waiting for an invoice or a vendor bill, and for how long?
Invoicing Turnaround	How many days pass between the work being charged and the invoice being approved?
Days Sales Outstanding	What do customers owe, how much of it is late, and how many days of sales does that represent?

To open one, select Reports > Interactive, then select the report under Finance in the list of reports. Choosing a report, the filters, the chart, the summary table, the drill-down lists and the Excel export work as for every interactive report: see Interactive reports. This page explains what is particular to the finance reports.

Note

Some labels use names set up for your company: the job reference (for example T/D) and the customer entity type (for example Customer). They may differ from this page.

What the finance reports share

One company, one currency

Every finance report covers one company at a time, so that all its amounts are in one currency. Choose it in Company, the first filter. The list shows the companies you have access to, each with its currency in brackets, and starts on your own company. Below the list, Amounts in names the currency of the report.

The report currency is the company’s Default Currency (see Setting up a company). If the company has none, the report uses the currency the company’s jobs and invoices use most, and the note under the table says so.

Amounts in other currencies are converted with one exchange rate per currency: the latest rate on or before a set day, whatever its age. If there is no rate from that currency to the report currency, TrakIT uses the latest rate the other way round. The day is:

Report	Rates as of
Job Profitability, Revenue Trend, Invoicing Turnaround	The end date of the report.
Work Not Invoiced or Billed	Today.
Days Sales Outstanding	The Statement as of date.

When a report converts amounts, a bar above the table lists the rates it used, for example Converted to XOF at 1 USD = 600 XOF (01 Oct 2026). A rate date in amber is more than about three months older than the report date. A currency with no rate at all shows no rate, left out in red: the amounts in that currency are not added in, and the note under the table names it. Add the missing rate and run the report again. The Excel file lists the same rates in its heading, under Exchange rates.

Two amounts appear in these reports:

• A charge is one account of a job’s finance (an income, expense or disbursement line). Its amount is its rate times its quantity, before tax, in the job’s currency: the currency of the job’s finance for the company (see Companies and currencies), or the job’s own currency when that is not set.
• An invoice total is the total of an invoice, debit note or credit note, including tax, in the invoice’s currency.

Job Profitability, Revenue Trend and Work Not Invoiced or Billed add up charges. Invoicing Turnaround and Days Sales Outstanding use invoice totals.

Jobs, work orders and charges

Job Profitability and Work Not Invoiced or Billed work on the finance of jobs. Each job counts once for the company, with all its charges for that company, including the “for WO” accounts of each of its work orders: the work orders are rolled up into their job. Deleted accounts are not counted.

When the job completed, an option of Work Not Invoiced or Billed and Invoicing Turnaround, is when the last of the job’s work orders was closed. Cancelled work orders are ignored. A job with an active or abandoned work order, or with no work orders at all, has not completed.

Invoices with no job

Some invoices are not for one job: invoices of ad-hoc accounts, and invoices raised across several jobs. Such an invoice belongs to no workflow. In Revenue Trend, Invoicing Turnaround and Days Sales Outstanding:

• it is grouped under (Without workflow);
• it is included only while no workflow and no workflow group is chosen, and left out as soon as you choose one;
• it is shown to everyone who may run the report for the company, whatever their workflows, as on the Invoices page.

The note under the table says so when the report has such invoices.

Customer filter

The customer filter (for example Customers) narrows each report to:

• the job’s customer, in Job Profitability and Work Not Invoiced or Billed;
• the entity the invoice is for, in Revenue Trend, Invoicing Turnaround and Days Sales Outstanding;
• the entity of the receipt, for the unallocated receipts in Days Sales Outstanding.

Notes under the table

Each finance report writes a note under its table that sums up how its figures were worked out, with the options you chose: the date the jobs or invoices were placed by, what was left out, and the currencies. The note is also in the Excel file, under the table.

Job Profitability

Job Profitability shows the income, expenses and margin of the jobs of a period, in the company’s currency, and how the margin compares with the estimate the job was planned at.

How it works

• Which jobs: the jobs that have finance for the company, whose finance status is one of those ticked under Job finance status, and whose date falls in the date range. You choose the date in Place jobs by their:

  • Rev/Exp Recognition date (the default): the job’s revenue and expense recognition date, the date its income and expenses count on, and so the date profitability targets are set against. A job with no recognition date yet is in no period and is left out.
  • Created date: the day the job was created.

  If no job in TrakIT has had a recognition date in the past year, the report starts on Created date instead, until you choose an option yourself.

• Which figures: all the job’s charges for the company, whatever their own dates. Income, expenses and disbursements come from the actuals; the estimated margin comes from the estimates.

• Margin is income minus expenses, before tax. Margin % is the margin as a percentage of income. Disbursements are passed on to the customer, so they are shown on their own and are not part of the margin.

• Each job is converted at one rate: see One company, one currency. A job whose currency has no rate still counts in Jobs, but not in the amounts.

These are the same figures as the Account Summary of the finance job, added up over many jobs.

Filters and options

Filter	What it does
Company	The company whose job finance is reported.
Workflows	The jobs of these workflows.
Customers	The jobs of these customers.
Rev/Exp Recognition date or Job created	The date range. The label follows Place jobs by their.
Job finance status	The finance statuses to include: Draft, Awaiting approval, Approved, Closing requested, Closed and Cancelled. Approved, Closing requested and Closed are ticked at first. Awaiting approval and Closing requested are the statuses the finance job page calls Approval Requested and Request for Closing.
Group by	Workflow, then customer or Customer, then workflow.
Place jobs by their	Rev/Exp Recognition date or Created date. The tip next to it explains the two.

Figures

Figure	Shows
Jobs	How many jobs the report covers.
Income, Expense	The actual income and expenses, with the currency, for example Income, XOF.
Margin	Income minus expenses. Red when it is negative.
Margin %	The margin as a percentage of income.
Loss-making jobs	How many jobs have expenses above their income.

Chart

Income and expense by workflow (or by customer), with the currency: a pair of bars for each first-level row of the table, the 15 largest. Select a bar to list the jobs of that row.

Table

One row for each workflow, which expands into its customers, or the other way round. (No customer) holds the jobs that have no customer.

Column	Shows
Jobs	The number of jobs. Select it to list them.
Income, Expense	The actual income and expenses.
Margin, Margin %	Income minus expenses, and as a percentage of income. - when there is no income.
Estimated margin	The estimated income minus the estimated expenses.
Against estimate	The margin minus the estimated margin: positive when the jobs did better than planned.
Disbursements	The actual disbursements, which are not part of the margin.
Loss-making jobs	The jobs with a negative margin. Select it to list them. A second-level row with a negative margin is red.

Estimated margin and Against estimate appear only if your role can read estimates.

Drill-down

Jobs lists the jobs, the most recent first. Loss-making jobs lists those jobs, the biggest loss first. The list has these columns, with amounts in the company’s currency:

Column	Shows
Job reference	The job, which opens its finance job page in a new tab.
Workflow, customer	The job’s workflow and customer.
Created	When the job was created.
Rev/Exp Recognition	The job’s recognition date.
Finance status	The status of the job’s finance for the company.
Job currency	The currency of the job’s finance.
Income, Expense, Margin, Margin %	The job’s figures.
Estimated margin, Against estimate	As in the table, if your role can read estimates.
Disbursements	The job’s actual disbursements.

Revenue Trend

Revenue Trend shows the revenue invoiced in each month or week, net of credit notes and before tax, broken down by workflow or by the entity invoiced.

How it works

• Which invoices: the company’s invoices, debit notes and credit notes that are approved and not cancelled, dated in the date range. You choose the date in Place invoices by their:
  • Invoice date (the default): the date on the invoice, which the accounts go by. An invoice can be back-dated, so a month can still grow after it has ended, when an invoice dated in it is approved later.
  • Approval date: when the invoice was approved. A month that has ended stays as it is.
• Revenue is the income charges on the invoices and debit notes, minus the income charges on the credit notes, before tax. A credit note’s charges are negative, so it reduces the revenue of the period it is dated in.
• Disbursements recharged are the disbursement charges on the same documents. They are passed on to the customer and are not revenue.
• Each charge is in its job’s currency, or in the invoice’s currency for an ad-hoc account. An invoice raised across several jobs takes the currency of its jobs, not its own. Each invoice is converted at one rate.

Filters and options

Filter	What it does
Company	The company whose invoices are reported.
Workflows	The invoices of jobs of these workflows. See Invoices with no job.
Customers	The invoices for these entities.
Invoices dated	The date range. With Approval date, it is the approval date that must be in the range.
Period	Monthly or Weekly. Weeks start on Monday.
Break each period down by	Workflow or Invoice to (the entity invoiced).
Place invoices by their	Invoice date or Approval date. The tip next to it explains the two.

A report can have up to 106 periods. For a longer range, choose Monthly or shorten the range.

Figures

Figure	Shows
Revenue	The revenue of the whole range, with the currency.
Average per month or Average per week	The revenue divided by the number of periods in the range, empty ones included.
Invoices	How many invoices and debit notes there are.
Credited	The income credited by credit notes, as a negative amount.
Highest month or Highest week	The period with the most revenue.

Chart

Revenue per month (or week), with the currency: one bar for each period, in date order. Select a bar to list the invoices of that period.

Table

One row for each period, including periods with no invoices, so the trend has no gaps. The first and last periods can be partial: they count only the days inside the date range. Each period expands into its workflows or the entities invoiced; (Not set) holds invoices with no entity.

Column	Shows
Invoices	The number of invoices and debit notes. Select it to list them.
Credit notes	The number of credit notes. Select it to list them.
Invoiced	The income charges on the invoices and debit notes.
Credited	The income charges on the credit notes, as a negative amount.
Revenue	Invoiced plus Credited. Select it to list all the documents.
On previous period	The change in revenue from the period before, as a percentage. On a workflow or entity row, the change from the same workflow or entity in the period before. Blank when there is nothing to compare with.
Disbursements recharged	The disbursement charges, net of credit notes.

Drill-down

The list shows the documents behind the figure, the largest revenue first:

Column	Shows
Invoice	The invoice, debit note or credit note number, which opens the invoice in a new tab.
Type	Invoice, Debit note or Credit note.
Job reference	The invoice’s job, which opens its finance job page. Empty for an invoice with no job.
Workflow, Invoice to	The workflow and the entity invoiced.
Invoice date, Approved	The date on the invoice, and when it was approved.
Revenue, Disbursements	The income and disbursement charges, in the company’s currency.
Charge currency	The currency of the charges before conversion.
Revenue in charge currency	The revenue before conversion.

Work Not Invoiced or Billed

Work Not Invoiced or Billed lists the charges that have not reached an invoice or a vendor bill yet, aged by the number of days they have been waiting. Use it to find work that is done but not invoiced, and costs that no vendor bill covers yet. It shows the situation today, so it has no date range.

How it works

• Not invoiced: the actual income and disbursement charges that are not on any invoice, not even a draft one.
• Not billed: the actual expense and disbursement charges that are not on any vendor bill, not even a draft one.
• A disbursement is both invoiced and billed, so it can be in both.
• Left out: estimates, the charges of jobs whose finance is Cancelled, and charges settled by an internal posting. Jobs whose finance is closed are included, since a job can be closed while some of its charges were never invoiced or billed.
• The age of a charge depends on Count days from:
  • When the charge was recorded (the default): the days since the charge was entered. Every charge still waiting is counted.
  • When the job completed: the days since the job completed. Jobs that have not completed are left out. Work orders are often closed only after invoicing, so this shows far fewer charges.
• Negative charges, such as deposit refunds or vendor credits, are shown under Credits pending, and are kept out of the ages and the total. A charge with no amount yet counts in Charges but adds nothing to the amounts.
• Amounts are before tax, converted at today’s rates.

Finance Pending shows the same kind of charges on a dashboard, with the ones on draft invoices and bills in boxes of their own and ages counted from the recognition date.

Filters and options

Filter	What it does
Company	The company whose charges are reported.
Workflows	The charges of jobs of these workflows.
Customers	The charges of jobs of these customers.
Count days from	When the charge was recorded or When the job completed. The tip next to it explains the two.

Figures

For Not invoiced and for Not billed:

Figure	Shows
Not invoiced, Not billed	The total waiting, with the currency, for example Not billed, XOF.
Not invoiced over 90 days, Not billed over 90 days	The part waiting for more than 90 days.
Jobs not invoiced, Jobs not billed	How many jobs have charges waiting.

Chart

Not invoiced by workflow and age (or Not billed), with the currency: a stacked bar for each workflow, the 15 largest, split by age. Select a part of a bar to list those charges.

Table

The report has two tabs, Not invoiced and Not billed. Each has one row for each workflow, which expands into the entities to invoice (Invoice to) or the vendors (Billed by). (Not set) holds the charges with no entity yet.

Column	Shows
Jobs	The number of jobs with charges waiting.
Charges	The number of charges waiting. Select it to list them.
0-30 days, 31-60 days, 61-90 days, Over 90 days	The amount waiting, by age.
Total	The amount waiting.
Credits pending	The negative charges waiting, such as refunds or vendor credits.
Oldest (days)	The age of the oldest charge.

Not invoiced appears only if your role can access income accounts. Select any amount to list the charges behind it.

Drill-down

The list shows the charges, the oldest first:

Column	Shows
Job reference	The job, which opens its finance job page in a new tab.
Workflow	The job’s workflow.
Invoice to or Billed by	The entity to invoice, or the vendor.
Charge	The account name, and its detail.
Recorded	When the charge was entered.
Job completed	When the job’s most recently closed work order was closed. With When the charge was recorded, the job can still have open work orders.
Days	The charge’s age.
Amount	The amount in the company’s currency.
Job currency, Amount in job currency	The job’s currency, and the amount before conversion.

Invoicing Turnaround

Invoicing Turnaround shows how quickly the work is invoiced: the number of days from the work being charged, or the job completing, to the invoice being approved. It breaks this down by workflow and by the person who raised the invoice.

How it works

• Which invoices: the company’s invoices and debit notes approved in the date range. Left out: credit notes, cancelled invoices, and refund invoices (an invoice with a negative total, such as a deposit returned), because a refund can be raised long after the charge it returns.
• The days depend on Count days from:
  • When the charge was recorded (the default): from when the last charge on the invoice was entered, the point it could have been invoiced, to the approval. A charge entered after the approval counts as 0 days. An invoice with no charges linked to it is counted under No charges linked.
  • When the job completed: from when the job completed to the approval. An invoice approved while its job had work orders still open counts under Before completion. Work orders are often closed only after invoicing, so with this choice many invoices can count there. Invoices with no job are left out: there is no job to complete.
• Days to approve is a separate measure: the days from when the invoice was created to its approval.
• The person is whoever created the invoice, shown as Raised by.
• Invoiced is the invoices’ totals, including tax, in the company’s currency.

Filters and options

Filter	What it does
Company	The company whose invoices are reported.
Workflows	The invoices of jobs of these workflows. See Invoices with no job.
Customers	The invoices for these entities.
Invoice approved	The date range of the approval date.
Group by	Workflow, then person or Person, then workflow.
Count days from	When the charge was recorded or When the job completed. The tip next to it explains the two.

Figures

Figure	Shows
Invoices	How many invoices the report covers.
Average days to invoice	The average number of days, over the invoices whose days could be counted.
Invoiced within 7 days	The share of those invoices approved within 7 days.
Over 30 days	How many invoices took more than 30 days.
No charges linked or Before completion	The invoices whose days could not be counted.
Invoiced	The invoices’ totals, with the currency, if your role can access income accounts.

Chart

Invoices by days to approval, by the first level of the table: a stacked bar for each workflow or person, the 15 busiest, split into 0-2 days, 3-7 days, 8-30 days and Over 30 days. Select a part of a bar to list those invoices.

Table

One row for each workflow, which expands into the people who raised its invoices, or the other way round.

Column	Shows
Invoices	The number of invoices.
No charges linked or Before completion	The invoices whose days could not be counted.
0-2 days, 3-7 days, 8-30 days, Over 30 days	The number of invoices by days.
Average days	The average number of days.
Days to approve	The average number of days from creation to approval.
Invoiced	The invoices’ totals, if your role can access income accounts.

Select any count to list the invoices behind it.

Drill-down

The list shows the invoices, the slowest first:

Column	Shows
Invoice	The invoice or debit note, which opens the invoice in a new tab.
Job reference	The invoice’s job, which opens its finance job page.
Workflow, Invoice to	The workflow and the entity invoiced.
Raised by	Who created the invoice.
Last charge recorded	When the last charge on the invoice was entered.
Job completed	When the job’s most recently closed work order was closed. With When the charge was recorded, the job can still have open work orders.
Approved	When the invoice was approved.
Days, Days to approve	The invoice’s days, and the days from creation to approval.
Invoiced, Invoice currency, Amount in invoice currency	The total in the company’s currency, its currency, and the total before conversion. Shown if your role can access income accounts.

Days Sales Outstanding

Days Sales Outstanding shows what customers owe on their invoice statements on a given day, how much of it is past due, and how many days of sales the amount owed represents.

How it works

The report reads the company’s invoice statement as it stood at the end of the Statement as of date:

1. What is on the statement: the invoices, debit notes and credit notes approved by the end of that day. Cancelled ones are left out.
2. What each one owes: its total, with tax and adjustments, less its Tax Deduction (the tax the customer withholds) and the receipts allocated to it. On a credit note, the tax deduction reduces the credit. Only approved receipts dated by the as-of date count. An invoice marked as paid or written off by then owes nothing.
3. Open items: a credit note that names its invoice (its Ref. Invoice Number, see Credit notes) is set against that invoice and shares its due date. Any other credit, such as a credit note on account, a refund invoice or an overpayment, stays an item of its own, aged by its own due date as a negative amount. Credits are not applied to the oldest invoices: matching a credit to an invoice is for your accountants to do.
4. Unallocated receipts: the part of an approved receipt, dated by the as-of date, that is not allocated to any invoice is a credit too. It is under (Without workflow), and is left out as soon as you choose a workflow or workflow group. Allocations have no date of their own, so for a past as-of date the report uses today’s allocations.
5. Due dates: an invoice or debit note is due on its date plus its Credit Period, or on its date when it has none. A credit note is due on its date. An unallocated receipt is due on its date plus the company’s Unallocated Receipt Grace Days, set on the company. Each item is past due from the day after its due date.

DSO is the statement total divided by what was invoiced in the 90 days up to the as-of date, times 90. What was invoiced is the totals of the invoices, debit notes and credit notes dated in those 90 days, less their tax deductions, including the ones already paid. For example, if customers owe 450,000 and 900,000 was invoiced in the last 90 days, the DSO is 450,000 / 900,000 x 90 = 45 days.

Amounts include tax. If your company does not record receipts or paid marks in TrakIT, every approved invoice still counts as owed, and most of the statement reads as past due.

Filters and options

Filter	What it does
Company	The company whose statement is read.
Workflows	The invoices of jobs of these workflows. Invoices with no job and unallocated receipts are left out once you choose one.
Customers	The invoices and receipts of these entities.
Statement as of	The day the statement is read at, today at first. It cannot be later than today, and goes back to today each time you open the page. The tip next to it explains how it is read.
Group by	Workflow, then customer or Customer, then workflow.

Figures

Figure	Shows
Statement total	What is owed in all, with the currency.
Past due	The part that is past its due date.
Past due %	The past-due part as a percentage of the statement total.
Not yet due	The part that is not yet due.
DSO (days)	The days sales outstanding.

Chart

Owed by workflow and days late (or by customer), with the currency: a stacked bar for each first-level row, the 15 largest, split into Not yet due and the four late ranges. Select a part of a bar to list those items.

Table

One row for each workflow, which expands into its customers, or the other way round. (Not set) holds the items with no entity.

Column	Shows
Open items	The number of items with something owed or credited.
Not yet due	The amount not yet due.
1-30 days late, 31-60 days late, 61-90 days late, Over 90 days late	The amount past due, by days late.
Past due	The amount past due.
Statement total	What is owed: everything above, credits included.
Past due %	Past due as a percentage of Statement total. Blank when nothing is owed.
DSO (days)	The DSO of the row. Blank when nothing was invoiced in the 90 days, or the row is in credit.
Oldest past due (days)	The days late of the oldest item still owed.

Select Open items, Statement total or an amount to list the items behind it.

Drill-down

The list shows the items, the most days late first:

Column	Shows
Document	The invoice, which opens the invoice, or the receipt, which opens the receipt, in a new tab.
Type	Invoice, Debit note, Credit note or Unallocated receipt.
Job reference	The invoice’s job, which opens its finance job page.
Workflow, customer	The workflow and the entity.
Date, Due date	The document’s date and due date.
Days late	How many days past due the item is. Blank when it is not past due.
Invoiced	The document’s total.
Credited	The credit notes set against it.
Received	The receipts allocated to it.
Tax deducted	The tax the customer withholds on it, net of any on its credit notes.
Outstanding	What is still owed: negative for a credit.
Settled	Marked paid or Written off, when the invoice was. What remains on such an item is its credit notes.
Currency, Outstanding in its currency	The document’s currency, and what is owed before conversion.

Messages

Message	What it means
Select a company	No company is chosen. Choose one in Company.
Select a company you have access to	The company is not one you can open. Choose another.
Select at least one job finance status	Job Profitability needs at least one status ticked.
That is more than 106 periods - choose monthly or a shorter date range	Revenue Trend has too many weeks or months.
Choose the as-of date	Days Sales Outstanding needs a Statement as of date.
You do not have the finance permissions this report needs	Your role lacks a permission listed below. The report is greyed out in the list of reports.

For the messages shared by all interactive reports, see Interactive reports.

Who can use these reports

To open the Interactive Reports page at all, see Who can use this page. Each finance report also needs the permissions its figures come from:

Report	Needs
Job Profitability	Read, Read Actuals and Access Income Accounts in Job Finance.
Revenue Trend	Read in Invoices, and Access Income Accounts in Job Finance.
Work Not Invoiced or Billed	Read and Read Actuals in Job Finance.
Invoicing Turnaround	Read in Invoices.
Days Sales Outstanding	Read in Invoices, and Access Income Accounts in Job Finance.

These permissions also change what a report shows:

Section	Permission	Allows you to
Job Finance	Read Estimates	See Estimated margin and Against estimate in Job Profitability.
Job Finance	Access Income Accounts	See the Not invoiced tab of Work Not Invoiced or Billed, and the Invoiced amounts of Invoicing Turnaround.

A report you lack the permissions for stays in the list, greyed out; selecting it shows why.

The Company filter lists your own company and the other companies you have been given access to. You see the jobs and invoices of the workflows you have access to, plus the invoices with no job and the unallocated receipts of the company. System administrators see every company and every workflow.