better way to create job cost reports

[t a]

I an trying to create job cost variance reports and looking for better
way to get it done.

I have one table (actuals) Jobs , Costcode , Amount, Acctdates
other table is (Budget) Jobs, costcode , Amount , month

trying to create report : with columns across
Actual month, Budget month, variance ,
actual year to date, budget year to date, varance,
actual project to date, Budget project to date , variance

current YTD PTD
Jobs costcode act bud var act bud var act bud var

I have done but only with many sql and its not easy to update or
change as you add new months of data.

Are there any suggestions,
Tom