Solved

Bank Import File Types


Badge

Acumatica help lists 3 files types for uploading. 

  • OFX (Open Financial Exchange)
  • QBO (QuickBooks Online)
  • QFX (Quicken File eXchange)

When choosing a “Statement Import Service”, I only see an OFX option.  Maybe it handles all 3 file types above, but I’m getting errors with QBO and QFX files so I doubt it.

How do I get or add the other Statement Import Services / PX.Objects?

 

 

icon

Best answer by Russ 17 November 2022, 19:19

View original

3 replies

Userlevel 2
Badge

Did you get this figured out?

Badge

Did you get this figured out?

I did, in a way.  Our bank has a normal platform and a “Treasury” platform (which we are on).  The treasury platform is run by a 3rd party.  They have spaces in the header of the QBO file that Acumatica doesn’t like.  Had to write a script to remove the spaces and it uploads fine.  No idea if the bank or Acumatica is wrong about the format.

 

TL;DR  Yes, OFX will open a properly formatted QBO or QFX file.

 

Wish we could import BAI2 files on this page.  That’s what the treasury platform prefers to export.

Userlevel 2
Badge

Thanks for the reply.  

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved