Reports

GSTR-1, GSTR-3B and GSTR-2, HSN summaries, e-invoice exports and the monthly GST totals. 9 reports.

1. GSTR-3B The GST on your purchases and on your sales for a month, by trading account and rate, with the balance of input tax and the bills behind every line. 9A
2. GSTR-1 Your sales for a GST return period split into the GSTR-1 tables, with HSN summary, credit and debit notes, and the filing JSON and Excel for a whole month. 9B
3. GSTR-2 Your purchases for a GST return period in the GSTR-2 tables, by supplier GSTIN, with HSN, returns, credit and debit notes received, and a supplier summary. 9C
4. GST Sales/Purchase Details Every item line of your sales, purchases, sales returns or purchase returns in a period, with units, price, amount before GST, CGST, SGST, IGST and the total. 9I
5. HSN Stock Statement The goods you sold in a period, item by item with their HSN codes, units, taxable amount, CGST, SGST and IGST, and the totals of each HSN code. 9E
6. TCS / TDS Statement Credit sales to each customer, or credit purchases from each supplier, in a period, with TCS or TDS worked out at the rate you type for parties above an amount. 9G
7. Invoice Series Status For each GST bill series, the first and last number used in a period, how many numbers that covers, how many documents were issued and how many are missing. 9F
8. GST Monthly Totals Purchases and sales by month: taxable value, CGST plus SGST and IGST on each side, returns and credit notes taken off, and each month's GSTR-3B one key away. 9H
9. GST E-Invoice Export The B2B sale lines of a period, with each buyer's pincode and place of supply checked, and an Excel worksheet of 70 e-invoice columns made from them. 9D

Ledgers, cash and bank books, day books, trial balance, trading and profit and loss account, balance sheet. 23 reports.

1. Ledger Every posting of one account for a period, with the other account, the narration and a running Dr or Cr balance, from opening balance to closing balance. 4K
2. A/c Copy One account's statement for a period, every posting including nil ones, with its narration and a running Dr or Cr balance. Print it for a customer or supplier. 4D
3. Cash Day Book The day book of money received and paid: cash and bank-paid sales added up, cash vouchers, other vouchers, and each day's opening, total and closing balance. 4T
4. Cash Book Every receipt and payment of the cash account for a period, day by day, with each day's total and closing balance, from opening to closing cash. 4B
5. Bank Book Every deposit and withdrawal of one bank account for a period, with the other account, cheque or transfer number and narration, from opening to closing balance. 4P
6. Journal The journal vouchers of a period, each leg with its account, credit or debit and narration, under each day's heading, to review transfers and adjustments. 4C
7. Trial Balance Every account's debit or credit balance for a period, grouped by account type, with opening balances and the period's debits and credits when you need them. 4E
8. Trading Account Opening stock, purchases, sales and closing stock as on a day, with the gross profit or loss balancing the sides, and a choice of how closing stock is valued. 4F
9. Interest Report Simple interest on an account's running balances, on each posting, or on many accounts at once, at rates you set, for checking and printing; it is never posted. 8B
10. Profit & Loss Statement Your expenses and other income as on a day, with the gross profit from the Trading Account, ending in the net profit or net loss. How each figure is worked out. 4G
11. Balance Sheet What the business owes and owns as on a day, with customers and suppliers as sundry totals, closing stock and the year's profit or loss, tallied on both sides. 4H
12. Balance Sheet (Grouped) The balance sheet drawn from your account groups, in three views (by account type, by group with schedule numbers, or group by group). 4I
13. Receipts/Payments List Cash received from, or paid to, each customer, farmer and supplier in a period, one line per account with its total, for a minimum amount and in any order. 4N
14. A/c Position What makes up one account's balance as on a date, with goods delivered but not billed, cheques not yet cleared and rate differences each on its own side. 4O
15. Multi Ledger The ledger of every account of a category or salesman, or of accounts you pick, one after another with opening, running balance, totals and closing balance. 4J
16. Consolidated Ledger One party's statement over the books of several years or companies, with the openings carried between years, a running balance and the closing balance. 4M
17. Consolidated Interest Simple interest on one party's balances or bills across the books of several years or companies, at rates and credit days you choose, for checking and printing. 4Q
18. Consolidated Outstanding What every linked customer and farmer owes over the books of several years or companies, by area, with the interest on the balance and the total due. 4V
19. Cash Balance Breakup The cash account's opening balance, receipts, payments and closing balance for each day with cash movement, or each month, with a total for the period. 4L
20. Category wise Ledger One account's bills, returns and notes of a single item category, such as fertilizers or pesticides, with a balance that starts at nil for the period. 4R
21. Sales Ledger A sales account's ledger as one line for each day, with the opening balance, the day's sales added up, journal entries one by one and a running balance. 4S
22. Bills Day Book Each day's bills on credit, returns and credit and debit notes in bill order, with a day's credit sales added up by account and a total for every day. 4U
23. 4 Col Day Book One page for every day's money and postings in four columns, Receipts, Credit, Debit and Payments, with the cash opening, total and closing balance of each day. 4A

Stock statements and ledgers, batch and godown stock, department forms and closing stock valuation. 34 reports.

1. Company Price List Your items' sale prices under their companies: the price including GST, the price before GST where you have recorded one, and the MRP, for printing or export. 3I
2. Stock Ledger One item's stock for a period, with its opening stock, every purchase, sale, return and damage with the balance after it, and the closing stock. 5A
3. Products & Technical Names Your items with closing stock on a date, your product groups with technical names, or your items with technical names and M.R.P., for checking or printing. 3M
4. Stock Board The stock of every item on a date, alphabetically, under manufacturers or under technical names, in units and in litres or kilograms, with MRP. 5B
5. Stock Statement Opening stock, purchases, sales, returns, damage and closing stock of every item for a period, in units, litres, kilograms or tonnes, with grouping. 5C
6. Sales Statement What you sold, item by item, in a period, with units, average net and sale rates and values, and the bills behind each line, by item, customer or manufacturer. 5E
7. Purchase Statement Items bought in a period with units, average net price and value, the bills and supplier behind each line, and goods received before the bill. 5F
8. Group Wise Stock Statement Opening, purchases, sales, returns and closing stock of each item group, with all its packings added up in litres, kilograms or tonnes. 5G
9. Stock Daily Movement The items that received or issued stock in a period, with opening, inward, outward and closing stock, and under each item its sources (party, bill and batch). 5H
10. Form X Print Form X, an insecticide dealer's self certification that the prescribed registers are kept, with signatory, premises, place and date from company details. 5N1
11. Appendix B The insecticide-wise register of receipts and sales with registration number, manufacturer, supplier, batch, dates and bills, as the Insecticides Rules ask. 5N3
12. Form N Stock Register Form N, the day-by-day stock register for each item: opening, received, issued and closing quantity, with the supplier and bill of the day's purchase. 5N4
13. Department Stock Statement Every item's technical name, trade name, manufacturer and packing with its opening, inward, outward and closing stock for a period, printed as the Stock Report. 5N5
14. Retail Stock Register The day-by-day stock register of retail bills only: opening, purchases, returns, sales and closing for each item, with the supplier and bill of each purchase. 5O
15. Sale Ara Each day's sales product by product with bills, units, net price and amount, and the day's cash and credit sales with GST; purchases and returns by party. 5P
16. Batch wise Sales Every sale of each batch of a product, village by village or customer by customer, with date, bill, units and batch; the tool for tracing a recalled batch. 5T
17. Stock Register The date-wise stock register of every item: opening, receipts, sales, returns and closing for each day, with supplier or customer, bill, batch and dates. 5U
18. Stock Verification Lists the purchase or sale bill lines priced more than 10% above or below the item's price in your stock setup, to catch a wrong rate or the wrong item. 5V
19. Dealer wise Purchases / Sales The value of purchases from each supplier or sales to each customer for a period, with the party's GST number and bill count, or a detailed list of its bills. 5W
20. Purchase Returns Statement Every item you sent back to suppliers in a period, grouped by supplier or item, with units, price and amount, and how SimplyERP works each figure out. 5L
21. Sales Returns Statement Every item customers returned in a period, by customer, with units, price and amount, and each return matched to the sale it came from. 5M
22. Bank Stock Statement The stock you hold on a date, valued item by item for your bank, with marking up to the amount the bank asked for and a print with the borrower's declaration. 5D
23. Packing Wise Stock The stock of every item you hold on a date, grouped by pack size, by manufacturer or by technical name, with how SimplyERP works out the quantities. 5I
24. Tech. Stock Statement A category's stock by technical name and company, with opening, inward, outward, closing and cumulative sales, or by company with sales to dealers and farmers. 5J
25. Stock Statement (Values) Every item's opening, purchases, sales, returns and closing stock with their values and the gross profit, and how SimplyERP values each figure. 5K
26. Stock Statement with Source A category's stock for a period, addressed to a bank or an officer, with the purchase bills and returns the receipts come from. Columns, choices and figures. 5R
27. Fert. Stock Statement Opening stock, purchases and sales before and during a period, and closing stock of every fertilizer item, with a view by technical name in tonnes. 5S
28. Group Wise Net Purchases Litres or kilograms purchased, returned to suppliers and net for each product group of a category, with or without the opening stock, for a period. 5X
29. Fertilizer Stock & Sales Register Opening stock, receipts, sales, returns, adjustments and closing stock of each fertilizer in bags and metric tonnes, printed for the agriculture officer. 5Y
30. Godown Stock Board How many units, litres or kilograms of each item each godown holds on a date, with stock not placed in any godown shown as Unassigned. 5ZA
31. Wholesale / Retail Stock Movement Opening, inward, transfers, outward and closing stock of each item in the wholesale or retail pool, in units or tonnes, for dealers with both licences. 5ZB
32. Closing Stock Statement The stock you hold on a date and what it is worth, item by item, valued from the purchases it came from, by GST rate or at cost, with or without GST. 5Q
33. Closing Stock Valuation Each item's stock on a date with its rate, value and the purchase layers it is valued from: the closing stock the Trading Account and Balance Sheet carry. 5ZC
34. Account Wise Stock Movement Every item bought from, sold to or returned by one customer or supplier in a period, bill by bill or totalled by item, in units, litres or kilograms. 5ZD

