---
title: "Retail Daily Cash Count and Monthly P&L · BuiltByEstrada"
description: "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…"
url: "https://builtbyestrada.ai/products/retail-cash-count-pl/"
lang: "en"
---

# 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](mailto:hello@builtbyestrada.ai) within 30 days of purchase and we refund you in full.

Retail-Cash-Count-and-Monthly-PL.zip SCREENSHOTS · full version

  [![Retail Daily Cash Count and Monthly P&L: the Cash count tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/retail-cash-count-pl/1-720.webp)](https://builtbyestrada.ai/img/products/retail-cash-count-pl/1-1440.webp)

Cash count: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/retail-cash-count-pl/1-1440.webp)

  [![Retail Daily Cash Count and Monthly P&L: the Daily sales tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/retail-cash-count-pl/2-720.webp)](https://builtbyestrada.ai/img/products/retail-cash-count-pl/2-1440.webp)

Daily sales: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/retail-cash-count-pl/2-1440.webp)

  [![Retail Daily Cash Count and Monthly P&L: the Expenses tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/retail-cash-count-pl/3-720.webp)](https://builtbyestrada.ai/img/products/retail-cash-count-pl/3-1440.webp)

Expenses: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/retail-cash-count-pl/3-1440.webp)

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

## What you do, what the sheet does

YOU THE SHEET

You count bills and coins It totals dollars and pesos and converts pesos at your rate

You type the day's sales It shows expected cash and over or short

You pick a category for a bill It lands on the right P&L line

You pick a month Gross 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.