nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Analyse Sales Report doesn't match the P&L. Freight not included.

Craig167

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?

Find more posts tagged with

Accepted answers

Steven_M

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

All comments

Craig167

Hi Steven,

I understand your point, however I would expect a customers sales report to show how much I have invoiced to them for the period. We do only use the sales module for sales and don't ever apply receive money to sales income, so our P&L should be a close check.

We apply a freight charge on most invoices now, so the amount is significant enough to be considered in our analysis. I do have a freight item-code, that we use sometimes, linked to the freight income account and those sales get added in but the freight doesn't. (therefor some freight is included and some not)

I am seeking a customer sales report that tells me how much my customers have purchased from me on a monthly basis. I would choose the Customer sales analysis report and expect it to show how much was charged. (plus/minus GST)

Is there any report that I can use?

Kind regards,

Craig

Steven_M

Hi @Craig167

The Analyse reports in AccountRight look at specific values that have gone against a record. For example, if you are running the Analyse Sales [Item] report, it will look at the items added to the transaction.

In relation to freight, if this is not added to the transaction as an item/activity it will not be included in the Analyse report for that type. The Analyse Sales [Customer] report will also not show that freight amounts as it's recorded outside of the customer's card history. So what you are describing with the freight not being included in those Analyse Sale reports is what I would expect to see from the program if you are using the freight field on the invoice. If you want to have those values included it would be a case of including those values as a freight item/activity (wouldn't be able to get it for the Analyse Sales[Customer] report.

Also, I don't think comparing the Analyse reports with the Profit and Loss reports will always balance. The Profit and Loss is reporting on values at an account balance (regardless of the type of transaction). Whereas those Analyse reports are doing it based on specific values (item or activities or customer) and would not include other values. For example, if you recorded a service layout invoice this would not impact the Analyse Sales [Item] or Analyse Sales [Activity] but would impact the Profit and Loss. Similar if you recorded a Receive Money or Journal entry involving an income account this would impact the Profit and loss but not those Analyse Sales reports.