Sales and purchases by day, bill, product group, customer and supplier, with rates and discounts. 14 reports.

1. Day to Day Sales What you sold each day of a period, split into credit, cash and card or wallet sales, with or without GST, and the same days rolled up by month. 6A
2. Sales Analysis Units sold, net amount and average price of each product in a period, with HSN code, narrowed to cash or credit bills and registered or unregistered customers. 6B
3. Bill wise Analysis [Sales] Every sale bill of a period under its day, with its customer, city and bill amount, narrowed by series, GST, payment and category, and the day totals. 6C
4. Product Group Wise Sales What customers bought from one product group, pack by pack, with returns and totals, under each customer's area, in units or in kilograms and litres. 6D
5. Daily Sales Each day's sale bills of one product category in a period, with the account each bill was posted to, its amount and the day total, for wholesale or retail. 6G
6. Day to Day Purchases What you bought each day of a period, split into credit and cash purchases, with or without GST, with the purchase returns and the same days rolled up by month. 6H
7. Purchase Analysis Units bought, net amount and average price of every product in a period, with its HSN code, so you can see what your purchases came to by product. 6I
8. Bill wise Analysis [Purchases] Every purchase bill of a period under its day, with its supplier and bill amount, narrowed by series and category, with the day totals and the purchase returns. 6J
9. Product Group Wise Purchases What you bought from each supplier of one product group, pack size by pack size, with purchase returns and the net total, grouped by the supplier's area. 6K
10. Customer vs Product Sales What one customer bought from you product by product over a period, bill by bill, with their sales returns, in a summary by product or in product groups. 6E
11. Product vs Customer Sales Who bought one product over a period, each customer and farmer under their village, with units, litres or kilograms, the amount and the bill lines behind it. 6F
12. Pur.Analysis ( Disc. ) One supplier's purchases or returns line by line, with each bill's discount and charges shared over its products, and the net amount and net rate per unit. 6N
13. Supplier vs Product Purchases What you bought from one supplier product by product, bill by bill, with the purchase returns you made to them, in a summary by product or in invoice order. 6L
14. Product vs Supplier Purchases Which suppliers supplied one product over a period, each supplier under their village, with units, litres or kilograms, the amount and the bill lines behind it. 6M

Outstanding and ageing, monthly sales and receipts, near expiry stock, registers and confirmations. 34 reports.

