Good Housekeeping in Sage Accounts
Do you practise good housekeeping with your Sage 50 Accounts Data, or your Sage Instant Accounts? We have had two cases in the last week of clients with errors in their Sage data which had to be sent away to be fixed, but with good housekeeping this cost could have been avoided.
So – what is ‘good housekeeping’ in Sage? What should you be doing on a day-to-day basis to help prevent errors, or give you the ability to return to ‘clean data’?
Sage recommend that you check your data regularly, always before taking a backup, and after restoring your data too. I would also add that data should be checked when data has been imported also. You check your data by going to File -> Maintenance then clicking the Check Data button.
Sage then runs through your data, checking for input errors, internal inconsistencies, missing data and invalid nominal account types, and presents you with the File Maintenance Problem Report. The report contains 3 pages – Errors, Warnings and Comments.
- Errors show data problems.
- Warnings indicate serious problems which should be attended to but are not as serious as errors.
- Comments are the least serious, and often refer to inconsistencies which probably exist just because of a perfectly valid way that you are using the data – e.g. negative budgets or negative balances on the sales or purchase ledger.
The File Maintenance Problem Report will look different in Sage 50 2012 compared to older versions. In 2012 you have Recovery Tools and in earlier versions there is a Fix button. I will go into more detail on what you should do if you have Errors in a later post.
So 3 simple rules for Good Housekeeping in Sage Accounts:
- Check your data
- Back up your data
- Stop for Errors
If you follow these rules you should find you never need to send your data away to be fixed. And sod’s law states that if you do practise good housekeeping then your data will never corrupt!