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.
How to use it
- Download the CSV using the button above. The shared template has Korean headers and weekday labels; the column guide below translates them.
- Excel: open it, then choose
Save As → Excel Workbook (.xlsx). Google Sheets: chooseFile → Import → Upload. - 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.
- 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.
- 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/CSVand 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.
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.