Is there away to import data into Accounts Hosted

nicole77777744
nicole77777744 Member Posts: 4 ✭
edited September 4 in Reckon Accounts (Desktop)

Hello, we are using Reckon Accounts Hosted and are looking for away to import credit card information straight into the system from a report - CSV or QIF or any other way to import data!

We are using a credit card app that allows our clients to put their expenses to a report that assigns an account code and classification, along with a memo/description. We are wanting to import this data into Accounts Hosted as a credit card transaction - currently we are having to enter these all manually and it is taking hours of staff time.

We are aware that Xero has this option but are loathed to move all 30 company files - but we may have to to save on data entry time.

Is there anyway it is possible to import this straight into Accounts Hosted? I have tried the bankdata/fastcoding method but it doesn't import the data correctly. (Leaves out the description, meaning the admin staff have to manually enter the data anyway).

Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 2,952 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 4

    @nicole77777744

    @PhuongDo or @cosmic are you able to assist with a solution for this ? 🤔😬☺️

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner(AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,060 ✭✭✭

    Hi

    I am not very clear in regards to you using credit card app for your customers ?

    Credit card info is subject to strict compliance , so i need more info ?

    Who is your "client" and what sort of expenses they enter?

    Cosmic already has a mobile app that connects to stripe and does customer invoicing .

    Also we have we base application www.cosmicbills.com that does bill and tax invoice automation

    You can call me on 0407068942 to discuss further , this way we know what you requiring .

    Chandra

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • nicole77777744
    nicole77777744 Member Posts: 4 ✭

    I just need to get data from a CSV file into Reckon Accounts hosted under the credit card account.

    Is there a way to import data into Accounts Hosted?

    The app our clients use for this creates a CSV file with all the expenses reported - hence needing to get it to import into Accounts Hosted without having to manually enter it.

  • cosmic
    cosmic Reckon Developer Partner Posts: 1,060 ✭✭✭

    Yes , this can be done , have you tried iif utility tool .

    Or call me we can build a hard coded Csv Import tool for you for RAH.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Datarec_ReckonLtd
    Datarec_ReckonLtd Reckon Staff Posts: 963 Reckon Staff

    Hi @nicole77777744

    You can manually transform your CSV format into the "IIF" format recognized by the Reckon Accounts desktop or Hosted software.

    You can have Cosmic Accounting Group develop a utility for you, as they have experience with development and integration with the Reckon Accounts products.

    You can try some 3rd party tools. https://www.propersoft.net/howto/csv2iif/

    image.png
    image.png
    image.png
    Example Credit Card Transaction - tab delimited text.iif.txt


    Regards,

    Reckon Data Recovery Team

    Data Services Tip - Try this first before requesting a data service

Categories