Exporting data from Reckon Accounts Hosted

CBASBookkeeping
CBASBookkeeping Member Posts: 5 Novice Member Novice Member
in Accounts Hosted

Hi,

I am a bookkeeper/ BAS Agent and I have a client who is converting from Reckon Accounts Hosted to Xero.

I need to export a file (CSV) containing all sales invoices for a 5 week period, between the conversion being done and the the roll out of Xero within the business. Xero provides great training and tutorials on how to import and apply this file, however no where can I find information on how to get the file exported from Reckon.

Thank you in advance :)

Cassie

Best Answers

Answers

  • CBASBookkeeping
    CBASBookkeeping Member Posts: 5 Novice Member Novice Member

    Hi Shaz,

    Thank you for your prompt reply. Can you please elaborate on how to export list info. Am I able to export a list of invoices for a period?

    Regards,

    Cassie

  • Zappy
    Zappy Accredited Partner Posts: 5,229 Accredited Partner Accredited Partner

    CBASB you CANNOT export transactions. This isnt QuickBooks or Zero or Myob. It isn't possible without a odbc connecter or access to the API.

    Trust me

    I do this stuff for a living

    Zappy

  • Zappy
    Zappy Accredited Partner Posts: 5,229 Accredited Partner Accredited Partner

    Phuong, such as?

    Easy to say not expensive like compared to what?

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 324 Reckon Hall of Famer Reckon Hall of Famer

    @Zappy, It should be less than the cost you spend/hire someone to "correctly" do it manually I would say.


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au

    https://free.beanwiz.com.au/
    https://www.youtube.com/watch?v=O61SfV2bte8


  • CBASBookkeeping
    CBASBookkeeping Member Posts: 5 Novice Member Novice Member

    Hi Zappy,

    Thank you for your input. Can I please ask your input on this situation;

    • Client file was converted by Jet Convert up until 22/05/2022 to include previous 2 years worth of all data, including invoices
    • Client intends to start using Xero as of the new financial year 01/07/2022. This allows time for staff to be trained properly.
    • The 'in between' period will be approx 5 weeks and 500 invoices. During this time all transactional data can be imported via a bank feed and allocated to correct accounts.

    The issue is, later on if the client wishes to view an invoice from the 'inbetween' period, he will have to open the reckon file OR I will have to spend hours manually recreating the invoices in Xero for this period so he will have all info in one software. Is this correct?

    Regards,

    Cassie

  • CBASBookkeeping
    CBASBookkeeping Member Posts: 5 Novice Member Novice Member

    Hi Zappy,

    I’m sure I just posted this comment, but now I can not see it in thread, so if this doubles up I apologise.

    Thank you for your input. Can you please offer some input on this situation.

    -         Client had reckon file converted to Xero up until 22/05/2022. This conversion included all invoices for the previous 2 years, so they can be referenced in the new software if needed. This was done by Jet Convert.

    -         Client intends to start using Xero in the business on 01/07/2022 – This allows time for employees to be thoroughly trained

    -         The ‘gap’ of data between conversion and roll out is about 5 weeks

    -         Transactional data can be easily imported via bank feeds and allocated to correct accounts for this ‘gap’ period

    -         However, if client wishes to view an invoice from this ‘gap’ period, after the 01/07/2022; are the only options…

    A)     Open the reckon file and view data there

    B)     For me to manually create invoices for the ‘gap’ period (500+) in Xero

    Thank you for your time.

    Regards,

    Cassie  

  • Zappy
    Zappy Accredited Partner Posts: 5,229 Accredited Partner Accredited Partner

    Well we really didn't plan that very well, did we? I don't think you have any alternative. You need to find a way to get the invoices from 05-23 to 06-30 into the new system. You ought to run the two systems in parallel for a period. Of course you could enter them all manually. Or you could pay someone like Phuong or Mr Cosmic to do it for you. Its probably a lesson to learn if you ever plan on switching ever again. If it were me, I would have stuck with Reckon. Zero doesn't justify the cost. The productivity improvements simply don't materialise. And the reporting is a lot worse.

    Call me if you wish to discuss 0407744914

    And thank you for your time.

    Zappy

  • CBASBookkeeping
    CBASBookkeeping Member Posts: 5 Novice Member Novice Member

    Thanks everyone for you input.

    Yes Zappy, hindsight 20/20. I will know better for next time :)

  • Zappy
    Zappy Accredited Partner Posts: 5,229 Accredited Partner Accredited Partner

    That's 6/6 in the new money (metres, not feet)

Categories