Precious Cabana Ynna OPC — TIN: 010-515-559-00000
🌅 Morning Review Checklist
Complete every item before recording the day's transactions. Date: —
ℹ️
Accrual Method Reminder: Record revenue when earned and expenses when incurred — not necessarily when cash is received or paid. This is required by BIR for VAT-registered entities.
Step 1 — Check Previous Day's Closing Balances
  • Cash on Hand — verify against yesterday's cash count sheet
  • Cash in Bank — note beginning balance from bank ledger
  • Accounts Receivable — list outstanding unpaid invoices
  • Accounts Payable — list outstanding unpaid supplier bills
  • Unearned Revenue — note any advance bookings still unearned
Step 2 — Collect & Sort All Invoices
⚠️ BIR Rule: Only transactions with a BIR-registered Official Receipt (OR) or Sales Invoice (SI) can be recorded for tax purposes. Do NOT book transactions without invoices.
  • Collect all Sales Invoices / ORs issued yesterday (Resort, Retail, Restaurant)
  • Collect all Supplier Invoices / ORs received yesterday
  • Check each invoice for complete details: Date · Customer/Supplier Name · TIN · Gross Amount · VAT Amount · Net Amount
  • Separate invoices by category: Room · Retail · Restaurant · Purchases
  • Flag any invoice missing details — do NOT record until corrected
Step 3 — Review Daily Reports & Upcoming Deadlines
  • Review Resort occupancy/sales report from front desk
  • Review Retail Store daily sales summary
  • Review Restaurant daily sales / F&B report
  • Check BIR/payroll/supplier payment deadlines (see separate deadline sheet)
  • Confirm scheduled payments for the day
📝 Record Daily Transactions
Enter each transaction with its invoice. Entries must be in chronological order.
ℹ️ For room revenue: if cash is collected today for a future stay, record as Unearned Revenue. Only recognize income when the guest actually checks in/stays.
Room Booking Revenue Sales Journal + General Journal
🏷️ Discount / Guest Type
💰 Amount Computation
🏛️ Withholding Tax (Government / Corporate Clients)
🏖️ PCY Resort Rates & Amenities
Official rate card of Precious Cabana Ynna Beach Resort & Hotels — for front desk and billing reference.
🏨 Room Rates (Per Night, VAT-inclusive)
Room TypeRate ₱VAT ₱Net ₱
🛖 Cottage, Pavilion & Tables
Unit / TypeDayRate ₱VAT ₱
🏊 Entrance & Swimming Pool
TypeCategoryRate ₱
🎯 Amenities & Recreational Charges
ItemUnitRate ₱
📋 Rate Notes & Policies
  • ✓
    All room rates are per night, VAT-inclusive. Breakfast and other inclusions depend on room package.
  • ✓
    Cottage rate: ₱1,800 on Fridays, Saturdays, Sundays, and Public Holidays. ₱1,500 on Mondays to Thursdays.
  • ✓
    Pavilion rate: ₱5,000 on Fridays, Saturdays, Sundays, and Public Holidays. ₱4,000 on Mondays to Thursdays.
  • ✓
    Table Charge: ₱1,200 flat. Umbrella: ₱800 flat.
  • ✓
    Karaoke is charged per hour (₱500). Basketball and Billiard are per session rental.
  • ✓
    Life Vest rental: ₱50. Kayak: ₱300/hr. All amenity rentals must be recorded with OR.
  • ✓
    Senior Citizen and PWD guests are entitled to 20% discount on the VAT-exclusive amount with VAT fully waived (RA 9994 / RA 10754). SC/PWD ID required.
  • ✓
    All rates are subject to change. Any rate changes must be approved by management and this rate card updated accordingly.
⚖️ Accrual Adjustments
Make end-of-period adjustments to properly match revenue & expenses to the period earned/incurred.
ℹ️ Accrual adjustments ensure your financial statements reflect economic reality — not just cash flows. Required under the accrual method mandated by BIR.
Accrue Earned but Unbilled Revenue
Example: A guest stayed for 3 nights but you haven't issued an invoice yet. You must still recognize the income earned each night.
📋 Journal Entry: Dr. Accrued Income ↑ / Cr. Gross Income ↑
Accrue Incurred but Unpaid Expenses
Example: December electricity bill will arrive in January, but the expense belongs to December. Accrue it now.
📋 Journal Entry: Dr. Expense ↑ / Cr. Accrued Liabilities ↑
Adjust Prepaid Expenses / Unearned Revenue
📋 Journal Entry: Dr. Expense ↑ / Cr. Prepaid Expense ↓
🔍 Daily Reconciliation
Verify all books balance before closing the day.
Cash & Bank Reconciliation
Accounts Receivable Check
  • All credit sales have a matching Sales Invoice
  • All collections recorded in Cash Receipts Journal
  • AR subsidiary ledger matches control account in General Ledger
  • Outstanding AR list is updated with new balances
