All GL systems I used have build-in report writer, which allows business users to define financial reports without writing any code. Try to find the report writer and figure out how reports are defined. Once you understand how reports are defined, it will be very easy to add new columns such as YTD and Variances.
In most report writers, reports are defined by row definitions and column definitions, and cell definitions are the product of intersecting row and columns based on their definitions. Normally row definition defines the report lines by accounts, and column definition defines the columns by amount type, e.g. MTD/YTD, Actual/Budget, Calculations of other columns (variance).
In most report writers, reports are defined by row definitions and column definitions, and cell definitions are the product of intersecting row and columns based on their definitions. Normally row definition defines the report lines by accounts, and column definition defines the columns by amount type, e.g. MTD/YTD, Actual/Budget, Calculations of other columns (variance).