Exporting data from Reckon 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

Accepted answers

Acctd4

Users can easily export List info to a csv, but not actual transactions.

I believe it can be done but it may require utilising a (paid) option - either via Reckon Data Services or a separate 3rd party program 😬

PhuongDo

@Zappy , my solution is not stupidly expensive :)

CBASBookkeeping, I can help you with the export, please reach out if you are interested.

All comments

Acctd4

Users can easily export List info to a csv, but not actual transactions.

I believe it can be done but it may require utilising a (paid) option - either via Reckon Data Services or a separate 3rd party program 😬

CBASBookkeeping

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

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

PhuongDo

@Zappy , my solution is not stupidly expensive :)

CBASBookkeeping, I can help you with the export, please reach out if you are interested.

Zappy

Phuong, such as?

Easy to say not expensive like compared to what?

PhuongDo

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

CBASBookkeeping

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

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

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

Thanks everyone for you input.

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

Zappy

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

Find more posts tagged with

Reckon Accounts Hosted Announcements & Important Info

Don't miss announcements and important info for Reckon Accounts Hosted

Button

Reckon Accounts Hosted Ideas & Feature Requests 💡

Do you have an idea for a feature in Reckon Accounts Hosted? Let us know here!

Button