Accounts Payable Check
  • All purchases have a matching Supplier Invoice with TIN
  • All payments recorded in Purchases Journal
  • AP subsidiary ledger matches control account in General Ledger
  • Upcoming due dates checked and flagged
Sales Matching Check
  • Resort: Room bookings recorded = Front desk report total
  • Retail: Sales journal total = Retail POS/sales report total
  • Restaurant: F&B sales recorded = Restaurant daily report total
  • Output VAT total reconciles with OR/SI VAT amounts
🌙 End-of-Day Report & Closing
Summarize the day's activities and prepare for tomorrow.
Room Revenue
₱0
Today's accommodation
Retail + F&B
₱0
Outlets combined
Total Purchases
₱0
Expenses today
Output VAT
₱0
Collected today
End-of-Day Posting Checklist
  • Post all journal entries to General Journal
  • Post sales to Sales Journal
  • Post purchases to Purchases Journal
  • Post collections to Cash Receipts Journal
  • Update Accounts Receivable subsidiary ledger
  • Update Accounts Payable subsidiary ledger
  • Post all entries to General Ledger
  • Compute depreciation & amortization (if applicable today)
Verification & Filing
  • Review all entries for accuracy — amounts, accounts, dates
  • Investigate and note any discrepancies found
  • Physically file all invoices and receipts in dated folder
  • Update digital backup / cloud records
  • Note tomorrow's tasks or outstanding follow-ups
📋 Day Summary Notes
📚 Chart of Accounts & Books Reference
Quick reference for which books and accounts to use for each transaction type.
Books of Accounts — PCY OPC
1

General Journal

Primary book of original entry for all transactions. Every entry goes here first before being posted elsewhere.

2

General Ledger

Summary of all accounts. Entries from all journals are posted here. The source of trial balance and financial statements.

3

Sales Journal

Records all sales on account and cash sales (Room, Retail, Restaurant). Includes OR/SI details, gross amount, VAT, and net amount.

4

Purchases Journal

Records all purchases from suppliers. Must have supplier TIN and official invoice for input VAT claims.

5

Accounts Receivable Ledger

Individual records per customer for credit sales. Must match the AR control account in the General Ledger.

6

Accounts Payable Ledger

Individual records per supplier for purchases on account. Must match the AP control account in the General Ledger.

7

Cash Receipts Journal

Records all cash and bank receipts — from sales, collections, advance payments, and other cash inflows.

Accounts to Update — by Transaction Type
🏨 Room Revenue (Earned)
  • Cash on Hand or Cash in Bank (Debit ↑)
  • Withholding Taxes Payable (Cr if applicable)
  • Gross Income — Room Revenue (Credit ↑)
  • Output VAT (Credit ↑)
  • VAT Relief/SLSP (update)
  • Cost of Sales (Debit ↑)
💰 Advance Payments (Future Stay)
  • Cash on Hand or Cash in Bank (Debit ↑)
  • Unearned Revenue (Credit ↑)
  • VAT Relief/SLSP (update)
  • No income recognized yet
🛒 Retail / Restaurant Sales
  • Cash on Hand or Cash in Bank (Debit ↑)
  • or Accounts Receivable (if on credit)
  • Gross Income (Credit ↑)
  • Output VAT (Credit ↑)
  • Inventory (Credit ↓)
  • Cost of Goods Sold (Debit ↑)
  • VAT Relief/SLSP (update)
📦 Purchases / Expenses
  • Inventory or Expense (Debit ↑)
  • Input VAT (Debit ↑)
  • Cash on Hand (Credit ↓) — if paid cash
  • Cash in Bank (Credit ↓) — if paid via bank
  • or Accounts Payable (if on account)
  • VAT Relief/SLSP (update)
⚖️ Accrued Revenue
  • Accrued Income / AR (Debit ↑)
  • Gross Income (Credit ↑)
