Share this content
12

csv and numbers file on a mac

how to stop conversion of csv files

Didn't find your answer?

client has downloaded on a Mac HSBC bank statements as .csv files but when he emails them to me they change to having a .numbers attachment and excel cannot open. is there a soution?

Replies (12)

Please login or register to join the discussion.

avatar
By Southwestbeancounter
28th May 2020 15:11

I have that with a couple of clients - if it is a spreadsheet I get them to convert it from Numbers to Excel and then resend it which works.

With bank statements, however, I get really hacked off that clients are so lazy that they cannot send proper PDFs of bank statements (as they ARE available to download!) and just ping across the .csv files instead. I refuse to accept them and make them send 'proper' bank statements and I make the excuse (rightly or wrongly!) that HMRC won't accept them in that format. That usually does the trick!

Thanks (1)
Replying to Southwestbeancounter:
avatar
By Cloudcounter
28th May 2020 16:29

That's the exact reverse of our position. We actually want the statements in a numeric format. Admittedly csv is third choice behind .qif or .ofx but we can import any of them into our softwware. We actually don't want pdfs, apart from a copy of the year end one to prove the balance.

Each to his/her own! :-)

Thanks (3)
Replying to Cloudcounter:
avatar
By Southwestbeancounter
28th May 2020 17:49

Yeah I think I'm a bit long in the tooth sometimes and can't seem to shake off doing things the old-fashioned way!

Thanks (1)
By coops456
28th May 2020 16:08

If the client is unco-operative about conversion or just technically inept, you can convert it using Zamzar.com - very useful site.

Thanks (1)
Replying to coops456:
avatar
By carnmores
28th May 2020 19:58

This looks good thankd

Thanks (1)
avatar
By johnhemming
28th May 2020 16:48

There is a complexity with apple that often they end a line of a file (which applies particularly to CSV files) with a carriage return character (aka \r or 0xd) as opposed to line feed in unix/linux (aka \n or 0xa) or even carriage return then line feed as you get in windows. (\r\n).

This from time time causes serious conversion problems.

My view, however, is that the best solution to how to pass around bank statements is to use open banking interfaces which enables a list of transactions for a period to be sent regardless of when banks (or credit card companies) print their statements.

Thanks (1)
avatar
By paulwakefield1
28th May 2020 17:18

I am pretty sure that LibreOffice (which is free) can open Numbers files and then you could save it in a csv or Excel format.

Thanks (1)
By Duggimon
04th Jun 2020 10:06

If you typed your question in to google instead of in to accounting web, you would have been given about a dozen solutions immediately.

https://www.google.com/search?q=convert+.numbers+to+excel

Thanks (1)
Replying to Duggimon:
avatar
By carnmores
04th Jun 2020 10:22

I did and always search for an answer on google first. Perhaps I wasn't clear enough i wanted to know why Macs changed excel files to numbers files so that the client can send me the correct files rather than having to go thru the laborious process of converting 48 files myself

Thanks (0)
avatar
By TheOngars
04th Jun 2020 10:13

I have the same issue with some clients using macs, if you have an iphone/ipad you can convert them yourself using 'Numbers', sometimes easier than trying to get the client to do it!

Thanks (0)
avatar
By pauljohnston
04th Jun 2020 10:35

I think you can also also do this through an icloud account. I opened one for the business for this purpose alone

Thanks (0)
avatar
By johnhemming
04th Jun 2020 11:40

I am having an interesting discussion with the Open Banking Implementation Executive as to the circumstances in which an accountant's client can give authority to the accountant to download bank statements (for accounting purposes) so that the client only has to give authority every 90 days although the accountant can download the information more frequently (weekly or monthly). I think common law agency law enables the accountant to act in this capacity on behalf of the client (if the client appoints the accountant to do this).

Thanks (0)
Share this content

Related posts