- Advanced Excel (using Excel beyond basic typing and calculations)
- Pivot Tables (automatically summarise large amounts of data—for example, total sales collected by each salesman )
- VLOOKUP/XLOOKUP (find information from another table—for example, enter a hawker’s/salesman’s name and automatically find his outstanding amount)
- SUMIFS (add numbers only when specific conditions are met—for example, calculate total collection from a particular hawker during a particular month)
- Filters (show only the information you want—for example, show only hawkers who have unpaid dues)
- Data cleaning (correcting duplicate, missing, wrongly entered or inconsistent data so the accounts remain accurate)
- Daily sales and collection entry (entering every day’s newspaper sales and the money received from salesmen/hawkers into Excel or accounting software)
- Hawker-wise outstanding/dues (maintaining a separate record for each hawker showing how much newspaper/product he received, how much he paid, and how much money he still owes you)
- Purchase and expense tracking (recording everything the business spends money on—newspapers, transportation, salaries, electricity, repairs, fuel, etc.—and keeping track of how much is spent)
- Bank reconciliation (matching your bank statement with your own records to make sure every deposit, withdrawal and payment is correctly recorded and finding any differences)
- GST/TDS basics, if applicable (handling basic GST-related records and TDS deductions/records when your business is legally required to do so; a CA can handle the more complicated compliance)
- Monthly profit/loss report (at the end of every month, calculating how much money the business earned, how much it spent, and whether you made a profit or loss)
- Inventory/returned newspaper tracking (recording how many newspapers were received, distributed/sold, and returned/unsold so you can see where the stock is going and how much is being wasted)
- Making automated Excel sheets/reports (creating Excel files where formulas automatically calculate things like sales, collections, outstanding amounts, expenses and profit when new daily data is entered)
- Basic accounting software such as Tally Prime (using accounting software to record sales, purchases, expenses, payments, receipts and other business transactions instead of maintaining everything manually in Excel)
Pay: ₹9,140.55 - ₹12,103.56 per month
Benefits:
- Flexible schedule
- Paid sick time
Work Location: Hybrid remote in Wazirganj, Uttar Pradesh 226001
