銷貨利潤分析表
可分析銷貨單利潤情況,得知銷貨單的毛利及毛利率,查看報表建議需先執行完當月【成本計價】後查閱,才會比較準確喲!
銷貨單金額-銷貨成本=毛利
毛利率=(毛利/銷售金額)*100%
銷貨成本是月平均成本制計算而得,請參考成本計價章節說明
![](https://cloudworker2013.blob.core.windows.net/upload/20240318111150202403181112031871.png)
![](https://cloudworker2013.blob.core.windows.net/upload/20240318111150202403181112031871.png)
1、開啟進銷存模組【進銷存報表】
![](https://cloudworker2013.blob.core.windows.net/upload/20240318104629202403181047153298.png)
2.點選【銷貨利潤分析表】
![](https://cloudworker2013.blob.core.windows.net/upload/20240318104629202403181047153298.png)
2.點選【銷貨利潤分析表】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-Lv4ajV6q-3IBkTbaGrm%2F-Lv4d2gs35_AT13NDZ4K%2F2019-12-02_160456.jpg?alt=media&token=6190cc08-f273-4fe0-ab2c-53b2a5e56b20)
3、報表會預設當月,可選擇查看的月份
![](https://cloudworker2013.blob.core.windows.net/upload/20240318104910202403181049202757.png)
4.檢視每張銷貨單利潤狀況
![](https://cloudworker2013.blob.core.windows.net/upload/20240318105927202403181059379741.png)
5.點選【列印】會產生PDF報表檔
若【其他條件】有勾選"列印銷貨明細",則可看到商品的明細利潤分析
![](https://cloudworker2013.blob.core.windows.net/upload/20240318110122202403181101347124.png)
【其他條件】無勾選"列印銷貨明細",則是整張銷貨單的毛利分析
![](https://cloudworker2013.blob.core.windows.net/upload/20240318110403202403181104122918.png)
6.【轉出】-【查詢資料】:將預覽的資料轉出至Excel
![](https://cloudworker2013.blob.core.windows.net/upload/20240318110526202403181105371361.png)
7.【轉出】-【報表格式】:轉出報表格式內容
![](https://cloudworker2013.blob.core.windows.net/upload/20240318110701202403181107125614.png)
The End