weelittletimmy Posted June 9, 2023 Share Posted June 9, 2023 I opened a restaurant a few months back and need to create a company bank account. I'd like to be able to quickly analyze the transaction data, for example "show me all incoming Grab payments in the month of August 2023" or "show me all incoming Foodpanda payments". To do this, I need my account's transaction history to be viewable in Excel, where this query would be a simple date + account name filter. I spoke to the customer service people at Krungsri and Kasikorn, and they both said they only let you export transactions in PDF format, which cannot be used in Excel. My lawyer who owns two restaurants herself told me she opens a different bank account for every restaurant and every delivery service, so she can do the accounting more easily by seeing the bank account's totals. This seems much more busywork to me than having a single account and simply doing filters in Excel in 5 seconds. In case you're wondering why I don't copy-paste the PDF text, I got my hands on a friend's statements from Krungsri and Kasikorn. Kasikorn's PDFs paste into a single cell with the column and entries in the wrong order compared to the header columns. Krungsri has a column called "Withdraw/Deposit" where the values are actually written spaced over 2 columns as a positive number, so whether it's a withdrawal or a deposit the line is "previous-column 100", making it impossible to automate the import. If all the banks are like this then I'm thinking my only option here is to have a friend write a computer script to convert a Kasikorn PDF into CSV data, but I feel I'm getting ahead of myself here, it would be mind-boggling if there's really no CSV export for a company's transaction data in Thailand. My bank's website back home has had a CSV export option since I was a teen, even for personal accounts. Does everyone else have a data entry clerk doing things by hand or something? Link to comment Share on other sites More sharing options...
MJCM Posted June 9, 2023 Share Posted June 9, 2023 (edited) With Bangkok Bank it’s possible see screenshot Edit: maybe this helps https://www.howtogeek.com/770474/how-to-import-data-from-a-pdf-to-microsoft-excel/ Edited June 9, 2023 by MJCM 1 Link to comment Share on other sites More sharing options...
OneMoreFarang Posted June 9, 2023 Share Posted June 9, 2023 K-Bank Login and go to https://kbiz.kasikornbankgroup.com/menu/account/account/recent-transaction Select a date range, at the bottom right is a button download. If you press it, you will get a .csv file. 1 Link to comment Share on other sites More sharing options...
CartagenaWarlock Posted June 9, 2023 Share Posted June 9, 2023 May be you can convert a pdf to excel. If you look for a software, I bet it is there. 1 Link to comment Share on other sites More sharing options...
OneMoreFarang Posted June 9, 2023 Share Posted June 9, 2023 57 minutes ago, weelittletimmy said: have a friend write a computer script to convert a Kasikorn PDF into CSV data, but I feel I'm getting ahead of myself here Additionally to above: I get emails for all my K-Bank and SCB transaction. Often those emails include more information than is available in the Bank csv files (see last post). I wrote a small program in Outlook VBA to check for any bank entries in my mail, analyze the mail body, and export the details into my home made csv file. Link to comment Share on other sites More sharing options...
OneMoreFarang Posted June 9, 2023 Share Posted June 9, 2023 3 minutes ago, CartagenaWarlock said: May be you can convert a pdf to excel. If you look for a software, I bet it is there. There is - and most of the time it is far away from perfect. The structure of pdf files is made for printing, not data collection or export. Link to comment Share on other sites More sharing options...
weelittletimmy Posted June 9, 2023 Author Share Posted June 9, 2023 24 minutes ago, OneMoreFarang said: K-Bank Login and go to https://kbiz.kasikornbankgroup.com/menu/account/account/recent-transaction Select a date range, at the bottom right is a button download. If you press it, you will get a .csv file. Thanks! It blows my mind that Kasikorn's own employees at their branch didn't know this. The first one wasn't sure, called another employee, and that one said "no it's only PDF". 1 Link to comment Share on other sites More sharing options...
NanLaew Posted June 9, 2023 Share Posted June 9, 2023 6 hours ago, CartagenaWarlock said: May be you can convert a pdf to excel. If you look for a software, I bet it is there. At least half -a-dozen good and reliable (and free) pdf-to-excel services on the internet. I use a couple of them frequently. 6 hours ago, OneMoreFarang said: There is - and most of the time it is far away from perfect. The structure of pdf files is made for printing, not data collection or export. The pdf's I import are multi-page and/or multi-format and I haven't encountered unmanageable issues. Anyway, moot point as the banks the OP is talking about do provide .csv format statement downloads. 1 Link to comment Share on other sites More sharing options...
scubascuba3 Posted June 9, 2023 Share Posted June 9, 2023 8 hours ago, weelittletimmy said: Thanks! It blows my mind that Kasikorn's own employees at their branch didn't know this. The first one wasn't sure, called another employee, and that one said "no it's only PDF". If they don't know they will just guess, happens everywhere 1 Link to comment Share on other sites More sharing options...
quake Posted June 10, 2023 Share Posted June 10, 2023 9 hours ago, weelittletimmy said: Thanks! It blows my mind that Kasikorn's own employees at their branch didn't know this. The first one wasn't sure, called another employee, and that one said "no it's only PDF". That surprised you. Link to comment Share on other sites More sharing options...
KhunBENQ Posted June 10, 2023 Share Posted June 10, 2023 (edited) As described above. Edited June 10, 2023 by KhunBENQ 1 Link to comment Share on other sites More sharing options...
Digitalbanana Posted June 10, 2023 Share Posted June 10, 2023 14 hours ago, weelittletimmy said: In case you're wondering why I don't copy-paste the PDF text, I got my hands on a friend's statements from Krungsri and Kasikorn. Kasikorn's PDFs paste into a single cell with the column and entries in the wrong order compared to the header columns. I use Acrobat on KBanks password PDF statements, using copy with format option and it pastes into correct cells on my Excel sheet. Link to comment Share on other sites More sharing options...
billd766 Posted June 10, 2023 Share Posted June 10, 2023 18 hours ago, MJCM said: With Bangkok Bank it’s possible see screenshot Edit: maybe this helps https://www.howtogeek.com/770474/how-to-import-data-from-a-pdf-to-microsoft-excel/ I have an account at both Kasikorn and Bangkok Bank and download my statements every month. I get the option of Excel, CSV or PDF. Kasikorn statements are from the oldest date to the newest and BBK is from the newest to the oldest. For them I go to (I think data) on the ribbon, and change the direction. I then made up an Excel spreadsheet and copy/paste with the data I use regularly and sort it out from there. I have been doing it that way for years and I am comfortable with it. Link to comment Share on other sites More sharing options...
billd766 Posted June 10, 2023 Share Posted June 10, 2023 5 hours ago, KhunBENQ said: As described above. That works for me every time. Link to comment Share on other sites More sharing options...
CartagenaWarlock Posted June 10, 2023 Share Posted June 10, 2023 (edited) 18 hours ago, OneMoreFarang said: There is - and most of the time it is far away from perfect. Use this one,I bet it will be perfect. Both the software were as old as the MSDOS.If it is not perfect, I don't think the developers are just sitting idle instead of fixing the issues. I tried one and it came out perfect. https://www.adobe.com/acrobat/online/pdf-to-excel.html Edited June 10, 2023 by CartagenaWarlock Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now