Are journal adjustment values captured automatically in Tally.ERP 9?

No, journal adjustment details are not exported to the excel template. The return forms sheet is hidden in the template, which disallows data posting from external sources.