27UGIPL ACCOUNTS WORKSPACEFiles stay on your computer

STARBUCKS

POS to Excel working

Choose your sales file and delivery period. Get the working ready for review.

Delivery date = dispatch + 1 day
1

Add POS sales reports

Use the item-level report with invoice number, customer, date, item quantity, price and invoice totals. You can add more than one month.

2

Select delivery period

Add a report to see the available delivery dates.

For a full month’s deliveries, also upload the previous month’s final dispatch day.

Your working

No period selected

Your invoice preview will appear here

We’ll include successful Starbucks invoices and list cancellations separately.

Inside the Excel file

  • Varsha’s product-by-invoice working, one sheet for 1–15 and one for 16–month-end
  • Delivery dates, dispatch dates and invoice references
  • POS quantities, actual rates, tax and rounding
  • Invoice register and excluded cancellations

Generated from POS only. PO acceptance and Tally reconciliation remain separate checks.