View source for Troubleshooting: Sales amount in P&L not the same as Monthly Sales Analysis?

'''Question :''' Why is the amount of Sales account in Profit & Loss Report not the same as in Monthly Sales Analysis Report?

'''Version :''' 1.8 / 1.9 / 2.0

[[File:Pl vs mth sales1.png|900px]]


[[File:Pl vs mth sales2.png|1200px]]


<u><b>Possible Reason :</b></u>

1)	Amount of Sales Account in P&L: is the total amount posted to Sales Account from various transaction types such as Sales Invoice, Credit/Debit Notes, A/R entries, A/P entries, Cash Book entries, Journal entries… Means it is not contributed only from sales documents/entries. It includes amounts posted from other documents/entries that will not appear in sales reports.<br/><br/>

2)	Amount from Sales report: is the total amount of sales documents/entries, it includes amount that are posted to Sales Account as well as other accounts. For example, an Invoice amount may post to Other Income Account and not Sales Account.



<u><b>Solution :</b></u>

To find out the differences of these two amounts:<br/>

(1)	Find out the summary of posting accounts from Sales report, to see how much was posted to Sales Account and other accounts respectively,<br/>

(2)	Find out the details of Sales Account total amount, to see is there any amount not posted from Sales related journal.<br/>



'''(1)	Find out the summary of posting accounts from Sales report''' <br/>

Go to <span style='color:red'>A/R > AR Monthly Sales & Collection Analysis Report</span>

[[File:Pl vs mth sales3.png]]


Define the <span style='color:red'>Date Range</span>, and choose Report Type = <span style='color:red'>Sales Analysis Report</span>.<br/>
 
At <span style='color:red'>More Options</span>, <span style='color:red'>check</span> to enable <span style='color:red'>Show in Local Currency</span>, click on <span style='color:red'>OK</span>. Click on <span style='color:red'>Inquiry</span>.

[[File:Pl vs mth sales4.png|1100px]]


<span style='color:red'>Preview</span> the report – <span style='color:red'>AR Monthly Sales Analysis Report - In Local Currency</span> and look into total amount.

[[File:Pl vs mth sales5.png|900px]]


[[File:Pl vs mth sales6.png]]

'''<span style='color:red'>AR Monthly Sales Analysis Total = RM 21758.40</span>'''


This is the summary of A/R Invoice, A/R Debit Note and A/R Credit Note. 
To see the details, we need to check into their listing reports. In this example, there is no transaction in A/R Debit Note and A/R Credit Note, so I will just check into A/R Invoice Listing.



Go to <span style='color:red'>A/R > AR Invoice Entry</span>, click on <span style='color:red'>Print A/R Invoice Listing</span>.

[[File:Pl vs mth sales7.png]]




Define the <span style='color:red'>Date Range 01/01/20 – 30/04/20</span>, click on <span style='color:red'>Inquiry</span>.

[[File:Pl vs mth sales8.png]]




<span style='color:red'>Preview report – AR Invoice Audit Trail Listing</span>.

[[File:Pl vs mth sales9.png]]




Scroll all the way down till before the end of report, look into <span style='color:red'>Summary of AR Invoice Audit Trail in Local Currency</span>.<br/>

Ignore <span style='color:red'>Trade Debtor Account and Sales/Service Tax Account</span>.

As you can see:<br/>
Posted to 500-0000 Sales Account = RM 21708.40<br/>
Posted to 555-0000 Other Income Account = RM 50.00<br/>

Which means, not all amount of RM 21758.40 was posted to Sales Account.


[[File:Pl vs mth sales10.png]]




'''(2) 	Find out the details of Sales Account total amount''' <br/><br/>

In P&L, the Sales Account amount = 21858.40 may include posting from non-sales related documents entries such as Journal entries or Cash Book entries.


[[File:Pl vs mth sales11a.png]]


<span style='color:red'>Double click on the amount 21858.40 drill down</span> to Sales Account. There were 3 transactions whose Journal Type is not Sales. Total of these 3 transactions is RM 150.<br/>

[[File:Pl vs mth sales12.png]]


So the total amount from Journal Type = Sales is 21858.40 – 150.00 = <span style='color:red'>21708.40</span><br/>

Which is the same as earlier total amount of <span style='color:red'>AR Monthly Sales Analysis Report</span>.




By : Ju Lee 180130, Lay Swan 200602, P200605


{{NavigateForUser}}

[[Category:Users]]