Export

Exporting Billing Batch Details

The data on the Billing Batch Grantee page can be exported into excel for review. This can be done by clicking ‘Export’ in the upper right-hand corner. NOTE: this will export only the line items displayed on screen, so if you have filtered the results by any criteria, it will only export the results of the search. Click the ‘x’ beside the Search button to clear your search if you wish to export all lines in a billing batch.

When you click ‘Export’, it will queue a Job. Once the job is complete, a green dot will appear on your ‘Job Manager’. Click Job Manager, then click the hyperlink for your target file to download.

If there is a Warning Label for your export:

Click the ‘Warning’ link to learn more about the warning. In this example, the Warning indicates that a BA code is missing for a Master Agreement. These warnings typically notify you if important data is missing such as cost centres or BA codes

Export Billing Summary & Detail Report

You can also export the billing detail report, which will give you an overview of every addendum for every grantee in the billing batch. This is located in the hamburger menu to the left of your billing batch on the main billing screen. This export will be found in your job manager (mentioned directly above).

Export Vouchers/Extracts & Other Options

Queue Voucher

This will queue a job to create a voucher file for your company’s accounting system. This file can then be downloaded and loaded into your accounting system.

Queue EnergyLink Extract

This will queue a job to create an excel file to be loaded into EnergyLink.

Update Cost Centres

This can only be applied to non-finalized billing batches. This will refresh any cost centre changes that have been made in the system since the billing batch was created. E.g. if a surface file’s cost centre got added/updated in the land system since the billing batch was created.

Finalize

This will ‘lock’ the billing batch and prevent any updates. This should be done once the voucher is processed in the accounting system and invoices have been sent. This will set the ‘Last Billed’ dates on the addendums preventing any double charging on already billed months. Finalized billing batches have a black Lock icon beside their name.