A gas station daily sales report template pulls fuel volume, in-store revenue, payment totals, cash counts, and inventory readings into one spreadsheet so the numbers reconcile before the shift ends. Most operators build around five sections: fuel sales, convenience store revenue, payment reconciliation, cash handling, and inventory. Formulas do the math, consistent cell placement forces clean data entry, and discrepancies surface the same day they happen instead of weeks later.
What to Gather Before You Open the Spreadsheet
The report is only as reliable as the raw numbers going in. Pull these figures from the pumps, the POS, and the drawer before you type anything:
- Opening and closing nozzle readings for each fuel grade (regular, mid-grade, premium, diesel). The difference is gallons dispensed.
- Posted price per gallon for each grade. If price changed mid-shift, capture both prices and the meter reading at the changeover.
- POS category totals broken out by tobacco, alcohol, lottery, general merchandise, prepared food, and packaged food and beverage. Different tax rates apply to restricted items, and separating them now saves work at tax time.
- Non-merchandise revenue: car wash, ATM surcharge income, and lottery. For lottery, record gross ticket sales and payouts separately so net commission calculates cleanly.
- Payment method totals from the POS: cash, credit, debit, fleet cards, mobile payments, and EBT/SNAP.
- A physical count of every bill and coin in the register drawer and safe.
If a fuel delivery came in that day, get the bill of lading from the driver and compare it against your automatic tank gauge readings taken immediately before and after the drop. When the numbers don’t match, have the driver note the discrepancy and sign off before leaving. Catching a delivery shortage at the pump island is far easier than untangling it a week later.
Building the Fuel Sales Section
Fuel is the backbone. Set up one row per grade with columns for opening meter reading, closing meter reading, gallons sold, price per gallon, and gross revenue. Two formulas do the heavy lifting:
- Gallons sold:
=ClosingReading-OpeningReading - Gross revenue:
=GallonsSold*PricePerGallon
Below the per-grade rows, add a total row that sums all gallons and all fuel revenue. That total feeds the daily sales summary and also anchors the monthly underground storage tank reconciliation.
Why Fuel Volume Tracking Matters Beyond Revenue
Federal EPA regulations require gas stations to perform daily measurements of tank contents and reconcile those measurements against sales and delivery records at least once every 30 days. If the difference between measured inventory and calculated book inventory exceeds 1 percent of the tank’s total throughput plus 130 gallons, the tank may be leaking and requires further testing.1U.S. EPA. Release Detection for Underground Storage Tanks – Internal Methods
The daily report feeds directly into that reconciliation. Accurate gallon counts from pump readings, combined with delivery volumes from bills of lading, form the book inventory side of the equation. Sloppy daily numbers make the monthly reconciliation unreliable, which means you could miss a real leak or fail regulatory scrutiny.
A useful add-on column multiplies gallons sold by the applicable federal excise tax rate (18.4 cents per gallon on gasoline, 24.4 cents on diesel) to give a running estimate of excise liability reported quarterly on Form 720.2Office of the Law Revision Counsel. 26 USC 4081 – Imposition of Tax3Internal Revenue Service. About Form 720, Quarterly Federal Excise Tax Return
Convenience Store and Non-Fuel Revenue
The in-store section should mirror the POS category structure. At minimum, give separate rows to tobacco, alcohol, general merchandise, prepared food, packaged food and beverages, and services like car wash. Sales tax rates vary by product type, and cigarette excise taxes alone range from under $0.20 to over $5.00 per pack depending on the state.
If the station accepts SNAP/EBT, those transactions need a dedicated row. SNAP-eligible items are tax-exempt, and commingling them with taxable sales creates reconciliation problems. The POS should already flag EBT separately; the template just needs a home for the total.
Lottery and Commission-Based Revenue
Lottery sales look misleadingly large because the gross ticket figure includes money that belongs to the state, prize payouts, and your commission. Record three numbers: gross ticket sales, total payouts made to winners, and net commission. The commission is what hits the income statement. Lumping gross lottery sales into general revenue inflates the top line and distorts margins.
Vendor Credits and Returns
When a distributor picks up stale bread, damaged merchandise, or unsold periodicals, they typically issue a credit memo. Add a row at the bottom of the in-store section for vendor credits received that day. Daily recording prevents the common problem of credits piling up untracked and never being verified against the next vendor statement.
Payment Reconciliation and Cash Handling
This is the section that catches problems. The template compares what the POS says you should have collected against what you actually have, broken out by payment type.
- Cash: total physical cash counted from register and safe, minus the opening bank. The result is net cash intake.
- Credit and debit cards: the batch total from your processor, which should match POS credit and debit subtotals. Differences usually mean a transaction was voided at the register but not reversed with the processor, or vice versa.
- Fleet cards: fuel-only cards like Comdata or WEX settle through separate networks and need their own line.
- EBT/SNAP: settles through the state’s EBT processor, not your card terminal.
- Mobile payments: loyalty and branded fuel apps may settle differently than standard card transactions.
At the bottom, one formula does the reconciliation:
=ActualCashCollected-ExpectedCashSales
A positive number means you took in more than expected; negative means less. Small variances of a few dollars happen routinely from rounding and making change. Persistent shortages, or any single shortage large enough to notice, deserve investigation before the report is finalized.
Safe Drop Documentation
Most stations require cashiers to drop excess cash into a timed safe once the drawer hits a set threshold. Each drop should be logged with time, amount, and the employee who made the drop, verified by a second employee when possible. If end-of-day cash doesn’t add up, the drop log traces exactly when money moved and who handled it.
Margin, Shrinkage, and Drive-Off Tracking
Revenue alone doesn’t tell you whether the station is profitable. A gross margin calculation turns the template from a cash-tracking form into a performance dashboard:
=(Revenue-COGS)/Revenue
For fuel, cost of goods is what you paid per gallon on the last delivery multiplied by gallons sold. For in-store, the POS or inventory software should provide a daily cost-of-goods figure by category. Fuel margins are thin, often only a few cents per gallon after wholesale costs, which is exactly why daily tracking matters. A one-cent swing across thousands of gallons adds up quickly, and a shrinking margin over several days tells you to check whether wholesale prices have risen or a competitor is squeezing you.
Shrinkage Benchmarks
Industry benchmarks put convenience store shrinkage at roughly 2 to 4 percent of sales and fuel-side shrinkage at 1.5 to 3 percent. Causes range from cashier errors and shoplifting to delivery shortages and meter drift on aging dispensers. Tracking daily gives you a baseline; a sudden jump above the baseline is where investigation starts.
Fuel Drive-Off Log
When someone pumps and leaves without paying, the loss needs to be documented. Create a drive-off section capturing date and time, pump number, gallons stolen, dollar value, vehicle description and plate if available, and whether surveillance footage exists. The log supports the police report you file and provides an auditable record that explains a portion of the day’s cash shortage.
Monthly Tank Reconciliation
Daily gallon counts feed the monthly inventory reconciliation required by EPA rules. Each day, record the tank gauge stick or automatic tank gauge reading alongside the calculated book inventory from sales and deliveries. At month’s end, compare cumulative measured inventory against cumulative book inventory. Variance beyond 1 percent of throughput plus 130 gallons triggers further investigation, including a tank tightness test.1U.S. EPA. Release Detection for Underground Storage Tanks – Internal Methods Keep the reconciliation records for at least three years.
Formulas and Conditional Formatting Worth Adding
A handful of formulas turn a static entry form into a tool that flags problems automatically:
- Gallons sold per grade:
=ClosingReading-OpeningReading - Fuel revenue per grade with a SUM totaling all grades:
=GallonsSold*PricePerGallon - Cash over/short:
=ActualCashCollected-ExpectedCashSales - Gross margin:
=(Revenue-COGS)/Revenue, applied to fuel and in-store categories separately - Estimated federal excise tax:
=TotalGasGallons*0.184 + TotalDieselGallons*0.244, with your state per-gallon rate added on
Conditional formatting is the most underused feature in daily report templates. Set the cash over/short cell to turn green when it’s within a few dollars of zero and red when it exceeds a threshold. Set the fuel shrinkage cell to turn yellow above half a percent. The report then actively alerts the manager instead of burying the problem in a column of numbers.
Employee Shift Line
Tie each report to a specific shift by capturing employee name, clock-in and clock-out times, and any breaks taken. Federal law requires employers to keep daily and weekly hours worked and the regular hourly rate for every non-exempt employee, with payroll records preserved for at least three years and time cards for two.4U.S. Department of Labor. Fact Sheet 21 – Recordkeeping Requirements Under the Fair Labor Standards Act If employees receive tips, anyone collecting $20 or more in cash tips during a calendar month must report those tips to you by the tenth of the following month, and you’re responsible for withholding Social Security, Medicare, and income taxes on them.5Internal Revenue Service. Topic No. 761, Tips – Withholding and Reporting A tip line on the daily report makes the paper trail simple.
What Never Goes in the Spreadsheet
A daily sales report holding credit card batch totals, employee data, and bank deposit details is a target. Two rules prevent most problems.
Never store full credit card numbers, card verification codes, or PINs anywhere in the template. PCI Data Security Standards flatly prohibit merchants from retaining that data after a transaction is authorized.6PCI Security Standards Council. PCI Data Storage Dos and Donts Keep only batch totals and transaction counts. If cardholder names or truncated account numbers appear for any business reason, encrypt them.
When emailing reports to an owner or accountant, use a password-protected file or secure file-sharing rather than an unencrypted attachment. For cloud archiving, look for a provider that has completed a SOC 2 audit.
Saving, Naming, and How Long to Keep the Files
Once the spreadsheet is finalized, save it with a consistent naming convention that includes the date and station identifier, like DailySales_Station42_2026-07-15. Six months later, when an auditor asks for a specific day, a consistent file name is the difference between finding it in seconds and digging through a cluttered folder.
Federal tax law requires every business liable for tax to keep records sufficient to show whether tax is owed.7Office of the Law Revision Counsel. 26 US Code 6001 – Notice or Regulations Requiring Records, Statements, and Special Returns The IRS uses a sliding scale for how long to hold on to them:
- Three years: general statute of limitations for assessing additional tax after a return is filed.
- Four years: minimum for employment tax records and excise records supporting Form 720 claims.
- Six years: applies if you fail to report more than 25 percent of gross income.
- Seven years: applies to claims involving bad debt deductions or worthless securities.
The safe approach is to keep daily reports for at least seven years. Back them up to both a cloud service and a local external drive, and check periodically that the backups actually open.