BuiltByEstradaBook a call

Retail Daily Cash Count and Monthly P&L

Retail and Auto line

Count the drawer by bill and coin in dollars and pesos, with pesos valued at the rate you post. Log each day's sales by payment type and see over or short. Log your bills by category and get a monthly profit and loss by prime categories: cost of goods, payroll, occupancy and operating, plus a 12 month view.

Excel and Google Sheets file, English and Spanish

Fare

$19

founding price until January 31, 2027 · then $30

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Retail-Cash-Count-and-Monthly-PL.zipSCREENSHOTS · full version
Retail Daily Cash Count and Monthly P&L: the Cash count tab, with EXAMPLE data
Cash count: tab with EXAMPLE data See the whole tab
Retail Daily Cash Count and Monthly P&L: the Daily sales tab, with EXAMPLE data
Daily sales: tab with EXAMPLE data See the whole tab
Retail Daily Cash Count and Monthly P&L: the Expenses tab, with EXAMPLE data
Expenses: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

What you do, what the sheet does

YOUTHE SHEET
You count bills and coinsIt totals dollars and pesos and converts pesos at your rate
You type the day's salesIt shows expected cash and over or short
You pick a category for a billIt lands on the right P&L line
You pick a monthGross profit, prime cost and net profit are added up

What the full version has

  • Cash count: 13 dollar lines and 12 peso lines, float, over or short, deposit, one printed page
  • Daily sales: cash, pesos, card, transfer and other, tax included, net sales, expected and counted cash, 400 days
  • Expenses: 500 bills with categories you can rename
  • Monthly P&L with gross profit, prime cost and net profit
  • Year view: 12 months side by side, with the share of sales paid in pesos
  • English file and Spanish file

Who it is for

Store owners who take dollars and pesos and want to close the drawer and know their monthly profit.

The days, expenses and store in the file say EXAMPLE. Delete them and add your own.

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.