VAT preparation support

General information for the business: Media / Technology Company
Kind of support: Tax
Accounting software: Excel
Description of support work: I need support in calculating my company's VAT.

I have a list of receivables/payables in excel for the period, there are around 50 items in total but some of these are not relevant (such as payments for wages etc.).

I would like someone to help by clearly showing the relevant recordings of VAT for each, within the excel sheet (for example, which amounts are used for the different VAT boxes in the VAT submission) so that I am able to do this myself in the future.

I have various invoices from within/outside the EU and I am very confused about how to go about the actual calculations.

I can provide the relevant invoices relating to each item.

I can make the actual submission online.
Extra notes: