Skip to content

Daily Reports

Menu Location: Reports > Financial > Daily Reports

Last Updated: 2026-08-07

Overview

The Daily Reports page (billing-reports.php) shows completed payment totals broken out by day and payment method (Cash, COD, Mail Check / Online Bill Pay, EBT, CC, Invoice, etc.), for a configurable date range. Each amount is a link through to the Payments page filtered to that day and payment method.

Note: The page itself labels this report as still being tested ("note: Only daily reports are available at this time").

Primary Functions:

  • View completed payment totals by day and payment method within a date range
  • Filter results by US state
  • Click a day/method total to jump to the matching filtered Payments list

Page Layout

Filter Controls

  • Report Type: Only "Daily" is currently available (Weekly/Monthly are present in the markup but disabled)
  • State Filter: Restrict results to customers whose order state matches the selected state
  • From / To: Date range pickers (defaults to the last 10 days)
  • Search: Apply the selected filters

Totals Table

One row per day, one column per payment method (only methods with amounts recorded are shown as links; others show -), plus a Total column. If a state filter is applied, a State column is also shown. A TOTALS row sums each column across the selected date range.

How to Use

Generating a Basic Report

  1. Navigate to Reports > Financial > Daily Reports
  2. The report loads with the default 10-day date range
  3. Review the day-by-payment-method totals
  4. Adjust the date range or state filter and click Search

Filtering by State

  1. Select a state from the dropdown filter
  2. Click Search to refresh
  3. Only transactions from customers whose order state matches will appear, and a State column is added

Common Use Cases

Daily Revenue Review

Set the date range to a single day to review completed payment totals by method for that day. Useful for end-of-day reconciliation.

State-Level Reporting

Filter by state and set the date range to a reporting period.

Troubleshooting

Report Shows No Data

  • Verify the date range includes days with completed payments
  • Remove the state filter to check if data exists

Slow Loading

  • Reduce the date range; wider ranges query more payment rows (and the archive database, when enabled)

Recent Updates

2026-08-07: Fixed a gap where overage credits entered through the Route Payments or Payment Entry (Enter Check) screens were not being counted in COD / Online Bill Pay daily totals. Only overage recorded via the older billing.php mark-paid flow was previously picked up; overage from the newer entry points is now included as well (FreeScout #8218).

  • Billing Payment Transactions - Detailed payment transaction reports
  • Monthly Transaction Spreadsheet Export - Monthly XLSX export
  • Tax Reports - Tax-specific financial reporting
  • Payment Transactions - Transaction summaries with drill-down modals