Dynamic Voucher Entry

Voucher Entry Redefined: The Improvised, Efficient, Optimized, Faster Voucher Entry for advanced user (familiar with Tally Accounting Software or Accountants). New Tab introduced with name <Dynamic Voucher Entry> leaving old good voucher entry untouched for those who wants to continue using the same old interface.  New Interface looks as shown below :

The beauty of this module is that you don’t need to select the voucher type like “Receipt”, “Payment”, “Contra” or “Journal” as required in old interface. It will automatically decide based on the entry passed. So, it will speed up as number of keypress is reduced. Secondly  you can continue with the same debit account (the bank in which the cheque is deposited) and just change credit account (from the payment is received) and keep pressing enter to add the data in the grid.

You can simply Reverse the ledgers selected by clicking on <[z]> button between the Debit Account frame and Credit Account frame.

You can also click on <Reset> button if you want to clear both the ledgers selected in Debit and Credit.

You can also Export the data (for record purpose or repeat the entry for future date) so entered and seen in the grid before saving by pressing the <Save Bulk Entry>. After saving the cursor is positioned to <Clear Data>, just pressing <Enter> will clear all the data from the grid or click on Clear Data to clear the data after saving.

You can also Import the Data from Excel sheet, just click on <Import Data> button to import the already saved data in Excel sheet. To get the column specification you can either click on <?> button, which will guide you through the details of columns required in the excel sheet and one can get Excel sheet automatically created with sample data on confirming to create excel sheet from <?> button. Also you can just enter the data by selecting the Debit and Credit ledger and filling the amount and pressing <Add> button to add data in the grid and click on <Export to Excel> as explained above.

Import Data will ask you to confirm the Excel file in which your data is stored. The excel file should be Excel 97/2003 format, once the file is selected it will ask you the name of the Excel Sheet from which you wish to import the data. On success, it will populate the data in the grid with details as shown below:

• Column#1: Debit Account Code / Ledger Code assigned to account
• Column#2: Credit Account Code / Ledger Code assigned to account
• Column#3: Voucher Date
• Column#4: Voucher Amount
• Column#5: Reference Number/Cheque Number/Document No., etc.,
• Column#6: Narration

You can <Double Click> in the grid to remove any garbage or any entry which you wish to Remove/Delete before saving the data.

Advertisement

New Reports and Modules.

Now you can see running total  for fuel items while entering the nozzle reading for fuel items, which earlier was possible only after seeing the Shift Analysis Report or MIS page. In the Meter Reading Entry Form there is a new toggle button at the bottom called / as shown in the image below:

Show/Hide Item Sales Summary for Meter/Nozzle Sale Entered

Now you can also auto print the cash sale bill/receipt, which earlier required you to first save and then print/preview the last invoice. With New button now it first saves then automatically fires the receipt to the printer, one must make sure that the printer is turned on.

Incorporated two new Tax introduced by Indian Government called SWC – Swtchh Bharat Cess and KKC – Krishi Kalyan Cess applicable on service tax. This is applicable to the petrol-pump dealers charging Processing Fees or Account Handling Charges or Account Processing Charges, etc., on the Bill amount towards the credit facility given to the customers for bill payment as a normal practice in Mumbai.

Configuration for SBC & KKC on Service Tax

With New version now you can print sales register as per meter reading with the nozzle-wise, Item-wise and Tank-wise sales reports for the selected period from Reports->Sales->Sales Register (Slips) as shown below:

Meter Reading Sales Reports

Please find below the preview of the reports for your reference:

Nozzle-wise, Item-wise Sales Report Preview

Also added much needed reports for Credit Card sales as demanded by many customers…

Credit Card Sales Reports

Now you can enter the Cash Transfer by Cashier/DSM/Supervisor without the denomination but with date and time details and frequency / number of times cash transferred to tally the cash for the DSM, vis-a-vis the the fuel dispensed on credit/cc/pc basic. Please note that one can invoke this modules from Meter Reading form by clicking on the button on the Meter Reading Entry form.

Enter Cash Denomination Summary

Also please note that now it will correctly fetch the Receipt/Payment by DSM from the voucher for the selected shift and also correctly fetches all the Credit/CC/PC indent for the respective nozzles, which earlier used to duplicate, which user required to manually set to zero (0). Also now when you manually change the quantity the value automatically calculated as per the prevailing rate and similarly quantity would be automatically calculated if user enters the value for credit/cc/pc column. This has resulted in using the ArtRM software and this form practically to actually tally cash efficiently.

Monthly P&L: The much needed and required almost by every pump dealers to check the profitability and expenses incurred at every pump, which earlier used to take lot of time to process and required to select the period or click on many keys to find the profit or loss.

Monthly Profit & Expenses Summary

The ArtRM, instantly processes and populates the Profit and Expenses details for every month and also allows to export the same to Excel.

Shift Report: Additional New Reports added in Reports->Petrolpump->Daily Shift Analysis->Day Analysis (Shifts-Clubbed) as shown below and also for the individual shifts in Shift-wise Report tab.

Daily Shift Analysis Reports

 

Daily MIS on TIPS Page and Improved Workflow.

13th January, 2014

Greetings!

Wish you all a Very Happy New Year.

With the new update, now you need not worry about the Date Selection while entering Meter Reading Entry, Slip Entry, Voucher, Dip, etc., Whatever Date and Shift is selected on the TIPS page will now be set for the respective from called from TIPS page. Earlier user would forget to Select the Date/Shift and data would get entered for different Date/Shift, which requried to be Edited and so on…

Also New, Button <MIS> is Introduced Next to Date/Shift selection on the TIPS page as shown below:

Daily MIS on TIPS

When you click on MIS button you will see All the Transaction for the selected Date/Shift with Opening Cash Balance for the Selected Date/Shift and actual Cash Receipt/Payment duly Added/Subtracted from the opening balance and available Cash Balance duly computed shown at the bottom-left of the screen as shown below:

Daily MIS with Cash Balance

Also find new Grids, Item-wise Sales summary and Sale Type Wise Item-wise Sales Summary below the Meter Reading Grid. The best part is that all the Information displayed on the form can be exported to Excel by just pressing the <Export to Excel> Button on Bottom-Left of the Screen. Please find below the screen dump of Excel Export Screen of MIS:

Daily MIS Export to Excel

Quicksoft PetrolPump Software Updated – Version 2.1.49

Version 2.1.49
Date Updated: 14th June, 2012

All Daily Transaction can now be exported to Excel.

Reports->Petrolpump->Daily MIS: All Petrol-pumps maintain their daily transactions on piece of paper or excel sheet, therefore we thought of providing them with the data on excel sheet so that they can easily verify the details and keep record of shift data in excel also.

Daily Entries

You can now select particular shift and export all the transaction mentioned below for the chosen shift

a) Meter Reading

b) Credit Sales Slip Details with Vehicle Details

c) Credit Card Sales

d) Petrol Card Sales

e) Credit Service (Fuel) Sales

f) Cash Sales (Fuel)

g) Cash Sales (Non-Fuel)

h) Credit Sales (Non- Fuel)

i) Credit Card / Petro Card Sales (Non-Fuel)

j) Credit Service Non-Fuel

k) Cash Receipt

l) Cash Payments

m) Purchase

n) Dip Entry for the Shift.

2.Bank Reconcilliation

can now be Printed without Clicking the Update Button. Now you can edit or delete the Uncleared cheques of the last year.

3. Purchase->Fuel Item Pricing

can now simply be Edited by Pressing Enter Key on the Last Column (Current Sell Price) . If Item Pricing for the Selected Date is already existing then system will just update the price and if the pricing does not exist for the chosen date then it will create the entry for the selected date. It will also warn you if you do not save before exiting.

4. Letter Head Printing:

Report->Sales->Customer Details (CRM)-> Misc Tab now allows you to print the Letter Head for the stationery chosen by user. Report file(s) needs to be sourced from quicksoft.

5. Cheque Printing:

Reports->Accounts->Voucher/Cheque Printing: Now you can print the Cheques as per your cheque size by clicking on Cheque Printing Tab on the form and select the date range and click on the transaction to print the cheque. You can simply key in the information for

a) Name of the Party

b) Cheque Amount  and

c) Cheque Date

Click on Print Preview Button to print the Cheque. Report to be sourced from quicksoft.

6. Meter Reading

is now Changed / Resized so as to not scroll and resize the columns which was earlier required. Also now you don’t need to use Mouse to use this module as it automatically positions to the Meter Closing/End.

7. Vehicle Master

was not opening, bug now fixed.

8. Customer Master:

New Account Number now automatically assigned to new customer and Mandatory field phone number is now brought on top frame so that user no longer need to press several Tab or Enter key to reach the phone number field. Just Enter the Name, Phone Number and press Alt-S to save the data.

9. Customer A/c Opening Form:

Customer Details Tab New button is provided to print the contract for credit custoemrs. Just click on “Credit A/c Contract” button to print the A/c opening form for credit customer.  Report to be sourced from quicksoft

SMS Templates introduced.

24-May-2012

As per the latest notification issued by TRAI (Telecom Regulatory Authority of India) i.e. on 5th September 2011,  which will govern telemarketing in India including SMS, voice and data.

The new TRAI regulation gives the guidelines for sending Information to its    customer(s)

•        i. in Transactional mode: 24×7
•       ii. in Promotional mode: 9:00am to 9:00pm

For Sending SMS in Transactional mode it is mandatory to register the template for sending message with the service provider.  Therefore new SMS template is introduced in the Administration->Configuration Screen->SMS Tab.

Also the Utilities->Mail Merge screen is now changed to select the template using which the SMS needs to be sent. User can now create Excel sheet containing the columns namely, Mobile No, Dynamic Text1, Dynamic Text2 to store the dynamic text to be sent to different mobile numbers and import the same by clicking the <Import Excel> button in Import Contact frame.

Earlier Bank Rconcilliation module (Reports->Accounts->Bank Reconcilliation) required user to Click on <Update / Reconcile> button to save the cheque clearance flag marked by user for the selected Bank/Month before printing the Report.

Also, there was a glitch as reported by customer. When a Cheque for lets say April was marked as cleared in May and when coming back to April, it was not showing as cleared instead of Uncleared is now fixed.

Ledger Printing: 

New, Checkbox introduced for omitting the ledger for printing, having no transaction for the selected period and opening and closing balance being ‘0’. Also the code is optimized to print ledger faster than earlier.

 

Product Sales Analysis and Customer Analysis introduced.

New Feature introduced for Product wise Sales Analysis and Customer Analysis on product purchased by customers.

Just Click on Report->Inventory->Stock/Product Ledger.

to See the two new tabs added in the Stock Ledger form.

SALES ANALYSIS

For Item-wise Sales Analysis you may click on <Sales Analysis> Tab to see the following screen.

Product Sales Analysis

Please observe the TreeView populated with Items/Products on the Top Left Corner. Just Click on the Item or Category.

For e.g. You can click on Category FUEL ITEMS or ULP, HSD, etc., under the Fuel Items Category to see the Monthly summary for the Item/Category selected below the TreeView / Bottom Left Corner of the Screen.  Also you will find the Sales Type wise summary and Transactions for all the sales type below the summary grid for full financial year 1st April, 2011 to 31st March 2012 in the above screen. Also it gives the list of Customers who have purchased the selected product in the order of value highest to lower.

Just Click on a particular Month Grid (on lower left corner) to view the Sales Type wise Summary for the particular month and the transactions for the said month.

Now, you can also click on particular Sales Type to view the transactions for the selected Sales Type in the Transaction grid below the Sales Type summary grid.

Just click on the Excel <Button> with icon/logo  <X> ( a  logo for Excel) displayed to the left of Total on lower left of the screen to export all the grids in different sheets as shown below:

Sales Transaction Export to Excel

Please observe the Sheets at the bottom of the  image shown above.

Monthly_Movement showing the Monthly Sales summary

Sales_SlipType-wise showing the summary of Sales for the Sales Type

Transaction_Detail shown in the above image

and

Customer_Lifting showing the Customer-wise total purchase by each customer in the order of highest to lower.

CUSTOMER ANALYSIS

Just click on the Tab <Customer-wise Item-wise> to see the following screen:

Customer wise Sales Analysis showing Item-wise lifting.

Please observe the TreeView populated with Items/Products on the Top Left Corner. Just Click on the Customer to see the Monthly summary for the Selected Customer  below the TreeView / Bottom Left Corner of the Screen.  Also you will find the Item-wise lifting summary and Transactions for the All Items just below the summary grid for full financial year 1st April, 2011 to 31st March 2012 in the above screen.

Just Click on a particular Month Grid (on lower left corner) to view the Item-wise lifting/sales  Summary for the particular month and the transactions for the said month.

Now, you can also click on particular Item  to view the transactions for the selected Item  in the Transaction grid below the Item-wise Sales summary grid.

Please observe the Radio Button option

• Date-wise
• Vehicle-wise

on the center of the screen above.

Just click on the desired option to view/export data date-wise or vehicle wise as shown in the excel sheet image below:

Just click on the Excel <Button> with icon/logo  <X> ( a  logo for Excel) displayed to the left of Total on lower left of the screen to export all the grids in different sheets as shown below:

Customer-wise Sales Analysis Exported to Excel

Top of the are in the above excel sheet image shows dump of transaction exported date-wise and bottom of the image shown in coloured shades showing vehicle-wise, date-wise export of transaction along with the following sheets.

Monthly_Movement

and

Item-wise lifting

Profit and Loss Calculation on a Click.

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:

Gross Profit Margin Yearly

On Clicking on the Item/Product It gives the Monthly Movement (Purchase and Sale) and monthly Profit on sale for the chosen item.

Monthly Purchase / Sales with Profit

Similarly, when you click on the particular Month, it gives daily sales/purchase and profit for every day in the given month

Daily Sales / Purchase with Profit for the 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:

Trading Account

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:

Profit and Loss Account

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.

 

Import Meter Reading and Dip Data.

28/09/2010

Now, it is possible to Import the bulk meter reading data and dip entry data in the software without keying in manually. This is very useful particularly, in case when user intends to go online without entering data manually for past months.

Import Meter Reading Data
It is now also possible to Import Meter Reading Entry data. You will find a New Tab introduced in the Meter Reading and Dip Entry form. In the Import tab you will be asked to select the Excel File containing the Meter Reading Data / Dip Data, Click on button to select the excel file. After choosing the Excel File, user will be asked to select the Sheet containing the data for the Meter Reading/Dip Entry. By Default Excel Workbook has Sheet1, Sheet2 and Sheet3 but user may have renamed the excel sheet and therefore user will be asked to select the sheet name in which the data for the Meter Reading and Dip entry is stored. After choosing the Sheet, user has to click on the button to populate the data for the sheet in the Grid below the Populate button. If the data contained in the sheet is verified as correct then user has to click on to Import the data to the Shift Meter Reading.

Data contained in the Excel sheet should be as per the Specification given below:

Meter Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Meter Reading data as desired but the Column heading specification should be as given under:
e.g.
where stands for Nozzle Description as given in Nozzle Master for ULP/Petrol Nozzle Number 1 in above example. should be followed by to specify that the column contains the Meter Reading Data for the said nozzle.

Similarly for Testing data for the said nozzle you have to specify the column name as to contain the data for Petrol Nozzle 1 and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row being the Opening Meter Reading for the First day in the sheet and third row containing the Meter closing for the first day and Meter Opening for the next day, fourth row onwards the closing meter reading data for the date in the first column and so on.

Import Dip Entry Data
Just as Import Meter Reading data mentioned above, it is now also possible to import Dip Entry data. To Import the Dip Entry data, procedure to be follow is exactly as mentioned in import meter reading data above.

1. Select the Excel File
2. Select the Excel Sheet to Import which contains the Dip Entry Data
3. Click on Button to populate the data contained in the selected sheet to preview before actually imprting data.
4. Click on Import Data button to Import the data.

Data contained in the Excel sheet should be as per the Specification given below:

Import Dip Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Dip Reading data as desired but the Column heading specification should be as given under:
e.g.

where stands for Tank Name as given in Tank Master for ULP/Petrol Tank in the above example. ULP should be followed by to specify that the column contains the Dip Stock Volume Data for the said Tank.

Similarly for importing the Dip Reading data for the said Tank you have to specify the column name as to contain the Dip Reading data in CM as per the calibration chart for Petrol Tank and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row onwards being the Dip Reading data for the date in the first column and so on.