RESOURCE 09

Weekly sales sheet template

Record daily in-store card, cash, delivery-app and other sales, with calculated totals. Enter each sale in one category only.

Download the file

How to use it

  1. Download the CSV using the button above. The shared template has Korean headers and weekday labels; the column guide below translates them.
  2. Excel: open it, then choose Save As → Excel Workbook (.xlsx). Google Sheets: choose File → Import → Upload.
  3. Enter one day’s sales per row. Count each sale once. If a delivery order also appears in your card terminal, enter it only under delivery-app orders.
  4. Update both the sale date and weekday for the week you are recording. Weekdays are text, so they do not change automatically with the date.
  5. Check that the totals calculate. If a formula displays as text, re-enter it in the total cell.

Decide these conventions first

  • Date: use the sale date, not the settlement or bank-deposit date.
  • Amount: use the amount paid, including applicable sales tax or VAT. Keep the same basis throughout.
  • Refunds and cancellations: subtract them on the date of the refund or cancellation. If you refund last week’s sale this week, subtract it in this week’s sheet and note the original sale date.
  • Delivery apps: enter the order value before fees. Your payout will be lower.
  • The total represents sales, not bank deposits or profit.

About the file

  • CSV does not preserve formatting, colors or multiple worksheets. Save it as an Excel workbook or Google Sheets file after opening.
  • If Korean text appears garbled in Excel, use Data → From Text/CSV and select UTF-8 encoding.

Use it with AI

With one week of data: Identify three observations about sales by weekday this week. Name the cells used in your calculations.

To compare two weeks: label the tables “last week” and “this week,” paste both, and ask: Compare last week with this week and explain three changes. Name the cells used in your calculations.

Check every number you will use for a decision against the sheet.

Column guide

Column in the file Meaning and what to enter
판매일 Sale date
요일 Day of week; update this text when changing dates
매장 카드(배달앱 제외) In-store card sales, excluding delivery-app orders
매장 현금(배달앱 제외) In-store cash sales, excluding delivery-app orders
배달앱 주문 Delivery-app order value before fees
기타(앞 항목 제외) Other sales, such as bank transfers or vouchers, excluding anything already recorded above
합계 Total of the four sales categories
메모 Notes, such as rain or a group booking

The weekday labels 월, 화, 수, 목, 금, 토, 일 mean Monday through Sunday. You can replace them with English text.

WORK WITH ME

Need something like this?

If you have similar repetitive work, I can build it for you. Start by telling me which files you use and how you work today.

Back to resources