GST Billing-Software for Distribution,Retail and Manufacturing

Horizon Technology Solutions

Product Overviews

REPORTS

GST Billing-Software for Distribution,Retail and Manufacturing


OUTSTANDING REPORTS

GST Billing-Software for Distribution,Retail and Manufacturing

All reports having the same format,

1- Select report date range.

2- Select report filtering criteria’s ie.;

→ Area wise.

→ Route wise.

3- List all reports under the outstanding reports such as,

 ⋇ Customer wise outstanding

 → It shows customer wise total outstanding amount. And shows credit limits also.

 ⋇ Bill wise Customer outstanding

 → It shows the customers and their bill wise outstanding amount. And we can identify the credit
  days allowed per bill.

 ⋇ Supplier wise outstanding

 → It shows supplier wise total outstanding amount.

 ⋇ Bill wise supplier outstanding

 → It shows voucher no. wise suppliers outstanding amount.

 ⋇ Customer bill ageing

 → For identifying credit days of the customers.

 ⋇ Retailer collection summary

 → It shows the total cash collected from each customers.

 ⋇ Route collection summary

 → It shows route wise bill summary.

 ⋇ Non billed counters

 → List of customers that not billing.

 ⋇ Bill wise profitability

 → For identifying the profit based on customer per bill. It shows the total discounts and schemes
  given on each bill.

 ⋇ Day wise profitability

 → For identifying day wise profitability.

 ⋇ Customer performance

 → Customer wise total sales and pending amount displayed here.

 ⋇ Customer performance item wise

 → This report is useful for identifying the products demand.

 ⋇ Supplier performance

 → Supplier wise total sales and pending amount displayed here.

 ⋇ Customer bill ageing 2

 → It shows the balance amount of customers in each short periods.

4- View the filtered report.

5- Refresh screen.

6- Export report to excel.

7- Print report.


MONTHLY COMPARISON

GST Billing-Software for Distribution,Retail and Manufacturing

1- Filtering the reports,

 → Category wise.

 → Group wise.

2- List all reports under monthly comparison.

  [Here, Monthly break up and its summary reports generated based on item wise and ledger wise
 for all transactions].

 → Sales break-up

 → Sales break-up summary

 → Sales ledger wise

 → Sales ledger wise – sum

 → Purchase break-up

 → Purchase break-up summary

 → Purchase ledger wise

 → Purchase ledger wise – sum

 → Credit note break-up

 → Credit note break-up summary

 → Credit note ledger wise

 → Credit note ledger wise – sum

 → Debit note break-up

 → Debit note break-up summary

 → Debit note ledger wise

 → Debit note ledger wise – sum

3- View the filtered report here.


SALES REGISTER

GST Billing-Software for Distribution,Retail and Manufacturing

1- Select configure , you can create new reports as your needs.

2- Tick the given fields based on the report you need to generate.

3- Give a name for report , if the generated report is used in future.

4- Save report.

5- Shown the report name, select the report name and press enter key.

6- Here, fill the fields for filtering the reports-> and then click on ‘Generate Report’ .

7- View

 → view the report.

 → Export report to excel.

 → Print report.

GST Billing-Software for Distribution,Retail and Manufacturing


STOCK FLOW

GST Billing-Software for Distribution,Retail and Manufacturing

Select report date range.

1- List all reports under stock flow report. ie.;

 ⋇ Closing stock

 → Closing stock report and its value calculated based on the average landing cost.
  Here, we can identify the case qty, free qty and damage stock separately.

 ⋇ Stock flow

 → Inward and outward qty and its value displayed.

 ⋇ Stock ledger

 → Select the report generating period and then select item and press enter key,
  for generating transactions and quantity under the selected item (qty based on the pcs).

 ⋇ Supplier wise stock

 → Report generated based on the supplier. Here, displayed all items under the selected supplier
  and its total sale and available stock.

 ⋇ Cl stock supplier wise

 → Supplier wise closing stock details and its stock value.

 ⋇ Godown wise stock flow and closing stock

 → Godown wise stock details displayed here. Mainly in those who used multiple godown in their
  firm.

 ⋇ Item wise profitability

 → For identifying item wise profitability, profit calculated based on the sales.

 ⋇ Non billed items

 → Listed the items that is not billed in the selected financial year.

 ⋇ Stock summary

 → Displayed all items and its stock summary.

 ⋇ Stock transfer summary

Closing stock report

GST Billing-Software for Distribution,Retail and Manufacturing

Stock Ledger

It shows all the transactions done under the selected item.

GST Billing-Software for Distribution,Retail and Manufacturing

