CGU integration

Invoices for CGU can be electronically exported from Case Manager and brought into the CGU system via integration with their servers. The process uses the journal entry facility.

Before using this feature it is important to:

  • apply to CGU to use this feature and
  • understand the information that will be included and where it is located in Case Manager.

Mandatory fields

The fields in this table are all required. You need to ensure that all of these fields have a value otherwise the export will fail.

Export FieldCase Manager FieldNotes
Registration IDOffice Bus NumberThe ABN of the billing entity - this must be registered with CGU to use this facility
Claim NumberClaim NumberCGU Claim number
Patient NameClient Name 
Invoice ReferenceInvoice Number 
Invoice DateInvoice Date 
Service DescriptionCost Description 
QuantityCost Duration / Qty 
Invoice Total Tax AmountThe tax included in the invoice 
Invoice Total Excluding TaxInvoice total minus the tax included 
Item Category

The shortcut of a cost's charge code:

Each cost should have a charge code and this charge code should have a shortcut.

The final mandatory field is the Payee Contact ID. CGU issues this number to you and you enter it as part of the export process.

You do not need to re-enter it each time, however you can override the previous entry when necessary.

Optional fields

The following fields will also be exported if a value is present in Case Manager.

Export FieldCase Manager FieldNotes
Payee NameTools > Options > Company NameBilling entity's (company) name
Payee LocationOffice Name 
Payee StreetOffice Street 
Payee SuburbOffice Suburb 

Payee State

Office State 

Payee Postcode

Office Postcode 
Payee EmailOffice Email 
Patient StreetClient Street 
Patient SuburbClient Suburb 

Patient State

Client State 

Patient Postcode

Client Postcode 
Patient EmailClient Email 
Service CodeCharge Code 
Start DateCost Start Date / Time 
End DateCost Finish Date / Time 
Provider Staff MemberCost Employee Name 
Provider Staff IDCost Employee Provider Number 

Steps in Case Manager

  • Create the required invoices.
  • For more information on invoicing, see Accounts overview.

  • Create a new journal entry that includes only the invoices for CGU.
  • You do this by filtering invoices by either "Bill To" or categories.

    For further information on creating Journals see Create a journal entry.

  • Select the newly-created CGU journal and click Export....
  • Select the CGU option button and click Next.

  • Enter the Payee Contact ID and click Next.
  • The export will begin and you will see its progress in the output window.
  • When the export is complete you will see a list of invoices that were successfully exported as well as those that were not (with exception details).
  • Save and print the log if required and then click Finish.

Important notes

  • When a batch is exported, any invoices with an error will be skipped. The details of the error(s) will be listed on the final step and can be optionally saved to a file. This means it's possible that only part of a batch has been exported. If that happens you will need to correct the problem invoices and export the batch (journal) again. Case Manager keeps a record of which invoices were successfully exported and will skip those when you re-submit the batch.
  • If you attempt to export a journal entry twice (where ALL the associated invoices have been previously exported), nothing will be sent to CGU and the output log will show that all invoices have been skipped.