Daily Report in Google Sheets: Setup and Tips

A daily report in Google Sheets is easiest to maintain when you record each activity in a consistent log and show the day’s totals in a separate summary. Create an Activity Log tab, add a Daily Report tab with a date selector and key measures, then use formulas or a pivot table to summarize the entries.

What a daily report in Google Sheets is for

A daily report captures what happened during a particular day in a format people can review, compare, and update. Depending on the work, it might track completed tasks, customer inquiries, orders, production, incidents, staff coverage, or expenses. Google Sheets is useful for reports that need frequent updates or input from several people because collaborators can work in the same file in a browser.

A spreadsheet is not automatically a report just because it contains rows of figures. A useful report makes the reporting date clear, defines each measure, and distinguishes the underlying records from the summary. For example, a sales report might show the number of orders and sales value for a day, while a service report might show requests received, requests resolved, and unresolved cases. The right measures depend on the purpose; adding every available number can make the result harder to read.

Decide whether each daily report should remain as a permanent snapshot or update when the reporting date changes. A date-driven summary is convenient for checking different days, but it is not by itself an archive of what readers saw earlier. If a signed-off daily report must be preserved, save a dated copy or record an approved snapshot using your organization’s process.

Plan the log before building the summary

Start with one row per event, task, or transaction. Use a clear heading for each column and keep the meaning of a column consistent. A general-purpose activity log could use these fields:

Date: the date the activity occurred, entered as a real date rather than text.
Owner: the person or team responsible.
Category: a consistent label such as Sales, Support, or Operations.
Description: a brief explanation of the work or event.
Status: a controlled value such as Complete, In progress, or Blocked.
Amount: an optional numeric value, such as units, hours, or sales, with its meaning stated nearby.

Do not put a subtotal row between records if formulas or pivot tables will summarize the log; those rows can be mistaken for data. Avoid merged cells and blank separator rows inside the data area, too. If a task can have several updates, decide whether the log will store one row per task or one row per update. Mixing those approaches can make counts misleading: counting updates is not necessarily the same as counting distinct tasks.

Build a simple two-tab report

In a new Google Sheets file, rename the first sheet Activity Log and create another sheet named Daily Report. Put the column headings in row 1 of Activity Log and begin entering records in row 2. On Daily Report, reserve a clearly labeled cell for the reporting date, such as A1 for “Report date” and B1 for the date. Add a few summary labels below it, for example “Activities,” “Completed,” and “Amount recorded.”

Enter dates as dates, not strings that merely look like dates. If the sheet interprets an entry incorrectly, select the date column and use Format > Number > Date. Likewise, apply a suitable number or currency format to numeric measures rather than typing currency symbols into the values. Formatting changes how a value appears; keeping the underlying value numeric lets formulas add and compare it.

To help people enter consistent statuses, select the status cells and choose Data > Data validation. Set up a dropdown with the allowed values, then apply it to the range where future entries will go. A controlled list prevents variants such as “Done,” “done,” and “Complete” from being treated as separate categories. Freeze the headings with View > Freeze > 1 row, so column names remain visible while someone scrolls through a longer log.

Summarize the day with formulas

Here is a small example to check the summary logic. Assume Activity Log has dates in column A, statuses in column E, and amounts in column F. Rows 2–5 contain these records: April 14, 2026, Complete, 400; April 14, In progress, 150; April 14, Complete, 250; and April 13, Complete, 300. Put the actual date April 14, 2026, in Daily Report!B1. The examples below use open-ended ranges so new records below row 5 are included.

With dates in Activity Log!A2:A and the selected report date in Daily Report!B1, put this formula beside the Activities label. It counts three entries for April 14, 2026:

=COUNTIF('Activity Log'!A2:A,$B$1)

With dates in Activity Log!A2:A, statuses in Activity Log!E2:E, and the report date in B1, use this formula beside Completed. It returns 2 because two of that day’s entries have the status Complete:

=COUNTIFS('Activity Log'!A2:A,$B$1,'Activity Log'!E2:E,"Complete")

With dates in Activity Log!A2:A, amounts in Activity Log!F2:F, and the date in B1, this formula returns 800, the sum of 400, 150, and 250 for April 14:

=SUMIF('Activity Log'!A2:A,$B$1,'Activity Log'!F2:F)

These simple date matches assume column A contains dates without time-of-day values. If records contain timestamps as well as dates, a value such as April 14 at 9:30 a.m. is not equal to a date-only value in B1. In that case, use a start-of-day and next-day boundary. With timestamps in Activity Log!A2:A, statuses in E2:E, and the report date in B1, this formula counts completed records at any time on the selected date; it returns 2 for the example records if their dates are stored as midnight timestamps or dates:

=COUNTIFS('Activity Log'!A2:A,">="&$B$1,'Activity Log'!A2:A,"<"&$B$1+1,'Activity Log'!E2:E,"Complete")

