Validate Sage Data

Validate is used to check that data on the spreadsheet is compatible with Sage accounting rules.

Validates lists any issues along with the error description and the line where the error ocurred.

By clicking next to the error, Excelerator takes you to the row in question.

Select Validate from the Ribbon for the relevant module. A box appears listing all rows where problems were encountered.

Validate quickly directs you to row where the issue was encountered by clicking next to the row in the validate box(see above).

When Validate encounters no errors, the following box appears and the information is ready to Save to Sage.

Any validation errors will be displayed in the Validation panel as shown below.

Note, ticking Fixed does not actually correct an error but acts as a reminder that the error has been corrected.

Once the data conforms to the Sage accounting rules, you can Save to Sage