Income and work

Combining earnings from several delivery apps in one daily log

A daily log layout for delivery partners who work on several apps: one row per app per shift, with the formulas to total earnings by app and by month.

Editorial illustration for Combining earnings from several delivery apps in one daily log

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.

ColumnHeadingWhat to enter
ADateThe day of the shift
BShiftMorning, lunch peak, evening or night
CAppUse the same spelling every time
DOrdersNumber of deliveries
EBase payPer-order earnings before bonuses
FIncentivePeak, target or weekly bonuses
GTipsTips shown in the app
HCash collectedCustomer cash you hold for the platform
IHours onlineLogged-in time, including waiting
JTotal earnedFormula, 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?

  1. Fill the row at the end of each shift while the numbers are on screen.
  2. Copy from the app's own earnings screen, not from memory.
  3. Use one spelling for each app, since SUMIFS ignores capital letters but treats a stray trailing space as a different name.
  4. Add a row even for slow shifts, so hours and earnings stay paired.
  5. 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
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports