Reports - Total Payments Received

This article will show you how to best interpret and use the information provided on the Total Payments Received report.

Report Summary 

  • This report summarizes the total value of all payment types (cash, check, credit card etc.) received over the specified date range.
  • This report provides the total and does not break down by individual transaction.
  • Any refunds processed are reflected in the totals shown. Refunds are not individually split out to view on this report. 
  • Report can be downloaded in either CSV or PDF format. 

The image below shows an example of this report is CSV format. 

 

Screen Shot 2022-07-27 at 15.48.23

Common Report Uses 

  • Match the total for a specified date range with deposits into your bank account for the same dates. 
  • Balance your cash drawer at the end of the day. 
  • Keep track of how much money you've taken in over a specified date range. 

Reports to Compare With or Supplemental Reports 

  • Journal Entry report - totals should match for the same date range in both reports. 
  • Invoice Payment by Type
  • Payments by User
  • Payments by User and Date

Common Report Questions

Q: Why doesn't the Credit Card payments total on my Total Payments Received report match with the amount deposited in my bank account from the Card Processor for the same date range?

A: The amount deposited in your bank account from the credit card processor should match the amount of credit card sales from your Total Payments Received report for the same date range. One common reason these may not match is if your credit card batch time is not at midnight. If your credit card batch time is earlier than midnight and you had payments come in after the batch time, those payments would not be deposited with that same day. This article walks you through how to check and update your batch time. 

Q: How can I see what transactions make up the totals shown on this report? 

A: To see the transactions that make up the totals on this report, download the Invoice Payment by Type report for the same date range. The Invoice Payment by Type report is the detailed version of the Total Payments Received report.

Q: Why doesn't the amount on my Total Payments Received report match with the amount one of my Revenue Summary reports for the same date range? 

A: The Total Payments Received report pulls different data than any of the Revenue Summary reports do and therefore the two should not be compared or attempted to match. Total Payments Received is based on any transactions that occurred during the specified date range while the Revenue Summary reports are based on reservation nights that occur over the selected date range. Since a reservation that takes place in that time frame could have had a payment either before or after (or vice-versa), these two reports most likely will not match up.