Concepcion, TarlacFRANCHISE

Finance

Franchise

Shift cash reconciliation, petty cash, payouts, utility bills, and email audit trail for Concepcion, Tarlac.

Shifts logged

-₱655.27

Net Over / Short

Invalid shortages

₱15,008

Company loss

Escalated to NTE

Shift Reports — Cash Reconciliation

Opening float (₱5,000–₱8,000) → Expected drawer → Counted → Deposit · Over/Short and Should-be deposit auto-compute · Invalid + Loss auto-flags NTE

Should Deposit	Over / Short	Warning / NTE
₱6,075.91	+₱0.09	—
₱1,556	0	—
₱11,410.01	-₱15,000.01	Added to NTE Tracker
₱3,337.65	-₱1.65	—
₱3,063	+₱1	—
₱973.85	+₱3,590.15	—
₱197.71	-₱8.71	—
₱867.43	+₱3,589.57	—
₱1,409.43	+₱3,584.57	—
₱1,387.28	+₱3,589.72	—

How the math works: Should Deposit = Expected − Opening. Over/Short = Actual Deposit − Should Deposit. Negative = shortage. Set Status = Invalid + fill Company Loss when the shortage is a real loss (theft/scam/negligence), then click + Send to NTE to escalate.

SOP:Open with change fund (₱5k–₱8k). Close → count → envelope → safekeep → deposit ASAP. After deposit, fill Actual Deposit from the deposit slip #. Company loss feeds Franchise P&L → Other Deductions and rolls up to AM shortage report.

Fund cap

₱20,000

Admin-locked

Current balance

₱19,120

Refills when status = Replenished

Outstanding

₱880

1 Pending · 2 Sent to Finance

Total entries

All-time

Receipt issuance — write these details on every Sales Invoice / Official Receipt:

Name: Account Ventures Inc

Address: Unit 403 Coojing Building, President Ave B.F. Homes, 1720, Paranaque City, Philippines

TIN: 010-536-321-00000

Petty Cash Fund

Vendor pulls from Vendors · Every expense needs a supporting doc · Replenish weekly

Show:Hide replenished(1 replenished)

Showing 4 of 4 entries

Amount	Finance Category auto-derived	Description
₱	e.g., PCF voucher, ballpen, logbook, market list	Bond paper, pens, printer ink for branch audit docs
₱	e.g., Glade Air Freshener, Dishwashing, Doormat, Squeegee, Broom, Mop, Zonrox, Baygon	Trash bags + cleaning solution (emergency restock)
₱	e.g., Transportation allowance for buying garlic or bank deposit	Tricycle fare for emergency garlic supply run
₱	e.g., Aircon Cleaning, Fryer checkup, Greasetrap, declogging, water analysis	Light bulb replacement (3 pcs) — kitchen area

Auto-email per entry

Emergency Payout is for unplanned, time-sensitive expenses (broken equipment, customer refunds, etc.). Unlike PCF, each entry is emailed to Finance individually and immediately after you fill it in and upload the receipt. Status flips from “Paid out” → “Sent to finance”.

Receipt issuance — write these details on every receipt:

Name: Account Ventures Inc

Address: Unit 403 Coojing Building, President Ave B.F. Homes, 1720, Paranaque City, Philippines

TIN: 010-536-321-00000

Total payouts

₱2,105

Total amount

Paid out (not sent)

Sent to finance

Emergency Payout

Each entry auto-emails Finance once complete · Vendor pulls from Vendors

Status	Amount	Description	Action
Sent to finance	₱	Emergency repair — broken faucet plumber. Approved by AM.	Sent 2026-06-03
Sent to finance	₱	Refund + replacement delivery — wrong order (FP).	Sent 2026-06-05
Paid out	₱	Customer refund — missing item (GF). Cash from drawer.

Bills auto-emailed to Finance per BOK SOP

· To: AP_Team@aviph.com
· CC (Corporate branches only): Area Manager + grace.ilagan@aviph.com
· Subject format: BOK [Branch] | [Supplier] [Billing Period] (Due date [Due Date])
· Bills must be sent at least 8 days before due date

Total bills tracked

Sent

Pending — on track

Pending — overdue

Utility Bills Monitoring

Send each bill to Finance as soon as it arrives

Utility Bill Supplier	Billing Period	Due Date	Date Emailed to Finance
No bills tracked yet — click “Send a bill” when the first utility bill arrives.

Transactions

₱1,675.00

Gross before discount

₱335.00

Total discount

₱1,340.00

VAT-exempt sales

PWD & Senior Discount Log — June 2026

For BIR compliance · 20% discount per RA 9994 (Senior) / RA 10754 (PWD)

Date	Transaction#	Customer	ID	Gross	Discount	Type
01 Jun 2026	TXN-04822	Jose Reyes	PWD ID 12345	₱580.00	₱116.00	Senior + PWD discount
03 Jun 2026	TXN-04915	Maria Santos	PWD ID 67890	₱320.00	₱64.00	PWD only
04 Jun 2026	TXN-04988	Carlos Lim	Senior ID 24681	₱480.00	₱96.00	Senior only
06 Jun 2026	TXN-05102	Anna Cruz	PWD ID 35792	₱295.00	₱59.00	PWD only

168

Total vendors

Categories used

PCF · Emergency Payout

Referenced by

Vendors

Add vendors here once · they become selectable in Petty Cash Fund and Emergency Payout

Vendor Name	Category	Contact	Phone	Notes

All portal emails tracked here

Utility Bill submissions, PCF Replenishment requests, and any future automated emails appear in this log. In production, emails are sent via Microsoft Graph API on behalf of the signed-in user — so each email also appears in their own Outlook Sent folder for two-way audit.

Total emails sent

PCF Replenishment

Utility Bills

Email Log

Read-only audit trail · Most recent first

Date sent	Type	From	To	Subject	Status
2026-06-12 14:32	Utility Bill	brian.luczon@aviph.com (via portal)	AP_Team@aviph.com	BOK Antipolo \| Meralco May 11 – Jun 10, 2026 (Due date June 20, 2026)	Delivered
2026-06-16 09:15	Utility Bill	brian.luczon@aviph.com (via portal)	AP_Team@aviph.com	BOK Antipolo \| Manila Water May 15 – Jun 14, 2026 (Due date June 25, 2026)	Delivered