Uploading bulk transactions from a 3rd party provider into Accounts Hosted from any format (.CSV, .QBO, IIF, .TXT)

  • 2
  • Question
  • Updated 5 years ago
  • Answered
  • (Edited)

We use NAB corporate cards so our staff can purchase what they need in the course of business without having to ask for approval. At the end of each month they use an online system to code their transactions, add descriptions, set the GST paid amount and advice the office of the cost center they are charging to.  At month end we can download a .CSV file (of about 900 lines of transactions). Our current process is to 'enter bills' in RAH for each corporate card and each expense line.  This takes 4 full volunteer days and has some fairly obvious issues I don't need to go into.   

How can we import the transactions, while maintaining Classes, descriptions, payee, GST etc?

I have looked at the online banking functionality, but the subscriptions for the number of cards / transaction volume is prohibitive as well as the hurdle of the card provider not being part of NAB.  Getting the data out and formatted is fine, getting it mapped and back in is the hard part. 

Thanks for any help / advice / comments, happy to provide more details if I have missed anything.


Ian.






Photo of Ian

Ian

  • 104 Points 100 badge 2x thumb

Posted 5 years ago

  • 2
Photo of Inigo

Inigo

  • 6,320 Points 5k badge 2x thumb
Hi Ian,

You can most likely be able to do what you are after by using a GENERAL JOURNAL transaction import.

Basically your CSV file would need to be transformed into an equivalent IIF file.

Read the following post which may help you.

https://community.reckon.com/reckon/topics/creating_iif_files_to_talk_with_reckon_accounts

Or you can use a 3rd party software integration middleware like Zed Axis
http://zed-systems.com/products/axis.aspx


-IM
Ian

As a Reckon Partner in Melbourne,  I'm aware of a top partner in WA: that might be able to assist you on all this, and I've copied your info to him just now.   Contact me to explain if you're interested.  Gary:   gaz@alchester.com.au
Photo of Ian

Ian

  • 104 Points 100 badge 2x thumb

Thanks - trying to upload the file through the menu FILE > UTILITIES > IMPORT > IIF FILES...

and get this message:


Problem signature:
  Problem Event Name: APPCRASH
  Application Name: qbw32.exe
  Application Version: 23.0.4004.1240
  Application Timestamp: 54374f67
  Fault Module Name: QBCONV32.dll
  Fault Module Version: 23.0.4004.1240
  Fault Module Timestamp: 54374fc7
  Exception Code: c0000005
  Exception Offset: 0001d195
  OS Version: 6.2.9200.2.0.0.16.7
  Locale ID: 3081
  Additional Information 1: 9ca4
  Additional Information 2: 9ca4339f1ab014b50e550d604f93c492
  Additional Information 3: 065a
  Additional Information 4: 065af4fdc2be4ceda964f2820ca5be82

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=190175

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

Any ideas?

Is there a previous thread outlining how to create IIF files (I want to know how long description fields can be) And how best to deal with sub-classes.


Thanks again, Ian.






Photo of Inigo

Inigo

  • 6,320 Points 5k badge 2x thumb
Hi Ian,

You can't just import a CSV file using the IIF import function.

-IM
Photo of Ian

Ian

  • 104 Points 100 badge 2x thumb

Thanks, but I have been trying with .iif files as per other posts on the forums and the one you linked for me.  Do I need to find proper conversion software rather than changing the file type using save as?

Thanks, Ian.


Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,130 Points 50k badge 2x thumb
Plenty of third party developers will do this for a fee. Try Siva at smart reports or Chandra at Cosmic Accounting Group.