Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Excel Reporting
Created by Gregor Imrie
Created on Jul 29, 2021

Excel Reporting - Revenue and Cost report: flip sign on budgets

A client is using the Excel Revenue and Cost report to extract budgets and actuals from Sage 200 for reporting. The actual values are signed flipped, so that the revenue credits are displayed as positives and the cost debits as negatives. Budgets, however, are not, these show as negatives for revenue and positive for cost. This then causes issues with formulas using these values, on this spreadsheet and when pulled into other spreadsheets. Can this be fixed so that when the spreadsheet is updated from the Excel reporting list the budgets use the same signage as the actuals? Keep them consistent with each other.