OFX Transaction Matching 1

[ramam1]

Hiya,
Accpac 5.5a Update 1.

We get BAI files from our bank (Wachovia) and then use a custom tool to convert from BAI to OFX with the intent of importing and reconciling in Accpac.
Import OFX file works just fine and the transactions show up correctly however the transactions never match automatically. The issue seems to be the name (aka description) field. Is there a reasonable way for me to work around this without building an explicit mapping between what we call things and what the bank calls them? Perhaps I'm overlooking something?

thanks

 

[ettienne]

For starters install update 2, it is always best to keep up to date.
Perhaps you are overlooking something, maybe in the conversion to OFX. Try to get OFX files from the bank, they are also know as MS Money format.

 

[DjangMan]

I suspect it is the lack of information in the BAI file that is preventing the matching. That being said if the check numbers are available the conversion tool could look into Accpac's database and update the OFX file accordingly.

 

[ramam1]

Etienne,
The bank only supports BAI files... they plan on supporting BAI 2 in the not to distant future.

DjangMan,
I ran a quick test - by changing the transaction description in the BAI (or consequent OFX) files the automatic matching succeeds. I will have to build a dictionary to translate into Wachovia BAI speak.

thanks all
ram

 

[ramam1]

Our tool works well - we now map the descriptions and all is well on a bank account basis. We're now trying to build an OFX file to contain the converted BAI data for several accounts and can't quite seem to make Accpac happy. Has any succeeded in getting Accpac to import a single OFX file with data for multiple bank accounts? Should this work? The OFX format supports it fine.

 

[ettienne]

Yes it works, you have to enter the correct transit number and bank account number in Banks in Bank Services.

 

[ramam1]

We have dozens of bank accounts setup in Accpac - we get a BAI file for each of them then convert the BAI files to OFX files. The issue we're hitting is in trying to combine the OFX files for multiple bank accounts into one OFX files then feeding it into Accpac. The idea is to save the accountant some clicking around (so he can do one import daily rather than a dozen - one per bank account).
I'll play a bit more.

 

[ettienne]

The transit number and bank account are saved in the OFX file, that is how Accpac identifies the bank that the transactions are for.

 

[ramam1]

This worked. By repeating the <STMTTRNRS> node once per BAI file (ie bank account).
thanks!