Item wise profitability

GST Billing-Software for Distribution,Retail and Manufacturing

 ⋇ Report filtered using certain criteria’s;

 → Category wise.

 → Group wise.

 ⋇ View report.

 ⋇ Print report.

 ⋇ Refresh the screen.

 ⋇ Export report to excel.


EMPLOYEE INCENTIVE

GST Billing-Software for Distribution,Retail and Manufacturing

1- List of all the employee incentive report. Setting the incentives based on the item category.

 → Monthly incentives

 →Cash collection statement

 →Collection statement

 →Incentives bill wise

2- Generate the report.


LEDGER STATEMENT

GST Billing-Software for Distribution,Retail and Manufacturing

 ⋇ List all ledgers here – Select ledger from this list.

 ⋇ Show all transactions based on the selected ledger. It can be export and print.


FINANCIAL ACCOUNTING

GST Billing-Software for Distribution,Retail and Manufacturing

1- Select report date range.

2- Listed all reports based on the financial accounting ie.;

[ The given financial accounting reports is by default displayed for the current date , you may select the required date period as per your requirements.]

 → Day book

 → Cash book

 → Ledger Statement

 → Trial Balance

 → Profit and Loss

 → Balance Sheet

 → Month wise profit

 → Month wise profit summary

3- View the report

4- View the total debit amount and credit amount .

5- Export the report to excel.

6- Refresh the window.


STATISTICS

GST Billing-Software for Distribution,Retail and Manufacturing

1- Select the transaction is from;

 →Is Interstate

 → Is Branch

 →Is Form 4

 → Is Tax exempted

[It already set for customer/supplier when creating customer/supplier in masters] .

2- Turn on the button and select ledger for generate report based on ledger wise.

3- All transactions reports are listed here,

 → Sales

 → Purchase

 → Credit note

 → Debit note

 → Receipt

 → Payment

 → Journal

 → Manufacturing voucher

 → Stock Journal

 → Sales and Purchase summary

 → GRN status item wise

 → DEL note status item wise


PURCHASE REGISTER

Purchase register is also same as sales register.

GST Billing-Software for Distribution,Retail and Manufacturing


GST REPORTS

GST Billing-Software for Distribution,Retail and Manufacturing

1- To give date for generating report.

2- GSTR1 report including,

 ⋇ B2B Invoices

 → Details of invoices of taxable supplies made to other registered taxpayers.

 ⋇ B2CS Invoice Summary

 → Details of supplies made to consumers and unregistered persons of the following nature;
  a) Intra-state : any value
  b) Inter-State : Invoice value Rs 2.5 lakh or less.

 ⋇ HSN Summary

 → HSN wise summary of goods/services supplied during the tax period.

 ⋇ Credit Note Summary

 → Credit note issued to the registered taxpayers against invoice will be reported here.

 ⋇ Exempt Sales Summary

 → It shows the value of supplies made under the "Exempted "category.

 ⋇ Voucher Summary

   Details of various documents issued by the taxpayer during the tax period.

   → Nature of document given.

   → Invoice/document series start number.

   → Invoice/document series end number.

   → Total no of documents in this particular series.

   → No of documents cancelled in the particular series.

3- To refresh the screen.

4- Click on Export to CSV.

5- Click Ok.

6- List of other GST reports.

 ⋇ GSTR2 report including,

 → B2B Supplies

  ♦ Details of invoices of taxable supplies received from other registered taxpayers.

 → B2BUR Supplies

  ♦ Details of Inward supplies received from an unregistered supplier.

 → HSN Summary

  ♦ HSN wise summary of goods /services received during the tax period.

 → Credit note registered summary

  ♦ Credit notes issued by the registered supplier during the tax period but not added by him in his GSTR-1.

 → Credit note unregistered summary

  ♦ Credit notes issued to the unregistered supplier.

 → Exempt supplies summary

  ♦ Declare the value of supplies received under the Exempted category for the tax period.

 ⋇ GSTR 3B report including,

 → Outward supplies& reverse charge applicable purchases

 → Outwards inter-state supplies to unregistered dealers

 → ITC eligible inwards supplies

Note : GSTR1 & GSTR2 reports are saved in local disc C. It can be import to
    GST offline utility for generate JSON file.

 ⋇ Sales tax% wise

 → It contains GST% wise sales reports (CGST,SGST separately).

 ⋇ Purchase tax% wise

 → It contains GST % wise purchase reports (CGST,SGST separately).

 ⋇ CRN tax% wise

 → GST % wise Credit note report.

 ⋇ DBN tax% wise

 → GST % wise Debit note report.

Product Overviews