Quickbook dates importing US format

Bank import generates wrong dates

Didn't find your answer?

I have one client using Quickbooks and she hasn't linked the bank account.

She sends me an excel download of her bank transactions which I covert to csv to upload to QB.

Previous quarters have imported fine but this quarter the statement dates (which look fine in excel) are importing as a mixture of UK and US date formats (eg 3 Dec is importing as 12 March).

I have reformatted the excel dates and tried again but with no joy.

Any ideas how I get it to import all dates correctly please (other than manual entry of all transactions or manually amending about 120 dates)?

Thank you

Replies (1)

Please login or register to join the discussion.

avatar
By tltodman
22nd Feb 2024 11:48

Now sorted.
User error!!
Time for another cuppa methinks.

Thanks (1)