Hi

We collect a MGD tax from our sites on a regular basis. These get imported on to a single nominal code 2107. I then pay the goverment this tax on a quarterly basis per site. It all gets a little complicated as the sites have different quarter ends for payment.

I am wanting to reconcile the quarterly government payment to the relevant site collections to keep it balanced as I pay the due amount.

Ideally, the way a bank nominal reconciles would work however I cant use a bank nominal as the money is already held in the current account.

Having a seperate nominal code for the different sites is not an option as it would cause complications on how we import the figures from excel.

Is there another way I can do this please?

Thankyou