Profit and Loss Statement Not Calculating Appropriately

1

Hi everyone,
I noticed ever since I have done periodic revaluation (Recalculate in Inventory Items) my profit margin is not calculating appropriately anymore. How could a profit of a location show 1,004,225.63 and second location profit 348,176.03 and manager is showing a total of 2,630,751.74 in profit and loss statement instead of 1,352401.66

image
image1821×447 57.6 KB

Please what could cause this and how can I fix it?

2

I assume you are using Divisions and you have created the report as follows:

  • Division A totals $1,004,225.63.
  • Division B totals $348,176.03.
  • The last column showing a total of $2,630,751.74 only includes Division A and Division B?
1 Like
3

The first thing to check would be your report definition.

  • Have you included columns for all Divisions?
  • Are the dates defined correctly? That is do the dates cover the same period for each Division and the Consolidated column?
1 Like
4

Yes division is being used, but the total of both divisions is incorrect, What could be the problem, please?

5

Have you checked the report definitions as recommended by @AJD ?

image
image823×560 16.7 KB

6
  1. Yes, all division is correct, as we only have two divisions
  2. The date is correct as it has been set to a single day (from 2-12-2024 to 2-12-2024)

I have even checked the Division Exception Report and everything is fine, nothing was their to fix

7

YES, THE DATE IS CORRECT… CHECK THE BELOW IMAGE

image
image901×478 16.8 KB

8

Is the total profit of $2.6M correct just in case some transactions do not have a division allocated to them and are included in the $2.6M but not the divisional figures?

2 Likes
9

Without showing the complete P&L, i.e. including Income it is impossible to assess your issue. Your last screenshot also shows a 3rd comparative column which is not reflected in the earlier screenshot as it should and therefore questions their relationship. So please provide full information so we stop guessing and are able to better help you.

1 Like
10

here is the screenshot for the two divisions for your kind of review

image
image703×814 21.5 KB

11

Here is another screenshot for another date for your kind of view

image
image712×825 22.4 KB

12

No issues on income, only on COGs and related to Cost of Soap and Cost of Rice. Let’s focus on Cost of Rice because the underlying issue may be the same for Cost of Soap. Please do the following:

  1. Click on the "-" blue empty field of Cost of Rice which is fro the screenshot where the first Division had 73,045.45 as amount and show a full screenshot including the headers.
  2. Show a complete screenshot including headers of the edit field of Rice in Inventory.
1 Like
13

Sorry forgot a third screenshot:

Please show the full results screen after clicking on (145,500.00) on the total of Cost of Rice.

1 Like
14

Have you examined your Division exceptions?

You can find that in Reports > Division Exception Report

1 Like
15

YES, HAVE CHECKED IT

16

@Najrash Please keep it polite and do not use All Capitals in your posts as they are perceived as SHOUTING as you may experience now.

1 Like
17

This screenshot you asked me to show is empty, which means the second division didn’t sell rice for the selected date

18

here is your request

image
image676×825 19.6 KB

1 Like
19

This is where I suggest the problem is, it is only a bag of rice sold for the selected date and when I click on 146,500 it shows two columns for rice with the second one cant be view or edited with no receipt number. See below screenshot!

image
image1543×342 18.6 KB

What might be the cause, please?
Cause I noticed this happened ever since I used periodic revaluation (Recalculate in Inventory Items)

20

This is another report for December 4 2024, see where I circled in the screenshot, the transaction cant be view or edited and some are under credit and some are under debit

image
image1557×786 82.4 KB

1 Like