Free Daily Cash Report Template for Excel & Google Sheets

What is The Daily Cash Report?

A daily cash report is a record of every cash movement in your business on a given day: opening balance, money in, money out, the counted cash and the closing balance. It tells you at a glance whether the drawer and the bank are where they should be, or whether something needs attention before it becomes a problem.

Depending on who you ask, the same document goes by a daily cash sheet, a cash-up sheet, an end-of-day report, a cashier's report or a till reconciliation. When the focus is customer payments against invoices, it is called a daily cash collection report. When it covers every bank account and e-wallet, not just the drawer, it is a daily cash position report. Whatever the name, the daily cash report format is the same, and our daily cash report template builds all three from the same data.

Here is what a daily cash report is not. It is not a cash flow statement, which summarizes a whole month or year by operating, investing and financing activity. It is not a petty cash log, which only tracks small office spending from a cash box. And it is not a sales report, because a sale paid by card or GCash is revenue today but cash in your bank only when the payout lands.

Importance of the Daily Cash Report Template

It catches shortages the day they happen

A discrepancy found at close takes minutes to trace: the cashier remembers the customer, the receipt is still in the drawer, the camera footage is a day old. Found a week later, it often never gets explained. The ACFE's 2024 Report to the Nations reviewed 1,921 occupational fraud cases with total losses above $3.1 billion, and small businesses, where one person often handles cash from sale to deposit, are especially exposed.

It shows the cash you can actually spend

Your bank balance can include a check that has not cleared and miss a deposit still in transit. A daily cash report separates what you recorded from what is available, so you never pay a supplier with money that has not landed.

It builds the audit trail your accountant needs

Signed daily reports, filed with the POS Z-report and the deposit slip, are the source documents behind your cash book and your net cash flow for the month. Month-end becomes a review instead of a reconstruction.

Daily Cash Report Sample

Here is a filled daily cash report sample from our daily cash report template for Mabuhay Hardware & Construction Supply, a fictitious store in Quezon City, on October 27, 2026. Amounts are in Philippine pesos.

Look at the receipts row. The store took 82,588.43 on the day, but only 44,620.00 of it went into the drawer. The other 37,968.43 arrived by GCash, card and a customer check, so it is not in the till and never should be. The 150.00 short was traced the same evening to change given twice on a 1,000 note, written up and signed by the cashier and the supervisor.

What Does The Daily Cash Report Template Contain?

Most free daily cash sheets online give you two columns, cash in and cash out, and a total. That is not enough. It never compares the books with a physical count, so it cannot tell you the drawer is short, and it mixes cash with money that has not arrived yet. Here is every field our daily cash report template uses, and why.

If you add only one field to the sheet you use today, make it counted cash. Every other number on a daily cash report is something you typed. The count is the only figure that comes from the real world, and comparing the two is the whole point of the report.

What Our Daily Cash Report Template Includes

I reviewed the daily cash sheets, cash-up templates and cash position worksheets that rank for these searches before building this one. Each covered one piece, and none connected them. So our daily cash report template runs on one transactions list and builds every report from it.

One list that feeds every report. Log each movement once as In, Out or Transfer, against the account it touched. The daily report, the cash position, the collection report and the month log all read from the same rows, so they can never disagree with each other.

A count that argues back. Enter how many of each note and coin are in the drawer. The template totals them, compares the total with expected cash and returns Balanced, Over or Short. Anything bigger than your tolerance turns red and says "investigate".

A drawer that only sees cash. GCash, Maya, UPI, JazzCash, card and bank receipts count toward the day's sales but stay out of expected cash. This one rule removes the most common false shortage in small businesses.

An opening balance nobody can type over. Each day opens with the previous day's counted closing cash, carried automatically. A gap or an edited number shows up immediately instead of at month end.

Money that has not landed yet, kept separate. Mark a deposit, a customer check or a card payout as not cleared, and the cash position shows it apart from what is available to spend today.

A month you can read in one screen. The month log lists every day with receipts, expected cash, counted cash and over or short, plus a chart of cash and non-cash receipts.

Every format. The daily cash report template Excel file and the Google Sheets copy do the math with formulas only, no macros, and the transactions sheet doubles as a daily cash flow template. The Word file holds a printable cash-up sheet, the filled sample, blank position and collection reports, and a cash-up checklist.

Daily Cash Report vs. Cash Flow Statement

These documents all track cash, but they answer different questions, and confusing them is one of the most common mistakes in small business finance.

