Molo, Inc.

• "How do I generate a Sales and Cash Flow Detail report and what information does it provide?"

Resolution Steps

1. Go to Reports.
2. Click on Point of Sale.
3. Select Sales and Cash Flow Detail.
4. Choose the desired Start Date and End Date for your report.
5. (Optional) Use the filter to exclude Reservation and Work Order invoices.
   • This ensures the report only includes standalone invoices created in the POS.
6. Click Run Report.
7. The report provides a summary of:
   • Total amount invoiced
   • Total payments received
   • Balances remaining
   • Breakdown of transaction types (Cash, Check, Bank Account, Credit Card, Wire Transfer, etc.)
   • Card type breakdown (Amex, Discover, MasterCard, Visa)
8. Scroll to the bottom of the report to see All Sales Revenue. This shows each item that was invoiced and the totals.
   

Report Breakdown:

The Sales and Cash Flow reports have two main components, the transactions section and the revenue section. Both sections display totals, as well as a break out for walk in transactions.

1. The Detail Version:  Shows one row for each inventory item or reservation rate in the revenue section.
2. The Summary Version:  Shows a summary by category in the revenue section.

Checking the Exclude Reservation and Work Order Invoices box excludes all activity related to reservations and work orders including any linked transactions and revenue.

Transactions (upper portion of report):

1. The date range entered is used to retrieve all payments and refunds in that time period and looks at the Transaction Date. That includes payments, overpayments, payment on account, prepayments, and security deposits.
2. Under Summary for All Sales:
   1. The All Sales line sums all the revenue
   2. The Less Payments line is the net of (payments-refunds)
   3. The Balances Remaining is the All Sales minus the Less Payments lines

Revenue (lower section of report):

1. The revenue section sums all the items in each invoice for the display. In short, this section mirrors the regular Revenue and Category Revenue report. The revenue sections of the report retrieves all receivable invoices with an Invoice Datethat is dated in the date range selected including:
   1. Reservation invoices
   2. Standalone invoices
   3. Service invoices

Note: In the Sales and Cashflow Reports, it is normal if the Sales and Payments don't completely line up for the date range.

Verification: This report is used to check sales and payments taken.