Charge card loaded up with columns wrong way round

[scapes]

I have been working on quickfile for over 40 hours just starting make some serious in roads with my accounts loaded up my charge card statement in qif as csv would not work as corrupted and the money in column and money out column are the wrong way round how can I resolve this please help my vat is a month late now and Hmrc are going to hang me

[ian_roberts]

The QIF format is basically plain text so you can make a number of fixes to it with find and replace in a text editor:

Barclaycard - commercial credit card credits/debits reversed

Both CSV and QIF are plain text file formats so if all else fails you can do a little bit of find-and-replace manipulation of the file before uploading to fix this. Here’s a post I made a while ago explaining what you would do with a QIF, a CSV would be slightly harder to identify exactly which bit needs replacing.

[scapes]

Thanks for your interest Ian but that was a bit beyond me so I deleted the QIF upload and tried again with the csv file and managed to edit the fields in excel basically making them wider so I didn’t get the error message and the upload worked ok, so I am a step closer to MTD and paying the VAT

[Lurch]

The main thing here was the fact you used CSV. Rows and columns and formatting are all stripped out when converted to/saved as a CSV file.