Browse Guides

Deferring Project Revenue
Reading mode
Copy Link
Link Copied!
Print
Feedback
This guide has multiple versions available:
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p data-pasted="true"><strong>- Initial Setup&nbsp;</strong></p><p><strong>- Creating Down Payments</strong></p><p data-pasted="true"><strong>- Recognising Down Payment Revenue from Fixed Price Projects</strong></p><p data-pasted="true"><strong>- Recognising Down Payment Revenue from Time and Materials Projects</strong></p><p><br></p><p><br></p><p>Deferred Revenue functionality in Halo allows you to take down payments (deposits) for projects upfront, but not yet have this revenue recognised in your accounting tool. You can recognise this revenue later on, when project work has begun and the revenue has been &#39;earnt&#39;. Both fixed price and T&amp;M projects can have the down payment revenue recognised at any point during the project, or when invoicing the final outstanding project amount. Time and material (T&amp;M) projects can also have the down payment revenue recognised as labour (time) is logged on the project.&nbsp;</p><p><br></p><p><strong><span style="font-size: 14pt;">Initial Setup&nbsp;</span></strong></p><p><strong><span style="font-size: 12pt;">Enable Deferred Revenue</span></strong></p><p><span style="font-size: 11pt;">First, you will need to enable deferred revenue. This is enabled under Configuration &gt; Billing &gt; General Settings, &#39;Enable Deferred Revenue&#39;.</span></p><p><span style="font-size: 11pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjcyNTQyZGFlLTdjZmUtNDYzZS05NTk1LWE2NDlhZWIzZjVhYiJ9.cnzq9bkrCxV6mKLZRIJOFuG2_av9DFc9qg_UMpKnDl8" class="fr-fic fr-fil fr-dib" width="733" style="width: 735px; height: 364.155px;" height="364"></span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 10pt;"><strong>Fig 1. &#39;Enable Deferred revenue&#39; setting</strong><strong><br></strong></span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Now, you can set a &#39;Deferred Revenue Customer&#39; (optional) and a &#39;Product to use for Pre Pay and Deferred Revenue Invoice line&#39; (mandatory).</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><strong>Deferred Revenue Customer&nbsp;</strong>- If you would like deferred revenue to be stored against a different customer to the customer that generated the revenue, choose a customer here. If set, all deferred revenue will be stored against this customer until it is recognised. If not set deferred revenue will be stored against the customer that generated the revenue.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><strong>Product to use for Pre Pay and Deferred Revenue Invoice line</strong> - Here, choose the product that you would like to represent pre-pay on invoices when using deferred revenue for pre-pay. The product chosen here should be assigned the accounts code used for your deferred revenue. Alternatively, the product can be linked to the item in your accounting integration that is mapped to your deferred revenue account. You may wish to create a new product in Halo for this, as we have done in Figure 1.&nbsp;</span></p><p><br></p><p><span style="font-size: 11pt;"><strong>Only recognise consigned quantity from the Sales Order</strong> - If enabled, only items that are consigned will be able to be recognised (should a down payment be taken for the item). Enable this if you want to recognise the revenue of an item sold only after it has been consigned to the customer.&nbsp;</span></p><p><br></p><p><strong><span style="font-size: 12pt;">Enable Down Payments</span></strong></p><p>Also under, Configuration &gt; Billing &gt; General Settings, you will need to enable &quot;Allow creation of down payment invoices from sales orders&quot;.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImUwNTZkYzEzLTcxZGYtNDI5OC1iYTM4LWFhZjI4N2FmMTQwNCJ9.x134kuidlrTTbGzzUWz5wGZK5B_Q-CNXGJb4XbTSTeY" class="fr-fic fr-fil fr-dib" width="779" style="width: 781px; height: 272.685px;" height="273"></p><p><strong><span style="font-size: 10pt;">Fig 2. Enable the ability to create down payment invoices from sales orders</span></strong></p><p><br></p><p>This will allow you to take down payments for sales orders. These down payments will have their revenue deferred. The product chosen here should be assigned the accounts code associated with your deferred revenue account. Alternatively, the product can be linked to the item in your accounting integration that is mapped to your deferred revenue account. You may wish to create a new product in Halo for this, as we have done in Figure 2.&nbsp;</p><p><br></p><p><strong><span style="font-size: 12pt;">Product Setup - Fixed vs Time and Materials Projects</span></strong></p><p>When deferring project revenue using Halo, you will need to create the project ticket from a sales order. The products representing the project on the sales order must be configured accordingly. For information on the general setup of products to allow projects to be created from a sales order checkout <a target="_blank" rel="noopener noreferrer" data-fr-linked="true" href="https://usehalo.com/halopsa/guides/2035" data-pasted="true">Creating a Project From a Sales Order</a>.</p><p><br></p><p>Against your project products you will also need to set whether the product is being billed using a fixed price or on a T&amp;M basis. This is set using the &quot;Project billing type&quot; field against the project.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQ4MjkxMTlhLTYzZWYtNDhiZC05YTAxLThmNjMxMzZjZjZiNyJ9.bIca2s7eUDX4Ng_94xRfE3ljpkBb4cF1sblaiqp3b3g" class="fr-fic fr-fil fr-dib" width="1108" style="width: 1110px; height: 519.535px;" height="520"></p><p><strong><span style="font-size: 10pt;">Fig 3. Project billing type for product</span></strong></p><p><br></p><p><strong><span style="font-size: 12pt;">Charge Rates - Time and Materials Only</span></strong></p><p>If billing projects on a T&amp;M basis you will need to create a new charge type(s) to use for deferred revenue. These charge types will need to be marked as being used for deferred revenue to allow the value of the labour to be deferred.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg0ZWIyNDNmLTdjZGUtNDgxMC1hOGEyLWE0Y2M3YTc3MmJjYiJ9.LsR4hvjA1IQMI6BggJgpSM8xuubXXu7LDR3O100Tm5U" class="fr-fic fr-fil fr-dib" width="1128" style="width: 1130px; height: 851.151px;" height="851"></p><p><strong><span style="font-size: 10pt;">Fig 4. Mark charge type as being used for deferred revenue</span></strong></p><p><br></p><p>The rates of your charge type(s) will determine the amount of revenue work generates. It is important to keep this in mind when quoting projects, as if quoting for 10 hours of work, the price of the line should equate to the charge rate x quantity of hours, to ensure value is deferred correctly.&nbsp;</p><p><br></p><p>If you have multiple rates of work, you will need to create multiple deferred revenue charge types, and quote these as separate lines.&nbsp;</p><p><br></p><p><strong><span style="font-size: 12pt;">Add lines to Project</span></strong></p><p>Once the project has been created from the sales order ensure you add any other lines to the project. This is done using the &quot;Add to Project&quot; action.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImU5ZjQ1YjAzLTM3NGYtNDU0OS1hZGQ1LTc2YjI1YzUyM2Q1NCJ9.IWsXRURlgfD7P41F42p9oYcwUgyhzoJLnBLpaT2UY9w" class="fr-fic fr-fil fr-dib" width="1225" style="width: 1227px; height: 401.011px;" height="401"><strong><span style="font-size: 10pt;">Fig 5. Add line item to Project</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Creating Down Payments&nbsp;</span></strong></p><p>Down payments are created from the sales order for the project, using the &quot;Create down payment Invoice&quot; button.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg5NzU2ZGI5LWYwMjktNDc1Mi1hZDc1LTNiNmFkMjBjZWE0MCJ9.XQdqPi1seHlykl8hzcD-GEqLbw0nu1KondPy3V-NXyk" class="fr-fic fr-fil fr-dib" width="1385" style="width: 1387px; height: 753.377px;" height="753"></p><p><strong><span style="font-size: 10pt;">Fig 6. Create Down payment&nbsp;</span></strong></p><p><br></p><p>When creating a down payment you have various options to control how much of the order a down payment is taken for.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ4MTJlMjczLTczMDktNGEzZi04YWQwLTQ5YmViOWY1MTRhOSJ9.4RngP_ApbpR5qkwY79iJqhDcv_4V7WvcWPrAIcROCDo" class="fr-fic fr-fil fr-dib" width="614" style="width: 616px; height: 801.577px;" height="802"></p><p><strong><span style="font-size: 10pt;">Fig 7. Create down payment</span></strong></p><p><br></p><p>In the Figure 7 example we have selected &quot;Invoice each line with a different percentage quantity&quot; which allows us to choose the percentage of each line we would like to take payment for. The hardware is being invoiced in full, but the labour is being partially invoiced.&nbsp;</p><p><br></p><p>A &#39;down payment invoice&#39; will be created and linked to the sales order.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM2MGE2MjE0LTlkNTUtNDQyNC04NTFiLWNkN2ZkMDRlMTdhNSJ9.XtfL48PQ8Faw5Isr7RogQWdiyX1S8pXMeIAdhIeZ1ns" class="fr-fic fr-fil fr-dib" width="1618" style="width: 1620px; height: 664.82px;" height="665"></p><p><strong><span style="font-size: 10pt;">Fig 8. Down payment invoice</span></strong></p><p><br></p><p>The names of the lines on the invoice will be copied from the sales order lines, but all lines will use the down payment product (set earlier). This means when the invoice is synced to your accounting tool, the revenue will be attributed to your deferred revenue account.</p><p><br></p><p>This invoice will be sent of to the customer so payment can be taken.&nbsp;</p><p><br></p><p><strong><span style="font-size: 14pt;">Recognising Down Payment Revenue</span></strong><span style="font-size: 14pt;"><strong>&nbsp;from Fixed Price Projects</strong></span></p><p>Down payments taken for fixed projects can be recognised in one of two ways. The full value of the down payment can be recognised at any point from the ready for invoicing area (manually). Or, the the down payment value can be recognised at the same time as invoicing the outstanding amount on the sales order.</p><p><br></p><p><strong>Recognise Down payment value manually&nbsp;</strong></p><p>To do this head to the &quot;Deferred Revenue&quot; section of the Ready For Invoicing area, here you will see a table containing &quot;Downpayments (from Sales Orders)&quot;.&nbsp;</p><p><br></p><p>Here, select the down payment invoice you would like to recognise, and generate the invoice. &nbsp;&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc3Zjc2YTg3LTYzM2YtNDYyZi05YjQxLTRjNGMxMzZhYTRiYiJ9.xflZwV7qaix94a_unX8eyUAfNMX4pOFFh2fuL-JoAp4" class="fr-fic fr-fil fr-dib" width="1043" style="width: 1045px; height: 620.299px;" height="620"></p><p><strong><span style="font-size: 10pt;">Fig 9. Recognise down payment&nbsp;</span></strong></p><p><br></p><p>This will create a zero value invoice, as shown in Figure 10.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY5NDRmYjgzLWY1Y2EtNGRkYS05ZTJjLTZlMTI0MTRjZDQ5YSJ9.rucu5wdkEOLwPJWcBUJvGqH1bJIKPY7n5OlOOTLuX0M" class="fr-fic fr-fil fr-dib" width="1496" style="width: 1498px; height: 605.869px;" height="606"></p><p><strong><span style="font-size: 10pt;">Fig 10. Recognition Invoice&nbsp;</span></strong></p><p><br></p><p data-pasted="true">You will see here there is a positive and negative line on the invoice for the same value, this gives the invoice an overall value of 0.&nbsp;</p><p><br></p><p>The positive line represents the value of the project that is becoming recognised revenue.&nbsp;</p><p><br></p><p>The negative line represents the down payment that is being used to &#39;pay&#39; for this invoice. In other words, the amount of money that is being taken out of the deferred revenue account.&nbsp;</p><p><br></p><p>As the invoice has 0 value the customer will not be sent the invoice, this invoice is just created in order to sync to your accounting tool, moving the revenue from your deferred revenue account into your standard income account. Resulting in the revenue now being recognised.</p><p><br></p><p data-pasted="true">Further down payments can be created from the sales order at any time, allowing you to take instalments from the customer and recognise the revenue of these as the project progresses.&nbsp;</p><p><br></p><p><strong>Recognise down payment value when invoicing the outstanding amount on the sales order (recognise on completion)&nbsp;</strong></p><p>To do this head to the sales order and use the &quot;Create Invoice&quot; button to invoice the rest of the sales order, select the option &quot;Invoice the entire order&quot;.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjdmM2NkZTljLTQ4OWMtNDUyMy1iOGRkLWQ3ODgzODdmOTljYSJ9.tHW8-d9WhFIe2OBRlz_Be5LJnqyKmwkW7CiHqWIIuhI" class="fr-fic fr-fil fr-dib" width="595" style="width: 597px; height: 434.437px;" height="434"></p><p><strong><span style="font-size: 10pt;">Fig 11. Invoice the rest of the sales order</span></strong></p><p><br></p><p>This will create an invoice that is equal to the total value of the sales order, minus the value of the down payment already paid.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFmZDNkODNhLTAwOTMtNDA4ZS1hYjA2LTY0MDA1MjRmYWI2ZCJ9.GTk0kzr7ccM9SPx_vQSPrhqW5d8agxifrdlodqSFIXs" class="fr-fic fr-fil fr-dib" width="1488" style="width: 1490px; height: 621.843px;" height="622"></p><p><strong><span style="font-size: 10pt;">Fig 12. Invoice to recognise down payment and bill for the rest of the project</span></strong></p><p><br></p><p>This will result in the total value of the project (including the down payment value) being recognised, and the down payment value value being moved out from your deferred revenue account.&nbsp;</p><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;">Recognising Down Payment Revenue</span></strong><span style="font-size: 14pt;"><strong>&nbsp;from Time and Materials Projects</strong></span></p><p>Time and materials projects can have their down payment revenue recognised as time is recorded for the project (the revenue of the whole down payment can also be recognised at any time using the method outlined in the &quot;Recognising Down Payment Revenue from Fixed Price Projects&quot; section).</p><p><br></p><p>To do this ensure the project ticket has been created from the sales order. Also ensure any other lines on the sales order for the project have been added to the project, if you do not add these lines the down payment of these lines will not be able to be recognised as time is logged on the project.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgxZjc3NzM3LWU2OTQtNDkxOC1hNjI0LThiZTlkMGNhY2UxZiJ9.YXR8uh2yaXieWM3jWKzNaRchH24oteu3drDldyO2KVI" class="fr-fic fr-fil fr-dib" width="1557" style="width: 1559px; height: 884.642px;" height="885"></p><p><strong><span style="font-size: 10pt;">Fig 13. Project created against sales order</span></strong></p><p><br></p><p><strong><em>Note: In this example, a down payment has been taken for 50% of the project labour line and 100% of the other lines.</em></strong></p><p><br></p><p>When logging time on the project ensure the charge types used to log time are marked as deferred revenue.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImVhNGY2MWY3LWNhMmEtNDQyNS05NzhjLTEzOTMwOTVjYWZiNiJ9.NqfGCiZpqRZmLV4ilGpt9g3CAT9w0vpQ0HFDoBYUsfs" class="fr-fic fr-fil fr-dib" width="1711" style="width: 1713px; height: 645.394px;" height="645"></p><p><strong><span style="font-size: 10pt;">Fig 14. Logging time using a charge type that is marked as being used for deferred revenue</span></strong></p><p><br></p><p>If a non-deferred revenue charge type is used on the project this time will be billed separately (in line with usual billing). The value of this time will not allow you to recognise revenue.</p><p><br></p><p>As time is logged this will become available to recognise in the deferred revenue section of ready for invoicing, within the &quot;Projects&quot; table.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjY0MDNkODRjLWFiMzktNDU2Yi1hZjI2LWUyMzhkNTczNzIwNyJ9.ncr5nlEa0DBmlq19XhodXUysN_flfedqgxvTIeC84l0" class="fr-fic fr-fil fr-dib" width="1823" style="width: 1825px; height: 904.444px;" height="904"></p><p><strong><span style="font-size: 10pt;">Fig 15. Value available to be recognised once time logged on a project</span></strong></p><p><br></p><p>Creating the invoice here will recognise the value of the time logged on the project so far.&nbsp;</p><p data-pasted="true"><br></p><p>The positive line represents the value of the project that is becoming recognised revenue, and moving into your income account.&nbsp;</p><p><br></p><p>The negative line represents the down payment that is being used to &#39;pay&#39; for this invoice. In other words, the amount of money that is being taken out of the deferred revenue account.&nbsp;</p><p><br></p><p>As the invoice has 0 value the customer will not be sent the invoice, this invoice is just created in order to sync to your accounting tool, moving the revenue from your deferred revenue account into your standard income account. Resulting in the revenue now being recognised.</p><p><br></p><p>Each time you would like to recognise the value of the time logged against the project generate a deferred revenue invoice here. The invoices generated here will continue to be zero value until the down payment &#39;credit&#39; has been &#39;used up&#39;. After this invoices generated will be positive as the customer will need to pay for this work.</p><p><br></p><p>In the Figure 16 example the amount of labour logged/to bill exceed the amount of down payment left to recognise, so the difference will be chargeable.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImVjZTU5NzEyLTE1MjgtNDQ3ZS05ZjYyLTk3NmY1YTM5NTc4MyJ9.DXLGSquPd8lVS-gWEONVGccvxl8s8khXh8E6shWByD8" class="fr-fic fr-fil fr-dib" width="1759" style="width: 1761px; height: 872.794px;" height="873"></p><p><strong><span style="font-size: 10pt;">Fig 16. Invoice to recognise remaining down payment value&nbsp;</span></strong></p><p><br></p><p>Down payments taken for any items issued on the project will not be used to &#39;credit&#39; labour logged on the project.&nbsp;</p><p><br></p><p>If you still need to invoice the remainder of the sales order this can be done using the &quot;Create Invoice&quot; action on the sales order, using the option here to &#39;invoice the entire order&#39; will invoice the remainder of the sales order, accounting for the down payment that has already been paid.&nbsp;</p><p><br></p><p>Further down payments can be created from the sales order at any time, allowing you to take another instalment from the customer and recognise the revenue of this as your agents log time on the project.&nbsp;</p>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.