Creating / Cloning / Templating Company File from existing file

Shane_9615721

Hi All,

We currently use Reckon Accounts 2021 R1 and are looking at upgrading to Reckon Accounts 2023.

The company file currently sits at nearly 3GB which is obviously far from ideal. I want to create a new company file using the existing company file as a template.

I am aware of the function to export customers / products etc. as lists and import them into a new file however I would like to hopefully create a company file using the same method (exporting company name, contact details, ABN etc.)

Any help would be greatly appreciated! Thank you!

Kris_Williams

No you can only export iif lists, only takes 5 minutes to create a new file and then import the iif files

Acctd4

Hi Shane

As per Kris's comment, RA doesn't have the ability to import actual transactions but @PhuongDo can probably assist with that.

Rav

My buddy @Datarec_ReckonLtd has created an article with some potential steps on reducing the size of a large company file which I'll link below, might be useful -

https://community.reckon.com/discussion/7945481/how-to-reduce-data-file-sizes-larger-than-500mb-for-reckon-accounts-business-desktop

Alex_10836088

Hi Shane - as someone with a file approaching 2GB, I've been worried about this becoming a hard limitation for us so happy to see someone with a 3GB file! (we backup daily for the inevitable crashes)

I'd worked through many of the options to resize including using the data recovery team but unfortunately we had too many variances in account balances after the reduction and had to keep using the large file. Most of our data relates to invoices and employee pays.

For us, starting a new file seemed to be our only option and at that point, it makes no sense to invest time into setting up the same system that imposes an all or nothing process to data file management. So we're stuck a little longer but good to see we can get to 3GB in meantime.

If you find a foolproof method to regain control over the filesize bloat, would love to hear about it

Rav

Hi @Alex

I imagine you've probably already been through a few of these steps but I'll also link a help guide below that contains a number of steps you could look at doing (regularly) that will help you get the best performance out of your file -

https://help.reckon.com/article/raxkcjai2w-kba-3793-how-to-improve-the-performance-of-your-qbi-company-file

Datarec

Hi @Shane,

Another way to create a 'new' file that retains all information EXCEPT for transactions (bills, checks, invoices, journals, paycheques, etc.) would be to use the built-in Clean Up Company Data function to 'remove all transactions'.

This would result in a smaller file since all historical transactions are removed, yet retain information such as Memorised Transactions, Memorised Reports and other elements such as Price Levels which would typically not be present if simply making use of the Export/Import of Lists functionality.