Skip to main content
  • Search
  • Home
  • Our Products
    • Protection
    • Health
    • Savings
    • Wellness Series
    • Insurance with investment
    • BPI AIA Direct
    • Partnership Insurance
    • Corporate Solutions
  • Key Moments
    • Building My Wealth
    • Getting Married
    • Becoming A Parent
    • Working Abroad
    • Planning For Retirement
    • Running A Business
  • About Us
    • Our People
    • Media Center
    • Corporate Governance
    • Our Commitments
    • Events & Promotions
    • Careers
    • Our Customer Charter
    • Our Internet Security Arrangement
  • Claims & Support
    • Contact Us
    • Contact Info Update
    • BPI AIA Funds
    • Payment Facilities
    • Benefit Payout Enrolment
    • Frequently Asked Questions
    • Claims Guide
    • Forms Library
    • Bill of Rights of Policyholders
  • Total Health Solution
    • Live Better
    • Get Better
    • Protect Better
    • My AIA PH
  • My BPI AIA
    • Bancassurance Portal
    • My AIA
    • REQUEST My AIA ACCESS
    • Bancassurance 101
BPI AIA
BPI AIA BPI AIA
  • Our Products

    Our Products

    Find a life insurance plan according to your needs

    SEE MORE

    For Individuals

    For Corporations

    • Protection

      Put yourself at ease by protecting those you love

    • Health

      Protect yourself from unforeseen medical costs and focus on getting better

    • Savings

      Make saving for the future within your reach

    • Wellness Series

      Protection solutions that reward your healthy choices

    • Insurance with investment

      Make the most out of your hard-earned money

    • BPI AIA Direct

      Affordable protection products readily available

    • Partnership Insurance

      Affordable insurance to protect yourself and your family

    • Corporate Solutions

      Protect your company's best assets

  • Key Moments

    Key Moments

    Where are you in life's key stages?

    VIEW ALL KEY MOMENTS
    • Building My Wealth

      Setting yourself up for success

    • Getting Married

      Embark on a beautiful journey as husband and wife

    • Becoming A Parent

      Preparing your child's future

    • Working Abroad

      Setting aside in order to come home for good

    • Planning For Retirement

      Having time to do things that you have always wanted to do

    • Running A Business

      Take care of your most important asset

  • About Us

    About Us

    BPI AIA is a partnership of financial icons

    Know more
    • Our People

      The foundation of our success

    • Media Center

      News and information about BPI AIA

    • Corporate Governance

      ASEAN Corporate Governance Scorecards

    • Our Commitments

      Partnerships and community initiatives

    • Events & Promotions

      Here’s what’s happening in BPI AIA

    • Careers

      Explore opportunities to bring real ambition to life

    • Our Customer Charter

      This is our commitment to you.

    • Our Internet Security Arrangement

      Safeguarding your data.

  • Claims & Support

    Claims & Support

    We strive to provide the best service for our customers

    Contact BPI AIA
    • Contact Us

      Cannot find the answer in our FAQ section? Contact us now

    • Contact Info Update

      Easily update your contact information with us to receive timely updates on your policy.

    • BPI AIA Funds

      BPI AIA and Ayala Life Funds Information

    • Payment Facilities

      We make it easy to pay your premium. Choose the best payment option for you.

    • Benefit Payout Enrolment

      Receive your benefits via our convenient payout options.

    • Frequently Asked Questions

      Have a question? You may find the answer here

    • Claims Guide

    • Forms Library

      A selection of forms you can download, fill in and send back to us

    • Bill of Rights of Policyholders

      The Bill of Rights details an insurer's obligations to consumers to better protect policyholders.

  • Total Health Solution

    Total Health Solution

    • Live Better

      Enjoy a healthier, better, longer life with AIA Vitality.

    • Get Better

      Be on the road to full recovery with access to health care services.

    • Protect Better

      Be better protected against life's uncertainties so you can live worry-free.

    • My AIA PH

      Welcome to My AIA! It's your new all-in-one customer portal for your policy, health and wellness needs. Login and try it today!

  • My BPI AIA

    My BPI AIA

    Access your BPI AIA accounts

    • CUSTOMER

      My AIA

      View the status of your policy & claim requests, monitor your policy’s account values, and keep tabs of your payments & benefits history.

    • BSE

      Bancassurance Portal

    • Bancassurance 101

      BPI AIA is the number one bancassurance company in the Philippines. Find an affordable life insurance product in 800+ BPI branches nationwide.

  • Search
  • Contact Us
    • Call Us

      Open: 8am to 5pm, Mon - Fri

    • Leave Us a Message

