Adjustments to VAT Returns without posting


Hi, I'm pulling together the vat return for a sports club. The club has a bar which produces accounts (on Sage since July 23) and a squash section which currently produces accounts via Excel. The accounts aren't consolidated, but we submit one VAT return.

Is there a way to add output totals, inputs totals and the associated tax values from the squash accounts as memo adjustments to the VAT return generated for the bar, without actually posting the journals? We have the squash VAT workings which can be added as an attachment in support of the adjustments.

Any advice is much appreciated, thanks