The rule: daily reports are the raw data, and the cash flow statement is the summary. If the daily records are clean, month end takes an hour. If they are not, it takes a week.

Cash Up Sheet: Counting the Till

A cash-up is the end-of-day routine that makes the daily cash report honest. Close the POS and print the Z-report, take the card slips and e-wallet confirmations out of the drawer, then count the cash by denomination. Expected cash is opening float plus cash receipts minus cash payouts. The difference between counted and expected is your over or short.

Count before you take the bank deposit out, then leave the same float every day. A fixed float, for example 5,000, makes the next morning's opening cash predictable and any overnight difference obvious.

What Is a Daily Cash Position Report?

A daily cash position report is a snapshot of the cash available to your business at the end of each working day, across the drawer, every bank account and every e-wallet. Where a daily cash report checks the till, a cash position report answers the owner's question: how much cash do we actually have right now?

The key is separating book balance from available balance. In the sample, the store's accounts closed at 861,394.13 on paper, but 60,013.50 had not cleared: a 43,200 deposit in transit, a 10,000 customer check and a 6,813.50 card payout. Available cash was 801,380.63. It also showed 40,300 in supplier checks issued but not yet presented, already deducted, so nobody spends that money twice.

Daily Cash Collection Report

A daily cash collection report lists every customer payment received that day, with the invoice it settles and how it was paid. Businesses that sell on credit, such as wholesalers, distributors and contractors' suppliers, use it to update receivables before the next morning's collection calls.

In the sample, three customers paid on October 27: 10,000 by check into the bank, 16,200 in cash and 14,600 by GCash, each tied to an invoice number. The cash one goes through the drawer; the other two never touch it.

How to Use The Daily Cash Report Template

1- Set Up Your Accounts Once

In Settings, add your business details, currency, the denomination set for your country (PHP, INR, USD, PKR or your own), your over/short tolerance and up to six accounts with opening balances. Account 1 is always the cash drawer. Add a "card settlements" account so card sales wait there until the bank pays them out.

2- Log Every Movement as It Happens

Add one row per receipt, payment or transfer. Choose the account the money went into or came out of, not just how the customer paid. This is what lets the template keep non-cash sales out of the drawer.

3- Record Customer Payments Against Invoices

Type the invoice number in the reference column for every customer collection. In the Philippines, where the invoice replaced the official receipt as the primary sales document in 2024, this is the number your bookkeeper will match.

4- Mark What Has Not Cleared

Set Cleared to No for checks you received, deposits you made and payouts you are waiting for. Switch it to Yes when they appear on the bank statement. Until then, they stay out of your available cash.

5- Count the Drawer Before the Deposit

At close, enter the quantity of each note and coin. Do it before removing the deposit so the count matches expected cash.

6- Explain Any Over or Short Before Leaving

If the status shows Short or Over, write the reason in the notes column the same evening. Never change a figure to make it balance. In the US, record and report any cash payment above $10,000 separately, because it may trigger Form 8300.

7- Deposit, Leave the Float, Print and Sign

Record the bank deposit as a transfer from the drawer to the bank, leave your standard float, then print the daily cash report, sign it with the supervisor and file it with the Z-report and deposit slip.

8- Review the Position and the Month Log

Check the cash position before approving payments, and review the month log every Friday. One short day is an incident; three on the same till is a pattern.

How to Make a Daily Cash Report in Excel

Wondering how to make a daily cash report in Excel or Google Sheets yourself? Here is the six-step daily cash report format in Excel our template uses.

1. Create a transactions table with Date, Type (In, Out, Transfer), Category, Account, Reference and Amount. Format it as a table (Ctrl + T) so formulas extend as you add rows.
2. Add drop-down lists with Data Validation for Type, Category and Account, so totals never break on a typo.
3. Total each day with SUMIFS: cash in = SUMIFS(Amount, Date, today, Type, "In", Account, "Cash drawer").
4. Calculate expected cash as opening cash + cash in - cash out, and link today's opening cash to yesterday's counted closing cash.
5. Add a denomination count with quantity times value for each note and coin, then over/short = counted - expected.
6. Flag variances with conditional formatting, for example red when the absolute over/short is above your tolerance.

That gives you the basic daily cash flow template in Excel most people search for, in a clean cash report format. The parts that take longest to get right, the uncleared items, the collection report and the month log, are already built in our free version.

How Enerpize Connects Your Daily Cash Report to Your Entire Operation

