Summary

Learn how to eliminate zero values from the Account Description that show up in reports. 

Root cause

The Account Description is populated based on the first uploaded file where the description is found. Loading additional General Ledger (GL) or Opening/Closing balance files will not update the Account Description. If an old GL file is replaced with a new GL file and the Account Description was initially blank in the old file, the data from the new file will update the blank fields. However, if the old file contains a zero value instead of a blank, it will not be replaced, and the zero value will be carried forward. 

Solution 

The way to override zero values is by uploading a Chart of Accounts (CoA) file. The CoA takes priority and updates the data. If a CoA file is not available, upload a Trial Balance file as a substitute CoA. This will override the data from the old file.