⚖️ Accrued Expense
  • Expense Account (Debit ↑)
  • Accrued Liabilities (Credit ↑)
🧮 VAT Calculator
Quickly compute VAT-inclusive and exclusive amounts for bookkeeping entries.
12% VAT Computation
Quick formula:
• Net → VAT: Net × 0.12
• Gross → VAT: Gross ÷ 1.12 × 0.12
• Gross → Net: Gross ÷ 1.12
Withholding Tax Quick Reference
Transaction TypeRateNotes
Professional fees (individual)5% / 10%5% if gross < ₱3M/yr; 10% if ≥ ₱3M/yr
Professional fees (corporation)10% / 15%10% if gross < ₱720K; 15% if ≥ ₱720K
Rental (commercial)5%On gross rental
Contractor / sub-contractor2%On contract price
Payments to hotels (lodging)2%If payor is top 20K corp
Commission (individual)10% / 15%Same thresholds as professional
🏦 Income Tax Calculator — TRAIN Law
Republic Act 10963 — Tax Reform for Acceleration and Inclusion (TRAIN). Effective January 1, 2023 onwards. For Precious Cabana Ynna OPC and individual taxpayer reference.
ℹ️ OPC Note: A One Person Corporation (OPC) is taxed as a regular domestic corporation — 25% Regular Corporate Income Tax (RCIT) on net taxable income, or 1% MCIT (Minimum Corporate Income Tax) on gross income if RCIT is lower. The individual TRAIN brackets below apply to Atty. Torres's personal income (compensation, professional fees, etc.).
🏢 OPC / Corporate Income Tax — RCIT & MCIT
⚠️ Precious Cabana Ynna OPC is subject to: 25% RCIT on net taxable income, or 1% MCIT on gross income — whichever is higher. MCIT applies only from the 4th year of operations onwards.
📊 Enter Annual Figures (₱)
📋 RCIT Tax Rate Table (TRAIN Law — RA 10963)
PeriodRCIT RateMCIT RateBasisBIR Form
Jan 1, 2020 – Jun 30, 202030%2%Net taxable income1702-RT
Jul 1, 2020 – Dec 31, 202225%1%*Net / Gross income1702-RT
Jan 1, 2023 onwards ✅25%1%Net / Gross income1702-RT
*MCIT was temporarily reduced to 1% from Jul 1, 2020 to Jun 30, 2023 (CREATE Act). It has remained at 1% under TRAIN/CREATE. MCIT applies only from the 4th taxable year of operations. OPC pays the higher of RCIT or MCIT.
📑 VAT Summary Report — Output & Input Tax
Printable VAT summary for BIR Forms 2550M (monthly) and 2550Q (quarterly). TIN: 010-515-559-00000.
ℹ️ Select a period and click Generate to compile the VAT report from your saved transactions.
🎓 BIR Compliance Guide
Key rules to avoid audit issues — every staff member must know these.
⚠️
CRITICAL: Bookkeeping errors that trigger BIR audits include: missing invoices, unregistered OR/SI series, unreported income, and improper VAT claims. When in doubt, ask before booking.
Invoice Requirements Checklist
Every OR and SI must have ALL of these fields — no exceptions:
  • ✓
    Date of the transaction
  • ✓
    Name of customer or supplier
  • ✓
    TIN of customer or supplier
  • ✓
    Gross Amount (total charged)
  • ✓
    VAT Amount (12% VAT separately stated)
  • ✓
    Net Amount (amount before VAT)
  • ✓
    BIR-stamped / registered OR or SI series number
Key BIR Tax Deadlines (Monthly)
DeadlineFormDescription
10th of monthBIR Form 1601-CMonthly remittance of withholding taxes on compensation
10th of monthBIR Form 0619-EMonthly remittance of expanded withholding tax
20th of monthBIR Form 2550MMonthly VAT return
25th of quarterBIR Form 2550QQuarterly VAT return
15th of next monthBIR Form 1601-EQQuarterly expanded withholding tax return
Last day of month +1SLSPSummary List of Sales & Purchases (quarterly)
SLSP (VAT Relief) — What to Record
Summary List of SALES
  • Buyer's name
  • Buyer's TIN
  • OR/SI number
  • Date issued
  • Gross amount
  • Exempt/zero-rated amount
  • VATable amount
  • Output VAT
Summary List of PURCHASES
  • Supplier's name
  • Supplier's TIN
  • Invoice number
  • Date received
  • Gross amount
  • VATable purchase amount
  • Input VAT claimable
