QuickBooks QBi Program performance is slow in multiple areas.
Legacy KB ID: 294
QuestionHow can I improve my QuickBooks QBi response speed?
The speed and efficiency of your company file will depend on several issues relating to:
· The condition of your company file
· The condition of your PC
· The condition of your network (for multi-user mode)
Condition of your company file
1. Check the size of the yourcompanyfile.qbw.tlg file
This file logs the changes to your company file since the last full QuickBooks backup was carried out. If you have not used the QuickBooks backup function for a long time (for instance because your computer is independently backup up by a 3rd party programme) then this file may be too large. A size greater than 25% of your yourcompanyfile.qbw is too large. To reduce the size yourcompanyfile.qbw.tlg:
i. Make a backup of your company file using the QuickBooks backup function with the option of a full verification; or
ii. It is safe to delete the yourcompanyfile.qbw.tlg
2. Too many File Fragments
The QuickBooks database (yourcompanyfile.qbw) is sensitive to the number of fragments it is stored as on your PC. If there are more that 50 fragments then you will experience a reduction in performance. To check and reduce file fragements:
i. Open your company file and Press Cntrl 1 to open the Product Information Screen
ii. Half-way down the screen on the left file DB File Fragments. If it is greater than 50 then continue.....
iii. Create a Portable Company File and then restore it (see Additional Note below). Check the number of file fragments; if still greater than 50 then continue.....
iv. Ask your IT professional to defrag your Hard Disk.
3. Too many sub-accounts or sub-items
a. The account list may have too many sub-accounts and levels of sub-accounts
b. The Item List may have too many sub-items and levels of sub-items
c. The Customer List may have too many Jobs
Where possible, reduce the levels of, and the total number of, sub-accounts and sub-items.
4. Centres (Customers, Suppliers, Employees) have custom sorted lists
Return these lists to their default order. To resort the lists:
Set View box to All Customers/Suppliers/Employees
Click on View and select Re-sort List
5. Print Forms have long queues of unprinted transactions that are never to be printed.
Clear the queues – print to a PDF printer until all queues eliminated
6. Eliminate file corruption
a. Create a Portable Company File and restore it
b. Resort all Lists, Rebuild the file and Verify
c. Follow-up on any errors and repeat Rebuild and Verify until the Verify returns the message ‘No Errors Found’ and the qbwin.log file contains no irregularities.
- Ensure that multi-user hosting is setup correctly
Only the Server or Host PC is hosting multi-user access
Workstations to show the option ‘Host Multi-User Access...’ in
File > Utilities
2. Your network is not overloaded
Check with your Network Administrator that there is plenty of capacity on your network.
3. Check that there is no malfunctioning physical items on your Network
Network Interface Cards (NIC) on individual PCs will slow the operation of QuickBooks if they are not performing at 100%
4. Users have correct permissions to the folders they need to access:
a. Users have at least Power User privileges to the QuickBooks application folders and to the data folders.
- QBDataServiceUser18 has full control to data folders
1. Your PC has sufficient RAM:
a. Windows XP – 1GB
b. Windows 7 & Vista – 2GB
- Hard Disk is not highly fragmented
- Your computer and network does not have any malfunctioning components or processes
- Users have Full Control permissions to the Intuit Registry Keys
- Internet Explorer security levels are not high
- QuickBooks processes are exceptions to firewall and anti-virus rules. See kb220 for full set of QB processors.
- Turn off any IP or Port Scanners (eg Malware Bytes Pro version) as they can interfere with the speed of QuickBooks, and in some cases prevent operation of QuickBooks.
If after all these steps the company file is still operating too slowly, then you may need to start a new company file. Some issues that may force you to create a new company file earlier than you would normally want to are:
- A large number of daily transactions.
- Complex invoices, bills, sales orders and purchase orders; that is, many line items to each form.
- Large lists of inactive items
- Inability to repair corruption
Creating and restoring a Portable Company File
Important: It is a requirement to process all of your online banking outstanding transactions and have no ABA files to be created before following the procedure.
1. With the file open, press the F2 button. Locate the File Size and make note of the size.
2. Click File > Save Copy or Backup.
3. Click the Portable company file radio button > click Next.
4. Select the save location. Saving to the Desktop is convenient for this procedure.
5. Click Save and/or OK.
6. When completed, restore the portable company file (PCF):
Click File > Open or Restore Company > click Restore a portable file radio button > Next.
7. Select the file previously saved to the Desktop, click Open. Note: The file will have a .QBM file extension.
8. The window "Where do you want to restore the file?" will open, Click Next.
a. If you are saving the file to the same location where the source file is then you will be presented with Confirm Save As message asking if you are willing to replace the current file with the file you are trying to restore.
b. It is recommended to save it with a different name, i.e "file name PCF.qbw " otherwise click Yes to confirm the replacement of your current data file.
c. Click Save.
9. After the file opens click OK.
10. Open the file, and log in. Press the F2 button. Locate the File Size. Has the file size decreased?
11. Check the performance of the newly restored portable QuickBooks file.