Skip to main content

Finance Report

Billings and Revenue Recognition reporting tool by financial year

Miel De Rycke avatar
Written by Miel De Rycke
Updated over 3 weeks ago

The finance report is probably one of the most comprehensive and valuable report in all of wayahead. It is an essential tool for accountants and finance administrators, and particularly important for agencies who do accrual accounting.

The report offers the following core features:

  • Define revenue recognition per job per month by entering accruals and deferrals on invoices, expenses, purchase orders, quotes or jobs.

  • Use automated revenue recognition and only adjust the exceptions or use full manual mode.

  • Analyse variances between revenue recognition and billings

  • Analyse revenue vs cost and work out the contribution (or agency fee)

  • Analyse work in progress and compare the planned, logged, completed and wip value with the finances of your job

  • Summarise data by job, client, job lead, job type or branch

  • The report handles data in multiple currencies.

1. Cash Accounting vs Accrual Accounting

To understand the purpose of this report, it is useful to get a basic understanding of what revenue recognition is. If you're an accountant or accounting generally bores you, you can just skip this chapter.

Generally speaking, there are 2 types of accounting that are applied in creative agencies: Cash accounting and Accrual Accounting.

Cash Accounting

Cash accounting means that you record revenue only when you receive the cash and you record the expense when you pay the bill. While it is a simpler way of working, it can give you a distorted view of the agency's performance. Cash Accounting agencies focus on invoicing and will rely more on wayahead's Forecast report.

The main benefit of the Finance report for you is that it gives you a financial overview for one entire financial year for both your income and forecast and it lets you make changes all from the same screen.

Accrual Accounting

The opposite method, accrual accounting means you record revenue when you earn it and expenses when you incur them, regardless of when the cash actually hits or leaves your bank account. Accrual Accounting agencies will need the Finance report where they can enter the revenue recognition for each job for each month.

The value that is recognised depends on not when an invoice is issued, but rather when the assets are delivered, when milestones are completed or simply on a percentage of the work that was executed.

Classic Accural Accounting

With accrual accounting, recognising revenue is more of a manual process, where we decide for each job and for each month how much value has been created. Most of the time the recognised value will be linked to an existing (draft) invoice. E.g. an agency can invoice a customer $10,000 in July, but the work is executed in August, September and October. So the income is deferred to 3 future months. In the opposite direction it's called accrued. When the work is delivered before it is invoiced, the invoice amount can be accrued to previous months, meaning you recognise the income before you issue the invoice.

Agencies who work like this will apply manual revenue recognition (see configuration)

Modified Cash Basis

Some agencies keep things a lot easier, using a practice where they simply invoice the work they delivered each month. We could consider this a sort of hybrid form of accounting. The benefit is that the billing and revenue recognition are much more aligned and we can assume that the work invoiced is practically the same as the value earned.

These agencies typically only run into one issue: Sometimes their customer requires them to invoice work they haven't delivered. E.g. the customer wants to use up their marketing budget for the financial year and asks the agency to invoice them $20k at the end of December. Over the course of the next months they will commission work to be delivered for that money. In that scenario, the agency will want to defer the income from December to future months.

Agencies who work like this will use automatic revenue recognition (see configuration), recognising each invoice as earned revenue, but they will define accruals and deferrals in wayahead to work around the exceptions. The Finance report was built specifically to make life easier for these agencies. Instead of building complex spreadsheets that are already out of date the minute you save them, you can use this integrated report that lets you combine automated data flows from Streamtime with manual data entry for revenue recognition.

2. Prerequisites

Financial Year

It is important to define the correct start of your company's financial year in the wayahead reporting preferences, because this report shows overviews per financial year.

Finance Administrator

The report also uses the finance administrator privilege for each wayahead user. Finance Administrators have different access privileges in this report than all other users: they can lock the report when the previous month is closed, so those without authorisation can not make any more changes to the report. But in their role they can overwrite data, even in locked months.

