Promissory Note Sample for Burial Assistance Tagalog
Having a well-structured promissory note sample for burial assistance tagalog is the single most important step you can take to ensure consistency, reduce errors, and save countless hours. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive Promissory Note Sample for Burial Assistance Tagalog template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.
What is a Promissory Note Sample for Burial Assistance Tagalog?
A promissory note sample for burial assistance tagalog is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the legal-contracts domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as an editable CSV spreadsheet for Microsoft Excel and Google Sheets, alongside a clean printable PDF.
Spreadsheet/Log Preview
Standard Operating Procedure
Registry ID: TR-PROMISSO
System Overview & Objectives
Purpose: This enterprise spreadsheet framework establishes a standardized operational ledger and promissory note tracking system for burial assistance funds administered by local government units (LGUs), charitable institutions, or corporate social responsibility (CSR) programs in the Philippines. It manages financial obligations executed in Tagalog/Filipino, tracking principal amounts, amortization schedules, guarantor details, and settlement statuses.
Operational Scope:
- Records beneficiary and guarantor identities, mortuary facility details, and approved burial assistance allocations.
- Calculates remaining balances, default risk metrics, and collection performance indicators.
- Accommodates bilingual documentation (Tagalog promissory note texts embedded via metadata and formal English tracking columns).
Update Cadence: Real-time transaction logging with weekly reconciliation reports and monthly executive dashboard updates.
Master Data Spreadsheet Table (PRIMARY EXPORT SHEET)
| ID | Date | Entity_Name | Tagalog_Note_Ref | Category | Funeral_Home | Principal_Amount | Partial_Paid | Net_Balance | Status | Owner | Target_Settlement | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PN-2023-001 | 2023-10-12 | Juan Dela Cruz | "Ako si Juan Dela Cruz..." | Burial Assistance | St. Peter Chapels | 15000.00 | 5000.00 | 10000.00 | Active | M. Santos | 2023-12-15 | Guarantor: Maria Dela Cruz |
| PN-2023-002 | 2023-10-15 | Elena Santos | "Sa pamamagitan ng kasulatang..." | Financial Aid | Funeraria Paz | 20000.00 | 20000.00 | 0.00 | Settled | J. Reyes | 2023-11-15 | Fully paid via cash voucher |
| PN-2023-003 | 2023-10-18 | Roberto Gomez | "Ipinapangako ko na babayaran..." | Burial Assistance | Cosmopolitan Memorial | 12000.00 | 2000.00 | 10000.00 | Overdue | M. Santos | 2023-11-18 | Requires legal follow-up |
| PN-2023-004 | 2023-10-22 | Analyn Ramos | "Ako si Analyn Ramos, may sapat..." | Casket Subsidy | Heritage Park | 10000.00 | 10000.00 | 0.00 | Settled | A. Cruz | 2023-11-22 | Subsidy released in full |
| PN-2023-005 | 2023-11-03 | Carlos Mendoza | "Ako si Carlos Mendoza ay nangangako..." | Burial Assistance | Sanctuario de San Jose | 25000.00 | 5000.00 | 20000.00 | Active | J. Reyes | 2024-01-15 | Installment plan approved |
| PN-2023-006 | 2023-11-10 | Marilou Bautista | "Batid ko ang aking utang..." | Financial Aid | Manila Memorial Park | 15000.00 | 0.00 | 15000.00 | Active | M. Santos | 2024-01-10 | Awaiting 1st installment |
| PN-2023-007 | 2023-11-15 | Generoso Villanueva | "Ako si Generoso Villanueva..." | Burial Assistance | Loyola Memorial | 18000.00 | 9000.00 | 9000.00 | Active | A. Cruz | 2023-12-31 | 50% paid on execution |
| PN-2023-008 | 2023-11-20 | Rosalinda Aquino | "Sa kasulatang ito, ako ay..." | Casket Subsidy | Arlington Memorial | 12000.00 | 12000.00 | 0.00 | Settled | J. Reyes | 2023-12-20 | Completed via LGU grant |
| PN-2023-009 | 2023-11-25 | Edgardo Ramos | "Ako si Edgardo Ramos ay nangangako..." | Financial Aid | St. Peter Chapels | 20000.00 | 5000.00 | 15000.00 | Overdue | M. Santos | 2023-12-10 | Defaulted on 2nd tranche |
| PN-2023-010 | 2023-12-02 | Lilibeth Santos | "Bilang pagtupad sa kasunduan..." | Burial Assistance | Funeraria Paz | 15000.00 | 15000.00 | 0.00 | Settled | A. Cruz | 2023-12-30 | Closed account |
| PN-2023-011 | 2023-12-05 | Fernando Cruz | "Ako si Fernando Cruz ay lumagda..." | Burial Assistance | Cosmopolitan Memorial | 25000.00 | 10000.00 | 15000.00 | Active | J. Reyes | 2024-02-15 | PDCs submitted |
| PN-2023-012 | 2023-12-10 | Jocelyn Reyes | "Sa pamamagitan ng kasulatang ito..." | Financial Aid | Heritage Park | 10000.00 | 0.00 | 10000.00 | Active | M. Santos | 2024-02-10 | New promissory note |
| PN-2023-013 | 2023-12-12 | Danilo Morales | "Ako si Danilo Morales ay nangangako..." | Casket Subsidy | Sanctuario de San Jose | 12000.00 | 4000.00 | 8000.00 | Active | A. Cruz | 2024-02-28 | Bi-monthly payments |
| PN-2023-014 | 2023-12-15 | Corazon Dizon | "Batid ko ang aking pananagutan..." | Burial Assistance | Manila Memorial Park | 30000.00 | 15000.00 | 15000.00 | Active | J. Reyes | 2024-03-15 | Emergency medical case |
| PN-2023-015 | 2023-12-18 | Ricardo Santos | "Ako si Ricardo Santos ay nangangako..." | Financial Aid | Loyola Memorial | 15000.00 | 0.00 | 15000.00 | Overdue | M. Santos | 2024-01-18 | Uncontactable at address |
Pre-Built Formulas & Calculation Logic
| Target Cell / Range | Formula Name | Exact Formula (Excel & Google Sheets) | Calculation Purpose |
|---|---|---|---|
I2 (Net_Balance) | Balance Calculation | =G2-H2 | Computes remaining financial obligation by subtracting partial payments from the principal amount. |
N2 (Total Principal) | Aggregate Principal | =SUM(G2:G16) | Calculates total financial exposure across all executed promissory notes. |
N3 (Total Collected) | Aggregate Collections | =SUM(H2:H16) | Sums all realized cash recoveries and partial payments. |
N4 (Total Outstanding) | Aggregate Outstanding | =SUM(I2:I16) | Computes total unpaid balance remaining across all accounts. |
N5 (Active Count) | Active Note Count | =COUNTIF(J2:J16, "Active") | Counts total number of active, non-settled promissory notes. |
N6 (Overdue Count) | Overdue Note Count | =COUNTIF(J2:J16, "Overdue") | Identifies accounts in default past their target settlement date. |
N7 (Recovery Rate) | Collection Efficiency | =N3/N2 | Evaluates percentage of funds recovered against total principal extended. |
Data Dictionary & Dropdown Validation Rules
| Column Header | Data Format | Required / Optional | Dropdown Validation Rules (Comma-Separated Values) |
|---|---|---|---|
| ID | Text (Alphanumeric) | Required | N/A (Manual Entry / Auto-ID) |
| Date | Date (YYYY-MM-DD) | Required | N/A (Date Picker) |
| Entity_Name | Text (Proper Case) | Required | N/A (Free Text) |
| Tagalog_Note_Ref | Text (Quoted String) | Required | N/A (Free Text / Template String) |
| Category | Text | Required | Burial Assistance, Financial Aid, Casket Subsidy |
| Funeral_Home | Text | Required | St. Peter Chapels, Funeraria Paz, Cosmopolitan Memorial, Heritage Park, Sanctuario de San Jose, Manila Memorial Park, Loyola Memorial, Arlington Memorial |
| Principal_Amount | Currency (PHP, 2 decimals) | Required | N/A (Numeric Greater than 0) |
| Partial_Paid | Currency (PHP, 2 decimals) | Required | N/A (Numeric Greater than or equal to 0) |
| Net_Balance | Currency (PHP, 2 decimals) | Required | =G2-H2 (Calculated Field) |
| Status | Text | Required | Active, Settled, Overdue |
| Owner | Text (Initials/Name) | Required | M. Santos, J. Reyes, A. Cruz |
| Target_Settlement | Date (YYYY-MM-DD) | Required | N/A (Date Picker) |
| Notes | Text | Optional | N/A (Free Text) |
Summary KPI Dashboard
| KPI Metric | Formula / Logic | Target Benchmark | Red Threshold | Amber Threshold | Green Threshold |
|---|---|---|---|---|---|
| Total Principal Exposure | =SUM(G2:G16) | N/A (Tracking) | N/A | N/A | Informational |
| Total Collected Funds | =SUM(H2:H16) | N/A (Tracking) | N/A | N/A | Informational |
| Net Outstanding Balance | =SUM(I2:I16) | < ₱100,000.00 | > ₱150,000.00 | ₱100,000 - ₱150,000 | < ₱100,000.00 |
| Collection Recovery Rate | =N3/N2 | > 75.0% | < 50.0% | 50.0% - 74.9% | >= 75.0% |
| Overdue Default Count | =COUNTIF(J2:J16, "Overdue") | 0 Accounts | > 3 Accounts | 1 - 3 Accounts | 0 Accounts |
| Active Portfolio Count | =COUNTIF(J2:J16, "Active") | N/A (Tracking) | N/A | N/A | Informational |
Setup & Export Guide for Excel & Google Sheets
-
CSV Export Preparation:
- Copy the Markdown table data provided in the Master Data Spreadsheet Table section.
- Paste the contents into a blank text editor and save the file as
Burial_Assistance_Ledger.csv.
-
Importing into Microsoft Excel:
- Open Microsoft Excel, navigate to Data > From Text/CSV, and select
Burial_Assistance_Ledger.csv. - Ensure the delimiter is set to Comma, and verify data types (set
Datecolumns to Date, andPrincipal_Amountto Currency). - Click Load to populate Sheet1.
- Open Microsoft Excel, navigate to Data > From Text/CSV, and select
-
Importing into Google Sheets:
- Open Google Sheets, click File > Import, and upload
Burial_Assistance_Ledger.csv. - Select Replace current sheet or Insert new sheet, and ensure "Convert text to numbers, dates, and formulas" is checked. Click Import data.
- Open Google Sheets, click File > Import, and upload
-
Applying Formulas & Formatting:
- In cell
I2, enter=G2-H2and drag the fill handle down to row 16 to compute Net Balances. - Designate a separate KPI summary block on the right (Columns K to N) and input the aggregate formulas (
SUM,COUNTIF) specified in the Pre-Built Formulas section. - Apply Conditional Formatting to the
Statuscolumn (J2:J16) where cell equals"Overdue"to highlight in light red, and"Settled"to highlight in light green.
- In cell
-
Saving and Securing:
- Save the final workbook as an
.xlsxfile with enterprise protection enabled, restricting master formula edits to authorized finance administrators only.
- Save the final workbook as an
Download this Template
*Disclaimer: This is a structural Spreadsheet/Log, not an official state-issued or government document.
Related Templates
View allPromissory Note Template New York
Promissory Note Template New York without the guesswork. Written in clear, enforceable language, in PDF & Word. Download, edit, and put it to work in minutes.
View templateTemplateTcs Master Services Agreement Sample
Download the complete service agreement sample tcs template. Production-ready, clinical precision checklist and document framework.
View templateTemplateMentoring Agreement Template Uk
Mentoring Agreement Template Uk template, ready to customize and use today. Written in clear, enforceable language. Ready to edit and use right away.
View template