Although ArtRMPP provided you with the Gross Profit Calculation and Margin earned on Fuel Items and Non-Fuel Items from:
Reports->Accounts->Profit & Loss Account -> Report Tab-> Trading Account – Fuel Items
Just click on < (.) Radio Button> Trading Account – Fuel Items Option. Just Click on <Process> button to populate the details of margin for products in the grid.
On Process you can view the Item-wise Stock Movement and Margin for the whole year in Yearly Summary Tab as shown in image below:
On Clicking on the Item/Product It gives the Monthly Movement (Purchase and Sale) and monthly Profit on sale for the chosen item.
Similarly, when you click on the particular Month, it gives daily sales/purchase and profit for every day in the given month
The above provided users with the Gross Profit, but it did not give the complete picture, so we have come out with the simple, fast Net Profit Calculation for the specified period on a single click.
Net Profit / Loss Calculation
We have just introduced the feature by adding the Tab <Analyse>.
Reports->Accounts->Profit & Loss Account -> Analyse Tab.
Just select the period for which you wish to get the Trading and Profit & Loss account and click on <Process> Button as shown in the image below:
Just click on <Profit & Loss A/c> Tab Next to <Trading Account> Tab to view the profit or loss for the specified period as shown in the image below:
Also note that <Export to Excel> button is provided on all above screen to export data to Excel for reformatting and recalculation or manipulation as required.
Filed under: Recent Updates, Software Update | Tagged: Calculation, Closing Stock, Excel, Expenses, Export, Fuel Items, Gross Loss, Gross Profit, Loss, Margin, Non-Fuel Items, P&L A/c, Profit, Profit & Loss A/c, Profit and Loss Account, Purchase, Purchase Register, Sales, Sales Register, Stock Movement, Trading Account | 1 Comment »