Invoice analysis

Close a month from one invoice: read the month-by-month charges and carryover, check the invoice against your sales, look up the plans on it, and understand every figure.

Use this page when you close a month. Starting from one invoice in the Merchant Portal you can see what it charged and refunded month by month, confirm it against what you sold, look up any plan or order on it, and download the PDF for your accounts.

The routine covers Product Protection invoices. Shipping Protection invoices have the same page and Monthly Activity but no reconciliation lists, because shipping protection is billed per order.

What an invoice covers#

Each invoice bills the plans that were ready to bill on the day it was generated, takes off the cancellations that were ready to refund, and leaves everything else for the next invoice.

QuestionAnswer
Which dates does it cover?From the day your previous Processed invoice of the same type was generated to the day this one was generated. A Pending invoice still starts at your last paid invoice, even if an older invoice is unpaid. Your first invoice has no start date, so all of it counts as the current period
When is a plan billed?Once the plan is complete and the amount you owe for it is fixed: the plan price minus your margin. A plan on a Processed invoice is never billed again
What is carryover?A plan on this invoice whose order date is on or before the period start. It became ready to bill after your previous invoice was issued. Refunds are split the same way
When is a cancellation refunded?You get back what you were charged, on the first invoice generated after the cancellation is ready to refund

Charges and refunds are shown under the month of the plan's order date, not the date it was billed or cancelled. A refund for a plan sold in March appears under March even if the cancellation happened in June.

Close a month, step by step#

  1. Open the invoice

    Go to Billing → Billing History. Unpaid invoices are pinned above paid ones, and only the latest Pending invoice is listed because it replaces any older unpaid one. Click the row to expand it.

    The expanded row shows How this invoice was generated, then either All warranties from this period are accounted for on this invoice. or two counts, Missing from Invoice and Late Cancellations, each with a note on what happens next. While the counts load it reads Checking reconciliation against Sales…. On the right is the Net Amount Calculation and View full invoice details →.

  2. Confirm the headline

    Check the status pill (Processed, Pending or Failed), the Invoice number, the period, the type and the net amount. The Invoice breakdown bar shows Charges, Refund for Cancellations and Credits as shares of the invoice. Activity lists Invoice generated, Awaiting payment (or Charge attempt failed), the charge step and Settled, then Charged to.

  3. Read the Net Amount Calculation

    Charges and Refund for Cancellations each appear once for the current cycle and, when there is any, once more as carryover. Credits are subtracted last. The final line is Net amount charged on a processed invoice and Net amount to be charged on a pending one. A row with a zero count is greyed out.

  4. Read Monthly Activity

    Monthly Activity lists each month in the period under Current invoice period, most recent first, with a blue bar for charges (N · $X) and a red bar for refunds (N · -$X). An empty month reads no activity. Bars share one scale, so months are comparable at a glance.

    Carryover from past periods groups older plans by the invoice whose period they were sold in: Invoice #… with that invoice's period and the group's net, then the same month rows in grey. Plans older than any invoice on record sit under Older than tracked invoices. The month containing the period start can appear in both sections, once for each side of the boundary.

  5. Click Analyse →

    Analyse → sits next to Current invoice period. It opens Sales with a Custom range set to the invoice period and a banner, Showing analysis for invoice #…, with ← Back to Invoice and Clear filter.

    A second banner compares Sales with the invoice:

    • All warranties from this period are accounted for. The two totals match.

    • N warranties are pending invoicing · $X: you sold more than the invoice billed. These plans are active and appear on your next invoice.

    • N warranties cancelled after billing · refund of $X: the invoice billed more than Sales now shows. The amount is credited on your next invoice.

    A separate red alert, N duplicate contracts across N orders, appears only when an order carries more contracts than the plans it bought. Payment reconciliation explains each banner in full.

  6. Look at the plans behind a difference

    Click View details → (or Review duplicates →) to open the Reconciliation Check: three tabs, Missing from invoice, Late Cancellations and Duplicate Contracts, each with its count and its own Download CSV. Files are named reconciliation-<tab>-<invoice number>-<date>.csv. The tabs are described on Payment reconciliation.

  7. Look up one order or customer

    Back on the invoice, Check Contracts → opens Sales → Recent sales with the banner Showing warranties for invoice #…, the date filter set to the invoice period and the list limited to this invoice's contracts. Use it to look up one order or customer, or Download the list. Warranties in this invoice at the foot of the invoice page lists the same contracts.

  8. Close out

    Click ← Back to Invoice, then Download PDF for your accounts. If the invoice is Pending and you have no payment method on file, add one under Billing.

