Skip to main content
N
northerngirl
June 21, 2023
Question

How to estimate future file size?

  • June 21, 2023
  • 1 reply
  • 0 views

Has anyone ever figured out a way to guess the growth of the QBW file?  I called Intuit and they were not helpful.  I was thinking that I could go by the number of transactions... so if they have 10,000 transactions in a month, that's 120,000 in a year, which would equate to "x" file size growth.  The other option, if other Enterprise users would post their File Size and Total Targets from [F2] in Enterprise, maybe I could make a table and guesstimate something for my client.  It seems that probably target value is the functioning measurement.

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
June 22, 2023

Audit logs are one of the main culprits for your file size. When you change only your data, the audit log will be registered. You can purchase a third-party condensing service to reduce the file size if needed.

 

If you regularly using Audit Trail Report, it also be a potential problem. Audit Trail Report provides the fingerprint of each and every transaction that you have recorded in QuickBooks Desktop. For example, by using Audit Trail Report you can easily check all the modified transactions, entries, deleted transactions and even voided transactions. As the number of transactions increase in a data file, the audit trail grows by a factor of 2, thereby increasing the size of a data file, and slowing QuickBooks down considerably.

 

Removing the audit trail brings down the file size of a data file and speeds up QuickBooks. You an purchase a 3rd party service to remove the audit trail from a data file. This will reduce the files size of the data file by as much as 30-50% and considerably speed up the data file. This service will also delete entries in the Voiced/Deleted Transactions Summary and Detail reports. It is also often required to remove the audit trail when handing over data files to government or other agencies such as the CRA and IRS in cases of data audits.

 

Terms & ConditionsAccessibility statement