What if the daily cash report came from the sales and payments you already record, instead of a second spreadsheet someone fills in at 9 pm? That is how it works in Enerpize.

POS Sessions and Cash Management

Each Enerpize POS session is closed and validated by entering the manually counted cash, so the cash-up happens inside the system. Cash in and cash out are recorded against the register, along with the employee in charge, and customers can pay by cash, check, card or several methods in one transaction.

Treasuries, Payments and Expenses

Client payments, supplier payments, expenses and incomes are recorded against the treasury or bank account they touched, inside the same accounting software. Each treasury has its own page and ledger, so you can follow one drawer or one bank account on its own.

Financial Transactions Report

The Financial Transactions report lists every amount in and out for a period with a running balance after each one, a start-of-period balance and an end-of-period balance. It exports to Excel, PDF or CSV, so your accountant gets the same numbers you see.

The country rules in the next section still apply. Enerpize does not file Form 8300 or any tax return for you, but it gives you one dated, searchable record of every receipt and payment to report from.

Daily Cash Rules by Country

Philippines

Philippine businesses changed their paperwork in 2024, and the daily collection report needs to follow. Under the Ease of Paying Taxes Act, the invoice became the primary sales document for goods and services from April 27, 2024, replacing the official receipt for services, as KPMG Philippines summarizes from BIR's Revenue Regulations 7-2024.

What to add for Philippine businesses:

• The sales invoice number on every collection line
• GCash and Maya receipts as their own account, not as drawer cash
• Check numbers for customer checks, marked not cleared until they post

Practical note for Philippine businesses: semi-monthly payroll days pull large amounts out of the bank, so check the cash position on the 14th and the 29th before releasing supplier payments.

India

In India, the daily cash report doubles as a compliance check on cash limits. Section 269ST of the Income-tax Act bars receiving Rs 2 lakh or more in cash from one person in a day, for one transaction, or for one event, with a penalty equal to the amount received. Section 40A(3) disallows a business expense paid in cash above Rs 10,000 to one person in a day, as the Income Tax Department sets out.

What to add for Indian businesses:

• A daily check that no single customer paid Rs 2 lakh or more in cash
• Cash payments to one supplier above Rs 10,000 in a day moved to bank transfer or UPI
• UPI receipts logged to their own account, not the drawer

Practical note for Indian businesses: filter the transactions sheet by payee at close. It catches a split cash payment before it becomes a disallowed expense.

United States

US businesses that take large cash payments have a federal reporting duty on top of their own controls. A business that receives more than $10,000 in cash in one transaction or related transactions must file Form 8300 within 15 days, according to the IRS. Related payments from the same buyer within 24 hours are added together.

What to add for US businesses:

• The payer's name on every cash receipt above a few thousand dollars
• A note when one customer's cash payments add up over the day or the deal
• A copy of each Form 8300 filed, kept with that day's report

Practical note for US businesses: make the $10,000 check part of the cash-up, not something the accountant finds in April.

Pakistan

For Pakistani businesses, how you pay matters as much as what you pay. Section 21(l) of the Income Tax Ordinance, 2001 disallows a deduction for an expense above Rs 250,000 under a single account head that is not paid through the banking system, with exceptions such as utility bills and taxes. The current consolidated text is published by the Federal Board of Revenue.

What to add for Pakistani businesses:

• Large supplier payments logged from the bank account, never the drawer
• JazzCash and Easypaisa receipts as their own accounts
• A note of the account head for any cash expense near the limit

Practical note for Pakistani businesses: keep the bank transfer reference in the reference column. If an expense is ever questioned, the proof is already on the report.

Who Uses the Daily Cash Report?

Retail and Hardware Stores

Use it to reconcile the POS Z-report with the till at close. High volumes of small cash sales mean small errors add up, so the denomination count matters most here.

Restaurants and Hospitality

Dine-in, takeaway, delivery-app payouts and tips arrive through different channels and at different times. Logging each to its own account keeps delivery payouts from looking like missing cash.

Pharmacies and Clinics

Cash, card and insurance payments mix every day. A cash-up per shift with two signatures is the simplest control.

Wholesalers and Distributors

Most of their cash comes from collections, not walk-in sales. The daily cash collection report, with invoice numbers, is what feeds the next day's collection calls.

Accountants and Bookkeepers

Daily cash reports are source documents for month-end close and a foundational input in financial accounting. For a full-period view, pair them with an income and expense statement.

Daily Cash Report Best Practices

Reconcile the bank weekly, the drawer daily

