Help with calculating VAT in a separate field

I do not know how to do this:

Please see attached file.
I made so that every time I put in an amount, in any category, I see how much is left in that category and how much we have left in the total budget.

Now we realized that all these amounts include VAT, and the budget does not allow us to use this budget for VAT - we need to pay that from other funds.

I would like to somehow make it, so that I can input the full charged amount (including VAT), have a column without the VAT (this would be the number that would get tallied up into the total we have left) and a separate tally for the entire VAT owed (which we will need to pay from somewhere else). VAT is say 12%.

Note that there is NO VAT on salaries.

What I did here is about as advanced as I go in excel, this seems to be a bit over my head, any help is welcome.

Oh that was easy enough. So now I am simply adding some rows to each category, adding those equations and I am good to go.
Works like a charm.

Thanks!