Accounting reports, stock value by location and pending lists
Trial balance, profit and loss, balance sheet, day book, cash and bank books and ageing. Stock value per shop and godown, and a summary of each shop's sales, margin and net. And the lists of what is still to deliver and receive.
PLANSFrom Growth
Built; not yet tried end to end at a customer.
The problem it solves
- The books are with the accountant, and the owner sees profit once a year.
- Each shop's profit is a guess, because stock and expenses are not split by shop.
- Stock value is known for the business as a whole, never for each godown.
- Orders wait undelivered and goods on order never arrive, and nobody has the list.
How it works
- Post bills, purchases, payments and stock as you work. Each bill, supplier bill and stock move carries its shop.
- Open Trade > Reports > Tax and Accounts > Accounting Reports, pick the report, the entity, the period and, if wanted, a shop. Show on screen, print or download Excel.
- Open Shop Summary for a period: one line per shop with opening and closing stock, purchases, sales, cost of sales, margin, expenses and net.
- Stock Value by Location gives the opening, in, out and closing of each item per shop and godown. The Location Stock Ledger shows every move behind it.
- Use Pending Deliveries and Pending Receipts each morning, and Sales, Order and Purchase Analysis for any grouping you need.
Everything it does
Accounting reports
- Trial balance: opening, debit, credit and closing per account for a period
- Profit and loss: income, cost of revenue, expenses and net profit
- Balance sheet on a date, with the profit not yet closed
- Day book; cash book and bank book with running balance
- Receivable and payable ageing: not due, 1-30, 31-60, 61-90 and over 90 days
- By entity and, where given, by shop; on screen, PDF or Excel
- Scale adds the full financial reports with drill-down, comparison and budget columns
Stock value by place
- Stock Value by Location: opening, in, out and closing per shop or godown and item for a period
- Location Stock Ledger: each move into or out of a place with cost, value and running balance
- Cost per Warehouse: each place's quantity, value and average cost
- Stock Cost by Location: one cost for the entity (to start with), or each shop and godown its own average
- Goods between shops show as in transit
Shop Summary
- For a period, one line per shop under one GST number
- Stock at the start and end, goods purchased, sent to and received from other shops
- Sales, cost of sales, margin and margin %, expenses and net
- Each shop has its own analytic account, made for you, so expenses booked with it count
- Entries without a shop on their own line
Analysis and pending lists
- Sales Analysis (groups by shop), Sales Order Analysis, Purchase Analysis
- Item Movement: done quantities by item and kind of move
- Pending Deliveries and Pending Receipts: not yet done, by kind
- Dues by Broker; GST Returns Data and GSTR-2B Match for India; Export Incentives in Scale
Who uses it
Trade ManagerReads the reports and shop summaries; checks pending lists.
OwnerCompares shops by margin and net, and sees the books without waiting for the accountant.
Trade AdministratorChooses one stock cost for the entity or a cost per place.
Where you use it
- Web: Trade > Reports (Trade Managers)
- The SmartMy Trade app: Today shows sales per shop, collections, dues and overdue for the owner. The app is built and in testing, not in the app stores yet
- Not in the app: the accounting reports and stock value reports
What you control
Settings
- Stock Cost by Location: One cost for the entity (to start with), or Each warehouse its own cost
- Own invoice number series per shop: Configuration > Shops and Parties > Shops and Godowns > the shop
Works with
SmartMy Tally connectorKeep the books in Tally as well: posted invoices and payments go to Tally.
Questions
Can I see profit for each shop?
Yes. Shop Summary gives sales, cost of sales, margin, expenses and net per shop for any period. Profit and loss can also be filtered by a shop.Can each godown carry its own cost?
Yes. Set Stock Cost by Location to each warehouse its own cost. Transfers then move value at the sender's average.Can I take the reports to Excel?
Yes. The accounting reports print or download as Excel; the analyses export from their lists.Who can open the reports?
The Trade > Reports menu is for Trade Managers.Related features
ACCOUNTINGFull accounting with GST returnsEvery bill, return, receipt, supplier bill and cheque posts into your books as you work, with the shop on each bill. Growth adds accounting reports by shop. Scale adds the full accounting screens and Financial Reports, from ledgers to cash flow and consolidation, with GSTR-1 and GSTR-3B for India.BILLING AND STOCKSeveral godowns, racks and transfers between shopsKeep stock in as many shops and godowns as you have, down to the rack and bin. Stock sent from one place to another leaves on a delivery, stays in transit at its value, and arrives on a receipt. What never arrives is written off as short on the transfer.GST AND APPROVALSGSTR-1 and GSTR-3B data, GSTR-2B match and bill of supplyFor Indian entities: a month's GSTR-1 sheets and GSTR-3B summary as one Excel workbook for your accountant. Match the GSTR-2B against your supplier bills, and print bills of supply as a composition dealer.CUSTOMERS, BROKERS AND REPORTSEach shop's staff see their own shopGive each user the shops and godowns they work in. Their list of bills and returns, and the goods coming in and going out, then show only those places. Trade Managers, and users given no shop, see every shop.ACROSS SMARTMY TRADEDashboardsSmartMy Trade opens on a ready dashboard: sales, what customers owe, supplier bills overdue and shop days not closed. It shows sales by day and your top customers. The owner's phone opens on Today: each shop's sales, collections, dues and low stock.WITH OTHER SMARTMY PRODUCTSBooks in Tally with the SmartMy Tally connectorBill, collect and keep stock in SmartMy Trade while your accountant keeps the books in TallyPrime. Every posted bill, credit note, supplier bill, receipt and payment goes to the Tally company by itself, through SmartMyTally on your office PC. Each party lands on its own ledger, the way your books keep them.
See your shop on it.
Tell us what you sell, how many shops and godowns you run and how you bill today. We will set up your items and parties with you and print your first bill.