Use the same boundary idea with SUMIFS if the amount total must include timestamped records. Check the column types and test a known date before relying on the result. Google Sheets uses the formulas shown here in a browser; Excel has similar functions, but menu locations, collaboration behavior, and some formula details can differ.

Make the report easy to scan

Put the reporting date and most important measures near the top. Use labels that explain both the measure and, where needed, its unit: “Units shipped” is clearer than “Total,” and “Open requests at close of day” is clearer than “Open.” Below the headline numbers, a small table can show results by category or owner. Add a chart only when it makes a comparison easier to understand; a chart of one day’s total may add little, while a seven-day trend can reveal a change.

Use Format > Conditional formatting to highlight useful exceptions, such as a status of Blocked or a value below a stated target. Choose colors with enough contrast and include text labels so color is not the only signal. Keep the data log and the presentation layer visually distinct—for instance, use one tab for entry and another for the summary—so users are less likely to overwrite a formula while adding a record.

For a report that needs grouped totals, select the source data and choose Insert > Pivot table. A pivot table can summarize records by date, category, or owner without writing a separate formula for every group. Make sure the source range includes the headings and future rows, or update its range as the log grows. A pivot table is a summary, not a replacement for clean source records; inconsistent category names still produce separate groups.

Choose a repeatable daily workflow

A reliable process is more important than elaborate formatting. Agree on who enters the records, when the day closes, which time zone or business-day cutoff applies, and who checks the summary. For work that crosses midnight, for example, decide whether an overnight shift belongs to the date it began or the date each event occurred. Write that convention in the sheet so different contributors do not make incompatible choices.

Enter each new activity as a separate row and use the approved category and status values.
Review dates, blank required fields, and numeric entries before treating the log as complete.
Set the report date on the summary tab and compare the displayed totals with a few source records.
Share the report with the intended audience and clearly identify whether it is final or still being updated.
Preserve a dated snapshot when the reporting process requires an immutable record.

When the report is used every day, duplicate a prepared template rather than rebuilding its layout. Check that formulas and formatting extend far enough for new rows, and consider protecting formula cells so routine editing does not replace them. Google Sheets offers protected sheets and ranges, but protection is intended to control editing, not to hide confidential data from people who can access the file.

Sharing, permissions, and common problems

Use the Share button to invite specific people and choose whether each person can view, comment, or edit. A link set to broader access may be convenient, but it should match the sensitivity of the contents and your organization’s sharing rules. Do not assume that hiding a tab or protecting a range makes its data private. If recipients only need a finished report, consider sharing a separate version containing only the information they are permitted to see.

A total that is unexpectedly zero often means the date in the log is text, the report date does not match, or the formula points to the wrong column. A count that is too high may mean duplicate rows or that the report is counting updates instead of unique tasks. A missing new record may be outside a fixed formula range or outside a pivot table’s source range. Compare a formula’s result with a manual check of a few rows, and confirm the selected date and headings before changing the formula.

For a shared file, File > Version history > See version history lets users inspect earlier versions and restore one when appropriate, subject to their access. Version history is useful for recovery, but it is not a substitute for a documented approval or retention process. Use clear sheet names and explain important definitions—such as what counts as “completed”—in a note or instructions area.

When Sheets is the right tool

Google Sheets works well for a lightweight report with structured records, straightforward calculations, and collaborators who need browser access. It is less suitable when the process requires a controlled database, complex audit trails, strict role-based access at the row level, or guaranteed automated delivery under formal rules. In those cases, a dedicated reporting system or database may be a better fit, with Sheets used only for a permitted export or analysis.

Compared with a document, a spreadsheet is better at sorting, filtering, counting, and recalculating structured data; a document may be preferable for a narrative briefing with little tabular information. Compared with Excel, Google Sheets emphasizes browser-based sharing and simultaneous collaboration, while Excel has its own desktop and web capabilities. The best choice depends on the organization’s tools, data volume, required controls, and how recipients consume the report—not on a universal claim that one spreadsheet app is always superior.

Frequently Asked Questions

How do I make a daily report in Google Sheets?

Create an Activity Log tab with one row per record, then make a summary tab with a report date and a few relevant measures. Use COUNTIF, COUNTIFS, or SUMIF for simple totals, or a pivot table for grouped summaries.

Can Google Sheets automatically show today’s report?

Yes. You can enter a date manually in the report-date cell or use a date formula such as TODAY(). A formula-driven date changes as the day changes, so it is convenient for a live view but unsuitable as the only way to preserve a past day’s final report.

How can I share a daily report without letting people edit it?

Use the Share button and give the intended recipients Viewer access rather than Editor access. Share only with people who should see the data; protected ranges limit editing but do not make information private.

Why does my daily total show zero?

Check that the log dates and report date are real dates, that the formula references the correct columns, and that the selected day matches the records. If the log contains timestamps, use date boundaries rather than an exact date match.

Can I reuse one template for multiple days?

Yes. A date-driven summary can display different days by changing its report-date cell. If each day needs a permanent approved record, save a dated copy or follow a separate snapshot and retention procedure rather than relying only on a changing summary.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.