Analyse Sales Report doesn't match the P&L. Freight not included.
My Analyse Sales report doesn't match the profit and loss report.
When I invoice freight to a customer, the freight amount is not included in Analyse Sales report, yet is is included in the sales total on the profit and loss.
I have been trying to find a multi-report sales report that either includes the freight or allows me to extract the freight on sales invoices. The sales reports just don't match the debtors ledger.
I am essentially trying to see what each debtor is being invoiced each month.
Any suggestions or solutions?
Hi Craig167
Apologies, I thought about this last night and there is actually a report you could look at using. Try the Sales [Customer Summary] report - Reports>>Sales>>Customer. By default, this report will show the Sales amount (less tax), the tax amount and the Current Balance. However, you can add in the Freight and Total amounts* to that report.
While this particular report doesn't provide as clean a list of the total sales per customer for a period as the Analyse Sales [Customer] report, it does have a total per customer and also a grand total of the Sales amount and Tax (or can be sent to Excel for totalling other values).
*Insert/Modify tab>>Report Columns>>Show Hide