Receivable Branch Reports for monthly analysis

Compare and check Branch monthly invoiced figures.

Introduction

Branch Performance Summary Report

Receivable Invoice Analysis Report

Compare Branch Performance Report and Receivable Invoice Analysis Report


Introduction

Let's take a look at some Receivable reports and the information they contain to help you track invoiced amounts, costs and margins for the month.

Two reports that are useful to keep an eye on are the Receivable Invoice Analysis Report and the Branch Performance Summary Report. To assist with analysing the figures for a Branch, you can compare the total figures from these two reports to help you check that everything is reporting correctly.

We'll take a look at these two reports and then look at reconciling some figures between these two reports.

Return to Top of Page


Branch Performance Summary Report

If there's only one report you want to review in order to keep an eye on your Branch's daily performance, this is the one. This key report shows you how the Branch is performing with a detailed analysis for the month. It helps you to track Actual Sales against Sales Budgets, and track Costs and Margin Percent against Sales during the month.

Selections

You can select a month and Branch to report or export. If you are part way through the month, you can track the figures to date for the month.

What you get

This report shows a summary for the selected Branch. The top segment gives summary figures while the lower segment summarises the daily activity. It shows various summaries in three top sections, and the daily totals on the lower section.

In the top left section:

  • Sales Budgets, Invoiced Sales, Costs to date, Percentage of Budget achieved, Margin Percent achieved.

  • Packing Slips not yet invoiced (this also includes Packing slips for all past months), Sales orders with some not supplied and value and count of Sales Orders entered.

The middle section:

  • Here you can see the number of trading days for the month and the number of elapsed trading days, so you then know how many trading days remain to achieve the sales budgets for the month.

  • You can see the Budget Daily Total required vs Average Daily Sales achieved and Average Required to Achieve Budget.

  • Below the budgets, you can see the Average cost of Stock on hand, and numbers, amount and margin of Sales Orders.

The right section:

  • This area shows value of Delivery Notes received (with and without Packing Slips).

  • Below that you can see Deliveries for Sales Orders, with the value received and sold, with margin achieved for those Sales Orders.

The lower section:

  • This section gives a break down by day for Packing Slip Count & Amount, Invoice Count & Amount, Credit Count & Amount, Nett Sales, Cost, Gross Profit, Margin, Received & Returned Amounts.

The report looks like this (minus the red borders, these have just been drawn below to show you each section):

Return to Top of Page


Receivable Invoice Analysis Report

This report allows you to analyse invoiced sales for a selected time period. There are many selection criteria that you can choose from, e.g. Top 20 products, Receivable account, Supplier, Stock by Group or Category, Region, Life cycle of stock, and many more. In the printed report, you can see invoices by Stock, and Brand & Description, with the Quantity and sale price of invoiced sales to help you determine what products are selling well. All these selections can be useful if you want to drill down to see detailed analyses of sales for Stock Groups, Invoicing Staff, Clients or Suppliers.

The summary option is very useful to give you an overall view of the Invoices for the Branch, and double check the figures against the Branch Performance Summary Report. In that case, select only the month, Invoice Branch and Summary option.

Other uses

You can select Cost Selection options for this report so you can export by Cost Price Margin, Replacement Cost or Branch Average.

Selections

To see an overall view of the Invoices for the Branch and be able to compare them against the Branch Performance Summary Report, enter selections for the month start and end dates, the Invoice Branch, and check the field for Summary Only.

If Summary is not selected, you will see a line for each invoice. While this might be helpful for viewing detailed analysis and the margin percentage per invoice, it also can potentially give you a very long report.

What you get

If you select the Summary option, you see these details for the invoices in your selection:

    • Quantity: This is the number of invoices for your date range.

    • Amount Excluding Tax: Total amount (excl) of invoices in your selection.

    • Cost amount: Cost for all items on these invoices.

    • Margin amount: Margin in dollars.

    • Margin Percent: Margin as a percentage of sales less costs.

Return to Top of Page


Compare Branch Performance Report & Receivable Invoice Analysis Report

Here, we've taken these two reports for one Branch for July.

 

Now we can check the totals from the Invoice Analysis Report against the Branch Performance Report.

For the Invoice Analysis report, we've selected only the month start and end dates, and the Invoice Branch. The Branch Performance Report prints the complete figures for the selected Branch and month. This allows you to compare the full Branch figures between the two reports. 

TIP: To get a true comparison between these two reports, it's important to include the complete figures for the Branch you are looking at, so in your selections for the Invoice Analysis report, don't add selections for any other fields, as this may filter out some data that should be included.

 

 

Figures we can compare between these two reports:

Branch Performance Report Invoice Analysis Report Represents:
Invoiced Sales to Date Total Amount Excluding Tax Total invoiced sales
Cost to Date Total Cost Amount Total cost of sales
Sales less Cost (calculate this yourself) Margin Amount Margin of sales less costs
Margin Margin % Margin as %


If there are discrepancies between the two reports, it's possible that something has been coded incorrectly. There may be sales that have been coded to a General Ledger code that is not included in the Sales range.

Return to Top of Page



Was this helpful? If you require further assistance, or would like to contact us about this article, please email us at support@lentune.com.

Thank you. We appreciate your feedback. It helps us to provide you with the best possible information.

Last updated: 22 November 2022