| # | Qty | Unit | Category 类别 | Item 规格 (or SKU) | ± % | Price | Amount |
|---|
Payment received now 现在收款 (leave empty if not paid yet)
Print preview 打印预览
Trucks 车辆
| Slip | Date | Staff | Customer | Total | Balance | Status |
|---|
Returns 退货
| No. | Date | Slip | Customer | Amount | Method | Status | By |
|---|
Collect & settle 收款核销
Several slips, one check: tick the slips → 「Receive = ticked total」→ choose Check and fill it in. One slip, two checks: add a second payment line. 多张单一张支票：勾选单据 →「收款 = 勾选合计」→ 选支票填号码。一张单两张支票：多加一笔收款。
| Slip | Date | Due | Total | Paid / credit | Open 未付 | Apply 本次冲抵 |
|---|
Money received 收到的钱
Summary
Counter receipts not paid yet 未付对账单
Scan the QR on the paper to open it. 扫纸上的二维码直接打开。| No. | Date | Customer | Slips 张 | Amount 金额 | Still open 仍未付 | Status |
|---|
Recent receipts 最近收款单 (30 days)
| No. | Date | Customer | Amount | Methods | Status | By |
|---|
Import opening data 导入期初资料
For what you already have before using the system: customers' unpaid slips, customers' checks you are holding (or deposited, not yet cleared), and checks you wrote to suppliers that are not yet cleared. Download the sample, fill it (Excel .xlsx or .xls), upload, check, import. 上线前已有的：客户未付单据、手上（或已存未入账）的客户支票、开给供应商还没过账的支票。下载模板 → 填好 → 上传 → 核对 → 导入。
Rules: unpaid slips come in as one line “Opening balance” for the amount still owed (stock is not changed). Customers not in the list are added. Our checks need the bank account added in Bank first. The same slip / check is never imported twice. 规则：未付单据按「未付余额」一行导入（不动库存）；新客户自动添加；开出支票要先在「银行」页登记账户；重复的不会导入两次。
Import slips with payments 导入单据（含现金/支票收款）
Columns 列: 单据号 | 日期 | 开户名 | 金额 | 付现金 | 付款日期 | 支票兑现日期 | 银行 | 支票编号 | 金额 | 交入银行日期. A row with no 单据号 is a second check for the slip above. 单据号空白的行 = 上一张单的第二张支票。
每月员工销售 Sales by month, per staff
| Loading… |
Staff sales 员工绩效
Sales = slips issued (SI / DR) or confirmed (H.S.T.C), voids not counted. Slips for 二盘 (reseller) customers are not counted in Sales, rank, share or average — shown in the 二盘 column only. “vs before” compares with the same number of days just before. Unpaid / overdue = still open on that person's slips today. 销售额 = 已开出/已确认的单，不含作废；二盘客户的单不计入销售额、排名、占比、平均，只显示在「二盘」一栏；“对比”= 和之前同样天数比较；未收/逾期 = 这些单今天还没收的钱。
| # | Staff 员工 | Slips 单数 | Sales 销售额 | Share 占比 | vs before 对比 | Avg slip 平均 | 二盘 不计 | 三盘 | Customers 客户 | Voids 作废 | Skips 跳号 | Missing 缺号 | Returns 退货 | Unpaid 未收 | Overdue 逾期 | Collected 收款 |
|---|
Whose number? 号码查询
Bank 银行
New deposit 存款（现金 + 支票）
Tick the customers' checks you are depositing (only checks dated today or earlier). 勾选要存的客户支票（日期已到的）。
| Check date | Customer | Bank / no. | Amount |
|---|
Waiting for the bank 待银行确认
Cash: tick when the bank SMS / statement shows it. Checks: “cleared” when credited, “bounced” if returned. 现金看到银行短信/流水后确认；支票入账点已过账，退回点退票。
| Deposit | Date | Account | What | Amount | Status |
|---|
Bank calendar 银行日历 — money into the bank each day 每日存入银行
Cash deposited + customers' checks deposited + transfers / GCash received + other money in. Everything into PTC, BPI, GCash counts as bank. 现金存款＋支票存入＋转账/GCash 收款＋其他收入，凡进 PTC、BPI、GCash 都算银行。Click a day for details 点日期看明细。
Customers' checks — manage 支票管理（查看 / 修改 / 退票 / 换票）
| Check date | Customer | Bank | Check no. | Amount | Status | Deposited 存入 | Cleared 过账 |
|---|
Account statement 账户流水
| Date | What | Who / note | Ref | In | Out | Balance 余额 |
|---|
Other entry 其他收支（银行费用、提款…）
Accounts 银行账户
| Name | Type | Bank | Account no. | Opening 期初 | As of |
|---|
Opening = the balance on that date (bank statement, GCash app, cash counted). Checkbook accounts are matched by account no. Customers' bank transfers go to the account named in the payment (PTC / BPI). 期初余额 = 当天余额（银行对账单 / GCash / 点算现金）；客户转账按收款时选的账户入账。
Write a check 开支票
Print settings 打印设置（第一次设好，Chrome 会记住）
Checkbooks 支票本
| Bank | Account | Numbers | Used | Left | Next |
|---|
Payees 收款人
New names are added when you write a check. 开支票时自动加入。
Check plan 支票预测 —
Out = our checks not yet cleared (by check date). In = customers' checks in hand / deposited, not yet cleared. 出 = 我们开出未过账的支票；入 = 客户支票（未存 / 已存未入账）。
| Period 时段 | Out 出 | In 入 | Net 净额 |
|---|
| Check date | In / out | Who 对方 | Bank | No. | Amount | Status |
|---|
Can deposit today 今日可存
| Check date | Customer | Bank | Check no. | Amount | Receipt |
|---|
Deposited, waiting to clear 已存入待对现
| Batch | Deposited | Bank | Customer | Check no. | Amount |
|---|
Next 30 days 未来 30 天
| Date | Checks | Amount |
|---|
All checks in hand 全部在手（盘点用）
| Date | Customer | Bank / no. | Amount |
|---|
History 记录 (cleared / bounced)
| Check date | Customer | Bank / no. | Amount | Status | Date |
|---|
| Customer | Tier | Terms | Balance 未收 | 0–30 | 31–60 | 60+ | Overdue 逾期 | Pending 待确认 | Prepaid 预收 | Bounced |
|---|
| Slip 单据 | Date | Due 到期 | Customer | Staff | Total | Paid / credit | Balance 余额 | Overdue |
|---|
Booklets 号段（SI / DR 本子）
| Type | Numbers | Staff | Given | Used | Void | Skipped | Missing 缺号 | Left | Next | Status |
|---|
管理看板 Management
三盘价 Retail prices (SI / DR)
Counter slips (SI / DR) use the 三盘 retail price = list price × (1 + %) + ₱ per unit. A customer marked 二盘 still gets the list (reseller) price. H.S.T.C slips are not changed. Set a whole category at once, or give one product its own % / ₱ (empty = follow the category). 门市单（SI / DR）用三盘价 = 价目表价 ×（1+%）+ 每件加价。客户是二盘的仍用二盘价。针式单不变。可整个类别一起设，也可单个产品另设（空白 = 跟类别）。
| Category 类别 / item 产品 | Items | Row % 加价% | +₱ / unit 每件加 | 二盘 list 价目表价 | 三盘 retail 三盘价 |
|---|
Warehouse 仓库库存
Stock-kept items only (steel, roofing, wood, price-list items — set per product). Sales take stock out, Stock in (进货) and returns put it back, a stocktake sets it to what you counted. 只显示管库存的货品。销售出库，进货与退货入库，盘点按实数调整。
Excel import 导入: Export first, fill the Counted 实点 column (optional: Safety 安全, Cost 成本), then Import — you see every change before it is saved. 先导出，在「Counted 实点」列填数量（可选：安全库存、成本），再导入，保存前会先预览。
| SKU | Category 类别 | Item 规格 | Unit | In 入 | Out 出 | On hand 现有 | Counted 实点 | Diff 差 | Safety 安全 | kg | Last cost 最近进价 | Value 金额 |
|---|
开出支票 Checks out
| Check date ⇅ | No. ⇅ | Bank | Pay to | Amount | For | Type 类别 | Status | Written 开票 ⇅ |
|---|
货款支付 Goods paid — cash + check 现金进货 + 支票进货
现金付货款 Pay cash / GCash / bank for goods
Goods paid by check: write it on 开支票 (type Goods). 支票付货款在「开支票」开（类别选货物）。
采购单 Purchase orders
Paper for the supplier only: printed or kept here. It does not change stock, money or any report. Receiving the goods is still done in 进货 Stock in. 只给供应商的单据，可打印或保存；不进库存、不进账、不进统计。到货仍在「进货」登记。
| No. | Date | Supplier 供应商 | Items 货品 | Total | Status |
|---|
| # | SKU (from stock 仓库) | Description 品名规格 | Qty | Unit | Unit price | Amount |
|---|
供应商 Suppliers & payees
Each supplier / payee gets its type: goods with its kind (RSB, steel, wood & board, cement, hardware…) or an expense kind. Writing a check to them picks this type by itself. New names are added when you write a check. 每个供应商/收款人设定类别（货物+二级分类，或开支分类），开支票时自动带出，不用再选。
| Name 名称 | Type 类别 | Print only 只打印·不统计 | Note 备注 | Checks 支票 | Total 金额 |
|---|
Spending 支出
Expenses only, in two lists: cash expenses (money out of Cash / GCash / bank) and check expenses (our checks marked as an expense). Goods are stock-in (进货) and are not listed here. Change a type in the list; add your own kinds with Categories. 只看开支，分两张表：现金开支（现金 / GCash / 银行付出）和支票开支（开支支票）。货物算进货，不在这里。类别可在表里改，「分类管理」可新增。
开支分析 Spending analysis — this year vs last year 今年 vs 去年
Pay out cash / GCash / bank 现金 / GCash / 银行付出
| # | From 从 | Amount 金额 | Type 类别 | Paid to / for 付给 / 用途 | |
|---|---|---|---|---|---|
| Total 合计 | 0.00 | ||||
Checks are written on the Write check page (choose the type there). Goods paid in cash: 货品 → 货款支付. 支票在「开支票」页开；现金付货款在「货品 → 货款支付」。
现金开支 Cash expenses
| Date | From 来源 | Paid to / for | Ref | Amount | Type 类别 |
|---|
支票开支 Check expenses
| Check date | Bank | Paid to / for | Check no. | Amount | Type 类别 |
|---|
A check written as Goods by mistake: change its type on Bank → Checks out (开出支票). 开支支票误选成货物：到「开出支票」改类别。
Other 其他（不是开支：老板取走、点钱差额…）
Stand-in 代班
Returns to approve 待批准退换货
Loading…
Record an expense 记开支
当日情况 Today
经营看板 Business
月度汇总 Monthly summary
年度参数 Year setup
Fill once at the start of each year: last year's monthly sales and cash (for 同比), and the account balances where the year starts. Grey = the system already has last year's figure for that month and uses it; your number is only a fallback. 每年开头填一次：去年每月销售、现金（算同比用），以及年初起点。灰色 = 系统已有去年该月资料，以系统为准，手填只作后备。
去年每月 Last year by month
| Month 月 | 去年总销售 Sales | 去年现金 Cash |
|---|
年初起点 Opening (1 Jan)
By product 按货物
| Item | Qty | Amount | kg |
|---|
By staff 按店员（门市现金格式）
| Staff | SI | DR | HS | Voids |
|---|
By customer tier 按客户等级
| Tier | Slips | Sales | Share |
|---|
Collected 收款（已确认）
Losses 损耗
| Return | Item | Qty | Amount* | Reason |
|---|
By day 按日期
| Date | Slips | Sales | kg |
|---|
Stock in 进货入库
1. Download the sample. 2. Fill it (or let AI fill it from the scanned supplier receipts — the sample has the instructions and the product list). 3. Upload: check the preview, then import. Stock goes up at once. 下载模板 → 填好（或让 AI 按扫描的进货单填）→ 上传核对 → 导入，库存马上增加。
| Product 产品 (SKU) | Unit | Qty 数量 | Unit cost 进价 | Amount | Price check 价格提醒 |
|---|
| No. | Date | Supplier 供应商 | Ref 单号 | Items | Qty | Amount | By |
|---|
Edit and press Save on the row. “Count” sets the stock to what you counted (recorded as a stock move). COD = must be paid on delivery (RSB). 显示前 150 项。
| SKU | Category | Item | Unit | Price | Price cell 格子 | kg | Status | COD | Stock? 管库存 | Stock | Safety |
|---|
Add a hardware item 新增五金杂项
Hardware items is a group (like Steel): each item has its category (Hinges, Screws, Bolts…) and that category's SKU, plus the last price sold. A new category gets its own SKU letters. Staff typing a new item on a slip also adds one here. 五金杂项是一个大类（像钢材）：下面分类别（合页、螺丝、螺栓…），按类别编 SKU，并记录最后售价；新类别自动生成编码字母。员工开单手打的新项目也会自动加到这里。
Auto = the slip fills in the price (it follows the last price sold); Blank = the price stays empty for staff to type. 自动价＝开单自动带出价格（跟最后售价走）；空白＝价格留空由员工填。
| SKU | Category | Item | Unit | Last price 最后售价 | Last sold 最后日期 | Price mode 价格方式 | Slip price 开单价 |
|---|
Terms 账期: 0 = COD. Check days 支票最长天数. New customers start at COD. 新客户默认 COD。
| Code 编号 | Tier 等级 | Name | Address | TIN | Phone | Terms days | Check days | Credit limit |
|---|
Cash drawer 钱柜日结
Count the drawer once a day (or at hand-over). The system adds up all cash written on today's slips and receipts, minus refunds, money taken out and cash taken to the bank. You only compare one number. 每天点一次钱柜（或交接时）。系统把今天所有单据和收款里的现金加起来，减去退款、拿出去的钱和存银行的现金，只需对一个总数。
Today's cash lines 今天的现金明细
Count 点钱
Money out of the drawer 从钱柜拿出
Record it the moment money leaves the drawer, or the count will not match. 钱一拿出来就登记，否则点钱对不上。Cash taken to the bank: use Bank → deposit. 拿去存银行：在「银行」做存款。
Staff cash receipts still waiting for you (cash only — receipts with checks / GCash / transfers stay in To confirm). Confirm them together once today's count matches. 员工收的现金还等你确认（只含纯现金；有支票、GCash、转账的仍在「待确认」逐笔看）。点钱相符后一次全部确认。
Counts 点钱记录
| No. | Time | By | System 系统 | Counted 实点 | Diff 差额 | Note |
|---|
Staff 员工
Add a name; the person sets their own PIN at first login.
| Name | Role | PIN | Status | Cash drawer 钱柜 | H.S.T.C 针式单 | Stand-in 代班 | Delivery 安排送货 |
|---|
Notices 通知
| Time | Type | By | Ref | Detail | Status |
|---|
年底盘点 Year-end count
Customers' checks still with us + bank balances + unpaid customer slips − our checks not yet cleared = what is left (stock not included). 剩余客人支票 + 银行余额 + 未收客户单据 − 未过账供应商支票 = 剩余资产（未含库存）。
1. 剩余客人支票 Customers' checks not yet cleared
| Check date | Customer | Bank / no. | Status | Amount |
|---|
2. 未过账供应商支票 Our checks not yet cleared
| Check date | Pay to | Bank / no. | Amount |
|---|
4. 未收客户单据 Unpaid customer slips
Balance still owed, incl. H.S.T.C slips not yet confirmed. Payments waiting for your OK are left out (their checks are in part 1). 含待确认的 H.S.T.C 单；待确认的收款不计（支票已在第 1 部分）。
| Customer 客户 | Slips 单数 | Oldest 最早 | Owed 未收 |
|---|
3. 银行余额 Bank balances (PTC · BPI · GCash)
| Account | Balance 余额 (confirmed 已确认) | Not confirmed yet 待确认（不计入） |
|---|
Balance = lines the bank already shows. Deposited customer checks not cleared are counted in part 1, so they are not counted again here. Cash on hand is not included. 余额只算已确认的；已存未过账的客人支票算在第 1 部分，这里不重复。现金不计入。
Settings 设定
Backup 备份
Downloads every table of the system (slips, receipts, checks, bank, customers, products, stock …) as one Excel file to this computer. Keep it on a USB / another drive. 把系统全部资料下载成一个 Excel 文件存到这台电脑，建议另存到 U 盘或其他硬盘。
清空测试数据 Clear test data
Deletes all slips, payments, checks (in and out), returns, stock-ins, bank entries, deposits, drawer counts, counter receipts, purchase orders, imported sales and notices. Tick what to keep. Download a backup first. 删除所有单据、收款、收到/开出支票、退货、进货、银行记录、存款、点钱、对账单、采购单、导入销售和通知。勾选要保留的。先下载备份。
Staff, PINs, settings, categories and year setup are always kept. 员工、密码、设定、分类、年度参数一律保留。
A full copy is saved to Google Drive (folder 「H.S.T.C 自动备份 Backups」) before anything is cleared. 清空前自动在 Google Drive 存一份完整副本。
Printing 打印对位
Positions come from your Excel forms (A42 / 正单 / DR). If the print lands off the pre-printed boxes: print a test page with the grid, measure how far it is off, then shift (mm, + = right / down) or scale (%). 打印偏了：先打测试页，量偏差，再调整位移或缩放。
| Form | Paper W mm | Paper H mm | Shift X mm | Shift Y mm | Scale X % | Scale Y % | QR X | QR Y | QR size | Text % | Items % | Feed 送纸 |
|---|
Move one item 单项微调 — e.g. DR total too low: Up/Down −10 = 10 mm higher 例：DR 合计太低，上下填 −10 就往上 10 毫米
| Form | Item 项目 | Up(−) / Down(+) mm 上下 | Left(−) / Right(+) mm 左右 |
|---|
Daily summary & archive 日汇总与归档
Every night (about 1 AM): the daily summary is updated, today’s receivables are saved, and settled records (fully paid slips, their receipts, voids) older than the keep days move to the archive file. Their totals stay in the summary, so reports, staff sales, the dashboards and the monthly summary do not change. Not archived: unpaid / part-paid slips, slips paid by a check until that check has cleared (in hand / deposited stay), prepaid money, pending items, booklets still in use. Keep days 0 = everything before today. 每晚约 1 点：更新日汇总、保存应收，并把已结清的单据（全额付清、作废）移到归档文件；统计数字不变。不归档：未付/部分付、支票付款但支票还没过账的、预收、待确认、本子还没用完的。保留天数 0 = 今天以前的全部归档。