The cash summary report gives you an overview by time period of all payment and refund activity under your account.
Use this report to:
- Track Gross and Net Payments by Day / Month / Quarter / Year
- Track cumulative cash payment contributions over time
- Trend average payment amounts processed on your customer base
What a Cash Transaction is in Fusebill
Fusebill records cash transactions whenever a payment or refund is recorded on your customers. A payment is considered an individual collection regardless of the number of invoices it pays off. In addition payments can be made to partially pay off invoices and refunds can be made for partial payment amounts.
Selecting your Time range
The Cash summary report can accept a starting month and number of months to consider. All submitted dates are interpreted in your account time-zone.
Selecting your Currency
The Cash summary report must be run for individual currencies available under your account. The system will use your default currency unless instructed otherwise.
Totals for Period Selected
The CashSummary report will display a global payments result for the entire period specified. These totals can be used to establish a scale for the interval result sets returned in the main Cash summary graph. The average payment amount for the full period will be displayed for both Gross and Net Cash in the summary.
Displaying different Intervals
Once the Cash summary report is run you have the flexibility to manipulate the interval used to return the data.
By default, if the time range requested for the Cash summary report spans less than 1 month the data will default to Daily granularity. If the time range requested exceeds 1 month then the data will default to Monthly Granularity.
Note that the granularity selected for the Cash summary data will be reflected in the graph, the data grid and the CSV export available from the report.
Gross vs Net Cash
The Cash Summary report allows for the flexibility of displaying Gross Cash vs Net Cash.
Selecting your Display options
Displaying by Interval – when this display mode is selected then individual cash figures for each interval are graphed separately.
Displaying Cumulative – when this display mode is selected then each interval is added to previous totals over the course of the full time range requested.
Displaying Averages – when selected this display mode will show the average Net payment amount for each interval. Trending Average Payment can be a powerful way to measure the result of different sales and marketing initiatives over a time period.
If you would like to do further analysis on the Cash summary data you can choose to export the Cash summary information in CSV format. The CSV data will be provided according to the interval you have selected at the time that you initiate a data export.