SAP Knowledge Base Article - Public

3236192 - Error : Currency of Plan Data differ from Local Currency, Set of Books and Company when Uploading Expenses and Income Statement from Excel


You are uploading an Excel file related to Expenses and Income Statement using Excel Add-In and the error message is shown as

"Currency of plan data differ from local currency,Set of Books and Company.

Local Currency of Plan data differs."

You are also entering the Currency in the Excel which is the Company Currency.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue Work center.
  2. Go to the Planning.
  3. Go to New and then to Plan Version for Microsoft Excel 
  4. Select the New Expense and Income Statement Plan and Download
  5. Enter the Data 
  6. Save the Data using the Excel Add-In


The Amount field in the Excel is blank. When the Amount field is blank, no currency code is fetched.The Overall currency code is the currency of plan data that is entered in the Excel.

When a comparison happens between the No Currency code and the Currency of Plan Data entered in the excel the error message is raised.

eg: XXX=/=null (XXX stands for the Currency entered in the Excel)


The Amount field in the Excel file must be populated with zero instead of leaving it empty/blank.Even if it is zero the Currency code will be fetched.


Local Currency of Plan data differs,Expenses and Income Statement Excel , KBA , local currency of plan data differs , expenses and income statement excel , SRD-FIN-COR , Cost & Revenue , Problem


SAP Business ByDesign 2205 ; SAP Business ByDesign 2208 ; SAP Business ByDesign 2211