<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><p><strong>In this guide we will cover:</strong></p><p><strong>- What are Billing Templates?</strong></p><p><strong>- How to Bulk Apply Billing Templates to Customers</strong></p><p><br></p><p><br></p><p><strong>Related Guides:</strong></p><ul><li style="font-weight: bold;"><a target="_blank" rel="noopener noreferrer" data-fr-linked="true" href="https://usehalo.com/halopsa/guides/2062" data-pasted="true" style="font-weight: bold;"><strong>Billing Templates</strong></a></li></ul><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;">What are Billing Templates?</span></strong></p><p>Billing Templates are used to easily apply a set of billing rules to multiple customers. If you have multiple customers that follow the same billing rules a single billing template can be created and applied to all applicable customers, rather than having to add all the rules to each customer one by one. </p><p><br></p><p>In this guide we will cover how to apply billing templates to your customers in bulk once the template is created. For information on creating the template itself, checkout <a target="_blank" rel="noopener noreferrer" data-fr-linked="true" href="https://usehalo.com/halopsa/guides/2062" data-pasted="true">Billing Templates</a>.</p><p><br></p><p>Billing templates can be applied to customers in bulk using a csv import. Useful if you have a large number of clients that require a billing template to be applied.</p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">How to Bulk Apply Billing Templates to Customers</span></strong></p><p>To bulk apply billing templates to customers you will need to complete a csv import to update client information. </p><p><br></p><p>First you will need to obtain the customers and sites csv template for the import. Head to Configuration > Users > General Settings > Import Customers and Sites.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImUzZGYzM2E1LTVkMzYtNDg5Mi04YzFlLWFhMzkzMjE4MDVhMSJ9.z64qdBytW0TnUABnd3Y-ZI22nukYnlQ-Cw9F_95bxYs" class="fr-fic fr-fil fr-dib" width="1148" style="width: 1150px; height: 411.294px;" height="411"></p><p><strong><span style="font-size: 10pt;">Fig 1. Import Customers and Sites</span></strong></p><p><br></p><p>A pop up will show for you to select a file to import. Cancel out of this pop up and you will be able to select "Download Samples". </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM0MWFiNjE3LTQ0YzYtNGI3Zi05OTM3LWZjYjRjNDU4ZGEwMSJ9.nII-jywzDrol1VpbIISjoaK4xMESMiqThvbGGnzS8GI" class="fr-fic fr-fil fr-dib" width="558" style="width: 560px; height: 251.622px;" height="252"></p><p><strong><span style="font-size: 10pt;">Fig 2. Download Samples</span></strong></p><p><br></p><p>This will download a zip file containing all the templates required for csv imports in Halo. Unzip this file and open up the file called "Clients and Sites". </p><p><br></p><p>Here, you will need to populate the template with the unique identifier for each customer that you would like to update. The unique identifier is set under Configuration > Users General settings. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA3NGQ0ZWFjLTY4M2QtNGU5NS05ZDI4LTlhYzkzMDI4M2U1NSJ9.3AU9-oKUR_B4OblE5Yb1SZ9-xP_SPtxyoAmQvO32C4E" class="fr-fic fr-fil fr-dib" width="1285" style="width: 1287px; height: 285.538px;" height="286"></p><p><strong><span style="font-size: 10pt;">Fig 3. Set unique identifier for customers and sites</span></strong></p><p><br></p><p>Ensure you add the unique identifier on the template under the correct column. If using "Name" as the unique identifiers you will need to enter the customer name in the "CustomerName" column. </p><p><br></p><p><strong><em>Note: Do not change the name of any columns on the template, this direct the data to the correct location in Halo. </em></strong></p><p><br></p><p>Now add a new column to the template called "billingtemplate_id" (this must be exact). Here, enter the ID of the billing template you would like this customer to have. </p><p><br></p><p>The id of each billing template can be seen in the URL when editing a billing template. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM5ZGRiNTU3LWVmOGYtNDgwMi1iNzUwLTAxMzllMWVlZWRhNCJ9.aVH0OTNxPawsF3CuQd77y5fEzxLK0yBAD1svGYM5Efs" class="fr-fic fr-fil fr-dib" width="545" style="width: 547px; height: 475.809px;" height="476"></p><p><strong><span style="font-size: 10pt;">Fig 4. ID of Billing Template</span></strong></p><p><br></p><p>Other columns on the spreadsheet can be deleted or left blank. </p><p><br></p><p>Your template will look something like the example in figure 5. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU1YjY0ZGUyLWNmOWMtNDRhYy04NTJiLWYxMDhhNzMyMzZiNSJ9.Gg2kOls0tnhLPU7cokJab2dAkuihZH9TF8YJn3HcWMs" class="fr-fic fr-fil fr-dib" width="550" style="width: 552px; height: 421.065px;" height="421"></p><p>Fig 5. Example template to update billing templates</p><p><br></p><p>Now save the template, head back to Configuration > Users > General settings > Import Customers and Sites and select the saved template file. You will see you data pull throguh here, check this is correct and hit "Start" to begin the import. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjM5YTJjMzBmLTY2MGYtNGZiMS1iYWRkLWNhZDg1OWI2NGMzYiJ9.pu67ltMRddzXAGX39NkN4WtlZaRon7TSTXhKwdFWiQc" class="fr-fic fr-fil fr-dib" width="1598" style="width: 1600px; height: 317.791px;" height="318"></p><p><strong><span style="font-size: 10pt;">Fig 6. Completed Customer Update </span></strong></p><p><br></p><p>Once the import is complete head to Configuration > Billing > Billing Templates > select a template > "Update Customers" to have the billing rules of this template added to the customers. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQzY2Y1NjZlLWRkYzAtNDEyNC1iNzg3LWZmMzc2NDM0MjQ4MiJ9.RKYow3pP43jna9weYz1LCKzw1P6SHI_yah5qQ5oEGYo" class="fr-fic fr-fil fr-dib" width="514" style="width: 516px; height: 418.306px;" height="418"></p><p><strong><span style="font-size: 10pt;">Fig 7. "Update Customers" Button</span></strong></p><p><br></p><p>Now all these customers will have their billing template updated. </p>
