Import additional report categories

Report categories are used to create your financial statements. They divide your nominal accounts into groups, which are then used to create the Balance Sheet and the Profit and Loss.

Each report category determines how the value from each nominal account is reported on your financial statements. To do this, each report category has a:

• Report Type: Determines whether the account balance is reported on the Profit and Loss or Balance Sheet.
• Category Type: Determines the section the balance is included in; Asset or Liability for the Balance Sheet; Income or Expense for the Profit and Loss.

We have provided a set of predefined standard report categories that reflect the broad groups of things required by most businesses. These are created when you first set up Sage 200.

If you also chose to use the set of nominal accounts provided by us, these will already be linked to the predefined report categories and no further set up is required.

Report categories are used to create your financial statements and group your account balances for reporting purposes.

Each report category determines how the value from each nominal account is reported on your financial statements. To do this, each report category has a:

• Report Type: Determines whether the account balance is reported on the Income and Expenditure reports (Profit and Loss) or Balance Sheet.
• Category Type: Determines the section the balance is included in; Asset or Liability for the Balance Sheet; Income or Expense for the Profit and Loss.

When you first set up Sage 200, a predefined set of report categories is provided for you. This includes:

• A report category for each CFR code based on current guidance from the Education Funding Agency and your LEA.

  See a list of the CFR code report categories

  CFR codes for Income and Expenditure

  Code	Name	Type	Category Type
  CE00	De minimis levels for capitalising expenditure	Profit and Loss	Expense
  CE01	Acquisition of land and existing buildings	Profit and Loss	Expense
  CE02	New construction, conversion and renovation	Profit and Loss	Expense
  CE03	Vehicles, plant, equipment and machinery	Profit and Loss	Expense
  CE04	Information and communication technology	Profit and Loss	Expense
  CI01	Capital income	Profit and Loss	Income
  CI03	Voluntary or private income	Profit and Loss	Income
  CI04	Direct revenue financing	Profit and Loss	Income
  E01	Teaching staff -	Profit and Loss	Expense
  E02	Supply teaching staff	Profit and Loss	Expense
  E03	Education support staff	Profit and Loss	Expense
  E04	Premises staff	Profit and Loss	Expense
  E05	Administrative and clerical staff	Profit and Loss	Expense
  E06	Catering staff	Profit and Loss	Expense
  E07	Cost of other staff	Profit and Loss	Expense
  E08	Indirect employee expenses	Profit and Loss	Expense
  E09	Staff development and training	Profit and Loss	Expense
  E10	Supply teacher insurance	Profit and Loss	Expense
  E11	Staff-related insurance	Profit and Loss	Expense
  E12	Building maintenance and improvement	Profit and Loss	Expense
  E13	Grounds maintenance and improvement	Profit and Loss	Expense
  E14	Cleaning and caretaking	Profit and Loss	Expense
  E15	Water and sewerage	Profit and Loss	Expense
  E16	Energy	Profit and Loss	Expense
  E17	Rates	Profit and Loss	Expense
  E18	Other occupation costs	Profit and Loss	Expense
  E19	Learning resources	Profit and Loss	Expense
  E20	ICT learning resources	Profit and Loss	Expense
  E21	Examination fees	Profit and Loss	Expense
  E22	Administrative supplies	Profit and Loss	Expense
  E23	Other insurance premiums	Profit and Loss	Expense
  E24	Special facilities	Profit and Loss	Expense
  E25	Catering supplies	Profit and Loss	Expense
  E26	Agency supply teaching staff	Profit and Loss	Expense
  E27	Bought-in professional services -curriculum	Profit and Loss	Expense
  E28	Bought-in professional services - other	Profit and Loss	Expense
  E29	Loan interest	Profit and Loss	Expense
  E30	Direct revenue financing (revenue contributions to capital)	Profit and Loss	Expense
  E31	Community-focused school staff	Profit and Loss	Expense
  E32	Community-focused school costs	Profit and Loss	Expense
  I01	Funds delegated by the local authority	Profit and Loss	Income
  I02	Funding for sixth form students	Profit and Loss	Income
  I03	High needs top-up funding	Profit and Loss	Income
  I04	Funding for minority ethnic pupils	Profit and Loss	Income
  I05	Pupil premium	Profit and Loss	Income
  I06	Other government grants	Profit and Loss	Income
  I07	Other grants and payments received	Profit and Loss	Income
  I08	Income from facilities and services	Profit and Loss	Income
  I09	Income from catering	Profit and Loss	Income
  I10	Receipts from supply teacher insurance claims	Profit and Loss	Income
  I11	Receipts from other insurance claims	Profit and Loss	Income
  I12	Income from contributions to visits	Profit and Loss	Income
  I13	Donations and/or voluntary funds	Profit and Loss	Income
  I15	Pupil-focused extended school funding and or grants	Profit and Loss	Income
  I16	Community focused school funding and or grants	Profit and Loss	Income
  I17	Community-focused school facilities income	Profit and Loss	Income
  I18	Additional grant for schools	Profit and Loss	Income

  Additional report categories for the Balance Sheet and control accounts

  Code	Name	Type	Category Type
  BS01	Property	Balance Sheet	Asset
  BS02	Office Equipment	Balance Sheet	Asset
  BS03	Furniture and Fixtures	Balance Sheet	Asset
  BS04	Motor Vehicles	Balance Sheet	Asset
  BS05	Stock	Balance Sheet	Asset
  BS06	Debtors	Balance Sheet	Asset
  BS07	Deposits and Cash	Balance Sheet	Asset
  BS08	Creditors (Short Term)	Balance Sheet	Liability
  BS09	VAT Liability	Balance Sheet	Liability
  BS10	Taxation	Balance Sheet	Liability
  BS11	Wages	Balance Sheet	Liability
  BS12	Creditors (Long term)	Balance Sheet	Liability
  BS13	P & L Account	Balance Sheet	Liability
  M01	Bad Debt	Profit and Loss	Expense
  M02	Suspense	Profit and Loss	Expense

Additional categories for your assets (Balance Sheet) and for the control accounts. The control accounts are those nominal accounts that Sage 200 automatically posts transactions to, such as the Debtors Control, VAT, Creditors Control, bank accounts and suspense.

1. Check the reason the import failed on the report and take the appropriate action:

   • If the record already exists: remove the record from your file.
   • If a mandatory field is missing: refer to the import file format (XLS file) and add the mandatory field to your record.
   • If a field is incorrectly formatted: refer to the import file format (XLS file) and amend the field so it adheres to the required format.
2. Remove those records that were successfully imported from your import file, so they aren't imported again.
3. After addressing all issues, import the file again.