To make someone a finance administrator, just go to the Team Preferences, and click their name in the list of wayahead users. In the modal that pops up, you can tick the option "Financial Admin" on or off.

The Configuration menu at the top of the page is only available for Finance Administrators.

Overservice Data

This report can use the data from the Overservice Value report, so that we can work out not just how much work we recorded, but also how much to the recorded time counts as actual billable time. If we spend 12 hours on a task we only sold for 10 hours then we can't include the 2 hours of over servicing in the value produced.

wayahead stored pre-calculated data from the overservice report automatically and loads it up when you view the Finance report. Over service data is stored on 2 occasions:

  • When you manually run the Overservice Report inside wayahead

  • Every month when the Management report runs automatically (assuming it includes the option for overservice data).

So if you want accurate WIP data in the Finance report, be sure to have an active Management Report schedule in your setup and if you need the very latest update, then just run the Overservice Value report manually for the current month.

3. Configuration

The configuration at the top right of the screen is only available for users who are marked as Finance Administrators for your company (see Team Preferences).

Data points

Every agency is looking for different information in the finance report. Some agencies are focused on revenue only, while others value contribution more (revenue - cost of third party services). Some agencies rely heavily on the sales data from quotes, while others only work with the invoices data. Some only accrue or defer income exceptionally – e.g. when a client uses up a marketing budget at the end of the calendar year – while others will bases accruals and deferrals on the WIP data in each job for each month.

The configuration lets you handle which type of data wayahead loads from Streamtime, when each type of data is loaded and what sort of data can be accrued and deferred.

  • Report: When selected, wayahead will fetch this data from Streamtime when you load the main view of the report.
    Note that the more options you check, the more comprehensive and data-packed the report becomes, but it can also take much longer to load each time you open the page.

  • Details: To avoid having to load all jobs data for the entire jobs list every time, you can check certain options for loading on the job details only.
    E.g. if you leave off quotes for the report, but check quotes on details, wayahead will fetch the related quotes from Streamtime when you view the details of 1 single job and display it in the job details view.

  • Revenue Recognition: This check lets you decide against what types of objects you can recognise revenue: invoices, expenses, jobs and/or quotes.
    Typically, it is recommended to only create accruals and deferrals against invoices or expenses (and purchase orders), but you could decide to recognise revenue on jobs and even quotes if you like.

Auto Revenue Recognition

When checking Auto Revenue Recognition, wayahead will automatically count every (draft) invoice, (draft) expense and forecast item as recognised revenue. In other words, this makes your revenue recognition the same as your billing overview (both past and future, so both recognised and forecasted). As a user you can then overwrite the revenue recognition manually for the "exceptions" only. This would be typical for agencies who apply the Modified Cash Basis accounting as explained earlier in this article. $10k invoiced means $10k recognised, unless your enter accruals or deferrals to push the revenue to a different month.

Alternatively you can deselect auto revenue recognition, meaning every value of revenue recognised will be a value manually confirmed by a user. Nothing is recognised unless you say so. This would be typical for agencies who do Accrual Accounting.

Issue Tracking

wayahead can help you track issues in your jobs, so you know which ones need your attention. Issues could be when you have a draft invoice in Streamtime that is overdue or when you have recognised less revenue than the work you delivered to date.

Issues are divided in 3 groups:

  • Job has overdue relations

  • Job has less revenue recognised to date than ...

  • Job has less revenue recognised till the end of the job than...

In the configuration you can choose which types of issues should be flagged.

Issues will be displayed with an icon in the Job Lead column and you can click the icon to see more details.

4. The Main view

When you open up the Finance report, you land on the main view. This view offers a list of the jobs you've worked on in the selected financial year (this financial year by default). These jobs could still be active (WIP) or already archived – as long as there were invoices, expenses, time entries, deferrals or accruals... in the financial year shown, they should also show up (note that this may vary based on the configuration of the report).

The main view displays all data in your home currency, using the exchange rate stored on the job in Streamtime, however if any job in the list is set up in a different currency in Streamtime, the job's currency is highlighted next to the job name:

Revenue, Cost and Contribution

The main view of the report focuses on income and revenue, but in the backend everything is calculated for you, including the monthly cost and the contribution (income – cost of third party services). Cost and Contribution will only be available if you ask wayahead to load up the Cost (via the configuration) or if you have entered negative forecast amounts via the Billing Forecast report.

At the bottom of the report, you will see a full breakdown of the report by sales, cost and contribution.

Also as you hover over the numbers in the report, you can see the expenses and the contribution (agency fee) in any given month, like in the example below:

View modes

At the top of the main view, there are a couple of dropdown menu's. The report has 2 or 3 defaults view modes, depending on the configuration.

By default wayahead will open the report in Billings > Income mode, however it will remember your last view mode, billings or revenue. So if you change it to Revenue Recognition, that's how it will display when you reload.

In each view mode there are a number of choices

  • Billings: This is the summary of your invoices and expenses in Streamtime, similar to the data you would see in the Forecast report. It combines Invoices and expenses from Streamtime with forecast data in wayahead to show you what the actual and expected Income, cost and contribution are for the financial year.

  • Revenue Recognition: This is the recognised revenue based on accruals and deferrals you enter into wayahead or – if you have auto revenue recognition enabled – based on the original invoice or expense date.
    Inside Revenue Recognition, you can choose between Income (recognised revenue), Cost (recognised cost) or Contribution (recognised revenue - recognised cost)

  • WIP: This mode is only available if you ask wayahead to load up the WIP data (via the Configuration).
    By default you see the WIP mode. Here wayahead will show you the value of work produced against each job and each month. For past months, this would be the value of the time logged minus the value of over servicing on that job that month. For the current and future months, this is the logged time + scheduled time – time already over serviced (for the current month).
    You can also choose to see the Planned value (based on your job items in Streamtime), the Logged value (based on time entries), the Overservice value (based on wayahead's overservice report), the value of items completed (based on the completion date of items inside each job) or WIP variance (the difference between the planned value and the WIP Value)
    While the view mode determines the main value displayed for each month, the tooltip sill show you every one of the values.

A. Billings View Mode

In a way, the billings view mode reports is comparable to the Billing Forecast report in wayahead. It focuses on invoices, draft invoices and income forecasts, viewed across one entire financial year.

If you configure the app to also load up the expenses from Streamtime or if you have expense forecasts in wayahead, the report will show not only income, but also the cost figures and the contribution (invoice - cost of third party), sometimes also referred to as agency fee.

In the Billings mode, the main columns show each job's budget, how much has already been invoiced, how much more is forecasted and what the total sum is of invoice + forecasted. These columns are similar to what you see in the billing Forecast report.

The 12 months of the year will display the (forecasted) income for each month of the year.

Values displayed in black at the top of the cell represent issue invoices. Gray values display draft invoices or forecast items, totalled up for each job for each month.

In case you have a draft invoice or forecast in a month in the past, it is marked in red with a strike-through. 3 ways to fix this:

  • Delete the draft invoice or the forecast item

  • Move them into the future

  • Or in case of a draft invoice, fix the invoice status, if it has already been issued.

You can hover over the values in each cell to get more details about what the values represent. The tooltip that appears will show the breakdown between forecasted, draft invoices and issued invoices. If your Finance report contains costs it will also show forecasted, draft and issued expenses as well as the corresponding contribution.

B. Revenue Recognition View Mode

The revenue recognition mode shows not the money you have invoiced, but the money you have earned. These amounts are the accumulated total of values you manually entered against each job and each month OR they match the values of your invoices, forecasts and expenses if you have have Auto Recognise Revenue enabled in the configuration.

In the revenue recognition mode, the main columns change slightly, because we focus on different information. In this view you'll see Budget, Invoiced, Recognised and Variance.

The variance is the difference between how much we have invoiced and how much we have recognised against each job. In the example below, we have billed the customer £10k, but we didn't recognise that amount. Hence the variance is -£10k and flagged in red (red is bad).

Another example shows that we have invoiced £30k but we have already recognised £60k, that's a variance of roughly +£30k. A positive variance is flagged in yellow (yellow is... also bad actually, just different, hence another colour).

Only if the invoice total and the recognised total is equal, is the variance 0 and is the job fully set up correctly.

Note that for some jobs the Recognised cell displays a yellowish background colour, while for other jobs it doesn't. That happens when you use Auto Recognise Revenue. In the example below, the £20k for the first job was recognised fully automatically be wayahead, based on the corresponding invoices.

The second job, with the yellow background, tells me someone manually entered accruals or deferrals for this job, so whatever value we're seeing was defined by a user and not by the system.

C. Work in Progress (WIP) View Mode

The WIP view mode will be available only if you get wayahead to load the WIP data in report mode via the configuration:

The goal of the WIP mode is to get some context around the production data on the job, so if you enter accruals and deferrals against the job, at least you can see how those amounts compare to the progress of the job itself.

In the main columns you'll see the total planned value (based on the job items), the logged value (based on completed timesheets), the overservice value (based on the overservice data stored in wayahead from the Overservice report) and the WIP value.

How is the WIP value calculated?

The WIP value is calculated as:

Total time logged

+ Total time scheduled (current + future months)

- Total time overserviced (current + past months)

So let's say we recorded $9k so far this month. Today is the 21st and we still have $2k scheduled as todo's before the month is over. But out of the $9k recorded, wayahead has worked out that $3k is overserviced (we recorded $3k more than the tasks we worked on were worth). That makes the WIP value $9k + $2k - $3k = $8k.

Of course, for months in the past, the scheduled work is ignored. If we didn't complete those todo's, we don't want to include them in our WIP value. Similarly, overservice doesn't apply to future months.

If we intend to base the revenue recognition on the value produced, then the WIP data is the most important indicator for our finances.

You can hover over the value in each job, each month to get an accurate breakdown of the WIP value as well as a breakdown of the overservice data.

Setting and updating overservice data

Overservice data can not be calculated on the fly in the Finance report, it requires individual todo's, job items, job item assignments and much more, which could mean fetching tens of thousands of records from Streamtime. Loading this data on the fly would make the report too slow to load.

So instead, wayahead loads the overservice data that is stored in the wayahead database, making it almost instant to load.

The overservice data is stored in the database on 2 occasions:

  • When you manually run the overservice report inside the wayahead app.

  • When wayahead runs the monthly management report AND it has overservice data included in the report.

So the idea is that the overservice data is automatically updated in the database at the end of every month, with no action required. In case you wish to see overservice to-date for the current month, you can just run the report on screen and wayahead will store an updated version of the data for you.

Similarly, in case the overservice data should change for certain months in the past, e.g. because you updated some job labels, then you can just run the report on screen going back as far as you like. It may take a while to fetch and calculate the data, but once it's ready, that data is stored and used in the Finance report again.

Numbers vs Chart

If you like, you can change how the job summary data is displayed, as numbers or as a chart.

Just use the toggle at the top of the page to modify how the main columns are shown:

By default, wayahead will display the key numbers for your job. These are pretty self explanatory:

Sometimes it's just easier to spot abnormalities if you can visualise the data as numbers. Note that rendering charts for every job in the list can be rather slow. So wayahead has a limit on how many jobs can be shown when you display the charts. When more than 150 jobs are shown, wayahead will show an error message and switch (back) from Chart to Finances. If you have over 150 jobs listed in one financial year, you can just use the filters to shorten the list first before you render the charts.

In the chart, the yellow bar in the background represents the job budget. Then, just like in the Forecast report, green represents income and blue represents cost. You can see bars stacked up together in 3 colours, representing issued, draft and forecasted invoices/expenses.

Just hover over the chart to see a detailed tooltip with all the numbers:

Locking the report

Once the revenue recognition for a past month is defined, we don't want to change it anymore. While we allow account managers to enter the value recognised for the current and future months, we don't want them modifying the revenue figures for past months.

Users will see which months they can still edit and which months are locked. Both in the main view and the detail view of the job, the locked months show with a lock icon in the header cell and the locked months are graded out. Once a month is locked, the user can not enter new values or modify existing values for revenue recognition.

If you are a finance administrator (as configured in the wayahead Team Preferences), you will see a button at the top of the report to change the lock date:

When you click it, you can choose the move the lock date forward by 1 month or backward by 1 month:

When you open the report for the first time, it is automatically set to lock at the last month of the last financial year.

While regular users can never modify data in locked months, finance administrators can. Regardless of the lock, they always have the ability to make modifications if necessary, so that they gain full control over the numbers in the report.

Report filters

This report has several ways to search and filter. There is a plain Search field at the top right of the page, which will search through job names, customer names, job labels job leads, job types, branch, PO number and even job currency.

You can also click the Filter icon to the left of the search field to get an advanced filter set and combine different filters.

When including job labels in the search request, you can even choose if those specific labels have to be included or excluded from the search, E.g. show all jobs that are not labeled as "Retainer"

To quickly select specific job leads, branches, job types or job status, just press the alt-key to select or deselect all.

The totals in the footer will recalculate every time you apply a search or filter.

Forecast Tiers

If you configured Forecast Tiers in the wayahead forecast report, you'll find they are automatically implemented in the Finance report.

Forecast tiers are mostly used to add a probability to upcoming work, by adding specific job labels in Streamtime.

In the billing Forecast report's configuration you can set up your tears with a name, corresponding labels, a colour and a probability:

Jobs with a specific Tier label are automatically colour coded in the list view of the Finance report, in exactly the same way as in the Forecast report.

All job values will be multiplied with the related probability in the list view, but when you look at the job details, you will see the original unweighted values of the job.

In the detail view you will see a label representing the Forecast Tier (or the default fallback value for jobs without a label) in the top right corner of the page.

Outputs

The report data can be exported in 3 different ways: as PDF, as CSV or as a CSV summary. The output values are the same as those displayed on screen, depending on the view mode. The CSV summary outputs all the footer rows as a financial year summary of the report.

Summaries

While the default view of the main table is an overview of all jobs, you can choose to summarise the data in one of the following ways

In the symmary, wayahead will display the key name and the number jobs included in that summary.

Issue Tracker

If you have issue tracking enabled in the configuration, your jobs list might show a warning on certain jobs. The types of warnings are indicated with one of 3 icons.

Hover over over the icon to see what type of warning it is.

If you click the warning icon, a modal pops up listing all the issues wayahead found in that job:

5. The Job Details view

In the job details view we can edit the revenue recognition data and see more details about the job and its financial status. To see the job details, just click on one of the month columns next to the job.

While the main jobs list always displays everything in the home currency of your company, the job details shows everything in its original currency. The job header is shown in the job currency. Invoices and expenses are shown in their respective currencies. So you may find a mix of different currencies on this page. The key thing is that values are displayed in the values we can relate to. We want an invoice inside the job showing as US$8,500, not as €7,296.40, because Euro happens to be our home currency.

There's no need to go back to the list view to see the next job, you can just click the previous and next buttons in at the top right of the page.

The configuration options determine if any data still needs to be loaded while opening up the job details, as well as what information is shown in this page.

At the top of the page you can see the job summaries. The key information here is to see a comparison between billings, revenue recognition and work in progress. E.g. At the end of the job, there should be no difference between what we invoiced and what we recognised. For any deviations you are expected to take action and update the numbers.

The top left of the page shows you the job summary. Like most reports, wayahead displays income in green, cost in blue and contribution in yellow.

The summaries can either be show to date (up until the current month) or until the end of the job.

The range changes from "Key figures to date" to "Key figures till end of job" if you click that toggle. But the range also changes as you hover over the charts on the top right of the page.

The top right of the page shows a cumulative line graph of the finances and the WIP. As you hover over one chart, the corresponding values on the second chart will be displayed and the key figures on the left hand panel change.

Once again the next part of the page depends on what you have set up in the configuration. The list shows the following item:

  • Job heading line

  • Job WIP: planned value

  • Job WIP: logged value

  • Job WIP: work in progress value

  • Job WIP: completed Items value

  • Issued invoices

  • Draft invoices

  • wayahead sales forecast items

  • Issued expenses

  • draft expenses

  • wayahead expense forecast items

  • Approved quotes

  • Quotes on approval

  • Draft quotes.

You can use the toggles at the top of this section to show and hide specific line items. Hover over the info panel of each line to see more details.

The date months displayed on the right hand side of the table are NOT the financial year, but the date range of when your job ran with a few months extra at the start and at the end. A job that covers 2 months would show 6 months. A job that ran for 15 months would show 19 months.

Entering Accruals and Deferrals

Accruals and deferrals are terms we use to indicate we are pushing income or expenses to a month other than the one they were issued or incurred.

When we recognise revenue before the actual sales date, we say the income is accrued.

When we recognise revenue after the actual invoice date we say the income is deferred.

The whole point of this view and the finance report is to make it easy to enter accruals and deferrals for each job each month.

In the example below, we had an invoice issued on September 22 2025. But we wish to spread the recognised revenue across September and October 25.

So in accountancy terms part of the income is deferred to October, the rest remains in September.

Just click in right month next to your invoice and either enter an amount or a percentage. The amount will be treated as a value in the invoice currency. When wayahead detects the % sign it will take that % of the invoice amount.

In the Recognised column, wayahead automatically calculates the sum of all recognised values over time and displays the variance between the (forecasted) billing and recognised value.

Every time you click a month to enter a new value, the variance is automatically entered for you.

Against which records can you recognise revenue and costs?

This is determined in the configuration. You just need to check the option in the Revenue Recognition column.

We would recommend only entering accruals and deferrals against invoices and expenses. It's probably not a good idea to start recognising revenue against jobs if you don't even know for sure they will ever get invoiced.

But wayahead does give you the option to also enter them against quotes or even on a job level.

E.g. you have a project that hasn't been signed off yet, then you could already enter the expected revenue on the job line. Then later, when you start to enter invoices on the job, you can migrate the recognised amount from the job level down to the right invoice to make sure the numbers tally up on your final job.

Note that it is never possible to enter accruals or deferrals against wayahead forecast items. That's because forecast items may be deleted in the Forecast report, without the user ever realising they're also deleting the corresponding revenue recognition in the Finance report.

Using WIP data

The WIP data shown in the planned, logged, WIP and completed lines will help you work out how much can be recognised each month. You should also make use of the charts at the top of the page to make sure you recognition doesn't exceed the completed value of the job.

Adding / modifying related records

There will be times when you want to modify the related records. This could be updating the date on an overdue draft invoice, draft expense or forecast item. It could be changing the amount of a forecast item or even adding a new forecast item all together.

As you hover over draft or forecast records you'll see the edit button appear. Just click the button

In the pop up dialog, you'll see the familiar interface from the Forecast report where you can simply drag and drop the invoice, expense or forecast amount into a different month. That way you don't have to switch forth and back between Streamtime and wayahead or between the Finance and the forecast report.

If the record was overdue, the month it is currently in will be shown with a red shading. You can delete forecast items

You can also add new forecast items directly from this screen.

Did this answer your question?