Guides - Recurring Billing Profiles (Import Recurring Invoice Lines)

Recurring Billing Profiles (Import Recurring Invoice Lines)

This guide has multiple versions available:

<div><div><div><div><div><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><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><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><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>In this guide we will cover:- What are Recurring Billing Profiles?- How to create a billing profile - Importing Recurring Invoice Lines- Worked Example What are Recurring Billing Profiles? Recurring Billing Profiles are used when importing recurring invoices lines into Halo from a csv file (spreadsheet). When importing lines each row in the csv will represent an invoice line and each column will represent which recurring invoice field the data needs to be imported into. Recurring Billing Profiles allow you to map the names of the columns in your csv file (spreadsheet) to the corresponding fields in Halo. This is useful when exporting recurring invoice lines from one platform, and importing them into Halo.  How to create a Billing profile  In this example, we will look at how Billing Profiles are configured & how they allow you to update existing recurring invoices. Your recurring invoice must already exist in order for you to be able to import lines into it. The first step is to configure a Billing Profile that will be used to map XLS columns to fields in Halo. Navigate to Configuration > Billing > Recurring Billing Profiles.<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg2MmNmZWU2LTE5ZjQtNDIyMC04ZTE4LTZkZjUyODNmN2ViYSJ9.P5IhOE5MPXAyqIaNVbBg3SDgOLg-f2pl4kHgQdIX7Cs" class="fr-fic fr-fil fr-dib" width="570" style="width: 572px; height: 368.378px;" height="368">Fig 1. Billing Profile Configuration Option. In here, you will have an option to View/Edit XLS/CSV Profiles for Recurring Invoice Lines- this is where you set up your import profiles (via the 'New' button in the top RHS). When creating a billing profile, you will be presented with a 'mappings table':<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjkyODViYmQ3LWEzM2EtNDFjYy04MDkzLThkNjAxZjM2MmFkYyJ9.6X6aPdNpN67HG9V1kb0Ibh03f-4Zlm6gVKFTxbIi7sw" class="fr-fic fr-fil fr-dib" width="1258" height="613">Fig 2. Creating a new Billing Profile. The profiles will be explained further below. The two settings that are displayed above the field mappings table are important to understand. The setting "When lines are not matched create new lines" if lines are not matched, which is based on the mappings that have "Is a matching field" set to yes, then with this setting enabled, there will be new lines created on the recurring invoice. The force_new option will make a new line for the row on your import, regardless of matching. This is acheived by creating a column header called 'force_new' and then setting the value of the rows to 'true'. Each import profiles can be set to "Import all lines as one time charge". This is for the lines added to the recurring invoice that are to be invoiced for that period and then made inactive in the next period. The idea of this mapping table is to add a series of records into the table, where each record details the column header of the import spreadsheet you will be using & the data that the column contains. For example, perhaps I would like to update the quantity of certain recurring invoice lines on respective recurring invoices. For this, I would be concerned with the following data: <ul><li style="font-size: 11pt;">Who's Invoice needs updating?</li><li style="font-size: 11pt;">What line needs updating?</li></ul>Assuming the combination of Invoice + Invoice line is unique, you may well find a similar output to:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI0OWU5ZDg5LTA0ZmItNGZkNi05YWJkLWY0NDMzM2UyOWIxYyJ9.qSwfmaY6Om02FZnPiAG_q0b-oHNYjxwtz7gEa_LFuT4" class="fr-fic fr-fil fr-dib" width="708" height="226">Fig 3. Import spreadsheet. With the import sheet formatted similar to Fig 3, you would want a Billing profile in Halo as:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjUxZDQ1NGFiLWY0NjgtNGVmMi05ZjRjLWQ3OTQwNjlkNjVjMCJ9.Fj-ZFjbxmwEak2T7Bnszcjwiel7YBvDJBeHgY9KHEo8" class="fr-fic fr-fil fr-dib" width="1137" height="656">Fig 4. Billing Profile, to match that of Fig 3. Notice how 'Customer Name' and 'Product Code' are specified as Matching Fields - this means that, upon importing, Halo will check to see if it can find a Recurring Invoice for the specified customer, with said Recurring Invoice containing a line with the Given Product Code. If found, the quantity for the matched line will be updated accordingly. There is a checkbox for "When lines are not matched create new lines" this will mean that new lines will be generated if they do not match previous lines. We can also force recurring invoice lines by adding a column header 'force_new' and setting the row values of the column to 'true' Importing Recurring Invoice LinesNow you have created your Billing Profile, you can use this to update Recurring Invoice line quantities. In Configuration > Billing > Recurring Billing Profiles, you'll find a button to 'Import Recurring Invoice Lines'.<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNmMzEyOWZjLTYzNDQtNGQ3MS05NWFhLTA4MmVmYmE0YTIyMCJ9.IUTNyXIPzYXVPRKus7Vqh-bW-BTQXP6zFj8wmTgSk6o" class="fr-fic fr-fil fr-dib" width="893" style="width: 895px; height: 326.392px;" height="326">Fig 5. Import Recurring Invoice Lines. You can also import recurring invoice lines from the recurring invoice section of the 'Invoices' module, using the menu in the top right hand side of the page.  <img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjYwODBhZTAyLTg4ZTMtNGMwYS1hNGI5LWNhZjYwNmRmZjcyZiJ9.k2mdWSP6oq-XwEUJdOqMxQnkvdH0FgTTux20mw9wfSg" class="fr-fic fr-fil fr-dib" width="1531" style="width: 1533px; height: 437.573px;" height="438"> Fig 6. Import recurring invoice lines from the invoicing module. Upon clicking this, you are presented with the option to select from the relevant billing profile (you may get spreadsheets from different systems, which use different naming conventions for similar columns: Client Vs Customer, for example. In this case, you would create multiple billing profiles for these different systems and use the relevant profile per import):<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg3MGNhN2E2LWZjNTUtNDQxZC05OWY0LTFmOGFmMGQzNjNiOCJ9.hBJn6qz3SdKTev6rqsNo2iZdqTe9XePKvvfiGoS9SWg" class="fr-fic fr-fil fr-dib" width="620" height="208">Fig 7. Selecting your billing profile to use when importing Recurring Invoice Lines. Once you have selected the relevant Billing Profile, you will be presented with the Import Preview screen, where you can select the import spreadsheet you will be using. You may find that some of your import rows fail.<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjIzZTI5M2RiLTQ3ZDAtNDk4MC1hMTE2LTJhYTQ3N2NmMzkxOCJ9.kPSve1thO1Kp4Z5HDF4fc3LMKf9Ws3bdyiABuGWPNuQ" class="fr-fic fr-fil fr-dib" width="1693" height="544">Fig 8. Result of importing Recurring Invoice Lines, based on our Example Billing Profile. If lines fail, then the 'failure message' will be returned in the browsers developer tools, which you can access via pressing f12 in the browser:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijk0ZmE4YTBmLTVmMDgtNDgyZS05ZjQ2LWUyY2MwMzNiYTNjOCJ9.j32F2JZaqlTk3P2sHgkLq8I0iuLkOCpqpDPrrAq1g8A" class="fr-fic fr-fil fr-dib" width="1128" height="847">Fig 9. Viewing the console in your browser. Worked example- Import for a Recurring Invoice LineAs an example, the following columns have been added to the billing profile:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjJhMTI3ZDBmLTU2NzQtNGEwOS04NDk2LWQ0MDg4MzBjZDI5NCJ9.gLkWOtG5Cr94n3Mv8BpXo8pIO27hMXh5aJZArF8FrP8" class="fr-fic fr-fil fr-dib" style="width: 1179px;">Fig 10. Example billing profile. The Recurring Invoice ID can be found in the URL of the browser's page. The import spreadsheet included the following:<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVmYjZkZjVhLTk1MzgtNDBhOS04MDJlLWQ3NGNhNDIxZmEyYSJ9.1rdsDl90jh9V_YSLUoVSXN_Cfzu6YqHR1M4ayYL3jYA" class="fr-fic fr-fil fr-dib" style="width: 1278px;">Fig 11. Import spreadsheet with relevant columns. The Recurring Invoice now has a new line on it for the line that has been added via the import spreadsheet.<img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImMxODNkZWYzLTkzMGEtNDMyYy05NjZmLTQwZWE1YWY4OTEyMiJ9.Zmiy6XVUq7RDAMd8UXntC3s_CwTcF1iH5jy40AE3VxM" class="fr-fic fr-fil fr-dib" style="width: 1339px;">Fig 12. Invoice following import.</div></div></div></div></div>

Feedback

Guide name here

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

One unified platform. Every team. Every workflow.

Tailored solutions for every industry.

Powerful capabilities, endless possibilities.

Browse Guides

Platform

Use Cases

Resources

Halo

Subscribe to Halo for latest news

Follow