Issue/Symptom/Question

 The month-to-date and year-to-date %'s do not show and we use the exact same format (Statement Format # 24) for the other companies and it works as expected.

Applies To

Finance & Accounting > Setup > Financial Statement Formats / Comparative Income Statement Formats

Resolution/Fix/Answer

Comparative Financial statements that indicate % of Sales column calculations require you to identify which accounts qualify to be included in the Sales total amount.  

The 'Normal Balance' column on the Detail tab of the statement setup screen has 3 possible entry values:  C, D, or S. 

• The entry of C or D indicates that the normal balance of the accounts selected is Credit or Debit. 
• The entry of S indicates the accounts included on this line are to be considered Sales accounts.
  • The “sales” balance code, has nothing to do with positive or negative account balances. 
  • You only use this code on Comparative Income Statements to tell PENTA that the associated balance is sales revenue. 
  • When producing the comparative statement, PENTA adds all the sales balances together to determine total sales, then calculates and prints your other account balances as a percentage of total sales.

In the example below, the accounts included in lines 20, 30, and 40 will all be factored into the Sales total to be used to calculate the remaining lines' '% of Sales' rates displayed in the