The central idea of the Income Report is to allow you to look at the progress of income received and that may be received in the future (potential income outstanding), for orders that were made during a specific time period.
The key detail for this report is that you first select a date range that will grab orders placed/created in that range. This date range does not reflect when share deliveries are scheduled, nor does it reflect when payments are made. Suppose you have a main season share that runs from June to November. You opened signups for this share in February. On July 2, partway through the season, you might wish to know how much payment has been processed for orders place from February to date July, as well as how much payment you can expect upcoming for those orders. So you set a date range from February 1 to July 2.
The report is broken into 5 sections, and there are plentiful help-text buttons that you can hover your mouse over for details.
SECTION ONE - DETAILED BREAKDOWN OF SHARES SOLD
The top section breaks down the sales by each unique combination of: Share Type, Share Size, Frequency and Price. So if you have two shares sizes - Large and Small and offer weekly and bi-weekly frequencies, you might see breakdowns for Large Weekly, Large Bi-weekly, Small Weekly and Small Bi-weekly.
For each combination it displays:
SHARES SOLD = the number of times this combination shows up on the orders. This does account for people buying multiple quantities.
SCALED SHARES SOLD = this shows the adjusted number of shares based on the inventory size ratio. So if you have a share size that for inventory purposes is 50% the inventory baseline and have sold 20 of those shares, the Scaled Shares Sold will be 10. This reflects how these shares affect your share inventory.
TOTAL DELIVERIES SCHEDULED - this shows how many individual share deliveries are scheduled for this combination. So if you sold 20 weekly shares for a 20 week season, this number should show 400 deliveries scheduled. This number will adjust for prorated shares signed up after the season has begun.
SHARE DELIVERIES GROSS - this is the total number of deliveries of that share times the individual price of the share. This will be the gross income related to that specific share combination prior to any delivery fees and/or adjustments.
SECTION TWO - GROSS SUB-TOTAL BY SHARE
The second section totals the gross income for all share sizes, frequencies and prices for each share.
SECTION THREE - ORDER GROSS TOTALS
The third section combines all the gross totals for shares, adds delivery fees, adjustments and also keeps track of swap charges and purchased extras related to these orders. This is all combined to show you the gross income prior to your Harvie and credit card fees. The final number, Total Order Maximum, is the nominal upper bound of income that would be received for these orders at final completion. This would assume no cancellations, holds, or failed payments, which would reduce the real number. It also would assume no further swap charges or extras purchases, which would increase the real number.
*** A note on this third section. We have put an exclamation mark on delivery fees due to a couple issues we are working on related to how we are currently calculated that. In Harvie we don't yet break out delivery fees as a separate line item on orders. Consequently this is calculated by taking the total price on all invoices minus the Total Share Gross from the above section. In theory, any discrepancy would be delivery fees, however what we are realizing is there are some anomalies that may have occurred on partially cancelled orders or certain instances where we have made some adjustments on orders for you.
SECTION FOUR - PROCESSED PAYMENTS
The fourth section breaks down all of the payments that have been processed related to these orders, the total fees and the net payments that should have been received for these orders. The "Total Paid on Shares" is the amount of payments made towards the main shares and the "Total Additional Charges Paid" is the total paid towards swap upgrades and purchasing weekly extras.
Reminder: The payments are not filtered by your date range. These will be payments occurring at any time for the orders you selected with the date range.
SECTION FIVE - UNPROCESSED PAYMENTS
And the final section shows you information related to unprocessed payments and breaks them down into these three categories:
TOTAL REMAINING ON ORDERS - this is the total number of future scheduled payments. This does include deliveries that might be currently suspended because they are awaiting additional payment and also future held deliveries.
TOTAL FAILED PAYMENTS - this is the total of failed payments on these orders. This may include both main share payments as well as swap/extras charges that failed when attempted
TOTAL PAST HELD OR SUSPENDED PAYMENTS - This is the total amount of payments related to share deliveries that were suspended due to non-payment or failed payment as well as the total amount related to deliveries that were held and have not yet been rescheduled.