Open Menu

© 2018 Capita Business Services Ltd. All rights reserved.

Capita Education Software Solutions is a trading name of Capita Business Services Ltd. Our Registered office is 30 Berners Street, London, W1T 3LR and our registered number is 02299747. Further information about Capita plc can be found in our legal statement.

CLFP - Format for Financial Data Import

Draft Format

Exports of data from an alternative financial product must be in the following XML Format

<Root>
  <Budget>
    <DateofData>12/02/2020 10:57:21</DateofData>
    <FinancialYear>2019</FinancialYear>
    <Start_Date>2019-04-01</Start_Date>
    <End_Date>2020-03-31</End_Date>
    <LedgerGroup>Income</LedgerGroup>
    <Ledger_Code>0100</Ledger_Code>
    <LedgerCodeDescription>School Meals Income</LedgerCodeDescription>
    <RevenueLedgerType>IN</RevenueLedgerType>
    <Fund>01</Fund>
    <FundDescription>School Budget Share</FundDescription>
    <CostCentre>710</CostCentre>
    <CostCentreDescription>School Meals Income</CostCentreDescription>
    <CFR_Code>I09</CFR_Code>
    <CFRDescription>Income from catering</CFRDescription>
    <Commitments>0</Commitments>
    <CentrallyInvoiced>0</CentrallyInvoiced>
    <Actuals>-11546.57</Actuals>
    <CurrentBudget>-21600</CurrentBudget>
    <OriginalBudget>0</OriginalBudget>
    <TotalSpend>-11546.57</TotalSpend>
    <BudgetLeft>-10053.43</BudgetLeft>
  </Budget>
  <Budget> ... </Budget>
</Root>

The Root node must be called <Root>

For each Fund | Cost Centre | Ledger Code there must be a   <Budget> record which must contain:

Attribute Exampke Notes
<DateofData> 12/02/2020 10:57:21 The date time that the data was exported.
<FinancialYear>  2019 The string name for the financial year
<Start_Date> 2019-04-01 Start date for the financial year
<End_Date> 2020-03-31 End date for the financial year
<LedgerGroup> Income | Expenditure Ledger Grouping
<Ledger_Code> 0100 Ledger Code
<LedgerCodeDescription>

School Meals Income

 Ledger Code Desription
<RevenueLedgerType> IN | EX Revenue Ledger Type
<Fund> 01 Pot of money within the school
<FundDescription> School Budget Share Description of the fund
<CostCentre> 710 Cost Centre
<CostCentreDescription> School Meals Income Cost Centre Description
<CFR_Code> I09 CFR Code
<CFRDescription> Income from catering CFR Description for the Code
<Commitments> 0 Commited spend awaiting invoicefor the funancial year
<CentrallyInvoiced> 0 Central invoices pending for the financial year.
<Actuals> -11546 Acutal spend for the financial year
<CurrentBudget> -21600.57 Current budget for the financial year
<OriginalBudget> 0 Original Budget for the financial year
<TotalSpend> -11546.57 Total spend for the financial year
<BudgetLeft> -10053.43 Remaining budget for the financial year