The Customer Sales Analysis report, Date range (CUSTSA40) is often used to compare and balance to the Management Console and the Profit & Loss.
The total Sales on the Sales Report and the Management Console should always match. The total Sales on the Profit and Loss may differ, due to lines on the invoices being coded directly to General Ledger Accounts or to products that are not linked to General Ledger Income accounts.
1. Generating a Customer Invoice and using a General Ledger Code rather than a Product code, eg an invoice raised for a contribution to advertising by a Supplier. The Sales Analysis Report and the Management Console will include both transactions. However, the value will not show up in Profit and Loss sales accounts, as the value will have reduced the General Ledger Code used in the Profit and Loss.
To locate any sales coded directly to a General Ledger ID; run the Customer Sales Analysis report and select GL Account as Sort Order 1.
2. The Management Console and the Customer Sales Analysis both gain their data from the Invoices processed during a specific period. The analysis is based on the underlying data, not the printed data. As the underlying data is used to establish the General Ledger sales codes, to be used for the financial transaction.
3. The Customer Sales Analysis (CUSTSA40) accumulates and displays at the report bottom the freight and rounding values from the Invoice Header. CUSTSA40 can also report the data sorted by General Ledger account, this is the General Ledger account at the time the invoice was processed.
To reconcile the income or sales value.
Cost: In the Financials the cost for the period is calculated
Opening Stock + Purchases minus Closing Stock.
Sales: the cost is recorded at the time an invoice line is entered.
Where to check?
Run the Products / Valuations / Product Valuation Detail reports. Are there any codes with values that are wrong? Check the Product Code.
Sales and Costs coded directly to General Ledger codes rather having gone through an Invoice
Products that are not set up correctly, they are being posted to an incorrect General Ledger ID; Check Customer Sales Analysis by Date Range;
Sort 1 General Ledger Account
Sort 2 Product Code
Sort 3 Invoices
Check the Cost and Margin.
Products being received towards the end of the month and the Suppliers Invoice received at the start of the next month; Check Purchase Orders / Reports / Purchase Order/Receipt Invoice Date Check