Ignore Rows

You may also need to have rows in your spreadsheet which do not post line items in your document.

These rows could be sub-totals or other items which are used for integrity checks of the document before posting.

1. In the first column of the spreadsheet, type the words IGNORE, COMMENT, or SKIP.

   Note: For the customers using a default language other than English, these values will be in the native language you have installed and translated.

2. GLSU will then ignore these rows when creating the .ZGL file.
3. All other rows with data are posted normally.

You can often use native Excel functionality to calculate when a row should be skipped. For example, if the dollar/monetary value of a calculated amount is 0 in column A of your spreadsheet, you could use the formula: =IF(D8=0, "Skip", " "). This could then be copied to all subsequent rows to avoid 0 currency warnings at the time of posting.

Note: Use blank rows to hold subtotals. This is especially useful for custom form development.