Hi Graeme.

Thanks for using Sage City.

What you will have to do is take a backup of the data. You will then need to post a journal reversal for the opening balance instead, using T0 again. 

If you then go to settings > company preferences > VAT tab > make sure non-vatable tax code is set to T9. 

Then post the opening balance journal again.

Regards.

Sean,
Sage UKI

Hi,

  Thanks for the response, sorry it has taken so long to respond but I have been out of the office at a conference.  Unfortunately I have tried what you have suggested and it has made absolutely no difference :(

I am not an accountant so am finding this software incredibly unintuitive and when setting up originally did put my starting balance in the wrong field (Payment rather than receipt) and then re-entered that twice to correct after following advice to do this on a Sage post somewhere.  I have as you suggested reversed all of the transactions for Opening Balance, and if I generate a VAT return at that point I get the same sales value as before.

My none VAT tax code was set incorrectly (T0) and I then corrected this to T9 and tried re-setting my balance and generating the VAT return again, this made matters worse! I believe the value I am having trouble with is an opening balance in my control account(?) 1100.  I don't know how I am to set this or where this entry which has a reference of "O/Bal Reveral" has come from initially.

Have tried for a couple of hours now and got no where aside from a few crashes to desktop which really isn't reassuring me that Sage actually know what they are doing when it comes to developing software :/

Graeme

Hi Graeme.

The O/Bal Reversal is generated when using the opening balance wizard. 

What I recommend you do is give us a call on 0191 479 5955 so we can take a closer look in to this for you.

Regards.

Sean,

Sage UKI

Hi Sean, I ended up resolving the issue by dumping all transactions out into Excel, wiping out my company (which required hacking around as the actual Delete Company function doesn't work) and then manually re-entering all the transactions and building it up again from scratch.

No idea how it had done it, but it seems that the various reversals had managed to imbalance various different accounts, so reversing one account made the value increment on another with each reversal.

RE the delete company, I selected to delete company, but as soon as I restarted the program the company was back again.  If I immediately created a new company, my old company data was still there.

I am sure the way I deleted by manually removing data files has left various vestigial bits of the old data set behind as things like Bank Feeds no-longer work and give a completely useless error message.

For the price I am paying for the monthly subscription the quality of the software is SERIOUSLY lacking.

Hi Graeme. 

Thanks for providing feedback on this. 

I think we would need to take a closer look in to exactly what was happening regarding deleting an adding a new company, in order to provide further comment on that.

In regards to the bank feeds though, let us know exactly what is happening, along with any error messages you may be receiving and we'll look in to it for you.

Regards.

Sean,

Sage UKI