Uploading bulk transactions from a 3rd party provider into Accounts Hosted from any format (.CSV, .Q

IanIan Member Posts: 3
edited August 2019 in Accounts Hosted

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.






Comments

  • InigoInigo Member Posts: 332
    edited April 2015
    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
  • gazza73gazza73 Accredited Partner Posts: 1,438 ✭✭
    edited February 2017
    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:   [email protected]
  • IanIan Member Posts: 3
    edited August 2019

    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.






  • InigoInigo Member Posts: 332
    edited April 2015
    Hi Ian,

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

    -IM
  • IanIan Member Posts: 3
    edited January 2015

    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.


  • ZappyZappy Accredited Partner Posts: 4,659 ✭✭✭
    edited June 2016
    Plenty of third party developers will do this for a fee. Try Siva at smart reports or Chandra at Cosmic Accounting Group.
Sign In or Register to comment.