If you deliver on more than one app, keep a single daily log with one row per app per shift, and add up everything from that one table. Each app has its own earnings screen and payout day, so memory fails quickly. One log lets you see total earnings, cash collected and hours in a single place.
What columns should the log have?
Use these ten columns in a spreadsheet, starting at row 2 under a header row. Keep dates as real dates, not text.
| Column | Heading | What to enter |
|---|---|---|
| A | Date | The day of the shift |
| B | Shift | Morning, lunch peak, evening or night |
| C | App | Use the same spelling every time |
| D | Orders | Number of deliveries |
| E | Base pay | Per-order earnings before bonuses |
| F | Incentive | Peak, target or weekly bonuses |
| G | Tips | Tips shown in the app |
| H | Cash collected | Customer cash you hold for the platform |
| I | Hours online | Logged-in time, including waiting |
| J | Total earned | Formula, see below |
Cash collected is not your earning. It is money you owe the platform, so it stays out of the total. Keeping it in its own column stops it inflating your day.
Which formulas do I need?
- Total earned for a row, in J2: =E2+F2+G2
- Earnings for one app in a month, with the month's first date typed in M1: =SUMIFS($J$2:$J$500, $C$2:$C$500, "App A", $A$2:$A$500, ">="&$M$1, $A$2:$A$500, "<"&EDATE($M$1,1))
- Total for a single day, with the date in L2: =SUMIFS($J$2:$J$500, $A$2:$A$500, L2)
- Earnings per online hour for the month: =SUMIFS($J$2:$J$500, $A$2:$A$500, ">="&$M$1, $A$2:$A$500, "<"&EDATE($M$1,1)) / SUMIFS($I$2:$I$500, $A$2:$A$500, ">="&$M$1, $A$2:$A$500, "<"&EDATE($M$1,1))
These work the same in Excel and Google Sheets. Change the 500 to a larger number if your log grows past that.
What does a real day look like in the log?
Hypothetical day, 14 March: a morning shift on App A with 9 orders, ₹540 base, ₹120 incentive, ₹40 tips, ₹1,150 cash collected and 3.5 hours online. An evening shift on App B with 11 orders, ₹660 base, ₹200 incentive, ₹0 tips, ₹800 cash and 4 hours.
Totals earned: 540 + 120 + 40 = 700 for App A and 660 + 200 + 0 = 860 for App B, so 1,560 for the day over 7.5 hours, or ₹208 per hour. Cash held for platforms is 1,150 + 800 = 1,950, which is not yours.
How do I keep the log honest?
- Fill the row at the end of each shift while the numbers are on screen.
- Copy from the app's own earnings screen, not from memory.
- Use one spelling for each app, since SUMIFS ignores capital letters but treats a stray trailing space as a different name.
- Add a row even for slow shifts, so hours and earnings stay paired.
- Once a week, compare the week's total with the payout you receive, which is covered separately when you reconcile app payouts with bank credits.
When does a sheet stop being enough?
A log like this records earnings well, but the money you spend on fuel, phone recharge, parking and food sits in your bank and UPI statements. If you want those spends categorised alongside, SpendixAI can take statement uploads in PDF, CSV or Excel, and you can add cash expenses by hand. Keep the earnings log either way, because it carries the app-side detail that a bank statement cannot show.
Monthly review in five minutes
- Total earned by app for the month
- Earnings per online hour by app
- Cash collected and how much was handed over
- Best and worst shift types
- Anything missing compared with the app's month summary
Useful ideas start with a clearer picture of your own spending.
Explore your reports

