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
The number the person *should* have written as their EFT transfer description.
The number used in Jomablue (it forms part of the order URL) and can be used to join multiple reports.
If the user entered a purchase order during checkout, it will be displayed here.
When the order was placed.
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.
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.
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.
Payment Total (inc. Tax)