<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>- Methods of Integrating</strong></p><p><strong>- Exporting via CSV Templates</strong></p><p><strong>- Exporting via Reports</strong></p><p><br></p><p><br></p><p><strong>Configuration Settings:</strong></p><ul><li><a href="https://usehalo.com/halopsa/guides/1391" target="_blank" rel="noopener noreferrer"><strong>CSV Templates</strong></a></li></ul><p><br></p><p><strong>Related Guides:</strong></p><ul><li data-pasted="true"><a href="https://usehalo.com/halopsa/guides/2326" target="_blank" rel="noopener noreferrer"><strong>Embed XML Attachments to Invoice PDFs</strong></a></li></ul><p><br></p><p><strong><span style="font-size: 14pt;">Methods of Integrating</span></strong></p><p>If using an accounting platform that Halo does not natively integrate with, there are alternate methods to sync your invoices across to that tool. This involves exporting a CSV file of the invoice from Halo, and importing this file into the accounting tool. The import requirements will differ per accounts platform, so the CSV will need to be formatted using the method that best matches yours.</p><p><br></p><p data-pasted="true">The creation of invoices will work the same inside of Halo, this covers the steps that follow this to get the information into your accounting platform.</p><p><br></p><p>Some accounting platforms may instead require XML formats. If using an accounting tool that can read ZUGFeRD or Factur-X PDFs (primarily in the EU), these can be generated by linking an XML Template to a PDF Template. More information on these and e-Invoicing can be found <a href="https://usehalo.com/halopsa/guides/2326" target="_blank" rel="noopener noreferrer"><strong>here</strong></a>.</p><p><br></p><p>A list of all native accounting integrations can be found within Configuration > Integrations > Accounts and Payments. If you use one not listed here, you may wish to check with support if it is available on Beta versions, or upcoming on our roadmap.</p><p><br></p><p>Some platforms may also have integrations created by a third-party. These can often be found by searching "Halo [Platform Name] Integration" in your browser.</p><p><strong><em>Note: Whilst the Halo Support team can assist in troubleshooting these, initial setup and most questions should be directed to the third-party platform.</em></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Exporting via CSV Templates</span></strong></p><p>CSV templates can be created to allow you to download CSV files of invoices in a specified column format, which can then be uploaded to the accounting platform each time.</p><p><br></p><p>In Configuration > Billing > General, click "Enable CSV Invoices". This will show a button to edit CSV templates (that can also be navigated to via Configuration > Reporting > CSV Templates).</p><p><br></p><p><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjkzMWI3NTAzLWI2ZmEtNDIzYS1hZjFmLTRjYmIxYzJmOTNkZCJ9.2v-SaPEWPu4d3BFNS-J1YqV-H3jUSz5d359p4Nh5DTc" width="198" height="169" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; max-width: none !important;" data-pasted="true" class="fr-fil fr-dib"></p><p><strong><span style="font-size: 10pt;">Fig 1. Enabling CSV invoices</span></strong></p><p><br></p><p>A list of existing templates will show upon clicking into this area. Ensure the entity is set to "Invoices", then click "New".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjM0OTJjZDI2LWJhNWMtNGVkOC04MzFjLTdhOTE2N2IxZjFmYyJ9.fYGXYHq5cG83oxBgIRRcjG6uajtuzM_1cm_d0iwfU-s" class="fr-fic fr-fil fr-dib" width="1511" style="width: 1513px; height: 129.117px;" height="129"></p><p><strong><span style="font-size: 10pt;">Fig 2. List of invoice templates</span></strong></p><p><br></p><p>First, give your template a name. You will then be able to set the type of template you need. It is important to note that there is a maximum download limit of 1000 rows at a time, so if you have a large number of invoices or are using the "Row for each Invoice Line" option, you may want to consider using the report method instead.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZmMWJmNzVmLTVhNzYtNDdiMy1hYzc5LWNhY2QyMjQ3NmZiNCJ9.aFal4YKaZUOhPfA-EVpALXiGccuBinT10OOR0kX_8nQ" class="fr-fic fr-fil fr-dib" width="1172" height="456"></p><p><strong><span style="font-size: 10pt;">Fig 3. Creating an invoice template</span></strong></p><p><br></p><p>After saving, you will then be able to see the "Details Table" tab, where you can configure what fields show on the CSV. Edit again, then click the "Add" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjI0ZTNjZjQ3LTM1ODEtNDY3OS05YTMyLTE2OGVhMjQ0ZDdmOCJ9.XNz4E2z0aEPNPgsrX_RPfVd-jALRh7NY1p4acHbwbqM" class="fr-fic fr-fil fr-dib" width="1518" style="width: 1520px; height: 218.03px;" height="218"></p><p><strong><span style="font-size: 10pt;">Fig 4. Creating the details table</span></strong></p><p><br></p><p>You can then choose a column to add to the table. This is a single select field, so you will need to add each column individually.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjViYjJmN2VlLTM0OTEtNDhlNS04MDJmLWJiNzIxYjM5MjQyZCJ9.N775KvFYo1WHqg3RjU98nD4fRbxgbDnxE0CrupOxovA" class="fr-fic fr-fil fr-dib" width="719" height="467"></p><p><strong><span style="font-size: 10pt;">Fig 5. Adding columns</span></strong></p><p><br></p><p>Once you have chosen a column, you can set the title for that column to use, as well as if it has a default value. This can be useful to set a default product code if none is set and will match on the invoice line once imported.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ3MWI4ZTljLWYzOWMtNDJkMi04NGRlLTdlYTE1ODUzNDc1YSJ9.u_GdFGYdpzZOh76mElDCaRJ8Ff_B2zFrzaT4lAqWc4E" class="fr-fic fr-fil fr-dib" width="723" height="333"></p><p><strong><span style="font-size: 10pt;">Fig 6. Choosing column name or default value</span></strong></p><p><br></p><p>After adding all of the columns, you may want to use the "Preview Print" button to show what the table format will look like with an example invoice from your system.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFkMjg3Y2UwLWE3NzQtNGNiMS05YTNiLTQwNDRiMWViOTQyZCJ9.3zJXzRNGfyqVEa8X2yOJA2_XuG6cBLr-2EOZq6xT88g" class="fr-fic fr-fil fr-dib" width="1521" style="width: 1523px; height: 130.877px;" height="131"></p><p><strong><span style="font-size: 10pt;">Fig 7. Previewing template</span></strong></p><p><br></p><p>Now that we have created the invoice template, go to the "Invoices" area.</p><p><br></p><p>The "Show invoices between" options will show if you enable the CSV Templates module in Configuration > Reporting, which can be used to filter the invoices that show to a specific time period. You can then click the checkbox in line with the column headers to select all the invoices within that date filter. Hover over the "Edit" button, and select "Create CSV".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImEyOWIxMWFkLWIyNzItNGU1Yy05NjM1LWExZTFiZGE0Y2EyMCJ9.MlZKfpUSube-SHfu2KB7JQB39vYXrHuaJ0F5OWa21SU" class="fr-fic fr-fil fr-dib" width="663" height="441"></p><p><strong><span style="font-size: 10pt;">Fig 8. Selecting invoices to download</span></strong></p><p><br></p><p>A popup will show to choose from your available CSV templates, and whether you want to mark these selected invoices as posted upon download.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgxNzc4NzZlLWZiMmQtNDliMy1hNjIwLTU5OTgxZTU1ZjZjNyJ9.cm7mUGNHhLW8Stmr7aaolA2utk9L6wVWzobcQKdt6_M" class="fr-fic fr-fil fr-dib" width="712" height="329"></p><p><strong><span style="font-size: 10pt;">Fig 9. Choosing a template</span></strong></p><p><br></p><p>A file will then be generated combining each of the invoices/invoice lines together.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImJkN2E0ZDRiLWU5ZDgtNDIzZC05N2JjLWVmMjkzNGU2NmJhNyJ9.4jqmNYpCptP4JBuLkZ5ug64GvJFoCVVu66FIn0fC4lg" class="fr-fic fr-fil fr-dib" width="333" height="194"></p><p><strong><span style="font-size: 10pt;">Fig 10. Downloaded file</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Exporting via Reports</span></strong></p><p>Reporting on the invoices created in Halo is an easy way to create a formatted CSV for download to your accounting tool. The report can then be scheduled to send a CSV file on a recurring schedule of your choice, which can then be downloaded and uploaded to the accounting platform each time.</p><p><br></p><p>This example report can be found in our Online Repository from this URL <strong>[YOURHALOURL.com]/reports?mainview=onlinerepository&id=2961</strong>. It is formatted to use one row per invoice line, with the "Invoice No" column used to match which rows go on an invoice together.</p><p><br></p><p data-pasted="true">This format may need to be adjusted, depending on your tool. Reports can be created customised to your import requirements, please ask your consultant or our support team for assistance.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA5OWNmNmFjLWFiNjQtNDYyYy05NTlhLWU5ZDYwMzlmNzY3OCJ9.C9M-PN-NBIL2YGYTeseWLcWMYwK5WQsZ9scFPKx4Bbg" class="fr-fic fr-fil fr-dib" width="1521" style="width: 1523px; height: 387.673px;" height="388"></p><p><strong><span style="font-size: 10pt;">Fig 11. Example export report</span></strong></p><p><br></p><p>If you need to adjust the column names to match the required format, this can be done within the "Data Source" tab on the Report, by changing the display names in brackets.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc2NjhiNGY1LTBlYzYtNDlhMi05Yjk3LTY4MTlkNTljZWM2ZiJ9.b5HNwMnePUsbuy1GD-RzRvKJ7sk2j-wXYppx69jcHLc" class="fr-fic fr-fil fr-dib" width="1519" style="width: 1521px; height: 565.713px;" height="566"></p><p><strong><span style="font-size: 10pt;">Fig 12. Changing report column names via SQL</span></strong></p><p><br></p><p>These can also be changed in the "Fields" tab. Add all of the fields to this screen, click the pencil icon to edit a field, then rename the column in the "Name" field.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjlhNGRlYjVlLTMwMTMtNDJkZC04ZjNjLTczMDI3ZjNiOTZiMyJ9.rSj6F-FtJQfNLI5ka4ioG-xczm3xrmTBxhWpwtNOB_o" class="fr-fic fr-fil fr-dib" width="715" height="727"></p><p><strong><span style="font-size: 10pt;">Fig 13. Changing report column names via field</span></strong></p><p><br></p><p>Once the report is configured, we can then schedule this to send on a recurring schedule. In the "Scheduling" tab, click "Add" on the table.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQ2YTM2ZTk4LTBhZjMtNDg3MS05NDk1LTg5MGUzNmVlM2E1NiJ9.HUQSqPykJ3SQOqEBe_VOM_UnJvSzOtsM-MjPqdsbc4w" class="fr-fic fr-fil fr-dib" width="1526" style="width: 1528px; height: 248.083px;" height="248"></p><p><strong><span style="font-size: 10pt;">Fig 14. Creating a report schedule</span></strong></p><p><br></p><p>When creating the report schedule, you will need to ensure to click "Include CSV" to add a .CSV file to your email. If you require a .XLS file instead, click "Include Excel/CSV Table".</p><p><br></p><p>Add the email(s) you wish to send this report to, such as your accounts email or the email of someone on that team.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRmNTQ5NjJkLTM4NDMtNGMyMy04ZTQ1LWZhOGFiNTAwZmMxYSJ9.M0X9MG5mE9doy5jsNj_19BgC1I7MrKtBBN0770BUywk" class="fr-fic fr-fil fr-dib" width="1524" style="width: 1526px; height: 542.323px;" height="542"></p><p><strong><span style="font-size: 10pt;">Fig 15. Adding a CSV file to the email</span></strong></p><p><br></p><p>When the scheduled time occurs, the listed email(s) will get a file emailed that can be downloaded, and imported into the accounting platform to create the invoices.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgzM2QyNDM5LWQ1NDItNGQ5MC1iNjk5LTBhMWJjZWZlYTFhNyJ9.Nptl7QvLudonLhug3a9EDRHAixL2GJNMog2gj0FVjsQ" class="fr-fic fr-fil fr-dib" width="925" style="width: 927px; height: 484.936px;" height="485"></p><p><strong><span style="font-size: 10pt;">Fig 16. Report emailed as a CSV file</span></strong></p>