⚠️ Input VAT can ONLY be claimed from suppliers who are also VAT-registered. Always verify supplier VAT registration before claiming input VAT.
🏢 Non-VAT vs VAT Supplier — Bookkeeping Treatment
Supplier TypeInput VAT Claimable?Journal Entry TreatmentSLSP TreatmentBIR Basis
VAT-Registered ✅ YES Dr. Expense (Net) + Dr. Input VAT | Cr. Cash/AP (Gross) Include in Summary List of Purchases with full VAT breakdown NIRC Sec. 110
Non-VAT (below ₱3M) 🚫 NO Dr. Expense (FULL invoice amount) | Cr. Cash/AP — NO Input VAT entry Do NOT include input VAT; list in exempt purchases column only NIRC Sec. 109
Exempt Entity (Coop, etc.) 🚫 NO Dr. Expense (FULL amount) | Cr. Cash/AP — NO Input VAT List as VAT-exempt purchase; zero input VAT NIRC Sec. 109
Government Entity 🚫 NO Dr. Expense (Net) | Cr. Cash/AP — Government not a VAT supplier Separate treatment; WV may apply RR 14-2005
How to verify supplier VAT status: Go to bir.gov.ph → TIN Verifier, or call BIR at 8538-3200. Ask supplier for their Certificate of Registration (BIR Form 2303) which shows if they are VAT or Non-VAT registered.
PCY OPC Tax Identification
Registered Name
Precious Cabana Ynna OPC
TIN
010-515-559-00000
VAT Status
✅ VAT-Registered Entity
This TIN must appear on all Sales Invoices and Official Receipts issued by PCY OPC, and on the buyer's name line of all purchase invoices received.
!

Unrecorded Cash Sales

All cash received must be recorded regardless of amount. Unrecorded cash income is a top BIR finding.

!

Input VAT from Non-VAT Suppliers

You can only claim input VAT credits from VAT-registered suppliers. Using non-VAT supplier invoices to claim credits is a violation. Always check supplier VAT status via the BIR TIN Verifier before recording input VAT.

!

Missing Supplier TIN on Purchase Invoices

Every purchase invoice used for input VAT must show the supplier's TIN. Invoices without TIN cannot be included in the SLSP and the input VAT cannot be claimed. Get corrected invoices from suppliers before filing.

!

Expenses Without Official Receipts

All expense claims must have a BIR-registered Official Receipt from the supplier. Informal receipts do not count.

!

Incomplete Invoice Details

Missing TIN, missing VAT breakdown, or wrong dates on invoices are common audit issues. Check every invoice before filing.

!

Misclassified Advance Payments

Advance bookings must be recorded as Unearned Revenue, not income, until the service is rendered. Recognizing early inflates taxable income incorrectly.