What to do with each finding#

FindingWhat it meansYour action
All warranties from this period are accounted forSales and the invoice agree within one dollarNone
Missing from invoiceSold in the period, not yet billed; coverage is activeNone. They appear as Charges · carryover on the next invoice, grouped under this invoice's number
Late CancellationsBilled here, cancelled sinceNone. They appear as Refund for Cancellations · carryover on the next invoice
Duplicate ContractsAn order was charged for more contracts than it boughtNone. SureBright cancels the Duplicate rows and the charge returns as a credit on next month's invoice
N orders have duplicates; showing the N with the largest overchargeMore than 100 orders are affectedThe CSV covers the same orders; contact support for the rest

Timing differences never need a ticket. Contact support only for a figure you cannot explain with the tables below, for example a Charges count that does not match Warranties in this invoice.

What each figure on the invoice means#

Use these tables when you need to explain a number to your accountant or check one yourself.

Status, period and net amount#

FigureWhat it means
Status pillFailed when the last attempt to charge you failed; Processed when paid; otherwise Pending
Period and N daysThe period described under What an invoice covers. Days are rounded, with a minimum of one. Your first invoice shows no day count
net amountThe invoice total. A negative total is a credit balance that goes towards your next invoice
Invoice breakdownEach segment is that item's share of charges, refunds and credits added together
N contracts billedThe number of charges plus the number of refunds

Charges, refunds and credits#

For one plan, the amount is the plan price minus your margin. Elsewhere in the portal this is the Warranty Cost column.

Row in Net Amount CalculationWhich plans it counts
Charges · current cyclePlans charged on this invoice whose order date is after the period start
Charges · carryoverPlans charged on this invoice whose order date is on or before the period start. Hidden when zero
Refund for Cancellations · current cycleRefunds for plans whose order date is after the period start
Refund for Cancellations · carryoverRefunds for plans whose order date is on or before the period start. Hidden when zero
CreditsAdjustments applied to the whole invoice; the count is the number of adjustments. On the PDF they appear as named rows above Sub total
Net amount charged / to be chargedThe invoice total. The PDF may also show a Payment Gateway Fee where it applies; that line is on the PDF only

Months and carryover groups#

In Monthly ActivityWhat it means
A month rowThe month of the plan's order date. Months follow UTC
Current invoice periodEvery month from the start of the period to its end, including months with no activity, with this period's charges and refunds
Carryover from past periodsCarryover charges and refunds, shown by month in the same way
Invoice #… groupCarryover plans sold during that earlier invoice's period, with that invoice's period and the group's net (charges minus refunds)
Older than tracked invoicesCarryover plans sold before any invoice on record. Shown last. An earlier invoice with no number yet reads Invoice from followed by the date

When Sales and the invoice count as matching#

FigureWhat it means
Sales totalWhat shoppers paid minus your margin, for plans ordered in the period that are not cancelled
Invoice totalThis period's charges minus this period's refunds. Carryover is left out, so it never causes a difference
A matchThe two totals differ by one dollar or less
N warranties are pending invoicing · $XSales is higher by more than one dollar. N is the Missing from invoice count
N warranties cancelled after billing · refund of $XThe invoice is higher by more than one dollar. N is the Late Cancellations count

Which plans each Reconciliation Check tab lists#

TabWhich plans
Missing from invoiceOrdered inside the period, not on this invoice, and not cancelled. A plan cancelled before it was ever billed is left out because there is nothing to charge
Late CancellationsCharged on this invoice and cancelled since. Plans already refunded on this invoice, and plans cancelled as duplicates, are left out
Duplicate ContractsEvery order this invoice charged, compared plan by plan: plans bought against contracts created. A plan that is still being set up counts as pending, not as a duplicate. At most 100 orders are shown, largest overcharge first

In the first two tabs Status is Active, Cancelled or Pending; Total Revenue is what the shopper paid, Margin is your share and Warranty Cost is the difference, which is what the invoice charges. Their CSVs add Order ID, Contract ID, Fulfillment Stage and Cancellation Reason to the on-screen columns. In Duplicate Contracts, Overcharged is what this invoice charged for the extras; when some extras were billed on another invoice the chip reads Extra cost with their full value.