Skip to main content
Mapping financial status in Klar

Here you will find explanations of the effects of financial status on the allocation to different revenue figures in Klar

Franz May avatar
Written by Franz May
Updated over a month ago

If financial statuses are not configured according to the standards from the store system, a customization of the data source can ensure that the orders are still correctly taken into account in Klar.

To set up a customization, the store data source can be adapted. To do this, click on the data source and add the desired customization:

There are 4 different options:
โ€‹
Financial status to paid

Financial status to partially refunded

Financial status to refunded

Financial status to cancelled

Which adding a value you would change the status of this to the selected value. How status is used per default can be seen for each shop system here:

WooCommerce: Financial Status of Orders

Net Revenue

  • Paid: Orders with the statuses completed or delivered.

  • Pending: Orders with the statuses processing, pending, on-hold, production, ready_to_pack, or similar.

Gross Revenue

  • Refunded: Orders with the status refunded.

  • Partially Refunded: Orders with the status partially_refunded.

Canceled

  • Canceled: Orders with the status failed.

This mapping ensures precise categorization of orders based on their revenue impact.


SW5: Financial Status of Payment Processes

Net Revenue

  • Paid: Payments with the status completely_paid.

  • Pending: Payments with statuses like open, review_necessary, 1st_reminder, AmazonPendingAuthorizationPayment, and similar.

Gross Revenue

  • Refunded: Payments with the status re_crediting.

Canceled

  • Voided: Payments with the statuses the_process_has_been_cancelled or zahlungsausfall.

This grouping reflects the effect of payment statuses on revenue classification.


SW6: Financial Status of Orders and Payments

Net Revenue

  • Paid: Orders with the statuses paid, completed, or refund_failed.

  • Authorized: Orders with the status authorized.

  • Partially Paid: Orders with the statuses paid_partially or partially_paid.

  • Pending: Orders with the statuses in_progress, open, unconfirmed, or pending.

Gross Revenue

  • Refunded: Orders with the status refunded.

  • Partially Refunded: Orders with the statuses refunded_partially, new_return, or return_completed.

Canceled

  • Canceled: Orders with the status cancelled.

This grouped mapping provides a clear understanding of how each status impacts financial reporting by assigning them to Net Revenue, Gross Revenue or excluding them altogether.

Did this answer your question?