Top 5 reasons to consider data repair – QuickBooks, Sage 50 or Sage 100

Errors:

Database errors are displayed about a list item, transaction or list item balance that you will need to accept. From time to time you have data corruption error messages that are displayed. It is recommended that you keep a log of dates and screen prints of these error messages the information they provide may be helpful in troubleshooting the root cause of the error.

Responsiveness:

Your system is slow and takes time to respond. That could mean your company data files are very large and exceeds the limit of the accounting program. First check with a consultant to determine that your software and installation environment are properly configured. Often purge routines will allow you to make the size of the data files smaller and faster.

Buyout:

You need to split off information because a part or division of a company will be purchased by another buyer or company.

Audit:

You need to split off information because of audit that requires only a single or multiple years of transactions.

Change in fiscal year:

The business has a need to change the fiscal year reported on the company tax return.

How do I prepare for a data repair on QuickBooks, Sage 50 or Sage 100?

Step 1 – Backups:

Backup first – Multiple backups are recommended the first should be for your company files and a second a complete system installation backup which includes the software, and the company data files.

Step 2 – Reports:

Reports – Print to PDF or hard copies the following reports as of the same period end date.

• General Ledger Trail Balance
• Income Statement
• Balance Sheet
• Department level financial statements
• Bank reconciliation open items
• Accounts receivable aging detail
• Sales Tax Liability report.
• Accounts payable aging detail
• Inventory valuation detail
• Open Purchase order detail
• Open Sales order detail
• Payroll Year to date earnings report
• Open Jobs Reports

Step 3 – Reconciliation:

Reconciliation – It is also recommended that you reconcile subsidiarity reports to the general ledger balances. During the repair process it will help determine that the repair was successful. Confirm the subsidiary grand total agrees with the stated general ledger balance as of the same period end.

Step 4 – Data Repair:

Data Repair means to determine the correct processes that will successfully fix any data issues that exist for Sage 50, QuickBooks or Sage 100. When you have errors, corruption messages or inconsistent information then data Repair may be necessary to resolve the issue.

Step 5 – Reports:

Reports are printed a second time in either PDF or hard copy to confirm the data repair process was successful. Compare the first set to the second set to determine the actual items the repair process effected. During this step if there are any additional issues discovered it may mean you will need to repair additional data or restore from a backup. Additional data repair may be necessary to get your system back on track and resolve the issue.

Step 6 – Backup:

Backup – After Step 1 – 5 are completed it is recommended that a backup is made once the project is finished, and the balances are confirmed to be correct.

Where Can I Find the Key Options for Data Repair for Sage 100, Sage 50 and QuickBooks?

QuickBooks Data Repair

How Do I Find QuickBooks Data Repair Options?

Rebuild Tool:

QuickBooks Rebuild Tool – QuickBooks rebuild tool is for minor issues the QuickBooks Rebuild Data tool is built-in and can automatically correct minor company file data issues. The QuickBooks Rebuild tool is found under utilities.

File Doctor:

QuickBooks File Doctor – QuickBooks file doctor is used when you can’t open your company file, QuickBooks File Doctor can help. Use it when you see: Error -6150, -6000 -82, -6000 -305, -6000 -301, -6147, or -6130 and Error H101. H202, H303, or H505 or when you have Missing or blank customer, vendor, or employee.

Condense Company Data Files:

QuickBooks Condensing Company Files – QuickBooks Condensing company data files may make the data files smaller by summarizing old closed, detailed transactions that use large journal entries. The most recent versions of QuickBooks work better at running the QuickBooks condense process than legacy versions. This process should be used carefully once it is completed it cannot be undone.

Sage 50 Data Repair

What Is the Best Sage 50 Data Repair Option?

Integrity Check:

Sage 50 Integrity Check – Sage 50 Integrity check is a tool that helps you verify if any of your Sage 50 company data files have been corrupted. This tool repairs some of the known data integrity issues.

Database repair utility:

Sage 50 database repair utility – Sage 50 database repair utility corrects a Pervasive database engine, fixes the data path or reconnects the data path across the network.

Data Verification:

Sage 50 data verification – Sage 50 Data verification allows you to confirm if any of your data files are missing or possibly damaged. During this data verification process this Sage 50 data repair utility may make necessary changes to your data records to correct their data file format.

Purge:

Sage 50 purge – Sage 50 Purge removes closed transactions for list items that are dated in periods prior to the current open 24 periods. Mark customer, vendor, inventory and job items inactive first. Then confirm their current balances are 0.00 and then all transactions must be dated in periods prior to the current open 24 periods. The most recent versions of Sage 50 work better at running the Sage purge process than legacy versions. This process should be used carefully once it is completed it cannot be undone.

Sage 100 Data Repair

What Are the Top Options for Sage 100 data repair?

This tool is the most powerful of them all. There are ways using the data editor to actually edit and repair a single record and synchronization tools that work when journals or transaction files need to be recalculated to reconcile to the module balances.

Purge:

Sage 100 purge – The Sage 100 purge process can be performed by module and is not a companywide purge utility. Establish the setup parameter for each module defining how many years of history transaction information to maintain. During the period end close any transaction that is older than the defiled years to maintain will be purged.  This process should be used carefully once it is completed it cannot be undone.

Reinitialize Files:

Sage 100 re-initialization – Sage 100 reinitialize files is typically used when creating new company data files and you wish to remove all recorded transactions. This process should be used carefully once it is completed it cannot be undone.

File Rebuild:

Sage 100 file rebuild – Sage 100 file rebuild – Sage 100 file rebuild allow the user to rebuild Sage 100 data key files. This utility can help repair system files including user names, company master file, etc.

Data File Editor:

Sage 100 data file editor – Sage 100 data file editor the data file display and maintenance utility provide the ability to edit, create or delete individual data records in a table. This process should be used carefully once it is completed it can be undone if you reverse the exact same record without impacting any other records and should be performed by an experienced consultant.

Can I Manually Repair Data Files For Sage 100, Sage 50 and QuickBooks?

While there are tools to repair company data files there are times when manually rebuilding a company data file may be necessary. Often the manual rebuild process may require tools that are not included with your accounting software.

Data Repair Option:

Contacting the manufacturer who produces the accounting software is an option. They can schedule your data repair and may require you not to use your system once you provide a backup of the company data files to them until they return your repaired data file. This can range from 5 – 10 business days to complete.

Services to choose from. Sage 50 Accounting  Sage 50 Pro  Sage 50 Premium  Sage 50 Quantum  Sage 50 Enhancements  Sage 50 consultant

Sage 50 support  Sage 50 training Sage Peachtree support  Sage 50 year-end

 Reach out today 800-475-1047