How does ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales
Overview
MYOB and ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales columns on reports differently.
This article details the differences.
How does MYOB assign values to Income and Cost of Sales on Sales Reports
MYOB assigns the values on it's Sales Reports predominantly based on how the data is entered in the Sales Screen and does not use the Accounts or Accounts Classification used.
For example, if a sale is created against an expense account, the value will still show up in the Income column on reports but as a negative value.
How does ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales
ExcelReportLink Sales Pivot Solution uses the Account Classification of the accounts used to record the transaction to determine whether the value will show up as income, cost of sales, expense, etc.
For example, if a sale is created against an expense account, the value will show up in the Expense columns on reports.
This also apply to Cost of Sales. For instance, if an item sale uses an Income account as it's cost of sale account, the value will show up as a negative income value on reports.