Daily Invoicing Condensed Report

Sample Daily Invoicing Condensed report

Managing cash inflows and outflows is vital for maintaining a company's financial stability. Analyzing daily financial data, including sales, taxes, refunds, and expenses, provides valuable insights into a company's cash performance to retailers.

 

The Daily Invoicing Condensed Report offers a quick and concise overview of the net revenue generated from transactions on a specific date. By monitoring cash flow through this report, businesses can track revenue trends and identify any discrepancies that require attention. Moreover, this report helps to identify trends and patterns that may impact the company's financial performance, allowing businesses to take appropriate action to achieve financial stability.

 

What the report shows

The report condenses one transaction date into a single view of revenue, refunds, and payments.

  • Shipments: the shipments dispatched and the total items shipped.
  • Revenue: item revenue, item discounts, net item revenue, tax revenue, and the shipping fee total.
  • Returns: items returned, item refunds, tax refunds, restocking fees, and shipping refunds.
  • Payments: shipment payments received and return refunds paid out through payment providers.

 

How teams use it

Finance teams use the report as a daily check on cash coming in and going out. Comparing revenue and shipping fees with the shipment payments received shows whether the day's shipments were paid in full, and comparing refunds with the return refunds paid out shows whether those refunds reached customers.

Sales and eCommerce leaders watch discounts, refunds, and restocking fees over time to see how promotions and returns affect the money the business actually keeps.

Because the report condenses each transaction date into one view, it is also a quick way to spot an unusual day, such as a spike in refunds or a drop in payments received, and to investigate before the month closes.

The Daily Invoicing Condensed Report is one of the pre-configured reports in the HotWax Commerce BI report library, which covers demand and sales, fulfillment, pre-orders, returns, and more.

 

User

Vice President of Sales, VP of Retail, Head of eCommerce, Chief financial officer

 

Glossary

ItemItem Details
All ShipmentsThe shipments dispatched in the month
Total ItemsThe total number of items shipped in the month
Item RevenueThe total revenue earned from the shipped items
Item DiscountsThe total discount given on all the shipped items
Net Item RevenueThe total amount from all the orders - Total discount on all the orders
Tax RevenueThe tax charged on all the orders
Transaction DateThe date on which all the transactions are made
Shipping Fee TotalThe shipping fee received for all the shipped items
Items ReturnedThe number of items returned on the transaction date
Item RefundsThe refund given against the items on the transaction date
Tax RefundsThe tax refund given against the items on the transaction date
Restocking FeesThe fee charged against restocking the returns from the customer
Shipping RefundThe shipping refund against all the order returns
Shipment PaymentsThe payments received against all shipment items from different payment aggregators
Return RefundsThe payments returned against all returned items to different payment aggregators