Jack,
From what I understand the domestic customers are still paying VAT (as far as your books goes) but in reality you will be swallowing that and effectively paying it for them because you don't want to raise their prices. Is that right?
It sounds like you should just reduce the price of the domestic customers in George so that the total figure with VAT is the same as they are paying now.
However, the maths isn't that straightforward:
For ease of figures lets say you have a nice domestic job that is £100
and you want to reduce the figure in George so that when 10.5% VAT is added it is still £100....
You can't just minus 10.5% because the VAT will then be added to the £89.50 and 10.5 % of £89.50 isn't £10.5.
What you do is stick a 1 before the vat rate and move the decimal left a couple of places and then divide the customer price by that.
eg. Customer price is £20
divided by 1.105 = 18.0995475 (£18.10)
£18.0995475 * 10.5% = 1.90045244 (£1.90)
£18.10 + VAT of £1.90 = Original price of £20
Therefore the new customer price to enter is £18.10
You could go through this on all your customers and change the prices but it would take a while to do.
The good thing with Excel is that you can easily tweak the program to adapt it to what you want to do. - This is a service we offer. (Round Tracker v4 PRO uses Excel combined with VBA coding- so it is more than just a fancy spreadsheet. - Previous versions of Round Tracker did not use VBA coding)
In your case the tweak would likely involve setting it up so that you would enter the £20 price in an 'agreed price' column and the £18.10 would appear automatically in the Price column as used for your accounts etc.
The only tricky bit is the fact that you have two different VAT rates going on. You would therefore need another tweak whereby the job would be labelled Commercial or Domestic and the VAT rate would be applied accordingly.