Balance by Date Range Report

The Balance Report gives you a clear breakdown of all payment transactions during a selected time period. It’s especially helpful when you’re reconciling revenue, keeping track of refunds, and reviewing the fees from your Stripe payments.

🧭 How to Access Reports

• Go ahead and click Reports in the left menu.
• Then, select the Balance box.

• When the detailed Balance by Date Range Report opens, it uses the Date Range filter from Reports. Once you’re in the detailed report, you can easily switch the date range to a wider window.

📊 What You’ll See

This report starts with a helpful summary at the top:

• Balance: The total payments collected minus any refunds within your selected date range.

  Refund: The total refunds within the selected date range.

  Breakdown of payment methods:

  • Stripe payments (credit and debit card payments processed through Stripe, plus payments made via Stripe link)
  • Cash
  • Taken offline 

After that, you’ll see the totals followed by a list of each individual payment and refund transaction. For every entry, you can view:

• Transaction: The date and timestamp of the transaction
• Payment/Refund: The payment amount collected or refunded for that transaction
• Stripe fee: The Stripe fee charged for any payment processed through Stripe
• Source: Who made the payment or refund (staff name or guest portal)
• Stripe Charge ID: The Stripe Charge ID for the Stripe payment or refund, so you can easily reconcile it with your Stripe account
• Type: Whether the transaction was for a Reservation or an Order
• ID: The Reservation or Order ID. This is clickable and opens the reservation or order in a new tab.
• Check-In: The check-in date for reservation payments or refunds
• Guest: Guest contact information and name. Just hover over the icons to view or copy the details.

💡 You can use the Stripe Charge ID to match transactions in your Stripe account for faster reconciliation.

📥 Download for Full Detail

Just click the Export button to download a CSV file of the current report. The export includes everything shown on the screen, so you won’t miss any details.

You can open the CSV file in your preferred spreadsheet app, like Excel, Google Sheets, or Apple Numbers.

File naming convention:

The file will always start with "report_balance-by-date_from", followed by the date range and the date and time the report was pulled.

For example:

report_balance-by-date_from_2025-06-01_to_2025-06-17_at_20250617T103920-04_00.csv

⚠️ When you open the exported file, it’s best not to convert any fields if you’re prompted.

💡 This report is a great fit for accounting and financial audits.

If you have any questions about the Balance by Date Range report, or if you’d like a bit of clarification, please reach out at [email protected]—we’re happy to review it with you.