Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 7, 2018
Question

Deleting transactions increases company file size?

  • November 7, 2018
  • 12 replies
  • 38 views

i am baffled... i just deleted 169 transactions, 1215 targets and 104 names in QB. rather then going down, my file size increased by 5.1mb... wth?

any ideas?

12 replies

Rustler
Level 15
November 7, 2018

when you delete that does not necessarily mean gone

 

make a current back and then from the file menu, create a portable file, save it

then open restore the portable file, sometimes that works for what you want

 

tilos1Author
November 8, 2018

thanks for the idea, it gave me hope which lasted until the portable restore was completed lol. the portable file size was about 15% of the original. but the restored company file is 500kb bigger then the original...

something is very wrong with this company file. we only have about 1300 names but the file size is 367mb. it doesnt make sense to me. 

i have to find a way to shrink it because i think its corrupt somehow. thus the deleting of stuff yesterday.

i will try today the condensing data option as a last resort to see if that helps. 

n.b.: after the deletions yesterday and file increase, i closed it. this morning i found the file size smaller then it was yesterday but exactly the same as it was before i started deleting. attached is a screenshot - top is before i started deleting yesterday, bottom is today.

AlcaeusF
Level 14
November 8, 2018

Hello there, @tilos1.

 

Thanks for reaching out to us here in the Community. Allow me to step in for a moment and share some information about deleting transactions in QuickBooks Desktop (QBDT).

 

Our Top Contributors @Rustler and @197905 are both correct. But if you want to reduce the size of your company file, you can condense your file using the Condense Data utility. Please note that this might be an option, but it is not recommended.

 

Before you start condensing the company file, you can run a report to see the logic of how and what the program uses to determine which transactions it will not condense.

 

To run the report:

 

1. Click the File menu at the top.
2. Select Utilities on the drop-down, then Condense Data.
3. In the first window of the wizard, select Transactions before a specific date then enter the appropriate date.
4. Put a checkmark in the checkbox labeled: Optional: Create a report showing which transactions cannot be removed.
5. Choose Next, then Summarize inventory transactions (recommended).
6. Select how your inventory will be Condensed, then select Next.
7. Then click the transaction groups you wish to be removed, then Next.
8. Choose Begin Condense. QuickBooks does not start Condensing but only runs the report.

 

Now, here's how to Condense your company file:

 

1. Go back to the first and second step that I've provided above.
2. Go through the wizard and select the options you need. Select Help if assistance is required.
3. Select Begin Condense. Before Condensing starts, QuickBooks will create a backup and an archive copy.

 

For your reference, you can check out this article for further guidance through the process: Use the Condense Data utility.

 

That's it! Please let me know how it goes after performing the Condense Utility. Don't hesitate to leave a comment if you have additional questions or I can be of further assistance. Wishing your organization and yourself continued success.

November 7, 2018

Deleting transactions marks them as deleted within the database, but the file does not get smaller (though that space within the file can be used again later for other data.)

 

It also adds the history to the audit trail, which can grow the file.