Finance and Insurance
Prev | Next
Back to Top
  • {{title}}

    {{label}}
  • 10 Excel and Google Sheets Tips for Budgeting Like a Pro

    30 April 2021


    10 Excel and Google Sheets Tips for Budgeting Like a Pro

    Many people view spreadsheets as either boring or overwhelming. It may look tedious for unfamiliar users and a lot of work for those well-versed in it. However, these seemingly dull spreadsheets can become powerful tools used with a dash of creativity and systematic thinking. One of its most common and effective uses is for planning and managing finances.

    Using Excel or Google Sheets to manage finances allows you to keep track of every penny that goes in and out of your bank account in a system that you best understand. Besides the fact that you can customize your savings plan and budget system using the tools, they're free and require no special software.

    Why spend your money on budget tracker or money management apps when you already have access and basic knowledge to use spreadsheets? Here’s how to create a budget in Excel or Google Sheets that is tailor-made for your financial goals. 

    10 Excel and Google Sheets Tips for Budgeting Like a Pro Infographic

    Building a Budget System Using Spreadsheets

    You don't have to be a spreadsheet wiz to create a money management system on either Microsoft Excel or Google Sheets.

    1.   Start with a template.

    Building your money management system from scratch may seem intimidating at first, but creating one that suits your needs and preferences is better than spending hours getting used to a tool with too many features you don't need (or understand).

    Creating your own template allows you to personalize and only include the necessary elements in the system. If you're unsure where to start, you can check out the templates below:

    ●   Google Sheets Monthly Budget Template - Select "Monthly Budget" from the Template Gallery on Google Sheets.

    ●   Microsoft Excel Budget Template

    ●   Monthly Expense Tracker from Tiller HQ

    ●   50/30/20 Budget Snapshot from Tiller HQ

    2.   Add dropdowns with data validation.

    In Google Sheets, you can use data validation to create dropdown lists into relevant groups to easily classify the category of every transaction, making it faster to fill and categorize data.

    First, create a list of category names. Then, go to Data on the menu, and select Data validation. Choose "List from range" as the criteria, and then select the category list you created.

    3.   Use comments for documentation or notes.

    If you need to include a note to a transaction for reference, insert a comment instead of writing the details in the cell to keep things tidy. In case you need to take note of specific transactions that are different from usual, insert a comment in the sheet instead of writing the entire detail in the cell. Also, you wouldn't want to adjust your template just to fit the text, would you?

    If you need to write a lot of notes often, perhaps it will be better to dedicate a notes column where you can see all the important records you may otherwise forget at a glance.

    4.   Organize your budget using shading.

    Looking at a budget spreadsheet filled with data and without any format, borders, or color-coding can make anyone's head burst from confusion.

    One of the best ways to make your budget easy to read is to separate sections with colors, highlight headers in bold, and change the font color of amounts into specific colors (e.g., total expenses to red and remaining balance to blue). Doing this can divide sections accordingly and make looking at your budget easier.

    5.   Master the basic formulas.

    Don't be intimidated by spreadsheets and the number of formulas that come along with using them. Contrary to what you think, creating a budget using spreadsheets doesn't require advanced knowledge about formulas.

    Getting the basics down, such as SUM, AVERAGE, MIN, MAX, and using data validation, are enough. From there on, you can explore other formulas like SUMIF, COUNTIF, AVERAGEIF, and more. You can view Google Sheets' function list here and Microsoft Excel's functions here.  

    6.   Set budgets and highlight spend to maintain awareness of your spending.

    To effectively track your spending and understand your money, you have to establish your income and expenditure for a period of time, usually monthly. You can use simple formulas like SUM and IF functions to track how much money goes in and out of your pocket or bank account.

    You can indicate this in the summary sheet like the example below (see: Totals under Planned, Actual, and Diff) for a clear view of your spending.

    7.   Represent your finances with visual graphs.

    Graphs are easy to comprehend. Plus, they make reading and understanding data a lot more pleasing. With graphs, you can quickly track your expenditures and see how your finances compare every month. It's also easy to spot unnecessary and impulsive purchases, as well as unwelcome transactions you're not aware of or may have forgotten.

    8.   Use COUNTIF to track payments of services or your spending habits.

    Do you think you order take-outs or deliveries way too much in a month? Perhaps you find yourself shopping impulsively more than usual?

    The COUNTIF function is helpful when you input many transactions per month for different categories and purposes. The function can tally how often you spent on shopping, food, and other categories. It keeps your bad spending habits in check and helps you manage your budget better for the following months.

    Function example:

    =countif(D5:D25, "shopping")

    9.   Create a summary of your expenses and income.

    Create a tab labeled as "Summary" where you can lay out a concise comparison between your planned income and expenses and your actual income and expenditures. This sheet should contain a summarized version of your monthly transactions, allowing you to see only the critical information you need to plan how you'll manage your budget for the next month.

    10.   End every monthly budget with a report.

    Looking at all the numbers in the spreadsheet can be overwhelming, and it may cause you to miss a few crucial points. In your summary tab, write a short "report" of your monthly budget to get a good overview of your finances for the month. Use bullet points and keep the sentences short and succinct for better reading. 

    Make Budgeting Fun with Spreadsheets

    Managing your finances can be a drag. Thankfully, spreadsheet tools like Microsoft Excel and Google Sheets make it easy and less stressful to create and track your budget. You don't have to learn and purchase fancy apps to get started. Since these tools are fully customizable, flexible, and easy to use, it can help minimize your time commitment and shape up your finances in no time.

    If you need a hand planning your budget and financial goals this year, BPI AIA can help you sort out your finances and build your savings. Reach out to our Bancassurance Sales Executives to learn more! 

    Did you know?

    You can buy a life insurance at any BPI branch nationwide! Talk to a bancassurance sales executive now!

    RECOMMENDED PRODUCTS

    Life Ready Plus

    Protection

    Get the power to protect yourself and your family with an affordable life insurance plan. Life Ready Plus is easy on the budget, but offers coverage of up to 30 times your yearly payment to support the financial needs of your loved ones.

    The plan gives you fast access to coverage and benefits and can match your long-term financial goals when maintained within an appropriate term.

    Philam Life Vitality

    Critical Care Max

    Health

    Critical Care Max will help you make more memories by providing financial aid during the early stages of a critical illness. This unit-linked life and health insurance plan offers assistance on your recovery. You can build a health fund that grows over time, depending on your chosen investment, to pay for other medical costs.

     

    In addition, it comes with a hospital confinement benefit that will replace lost income due to hospitalization. This daily cash benefit may also come with optional benefits like cash payout for surgery-related expenses, allowance for consultation fees, and many others.

    Philam Life Vitality

    Build Estate Plus

    Life Protection

    Let your loved ones enjoy the fruits of your labor even when you’re no longer around. Build Estate Plus is a unit-linked protection plan that will cover your estate taxes after your passing so that you can ease your family’s burden.

    It doubles as an investment savings fund that builds Account Value as you pay. It is also integrated with AIA Vitality that provides additional upfront coverage of 20% to your policy and add-ons.

    Philam Life Vitality

    CRITICAL CARE PLUS

    Health

    Be in good hands in times of sickness. Let Critical Care Plus, a unit-linked health and life insurance plan, take care of you with financial aid in case of a major illness, so you can focus on getting better and spending more time with your loved ones.

     

    It even gives you more benefits for having good health through the AIA Vitality program that adds 20% upfront coverage and supplemental benefits on your policy. 

     

     

    Philam Life Vitality
    Newsletter

    CONTACT BPI AIA

    (02) 8 528 5501

    FACEBOOK MESSENGER

    15th Floor BPI-Philam Life Makati (formerly Ayala-FGU Bldg) 6811 Ayala Avenue Makati City 1226

    CONTACT BPI AIA

    (02) 8 528 5501

    FACEBOOK MESSENGER

    15th Floor BPI-Philam Life Makati (formerly Ayala-FGU Bldg) 6811 Ayala Avenue Makati City 1226

    GO TO

    AIA Philippines

     

    BPI

     

    AIA.COM

      

    Explore BPI AIA

    Our Products

    Key Moments

    About BPI AIA

    Who we are

    Our People

    Media Center

    Careers

    GO TO

    AIA Philippines

     

    BPI

     

    AIA.COM

    Learn more about AIA Group

    EXPLORE BPI AIA

    Our Products

    Key Moments

     

     

    ABOUT BPI AIA

    Who we are

    Our People

    Media Center

    Careers


    Copyright 2016. AIA Group and its subsidiaries. All rights reserved.
    Terms of Use | Privacy Statement | Cookie Policy

    This website uses cookies for the purpose of enhancing your user experience. You can find more information on the types of cookies we collect, what we use these for, and how to manage your cookie settings in our Cookie Policy and Privacy Statement.