Count the drawer every day, and match bank and e-wallet balances at least weekly with a cash reconciliation template, so cleared and uncleared items stay accurate.

Keep the float fixed

Leave the same opening float every day. When it changes, so does every comparison, and small gaps hide inside the noise.

Never adjust a number to make it balance

Document the variance, investigate and keep the record. Unexplained adjustments are how small differences become accounting errors that carry into every later period.

Archive signed reports

File each signed report with the Z-report and deposit slip by month. In a dispute, they are your primary evidence.

What to Do When Cash Is Over or Short

Work through the causes in this order. Start with the first two, because they are the easiest to miss.

1. Non-cash receipts logged as cash. A GCash, card or bank payment recorded against the drawer makes the drawer look short by exactly that amount.
2. Payouts not written down. A refund or a petty cash purchase taken from the drawer without a voucher.
3. Change errors on large notes. The sample's 150 short was change given twice on a 1,000 note.
4. Voids and duplicates. A sale rung up twice, or voided after the cash was taken.
5. Count errors. Recount before you escalate.

If the variance is still unexplained and above your tolerance, escalate the same day and keep the note with the report. Overages deserve the same attention as shortages, because an overage on one day is often a shortage on another that has not been found yet.

Key Takeaways

• A daily cash report template records opening cash, money in and out, the counted cash and the over or short for one day.
• Expected cash = opening cash + cash receipts - cash payments. Over / (short) = counted cash - expected cash.
• Only cash belongs in the drawer. GCash, UPI, card and bank receipts are sales, but not drawer cash.
• Count by denomination before taking out the bank deposit, and leave the same float every day.
• A daily cash position report shows what is available after uncleared items; a daily cash collection report ties each payment to its invoice.
• Country cash rules matter: Form 8300 in the US, Sections 269ST and 40A(3) in India, Section 21(l) in Pakistan, invoice numbering in the Philippines.
• Our free daily cash report template builds the report, the cash-up sheet, the cash position, the collection report and a month log from one transactions list.

FAQs

What is a daily cash report used for?

A daily cash report is used to record and verify every cash movement in a business on a given day. It captures the opening balance, money in and out, the counted cash and the closing balance, so managers can confirm the drawer is right and see the day's cash position without waiting for a bank statement.

What should a daily cash report include?

The date, till and cashier, opening cash, receipts and payments by category, expected cash, counted cash by denomination, the over or short with a reason, the bank deposit, closing cash, and two signatures.

Is a daily cash report the same as a cash flow statement?

No. A daily cash report is an operational document for one day, prepared by the cashier and checked by a supervisor. A cash flow statement is a formal financial statement for a full period, prepared by an accountant under GAAP or IFRS.

Can I use this template for multiple bank accounts or payment channels?

Yes. Set up to six accounts, such as the cash drawer, two bank accounts, an e-wallet and a card settlements account. The daily cash position report shows each account's balance and the total available.

How often should I update my daily cash report?

Every business day, at close. Log transactions as they happen, count the drawer at close, and print and sign the report before the cashier leaves.

What's the difference between a daily cash report and a petty cash log?

A daily cash report covers all money in and out of the business: sales, collections, supplier payments, wages and deposits. A petty cash log tracks only small office expenses from a separate cash fund. The petty cash total is one line on the daily cash report.

How do I create a daily cash book in Excel?

Create a table with date, description, reference, cash in, cash out and a running balance column, where each row's balance equals the previous balance plus cash in minus cash out. Add drop-down categories and a daily total with SUMIFS. Our transactions sheet works as a daily cash book for every account.

What is a cash up sheet?

A cash up sheet is the end-of-day form a cashier uses to count the till by denomination and compare it with the POS total. It records the opening float, cash sales, payouts, expected cash, counted cash, the over or short, and the cashier's and supervisor's signatures.

What causes cash over and short?

The most common causes are non-cash payments recorded as cash, refunds or payouts not written down, change errors on large notes, voided or duplicated sales, and simple count errors. Recount before escalating.

Can you provide an Excel template for a daily cash position report?

Yes. Our daily cash report template includes a daily cash position report sheet. Pick a date to see each account's balances, uncleared items and the cash available now.

About the Author

Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.

Disclaimer

This daily cash report template and guide are for general business use and are not tax, legal or accounting advice. The sample business and people are fictitious. Cash handling, reporting thresholds and record-keeping rules change and vary by country, so confirm them with the relevant authority or your accountant.