Skip to main content

Project-based revenue recognition

Recognize revenue by project using percentage of completion or milestone billing

Project-based revenue recognition is available for QuickBooks Online clients on Scale.


What is project-based revenue recognition?

Straight-line recognition works for subscriptions, but project-based work is earned as the work gets done, not evenly over time or when you send an invoice. Project-based revenue recognition lets you track each project's progress every period. Double calculates the revenue earned and books the difference between what's been earned and what's been invoiced.

You can choose between two methods:

  • Percentage of completion: You record how far along the whole project is each period.

  • Milestone billing: You set up the project's milestones, each with its own amount and revenue account, and track progress on each one. Revenue is recognized based on the work completed, not when milestone invoices go out.


How the calculation works

Each period, Double recognizes revenue equal to the increase in progress multiplied by the project value (or the milestone amount). For example, moving from 20% to 30% complete on a $20,000 project recognizes $2,000.

Double then compares cumulative revenue recognized to cumulative invoices linked to the project, through the close you're working in:

  • Recognized more than invoiced: The difference sits in Accrued revenue, an asset.

  • Invoiced more than recognized: The difference sits in Deferred revenue, a liability.

At 100% complete and fully invoiced, both balances net to zero.

Note: Book invoices for the project to the project's Deferred revenue account in QuickBooks. The Add invoices list only shows invoices that credit that account. Double's journal entries move the recognized revenue into your revenue accounts.


Set up a project

  1. On the client's Close page, find the Project-based revenue recognition section. It's hidden by default. Unhide it the same way you unhide any Close page section.

  2. Click Add project and fill in:

    • Project name, customer and start date

    • Method: Percentage of completion or Milestone billing

    • Revenue account, Accrued revenue account and Deferred revenue account

    • Project value

    • Optional: project end date, class, location and description

  3. For milestone billing, click Add milestone for each milestone and enter its label, amount and revenue account. Milestone amounts must add up to the project value before you can save.

  4. Save. The project appears as a task in the section.

You can create a project before any invoices exist. When a project starts before your current close, add progress for each period from the project start date through the current close.


Record progress: percentage of completion

  1. Open the project and click Add project update.

  2. Choose the period and enter the progress made in Increase by. Double shows the current progress and what the new progress will be. Progress can't go above 100% or go down.

  3. To link invoices, click Add invoices. The list is filtered to the project's customer.

  4. Save the update. It stays as a draft, showing the calculated accrued or deferred revenue, until you post it.

  5. Post the update to create the journal entry in QuickBooks.

You can add more than one update in the same period.


Record progress: milestone billing

Milestone projects use a grid, with milestones as rows and periods as columns, so you can update every milestone in one place.

  1. Open the project and click Add project update.

  2. The grid shows the last three periods plus the current close, which is highlighted. Use the period selector to show more. Posted periods are read-only.

  3. Choose how to enter progress for the whole grid: Cumulative %, Increase by %, or Amount $. Double shows the other two values beneath each entry.

  4. Fill in the current close column. Milestones already at 100% show Completed. To paste a column of values from a spreadsheet, use Paste from spreadsheet.

  5. To link invoices, click Add invoices in the current close column. Invoices link to the project for that period, not to individual milestones.

  6. Review Recognized in period and the accrued or deferred balance at the bottom, then click Save, or Save and post to post one journal entry for the period.

When every milestone reaches 100%, the project status changes to Completed.


Review the schedule

Each project shows a schedule by period with these columns:

  • Incremental and cumulative revenue recognized

  • Invoices linked

  • Accrued and deferred revenue balances

  • Cumulative percentage complete

The project header shows totals for recognized, invoiced, remaining, accrued revenue and deferred revenue.


Edit or delete an update

You can edit or delete only the most recent update, and only while it's unposted. To change a posted update, unpost it first. Older updates can't be changed.


Archive or delete a project

From the project's … menu:

  • Archive: This hides the project from the current close and future closes. It stays visible in earlier closes, with all updates and journal entries kept.

  • Delete: This removes the project and all its updates, unposts every journal entry it created from QuickBooks, and unlinks its invoices. It can't be undone. If any of the project's entries are in a closed QuickBooks period, the project can't be deleted.

Did this answer your question?