Archive for the ‘DAILY REPORTS’ Category
BULK SMS
Posted on: October 8, 2010
This feature help an organisation to send SMS to its customers informing several details whenever required.
STOCK & SALES ANALYSIS ON NET
Posted on: October 8, 2010
Select this option to view the report on Stock & Sales Analysis on the website( http://www.margcompusoft.com) by uploading the same .
PURCHASE PLANNING
Posted on: October 8, 2010
This gives report on the planning of the purchases i.e. purchased from which company , at what price ??
ALWAYS BETTER CONTROL ANALYSIS
Posted on: October 8, 2010
This option prints the analysis report of the complete stocks in hand of each item based on the following filter settings which facilitates the firm / management in the following ways:
– to keep a complete control over the inventory items
– to track down / reveal any pilferages by the staff / person in-charge
– to find out the value of the dump stock of each item remaining unsold.
– to find out which item(s) have a poor score of sales as on any date.
ALL ACCOUNTING RECORDS
Posted on: October 8, 2010
Selecting this option will print the complete daily transaction of the firm for the specific period. The statement will include the transactions like Purchase Book, Sale Book (Cash & Credit), Payment Collection Register, Payment Register, Sales Return, Purchase Return and the Accounting Records (Payment, Receipt, Journal) based on the following filter settings.
INVENTORY REPORTS
Posted on: October 8, 2010
TODAY’S SALE, PURCHASE, CLOSING:
Select this option to print the statement of sales, purchases & closing stock of each item for the specific period / day.
VARIOUS TYPES OF ITEM LIST : This gives the report on the various types of item we have in our stock( no rate & MRP is given) . The report can be filtered Company Wise, Alphabatic wise , Columnar wise, Salt wise, category wise.
DIFFERENCE BETWEEN THE TWO
Whereas in Report ManagerOther ReportsItem List . This Also Gives The Same Report Of Items But It Gives Rate & MRP Also.
NEAR EXPIRY & EXPIRED REPORTS :This gives the report of the stock which are near to expiry Or Expired Stock so that it is not delivered to our consumer & so as To maintain the Goodwill & repo of the company & should be shifted to the Scrap store.
DUMP STOCK REPORT This gives the report of the stock which have not been put into transaction i.e. Sale or Purchase from the no. of days defined (say 60 or 30 or 90 days ) are called DUMP STOCK.
HOLD STOCK REPORT: This gives the report to see the particular bills, products, quantity, & Batch No. which have been set on hold.
NEGATIVE STOCK REPORT : Select this option to print the report of the items that have reached the negative balance according to the system data.
When the negative option is enabled from the control panel and bills / challans issued for certain items (due to the inter-branch / inter-store adjustments or due to any other reason) when the stock in hand is nil, then obviously the stock in hand of that item becomes negative. Although the system permits this type of working, but as per the accounting & inventory system this is an error. At one stage the user must update (correct) this type of error (negative balance of stock). In such case this report is needed to make the required entries.
RATES DIFFERENCE STOCK LIST: This report gives the list of the items whose MRP has changed ( in accordance with MRP when it was purchased).
BANK STATEMENT (Stock Valuation): This option is used to print the stock valuation statement (for bank purpose) based on various rates and filter settings.This report can also be used to get the loan sanctioned from the bank.
TODAYS GROSS PROFIT : This option is used to evaluate and print the gross turnover / gross loss of the business on a specific duration.
STOCK REGISTER PLANNING:
Select this option to print the detailed stock register of each item for the specific period.AND WE CAN SEE THIS REPORT FROM STOCK BOOK ALSO.
DIFFERENCE BETWEEN THE TWO……..
THIS OPTION GIVES A MORE FILTERED REPORT & GIVES THE COST OF THE ITEM ALSO.
STOCK AGEING ANALYSIS: This option is used to print the ageing analysis of the amount value or the stock quantities of each item during different intervals of period.
FAST AND SLOW MOVING ITEMS: Every firm will be very keen to know the pace of flow of each item to make appropriate changes / drastic decisions in the business.
ITEM WISE TAX DIFFERENCE: This option is very much useful in cross checking the incorrectly taxed items while preparing the bill. The system will cross check the tax type applied in the billing with the tax type mentioned in the master item record and bring out the errors so that the user can correct these errors.
BARCODE PRINTING : NA
DAILY WORKING
Posted on: October 8, 2010
DISPATCH SUMMARY:
This option prints the summarised dispatch report of all the items on daily basis depending on the filter settings explained in the process below.
PROCESS TO VIEW ENTRY IN DISPATCH SUMMARY:
1. Enter username and password to login into your Marg software.
2. Click on transactions Daily Reports Purchase ReportDispatch Summary.
3. A window will appear on the screen with following options:
I. Type- what type of report you wish to view. 1 for only sales report, 2 for sales and sales return report and so on.
II. Mention the period for which you want to view the report.
III. Mention the range of bill no you wish to view.
IV. State whether you want to include challan or not.
V. Mention the item supplied.
VI. Mention the free samples, if any.
VII. Mention the bill item/no.etc and line no.
VIII. Bill index no. and whether you wish to merge two or more bills.
IX. Item Index no. and whether you wish to view merge two or more
than two items.
X. Format.
XI. Print MRP
XII. Single or multi account group
XIII. Mode of Transport.
XIV. Select Party, Area, M.R. and Route.
XV. Click on accept to accept the entries made by you or cancel if you wish to again feed the data or wants to make some changes in the data entered.
4. You would get the Dispatch Summary according to the criteria mentioned by you.
5. Select the Party whose bill and its details you want to view.
6. You can view and modify this bill.
MULTI BILL/OTHER PRINTING: Select this option to print all the unprinted invoices one by one.
PROCESS TO VIEW ENTRY IN MULTI BILL/OTHER PRINTING:
1. Click on transactions Daily Reports Purchase ReportMulti Bill/Other Printing.
2. A window will appear on the screen with following options:
I. Type- what type of report you wish to view. 1 for only sales report, 2 for sales and sales return report and so on.
II. What you wish to print- invoice, Bank Letter, etc
III. Print For
IV. Mention the period for which you want to view the report.
V. Mention the range of bill no you wish to view.
VI. State whether you want to include challan or not.
VII. Single or multi Party & Group.
VIII. Select Party, Area, M.R. and Route.
IX. Click on accept to accept the entries made by you or cancel if you wish to again feed the data or wants to make some changes in the data entered.
3. You would get the Multi Bill/Other Printing Summary according to the criteria mentioned by you.
4. Select the Party whose bill and its details you want to view.
5. You can view and modify this bill.
REORDER ON SALES/MINIMUM BASES:
Select this option to print the detailed stock position of the items for reordering based on its minimum level of stock (to be maintained) as it was entered while creating the master item record (or) based on the frequency of sale of each item. For more details , view the screen shot which reflected at the time of master Item Creation. It is used to prepare the reorder / Purchase new stock on the basis of sales of previous 7 days
STOCK & SALES ANALYSIS :
RATE COMPARISON STATEMENT:
Select this option to compare two different rates of the item of each batch. For example the firm may want to compare the Purchase Rate with the MRP based on the selected numeric validation (, =, ==) and bring out the difference, bill details and the supplier detail.
BILL TAGGING/ COLLECTION LIST & BILL TAGGING IN SINGLE O/S :
In the firms which have a huge number of daily transactions, normally when sending their field person for collection of the outstanding payments, the firm will keep a written copy of the outstanding statement to be given to the clients and when the field person returns with the payment they make a note of the same detail against each invoice detail, in the written copy, and then update this payment information on each outstanding ledger account.
To ease this tedious task MARG has an option called ‘Bill Tagging’
The system operator will create a tag of each statement he issues to the field person by giving a separate tag number for each tag.
Once the payments are received for all or part of the invoices of one tag, the system operator will open the respective tag using its tag number and feed in the amount received against each invoice. The invoices for which the total payment is received will automatically be removed from the tag file and the remaining invoices will be shown in the tag file next time.
By this the system generates the receipt vouchers automatically and updates the debtor’s outstanding balances.
MARG names this complete process as ‘Bills Tagging’
Once you enter the indexing / sorting preferences the system will prompt to choose the pattern of the statement, that is, party-wise, area-wise, salesman-wise.
THIS IS BASICALLY USED BY FMCG Companies.
After completing all the process press the button to enter the Tag number, Date & the name of the field person to whom the statement is issued.
Now the all the selected bills are tagged and the Tag File for the outstanding statement is generated.
The payment receipt entry against the tagged bills can be done through the receipt entry option from the transactions menu. In the Similar way , We can tag the Bill in Single Outstanding also.
PENDING CHALLANS:
Select this option to display / print the pending challans against which action has not been taken yet.
PROCESS TO VIEW ENTRY IN PENDING CHALLANS:
1. Click on transactions Daily Reports Daily WorkingPending Challans.
2. A window will appear on the screen with following options:
I. Type- what type of report you wish to view. 1 for only sales report, 2 for sales and sales return report and so on.
II. Mention the period for which you wish to view the bills
III. Mention the value of the challan (up to which or equal to or greater than)
IV. Mention bill series
V. Mention the range of challan no you wish to view
VI. Mode of transport
VII. Select Party, Group, Area, M.R., Route
VIII. Click on accept to accept the entries made by you or cancel if you wish to again feed the data or wants to make some changes in the data entered.
3. You would get all the challans issued by your company according to the criteria mentioned by you.
4. Select any challan to view more details regarding it or to modify it.
CHALLAN TO BILL:
Select this option to prepare the corresponding bills against pending challans issued.
PARTY NOT VISITED: This gives the report of the list of the parties who have not visited us for any transaction i.e.Sales or Purchases.
BILL NOT PRINTED( MIS) : Select this option to check all the bills that are not printed and print them one by one. (When you prepare a bill the system keeps a record of how many copies of bills have been printed. In case no bill is printed this option shows the list of all the unprinted bills) . So this can be used to send the bills to party for payment.
BILL NOT PRINTED (AFTER MODIFICATION): Selecting this option will display the list of bills for which some modifications has been made and the printout was not taken yet.
SIGNED/UNSIGNED: In the firms having huge number of transactions per day, it is very difficult to maintain the track of the bills prepared, sent to the authority for signature & received back duly signed by the authority. ALSO CALLED VERIFICATION OF THE BILL.
In MARG the user has the option of maintaining the bills that are sent for the signature of the authorized person of the firm and once they return the bills, duly signed, the user can enter the signed bills details. The system maintains the complete track of this process.
DELIVERED & UNDELIVERED (MIS) :N.A.
PURCHASE REPORT
Posted on: October 8, 2010
Similarly , We Can View The Purchase Reports :
• Supplier Wise
• Bill Wise
• Company Wise
• Item Wise
& We Can Further Also Filter The Data : Area Wise & Month Wise & Product Wise
SELF LIFE STATEMENT: This option IS USED to print the detailed statement of purchases showing the expiry date, life duration days, the period-in-between manufacturing date & purchase date and the period-in-between the purchase date and the expiry date of each item.
PROCESS TO VIEW ENTRY IN SELF LIFE STATEMENT:
1. Enter username and password to login into your Marg software.
2. Click on transactions Daily Reports Purchase ReportSelf Life Statement.
3. A window will appear on the screen with following options:
I. Stock Add (during a purchase activity stock of an organisations increases)
II. Add Challan.
III. Mention the period for which you want to view the report.
IV. PURCHASE COSTING COMPARISON-MIS:
V. Select this option to compare the costs of the items that were purchased from two different suppliers (sellers) at different time intervals. The detailed cost comparison statement will show the cost difference if the item has the same MRP as well as different MRPs.
VI. State whether you wish to view cash transactions, credit transactions or both.
VII. Click on view to view the report, print to take a print out of the report and cancel if you wish to again feed the data or wants to make some changes in the data entered.
4. You would get the Self Life Statement according to the criteria mentioned by you.
PURCHASE DIFFERENCE STATEMENT:
Select this option to print the reports of the purchase entries for such bills / items where there is a difference between the billed amount and the actual paid amount.
PURCHASE CHECKING STATEMENT:
Select this option to print the detailed checklist of the purchased items (bill-wise), purchase details like MRP, Rate, Cost, Discount & Bill Amount and the corresponding sales details of that item like type of the Rate, Tax & Amount etc. This report is useful to verify the correctness of the purchase rate entries and the sales rate entries of each item.
PURCHASE COSTING COMPARISON-MIS:
Select this option to compare the costs of the items that were purchased from two different suppliers (sellers) at different time intervals. The detailed cost comparison statement will show the cost difference if the item has the same MRP as well as different MRPs.
PURCHASE DISCOUNT MISMATCH:
Certain firms have fixes an agreed amount of discount percentage with the suppliers / dealers / sellers for certain items or all of their items to be supplier. This agreed fixed discount percentage is normally entered when creating the master entry of that item. In case the supplier / dealer / seller prepares their bills for a less discount percentage and not abides by his agreement of providing the fixed discount, then this report helps to track such discount mismatched purchase bills.
SALES REPORT
Posted on: October 8, 2010
SALES REPORT:This report can be viewed through various ways:
M.R. SALES STATEMENT:
Select this option to view / print the sales statement during the day for the selected period M.R.-Wise (Salesman Wise).
PROCESS TO VIEW ENTRY IN M.R. SALES STATEMENT:
1. Enter username and password to login into your Marg software.
2. Click on transactions Daily Reports Sales Report M.R. Sales Statement.
3. A window will appear on the screen with following options:
I. Stock Less (during a sale activity stock of an organisations declines)
II. Add Challan.
III. Detail/Summary- if you select summary, you would get a report of all the bills in the sales report, however, if you choose details, you would also get the items sold through that bill in the sales report.
IV. Report for- what report you wish to view. 1 for only sales report, 2 for sales and sales return report and so on.
V. Mention the period for which you want to view the report.
VI. Select Area and Route.
VII. Click on view to view the report, print to take a print out of the report and cancel if you wish to again feed the data or wants to make some changes in the data entered.
4. Select the M.R.
5. You would get the sales statement according to the criteria mentioned by you.
Sales report:This helps to view the sales report M.R Wise, Party wise, Company Wise & Sales Return Wise , And all these reports can be seen on :
• Monthly basis
MR/ SALES PORTION “— ALL ITEM / MONTH WISE :-
• Daily Basis
• Bill wise
• Supplier wise
• Operator Wise
NET SALES COMPANY WISE
And the Medical Representative( MR) Report on Sales again can be viewed through various means:
MR Sales statement: MR WISE SALE BOOK : –
MR summary : ALL MR. ,, MONTHLY :-
MR / Company wise Summary: COMPANY WISE – (WITH ITEM) : / MR SALE :-
MR / Product wise summary :
Party Return Analysis
This option to print the analysis report of the total sales made to a single buyer and returns made that buyer giving the break-up of the types of returns made by that buyer.
The analysis report will be showing the total sales, percentage of total returns & total return quantities, total sales returns and percentage, total breakage returns / expiry returns and percentage to evaluate the performance of the buyer.
WE CAN FILTER ALL THESE OPTIONS DAY WISE SUMMARY /MONTHWISE /BILL WISE & SUPPLIER WISE & AREA WISE.
Select this option to print the DAY WISE /MONTHY WISE/ BILL WISE/ sales summary of Cash Sales, Credit Sales & Total sales of the day.
MARG ACADEMY 