CSV File Format for Billable Charge Upload

Before uploading a billable charge file, you need to ensure that the CSV file contains the following columns:

Column Name Description Mandatory (Yes or No)
Account Identifier Type Used to specify the account identifier type. Yes (Conditional)
Note: This data is required when the Account ID is not specified.
Account Identifier Used to specify the account identifier of the account for which you want to create the billable charge. Yes (Conditional)
Note: This data is required when the Account ID is not specified.
Account ID Used to specify the account for which you want to create the billable charge. Yes (Conditional)
Note: This data is required when the Account Identifier Type and Account Identifier is not specified.
Contract ID Used to specify the contract against which you want to create the billable charge. Yes (Conditional)
Note: This data is required when you want to create the billable charge against a specific contract on the account. If this data is not specified then billable charge is created against a contract with highest priority.
Start Date Used to specify the start date of billable charge. Yes
End Date Used to specify the end date of billable charge. Yes
Charge Type Used to specify the charge type for which you want to create a billable charge. No
Description On Bill Used to specify description for a billable charge. Yes
Recurring Flag Used to indicate whether recurring bill segments must be created at the intervals defined in the bill period or at the set policy invoice frequency. The valid values are:

  • BP

  • FR

 Yes (Conditional)
Note: This data is required if Frequency or Bill Period is specified.
Frequency Used to specify the invoice frequency at which the recurring bill segments must be created. Yes (Conditional)
Note: This data is required if Recurring Flag is FR.
Bill Period Used to specify the bill period that you want to use for specifying the intervals at which the recurring bill segments must be created. Yes (Conditional)
Note: This data is required if Recurring Flag is BP.
Bill After Used to specify the date after which the bill must be generated for the billable charge. No
Adhoc Bill Used to indicate whether the billable charge should be considered during adhoc or regular billing. No
Description on Bill1, Description on Bill2, ....., Description on Bill5 Used to specify description for the billable charge lines. Yes (Conditional)
Note: This data is required when the charge amount is specified.
Currency1, Currency2, ....., Currency5 Used to specify the currency in which the amount is charged.
Note: If you specify a currency other than the account's invoice currency, the system will do the currency conversion if the appropriate exchange rate is available in the system.
 Yes (Conditional)
Note: This data is required when the charge amount is specified.
Amount1, Amount2, ....., Amount5 Used to specify the charge amount. Yes (Conditional)
Note: This data is required when the description on bill or currency is specified.
Show On Bill1, Show on Bill2, ....., Show On Bill5 Used to indicate whether the charge should appear on the person's printed bill or not. The valid values are:

  • true

  • false

Note: By default, the value will be set to true if the column does not contain any value.
 No
Summary1, Summary2, ....., Summary5 Used to indicate whether the charge should be included in the summary line or not. The valid value are:

  • true

  • false

Note: By default, the value will be set to true if the column does not contain any value.
 No
Memo Only1, Memo Only2, ....., Memo Only5 Used to indicate whether the charge should be included in the bill amount or not. The valid values are:

  • true

  • false

Note: By default, the value will be set to false if the column does not contain any value.
 No
GL Distribution Code1, GL Distribution Code2, ....., GL distribution Code5 Used to specify the distribution code which indicates the GL account associated with the charge. Yes (Conditional)
Note: This data is required when false is specified in the Memo Only column corresponding to the bill line description.
Price Item Used to specify the price item code. Yes (Conditional)
Note: This data is required when Variance Parameter or, Price Item Parameter and Price Item Parameter Value is specified.
Variance Parameter Used to indicate the variance that must be used along with the price item for determining the price item pricing. Yes (Conditional)
Note: This data is required when Price Item is specified and Price Item Parameter and Price Item Parameter Value are not specified.
Price Item Parameter1, Price Item Parameter2, ....., Price Item Parameter15 Used to indicate the price item parameter that must be used along with the price item for determining the price item pricing.
Note: If the data in these columns will be used for price item parameter mapping, you must not use the equal to (=) and tilde (~) symbols in these columns.
 Yes (Conditional)
Note: This data is required when Price Item is specified and Variance Parameteris not specified.
Price Item Parameter Value1, Price Item Parameter Value2, ....., Price Item Parameter Value15 Used to specify the parameter value.
Note: If the data in these columns will be used for price item parameter mapping, you must not use the equal to (=) and tilde (~) symbols in these columns.
 Yes (Conditional)
Note: This data is required when Price Item is specified and Variance Parameteris not specified.
SQI1, SQI2, ....., SQI5 Used to indicate the service quantity identifier that must be used for calculating the price item charges. Yes (Conditional)
Note: This data is required when the service quantity is specified.
SQI Value1, SQI Value2, ....., SQI Value5 Used to specify the number of units of the service quantity. Yes (Conditional)
Note: This data is required when the SQI is specified.
Effective Date1, Effective Date2, ....., Effective Date20 Used to indicate the effective date of the characteristics. Yes (Conditional)
Note: This data is required when Char Type or Char Val is specified.
Char Type1, Char Type2, ....., Char Type20 Used to indicate the characteristic that must be defined for the billable charge. Yes (Conditional)
Note: This data is required when Effective Date or Char Val is specified.
Char Value1, Char Value2, ....., Char Value20 Used to specify the value of the characteristic type. Yes (Conditional)
Note: This data is required when Effective Date or Char Type is specified.