We have something similar here. You will need ms access (it can be done on ms excel, but it will be more complicate) to create a report like that
Here is the query: (For current year only, also our fiscal year start on August)
SELECT
CInt(Trim([BKGL_ACCT])) AS ACCN,
Trim([BKGL_TYPE]) AS ACCT,
Trim([BKGL_ACCTD]) AS ACCD,
Trim([BKGL_GLDPT]) AS DPT,
CCur([BKGL_CURRENT_2]) AS CY_AUG,
CCur([BKGL_CURRENT_3]) AS CY_SEP,
CCur([BKGL_CURRENT_4]) AS CY_OCT,
CCur([BKGL_CURRENT_5]) AS CY_NOV,
CCur([BKGL_CURRENT_6]) AS CY_DEC,
CCur([BKGL_CURRENT_7]) AS CY_JAN,
CCur([BKGL_CURRENT_8]) AS CY_FEB,
CCur([BKGL_CURRENT_9]) AS CY_MAR,
CCur([BKGL_CURRENT_10]) AS CY_APR,
CCur([BKGL_CURRENT_11]) AS CY_MAY,
CCur([BKGL_CURRENT_12]) AS CY_JUN,
CCur([BKGL_CURRENT_13]) AS CY_JUL
FROM BKGLCOA
WHERE (((CInt(Trim([BKGL_ACCT])))>3999));