1. Customer vs Product Group Sales Each customer's net quantity of every product group, in litres or kilograms or units, with their turnover in those groups, under each area. 7H
2. Batch Wise Stock The stock in hand of every batch with its manufacturing and expiry dates: filter by category, expiry range and quantity, and list batches gone below zero. 7S
3. Tech/Group Monthly Sales The litres or kg sold of each product group or technical name, month by month from April to March, with each row's total. 7I
4. Creditors/Debtors St. The balance of every customer, supplier and farmer on a date, as a debit or credit, with a creditors statement, a debtors statement and a balance limit. 7A
5. Product Monthly Purchases The units bought of each product from your suppliers month by month, less purchase returns, or litres and kilograms by product group. 7J
6. Customer Monthly Sales The sales to each customer month by month from April to March, in rupees with GST, grouped by area or by representative, with returns taken off. 7M
7. Customer Outstanding What each customer owed at the start of a period, the debits and credits in it and what they owe now, grouped by area, with a closing-balances-only summary. 7B
8. Book Debits Each debtor's balance with the date of their last posting, split into balances booked within a number of days and older ones, to see who has gone quiet. 7L
9. Sales Register Every product line of your sales bills in the period, grouped by customer, with the quantity, the price, the amount and the total of each bill's lines. 7ZB
10. Out.St. [A/c Grp] The debit or credit balance of every account in each account group on a date, with a total for each group, for example a delivery route or a class of suppliers. 7P
11. Purchase Register The products you bought from each supplier in the period, with the quantity and the amount, grouped by supplier and company, with each company's total. 7ZC
12. Out.St. [Grp/Sl.Man] What the dealers or the farmers owe, grouped by the representative who looks after them and then by area, with opening, debits, credits and closing balance. 7Q
13. Representative Sales The sales, returns and net sales of each product to the customers of one representative, by customer or as a product summary, in units or litres and kg. 7ZD
14. Company Wise Turnover The credit sales, sales returns and net turnover of one company's products to each customer, with the bills under each customer when you want them. 7ZE
15. List of Customers The customers and farmers in your books with their city, GSTIN and any licence numbers recorded, in name, account-type or area order, for printing or export. 8O
16. Out.St. Detailed Each customer's balance worked out from the period's sales, cash and bank receipts, sales returns and other entries, grouped by area or totalled month by month. 7U
17. Group Wise Batch Sales Every sale of one product group in the period, with the customer, bill, packing, units and the batch, expiry and manufacturing date of each line. 7ZF
18. Supplier Outstanding What you owe each supplier by area for a period, with opening balance, debits, credits and closing balance, and the suppliers you have paid in advance. 7V
19. Category wise Out.St. What each customer was billed in the item categories you choose, by area or representative, with the opening balance and the period's debits and credits. 7W
20. Bill Ageing How old each customer's, supplier's or farmer's unpaid bills are, in five age ranges as on a date, with payments settling the oldest bills first. 7G
21. Cust./Supp. Analysis One customer's or supplier's statement for a period, with the items of each bill, the amount posted and the running balance from the opening balance. 7C
22. Outstanding with Interest Each customer's and farmer's outstanding balance with simple interest on its daily balance at a rate you choose, by area, to see what late payment is worth. 7Y
23. Purchase Due Dates Purchase bills with their due dates and credit days, for one supplier over a period or for every supplier on one date, so you know what to pay and when. 7ZA
24. Rate Difference Statement Every stock line billed with one customer or supplier, with the bill price, the price agreed and the difference in rupees, to claim or give a rate difference. 7D
25. C.D. Statement One customer's bills settled oldest first by the customer's receipts, with the days each part took and the cash discount at the rate of its day range. 7X
26. Pending DC List Goods received on a delivery challan, or sent back on a return challan, that no bill has taken yet, by supplier, with the units and value still unbilled. 7E
27. A/c Confirmation List accounts with their balances for a period and print each marked account's statement with a balance confirmation letter and reply block to sign and return. 7ZH
28. Company Wise Analysis One company's trading statement for the year: opening stock, purchases from its suppliers, returns, notes, sales and closing stock, with the net value. 7O
29. Pur/Sales Analysis Each customer's sales, or each supplier's purchases, by company and product, with the net price, the actual price agreed and the difference, returns taken off. 7F
30. Purchase Analysis by Supplier Each supplier's purchases by company and product, with the bill, batch, dates, net price, amount and agreed price, and purchase returns taken off. 7K
31. Near Expiry Stocks Every batch you have bought with its batch number, manufacturing and expiry dates, earliest expiry first, so you can sell or return batches before they expire. 7R
32. Extra Discounts Every credit bill and return of the period that carries a discount, with gross and net amounts, the discount and the extra discount, by customer or supplier. 7T
33. Seed Stock Register The seed stock register by crop: each receipt with company, variety, lot and weight, each day's sales, and running opening, received, sales and closing stock. 7ZI
34. Monthly Receipts The money each customer paid you, month by month from April to March, grouped by area, with a total for each customer and for the period. 7ZG

Day Status, the bill and voucher registers, changed bills, the request log and the books’ own checks. 7 reports.

1. Cash and bank balances Each cash and bank account's balance and the bank total, with the issued cheques still pending, worked out from the running totals in your books.
2. Day Status Day Status shows the cash and bank balances, what customers owe and what you owe suppliers, today's sales and purchases, the day's bills and the stock alerts. 0
3. All Bills Find, open, mark and print the saved bills and notes of the financial year in SimplyERP, with each bill's party, place, tax and net amount. 1Y
4. All Vouchers Every receipt, payment, journal and non-GST note saved in the financial year, one line each, with its accounts, amount and narration, to find, open and print. 1BM
5. Changed Bills See every saved bill that was modified or deleted, when it was changed, and the bill as it stood before the change. 8S
6. Request Log See every change request the books handled: when it came, who sent it from which device, whether it was done, and what it created or changed. 8Y
7. Check Trial Balance Find the bills, notes and vouchers of the financial year whose debits and credits do not agree, or that post to an account that no longer exists. 8P