HOW TO MAKE FILE ALOT SMALLER

  • 2
  • Question
  • Updated 1 year ago
  • Answered
Hi we have been using this company file for over 10 years and it is very large. I want to get it smaller and keep it below 250mb how do i do this easily!
Photo of Hayley Hope-Hodgetts

Posted 1 year ago

  • 2
Photo of Rav

Rav, Community Manager

  • 64,790 Points 50k badge 2x thumb
Hi Hayley,

I'd suggest taking a look at creating a portable company file and then restoring it.
Check out this KB for instructions and other tips on getting the best performance from your file -
How to improve the performance of your QBI company file
Photo of John Peppas

John Peppas, Accredited Partner

  • 1,532 Points 1k badge 2x thumb
Hi Hayley

Give me a call on 0418 771 971 if further assistance is required.

John Peppas
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,880 Points 20k badge 2x thumb
Or give me a call in Geelong Im a accredited Partner

0407744914

Kevin V Russell BAS Agent 92779001
Photo of John Peppas

John Peppas, Accredited Partner

  • 170 Points 100 badge 2x thumb
All organised Kevin
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,880 Points 20k badge 2x thumb
Im ALWAYS organised John
Photo of Rachel

Rachel

  • 670 Points 500 badge 2x thumb
Anyone in New Zealand that I could please call?
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,880 Points 20k badge 2x thumb
Email me kevin@zappy.com.au I can call you
I use the Clean up Company Data regularly for many clients. Make sure you resort all list to their original order and verify your data file before commencing.  Do a screen dump of the product info (Click ctrl+1) and check usage information after the first cleanup and list information after the final "#".  Depending of the number of transactions I do it in increments of 6 or 12 months, it may take some time. I select all under "Additional Criteria for removing transactions" leave the unused list items to begin with.   NB you will end up with multiple archive files, I keep the first one, rename appropriately "ABC pre 30/6/2014, change the admin password and remove all other users.  Once I've completed say clean up to say 30/6/14. # Now run the clean up once more for the same date and select all under " unused list items" finally create a portable file and restore it.
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Jacqui,

Just to make this clear to other users who may read this, the clean-up data utility doesn't actually reduce the size of data files. This is clearly stated before you proceed to use the utility. See below:




The best way to reduce the size of a data file is to follow the KB article Rav posted at the start of this thread and to also create a portable file and restore it.

Luke.