Tracking Sheet for Credit Notes

System to Tracking Credit Note:

Objective: To see be consistent with the usage of tracker. This is solely for Coles and Woolworths.

What do we need?

·         Access to Zoho Books through Zoho One.

·         Spreadsheet file for tracking Credit Notes (1) – View only for now, Natalia and Dodge have access to edit it.

Process:

1.       After gathering all invoices make sure that the columns are filled accordingly. Take note that the invoice needs to be placed in the appropriate sheet.

 2. As for the Location,  use the Table below as reference. It is either Local or Interstate.

3. For the Status, it is either Unpaid or SOA. Unpaid, when the entire amount is not paid (highlighted in yellow). SOA (Statement of Adjustment), when partial payment was made (highlighted in orange).

  4. Indicate any updates or changes under Notes Column.

5. Once you have all the necessary documents such as POD (Proof of Delivery), Invoice Copy and SOA (applicable for Woolworths), then we are now ready to mark each in the list and submit via each Portal. 

Yellow Cell: already has POD and submitted in the Portal.

Green Cell: already paid

Purple/Violet Cell: no POD yet

No fill/White Cell: see Notes Column for any indication