📊 Transaction Log
All transactions recorded in this session. This is your working reference before posting to your physical books.
Total Entries
0
Total Revenue
₱0.00
Total Expenses
₱0.00
Net VAT Payable
₱0.00
Today's Transactions
# Date Time Entered Type Description Invoice # Net ₱ VAT ₱ Gross ₱ VAT Status Dr. Account Cr. Account Actions
No transactions recorded yet. Go to Record Transactions to begin.
🗒️ Daily Summary Report
Complete end-of-day summary across all revenue streams, discounts, VAT, and expenses — ready to print.
ℹ️ Select a date and click Generate Summary. Works for any past date — data is saved permanently on this device.
📅 Monthly Summary Report
Aggregates all saved transactions for the selected month. Data persists across days automatically.
ℹ️ Select a month and click Generate.
📆 Yearly Summary Report
Full year overview with month-by-month breakdown — ideal for BIR annual returns and management review.
ℹ️ Select a year and click Generate.
🔑 Staff Account Management
Create and manage login accounts for all PCY bookkeeping staff. Only the Owner can access this panel.
⚠️ Security: Each staff member has their own email and password. Never share the Owner account. Roles control what each person can see and do.
🎭 Role Permissions
RoleRecord TransactionsView SummariesPayrollIncome Tax / VAT ReportsStaff ManagementDelete Records
✅✅✅✅✅✅
✅✅✅✅❌❌
✅✅View onlyView only❌❌
✅ (own entries)Daily only❌❌❌❌
➕ Create New Staff Account
After creating the account, share the email and temporary password with the staff member. They will use it to log in from any device.
👥 Current Staff Accounts
NameEmailRoleDepartmentCreatedPasswordActions
Loading staff accounts…
🔑 How to Retrieve / Reset a Staff Password
Step 1. Enter the staff member's email address below.
Step 2. Click Send Password Reset Link.
Step 3. The staff member receives an email from Firebase / Google with a secure reset link.
Step 4. They click the link, create a new password, then log in normally.
Note: The reset link expires after 1 hour. If not received, check the spam folder or verify the email is correct.
⚠️ Owner use only. Do NOT create a new account for a forgotten password — always use this reset feature to maintain the same account.
🗑️ Remove Staff Account Access
Permanently removes the staff member's login record from this system. This action cannot be undone. The staff member will no longer be able to log in.
🔒 Set Local Password (for offline / file access)
ℹ️ When the system is opened directly from a file (not from a web server), Firebase Authentication may be blocked by the browser. Use this to store a local password in Firestore so you can still sign in. Set this for your own account and for each staff member.
This does not change the Firebase Auth password. It only stores a password in Firestore for use when signing in from a local HTML file.
👥 Employee Setup
Add and manage all employees of Precious Cabana Ynna OPC. Data is saved on this device.
ℹ️ Basic Salary here is the monthly rate. The system uses 26 working days/month as the standard divisor for daily rate computation (per DOLE guidelines).
Add New Employee
Employee List
#NamePositionDepartmentMonthly SalaryTypeActions
No employees yet. Add one above.
💳 Compute Payslip
Automatically calculates SSS, PhilHealth, Pag-IBIG, and withholding tax based on current BIR/DOLE rates.
Payslip Details
📌 Mandatory Contribution Reference (2024)
ContributionEmployee ShareEmployer ShareBasis
SSS4.5% of MSC9.5% of MSCMonthly Salary Credit (max ₱20,000)
PhilHealth2.5% of basic2.5% of basicMax premium ₱5,000/month
Pag-IBIG1–2% (max ₱100)₱100 flat1% if ≤₱1,500; 2% if >₱1,500
Withholding TaxPer BIR tableNoneAnnual tax ÷ 12; 0% if annual taxable ≤₱250,000
13th Month Pay: All rank-and-file employees are entitled to 1/12 of total basic salary earned during the year. Due not later than December 24. Tax-exempt up to ₱90,000.
📋 Monthly Payroll Register
Summary of all payslips for the selected month. Use this for BIR Form 1601-C filing and payroll journalizing.
#EmployeeDept.Gross ₱Mandatory Ded. ₱W.Tax ₱Total Ded. ₱Net Pay ₱ER Contrib. ₱
Select a month and click Load Register.
BIR & Contribution Remittance Deadlines
FormDescriptionDue Date
BIR 1601-CMonthly withholding tax on compensation10th of following month
SSS R-3SSS contribution collection listLast day of following month
PhilHealth RF-1PhilHealth premium contributions10th–15th of following month
Pag-IBIG MCRFPag-IBIG monthly contribution remittance10th–15th of following month
BIR 2316Certificate of compensation per employeeJanuary 31 (annual)
BIR 1604-CAnnual information return on compensationJanuary 31
🧾 Acknowledgement Receipt (AR)
Issue an AR for down payments and advance bookings. AR is not a Sales Invoice or Official Receipt.
📋 Generate AR
ℹ️ An AR acknowledges receipt of down payment only. Sales Invoice is issued on check-in. Official Receipt on full payment.
📋 Recent ARs
AR No.DateReceived FromAmount
No ARs yet.
🧾 Official Receipt (OR)
Issue an OR for full payments received upon check-out or service completion.
📋 Generate OR
Output VAT (12/112):₱0.00
Net of VAT:₱0.00
📋 Recent ORs
OR No.DateReceived FromAmount
No ORs yet.
🧾 Sales Invoice (SI)
Issue a Sales Invoice upon check-in or service rendered.
📋 Generate SI
Discount:₱0.00
Output VAT (12/112):₱0.00
TOTAL DUE:₱0.00
📋 Recent SIs
SI No.DateCustomerAmount
No SIs yet.
🗑️ Delete Entries
Delete test or erroneous entries by date. Only the Owner can access this feature.
⚠️ Warning: Deleted entries are permanently removed from Firestore and cannot be recovered. Please review carefully before confirming deletion.
📅 Select Date Range to Delete