COMPOSITE REPORT
This report is designed to reconcile the Revenue/Sales on the Orders with the Payments Received in the same date range, whether from Mainstore or eCon.
Sales/Revenue
- This is the from the order detail. Total Columns as follows:
- Level 1 column is the Category total
- Level 2 column is the Parent Category total.
- Level 3 column is the Fund ID total (or Tax and other fees)
- Total is the overall Sales/Revenue total (inc Tax and other fees)
- GL Acct – This is the number given to the Fund ID
- Fund – This is the Fund given to the Product. (NB the Category Fund is not used for this sorting)
- Sales appear in this part of the report whenever the product is completed. If the order is placed say on 7/1 and goes to pending (either intentionally or not) then it will not appear on 7/1 revenue. If the order is then completed on say 7/15 the Revenue will appear on 7/15. Even though the original order was placed on 7/1.
Payments
This summarizes the Payments taken on a particular day. It does not look at whether the order was completed or not. Partially paid or paid in full. It should match the Payment Report. If you take a payment on an order from another venue (as in Group Sales) then that will show in the report as a separate line item.
Charge
This line is used for transactions where the Sales/Revenue and Payment totals do not match. E.g. Deposits taken on Orders, interim payments and balances due. NB If barcodes are generated the Charge line is triggered to look at the order in full and show any changes needed.
Notes on Non-Balancing
- Barcodes are generated in a pending order. This will cause the charge line to include the order total in the charge line (or the balance if any payment taken). Look in the incomplete orders for that time period, or at the Report you use for timed entry that will show up issues. Completing the order should solve the issue. If the barcodes were generated by mistake then contact Convergence and request the “Completion Date” be removed. This will take the order back to pre-barcode status as far as this report is concerned (barcodes remain generated)
- There are certain users that are set to “Test” principally Convergence users. These are purposely excluded from the Composite Report as we do not want them mixing with your real results. Sometimes if a Convergence user has assisted you with a refund, or order transaction and the rest of the order is done with a non-test transaction that will cause an imbalance as not the whole transaction will be included. This can be fixed by Convergence who will change the Convergence user to a non “Test” User.
Reports to find Charge line items
- Look for payments taken on orders date pre the current date range. Look for the first order number in your date range. Then run the Payment report for this date range and sort by order number. You will then have a list of those orders that are pre your date range that has payments or refunds against them.
- Run the Balance Due Report for the date range of the report. Choose the filter option “Balance Due for Order calculated from payments or cart items inserted date range”. That will show any orders that are completed that have payments taken.
