Hi support, My client is looking for a program to convert bank statement to OFX format in order to be imported into the OFX statement reconciliation in Bank service. As his office is located in China and most of the China bank does not provided electronic bank statement in OFX format (only in excel or csv format). Does Sage can help to provide a conversion utility in case I could provide you the bank transaction data exported from the e banking? If not, is there any existing third party option could help do the same conversion ? As I know, even I could get a OFX file, it might not compatible with the one the Bank Services required, am I correct? Below are the banks that my client is using. Could you advise how my client request could be achieved? Bank of East Asia www.hkbea.com.cn Bank of China www.boc.cn ICBC: www.icbc.com.cn Many thanks, Cinny

Convert bank statement to OFX format

Posted By Cinny Wong over 7 years ago

Hi support,

My client is looking for a program to convert bank statement to OFX format in order to be imported into the OFX statement reconciliation in Bank service.

As his office is located in China and most of the China bank does not provided electronic bank statement in OFX format (only in excel or csv format).

Does Sage can help to provide a conversion utility in case I could provide you the bank transaction data exported from the e banking?
If not, is there any existing third party option could help do the same conversion ?
As I know, even I could get a OFX file, it might not compatible with the one the Bank Services required, am I correct?

Below are the banks that my client is using. Could you advise how my client request could be achieved?

Bank of East Asia www.hkbea.com.cn
Bank of China www.boc.cn
ICBC: www.icbc.com.cn

Many thanks,

Cinny

Parents

0 49153 over 7 years ago

OFX is just an XML file, you can view samples of OFX files in the DOCS folder, search for SAMINCOFX.ASO
I write macros for my customers to convert text or Excel files to OFX format, it is relatively simple. There are also utilities on the web that will do the same, but a custom macro is much simpler to use for the end users.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 49153 over 7 years ago

OFX is just an XML file, you can view samples of OFX files in the DOCS folder, search for SAMINCOFX.ASO
I write macros for my customers to convert text or Excel files to OFX format, it is relatively simple. There are also utilities on the web that will do the same, but a custom macro is much simpler to use for the end users.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Cinny Wong over 7 years ago in reply to 49153

Hi,
Thank you very much for your reply.
So does that mean as long as I could convert the file into the OFX format, the bank service import would work?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 7 years ago in reply to Cinny Wong

Yes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Convert bank statement to OFX format

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING