Credit Sale / Collection Book

Software Updated as on 25/03/2019

The most frequently required feature for most business is undoubtedly the Collection Book and Outstanding Statement. In petrol-pump business there is a peculiar requirement of product and vehicle details in the collection book is different from other business. For normal business traders are just interested to know bill wise collection details. But, in petrol-pump business again the bills are generated periodically (weekly, fortnightly and monthly or even daily) that too with vehicle details is somewhat different than normal traders. So, we have come out with the Collection book with Billed and un-billed sale with Product and Vehicle details columns so that it becomes easy to identify indents for which the invoice already generated and so on…

Statement of Account

You can also get Summary Report with Option for Daily Total and Monthly Outstanding and Collection in Summarized format for overall account movement view of customer.

Day Total Summary

Monthly Collection – Sale Summary

The Module can be accessed from Reports->Petrol Pump->Customerwise Credit Sales form. On the form New Tab is created “Dues vs Collection” and when you click you will find the screen below:

The Interface is simple Just click on a Customer and Click on the View “Detailed” and Click on Print Button to see report shown above or Click on “Day Total” Tab and click on Print button to View Summary Report with Day Total and Click on Monthly Summary and then Click on Print Button to Print Monthly Account Movement. You can also click on Export button to Export the data in Excel format. By Default the Report is for the financial accounting year but one can change the Date Range to print the Report for the specified period and Click on <Show All> to View Reports for all the Customers. Please note the <ReProcess> Button, this is provided to Refresh the Data and ReProcess all the transactions to fetch any new data Entered or Altered after the last processing. However if there are few transactions then it automatically refreshes and reprocesses as the time for process is in fractions but if the transactions are in bulk then it asks users to confirm the process.

Other Major change is for GST. The GSTR1 option in Reports->Sales->Sales Register (Credit Sales) the Export feature already provided was just used to export the credit invoices and for Cash Sales for GST purpose one was required to export separately from Sales->Cash Sales->History Button and then Click Export for Non-Fuel Items… is now integrated in the GSTR1 already provided in Sales Register, it now exports the Credit and Cash Sale Details in Separate Sheets in Excel Workbook.

One common requirement by many customer was to get rid off the duplicate items created by mistake. At times the same item is created with different names as 2T 1/2Ltr and 15W40 500ml or 2T 40ML and POUCH 40 ML and so on… Software does not allow to delete the item as long as there are transactions for the item in the database. The best practice is Items should not be allowed to be created by normal users the Items should be created by only the Administrator. However to solve the above problem we have added new feature to Merge the duplicate items as shown below:

Just select the Item to be Removed from the Left hand side Listbox (Source Item) and click on the Item in the Right hand side Listbox (Targe Item) to which the Item selected is required to be merged and then Click on <Merge Item> button on the bottom of the screen. This will safely merge all the transactions with Source Item to Target Item and retain only the Target Item.

Advertisement