This report contains all Order payments that were "manual" (ie; not a credit card transaction). With some basic Excel filtering this report offers multiple solutions, such as finding long-standing/overdue invoices, or reconciling a bank statement for EFT orders.

Report Column Definition


public_order_id
The number the person *should* have written as their EFT transfer description.

private_order_id
The number used in Jomablue (it forms part of the order URL) and can be used to join multiple reports.

purchase_order_number
If the user entered a purchase order during checkout, it will be displayed here.

order_date
When the order was placed.

payment_notification_date
They have the ability to press "Notify of Payment" after checking out via invoice and making the payment. This is optional so not all rows will contain this - it is a "best effort" approach at getting the person to notify you. This field shows the date that this effort occurred.

payment_notification_message
A message that they could have left when pressing "Notify of payment". This is optional so not all rows will contain this - it is a "best effort" approach at getting the person to notify you. 


payment_received_date
When a Jomablue user pressed "Payment Received" for the particular order. Generally meaning the receipt of monies have been confirmed. 


The report also contains the following headings but they're self explanatory.

billing_first_name
billing_last_name
billing_email
billing_phone
billing_company
billing_address
billing_city
billing_state
billing_country
billing_postcode
Payment Total (inc. Tax)
Payment Method
currency

Did this answer your question?