Write, Bureaucrats, Administrators
1,171
edits
Difference between revisions of "How does ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales"
Jump to navigation
Jump to search
How does ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales (view source)
Revision as of 20:13, 15 April 2015
, 20:13, 15 April 2015no edit summary
(Created page with "== Overview == MYOB and ExcelReportLink Sales Pivot Solution assign values to Income and Cost of Sales columns on reports differently. This article details the differences....") |
|||
| Line 9: | Line 9: | ||
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. | 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. | 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 == | == 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 | 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 | 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. | 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. | ||