Exporting data from Reckon Accounts Hosted

CBASBookkeeping

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

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.

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

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  

CBASBookkeeping

Thanks everyone for you input.

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