Summary
Overview
Work History
Education
Skills
DUTIES AND RESPONSIBILITIES
Work Availability
Accomplishments
Software
Timeline
AssistantManager
JOHN KELLY YTAC

JOHN KELLY YTAC

Accounting/ Lonewolf Specialist/ Quickbooks Online
Surigao City, Province Of Surigao Del Norte,SUN

Summary

Detail-oriented and organized accounting professional with a strong foundation in management and accounting principles, complemented by proficiency in interpersonal and communication skills. Recognized for reliability, integrity, and a keen ability to learn quickly, bringing a passion for continuous learning and professional growth. Highly motivated and driven, with a commitment to excellence and a resourceful approach to problem-solving. Proficient in various computer applications, adept at identifying and correcting errors to ensure accuracy and efficiency in financial processes.

Overview

18
18
years of professional experience

Work History

Accounting Assistant

Canada Real Estate Brokerage
05.2021 - Current
  • Update Previous Day’s Bank Transactions in Quickbooks Online
  • Consolidate Expenses on Keep Card to manage AP in Quickbooks Online
  • Bank Reconciliation Operating and Trust account
  • Record Previous Days Sales /Mortgage Files
  • Agent Monthly billing and reports generated in Lonewolf back office
  • Follow up with Agent outstanding balance to manage AR in Quickbooks Online
  • Process Commission payout in Lonewolf back office
  • Process Overseas and Local contractor and employee via Wise and EFTs to Local in Quickbooks Online
  • Process commission advances
  • Update AP and AR report
  • Budgeting
  • Daily sales report
  • Weekly P and L
  • Monthly reporting Company Production report, Agent production report, monthly sales report, AR and AP, Comparison of P and L from previous month’s Balance Sheet and forecast next month budget
  • Preparation of T4 and T4a
  • Graveyard Shift Part time

Accounting Assistant

Tender Home Health
01.2020 - 02.2025
  • Invoice Private patient, Pharmacy patient using Quickbooks Online
  • Collect payment from Private patients and Insurances and post to Quickbooks Online
  • Sending invoices to Insurances and patient
  • Generate report for account receivable aging
  • Gather billings from Accounts Payable vendors
  • Generate report on Account Payable aging and ensure that payment process in a timely manner
  • Process payments using payment links and QB links
  • Categorized bank transactions in Quickbooks Online
  • Bank Reconciliation
  • Financial reporting
  • Preparation of 1099
  • Related Accounting task
  • Contract End

Accounting Assistant

Real Estate Brokerage
02.2022 - 08.2022
  • Contract End
  • Graveyard Shift

Commission Accountant/AR Accountant

Real Estate Broker
02.2017 - 01.2022
  • Add Admin fee in CDF and set up its details and fee levels
  • Add B & O Tax in CDF and set up its details and fee levels
  • Add E & O Insurance in CDF and set up its details and fee levels
  • Add NAF 2% fee in CDF and set up its details and fee levels
  • Add Royalty 6% fee and set up its details and fee levels
  • Add Personal Lead Commission Listing side in CDF and set up its details and fee levels
  • Add Personal Lead Commission Selling side in CDF and set up its details and fee levels
  • Add Company Lead Commission Listing side in CDF and set up its details and fee levels
  • Add Company Lead Commission Selling side in CDF and set up its details and fee levels
  • Add charges SKCAR 2018 escrow paid option in CDF and set up its details and fee levels
  • Add charges Home Warranty escrow paid option in CDF and set up its details and fee levels
  • Add charges Commission by Agent escrow paid option in CDF and set up its details and fee levels
  • Assign agent fees with CAP (Personal listing & selling sides) and set up conditions for CDF Gross commission computation
  • Assign agent fees without CAP (Personal listing & selling sides) and set up conditions for CDF Gross commission computation
  • Add transaction classification under CDF in listing and selling Personal lead
  • Add transaction classification under CDF in listing and selling Company Lead
  • Add transaction classification under CDF BPO, Landlord and Tenant
  • Add the pipeline cover sheet to BrokerWolf transaction
  • Create CDF for Personal Listing Side inside BrokerWolf
  • Create CDF for Personal Selling Side inside BrokerWolf
  • Create CDF for Company Listing Side inside BrokerWolf
  • Create CDF for Company Selling Side inside BrokerWolf
  • Create CDF with an outside broker to be paid by escrow company inside BrokerWolf
  • Create CDF with the option for all commissions payable to Real Estate Company
  • Invoice Sign installation charges inside BrokerWolf
  • Invoice PLP charges inside BrokerWolf
  • Invoice Active Listing Bonus inside BrokerWolf
  • Invoice Marketing Charges inside BrokerWolf
  • Invoice Copier Print Charges inside BrokerWolf
  • Invoice Short Sale Charges inside BrokerWolf
  • Invoice Cubicle fee inside BrokerWolf
  • Invoice Monthly fee inside BrokerWolf
  • Invoice CBA fee inside BrokerWolf
  • Generate Agents Monthly Statements
  • Post Agents’ Payment
  • Invoice SKCAR
  • Invoicing Active Listing Bonus on multiple Agents
  • Invoicing L & I (Quarterly)
  • Generating Outstanding Invoice
  • Generate Statement by Category for cross checking of amounts
  • Updating and posting of recurring fee on Monthly fees for newly on boarded agents
  • Archiving Agent Credit Card Information
  • Processing Credit Card Payments for Invoices
  • Posting Credit Card payments of Agents in BW
  • Contract End
  • Graveyard Shift

Account Resolution Specialist

Medical Billing Company
10.2017 - 02.2020
  • Posting insurance payment of patient claim at Meditouch
  • Crossover claims patient to secondary insurance
  • Posting unapplied payment of insurance
  • Posting unapplied patient payment
  • Gathering Statement of Billing on various insurance companies
  • Contract End
  • Graveyard Shift

Accounting Assistant of Australian CPA

Preston Chow Accounting firm
12.2016 - 02.2017
  • Preparation of Balance Sheet, Profit and loss statement
  • Computation of Superannuation
  • Check for GST on all goods and services sold from the client
  • Preparation of BAS to the Australian Taxation Office
  • Input client Purchase order into Xero Accounting Software
  • Microsoft office
  • Xero
  • Freelance (Project done)

Accounting Supervisor/Accountant

Surigao City Evergreen Rural Bank Inc.
01.2010 - 01.2016
  • Supervises and ensures proper functioning of all internal controls
  • Supervises function of accounting staff
  • Implements best practice and standards in all accounting procedures
  • Ensures the proper reconciliation of bank accounts
  • Prepares and maintains various accounting records and a statement
  • Supervise in preparing payroll reports and statements
  • Train and assists accounting staff in performing various financial tasks, trains and develops subordinates, enhancing personal and professional growth
  • Creates innovative methods geared at enhancing the performance levels of all accounting staff
  • Assist accounting staff in dealing with banking transactions and handling customers’ needs and inquiries
  • Organize, direct and lead the team in the pursuit of corporate objectives
  • Oversee the implementation of the team activities through shrewd planning and effective monitoring and evaluation
  • Perform administrative tasks such as accurate accomplishment and timely submission of reports, and maintenance of files and records. The reports shall include but will not be limited to the following. Financial statement, trial balance, loan listing, saving, daily cash position
  • Performs basic process of staffing in coordination with my immediate superior such as recruitment, orientation of personnel, job-rotation, and managing manpower challenges and opportunities in the unit requiring hiring, firing or sizing-up people and confronting directs reports

Account Officer/Collection Agent

Surigaonun Rural Banking Corp.
01.2010 - 01.2010
  • Daily collection of client loan payment
  • Weekly monitoring of past due loans
  • Monthly monitoring of collection
  • Market loan product
  • Process loan application

Branch Accounting Clerk

Tateh Feeds Corp.
01.2008 - 01.2010
  • Update AR collection
  • Bank reconciliation
  • Keep a book of record updated
  • Monthly report on sales and expenses
  • Monthly inventory of stocks in warehouse
  • Meet up with a client for collecting payment
  • Market product to a prospective client

Education

Bachelor of Science in Commerce - Management Accounting

University of Mindanao
01.2008

Skills

Accounting

DUTIES AND RESPONSIBILITIES

  • Accounting Assistant Canada Real Estate Broker
  • Update Previous Day’s Bank Transactions in Quickbooks Online
  • Consolidate Expenses on Keep Card to manage AP in Quickbooks Online
  • Bank Reconciliation Operating and Trust account
  • Record Previous Days Sales /Mortgage Files
  • Agent Monthly billing and reports generated in Lonewolf back office
  • Follow up with Agent outstanding balance to manage AR in Quickbooks Online
  • Process Commission payout in Lonewolf back office
  • Process Overseas and Local contractor and employee via Wise and EFTs to Local in Quickbooks Online
  • Process commission advances
  • Update AP and AR report
  • Budgeting
  • Daily sales report
  • Weekly P and L
  • Monthly reporting Company Production report, Agent production report, monthly sales report, AR and AP, Comparison of P and L from previous month’s Balance Sheet and forecast next month budget
  • Preparation of T4 and T4a
  • Accounting Assistant Tender Home Health
  • Invoice Private patient, Pharmacy patient using Quickbooks Online
  • Collect payment from Private patients and Insurances and post to Quickbooks Online
  • Sending invoices to Insurances and patient
  • Generate report for account receivable aging
  • Gather billings from Accounts Payable vendors
  • Generate report on Account Payable aging and ensure that payment process in a timely manner
  • Process payments using payment links and QB links
  • Categorized bank transactions in Quickbooks Online
  • Bank Reconciliation
  • Financial reporting
  • Preparation of 1099
  • Related Accounting task
  • Commission Accountant/AR Accountant Real Estate Broker
  • Add Admin fee in CDF and set up its details and fee levels
  • Add B & O Tax in CDF and set up its details and fee levels
  • Add E & O Insurance in CDF and set up its details and fee levels
  • Add NAF 2% fee in CDF and set up its details and fee levels
  • Add Royalty 6% fee and set up its details and fee levels
  • Add Personal Lead Commission Listing side in CDF and set up its details and fee levels
  • Add Personal Lead Commission Selling side in CDF and set up its details and fee levels
  • Add Company Lead Commission Listing side in CDF and set up its details and fee levels
  • Add Company Lead Commission Selling side in CDF and set up its details and fee levels
  • Add charges SKCAR 2018 escrow paid option in CDF and set up its details and fee levels
  • Add charges Home Warranty escrow paid option in CDF and set up its details and fee levels
  • Add charges Commission by Agent escrow paid option in CDF and set up its details and fee levels
  • Assign agent fees with CAP (Personal listing & selling sides) and set up conditions for CDF Gross commission computation
  • Assign agent fees without CAP (Personal listing & selling sides) and set up conditions for CDF Gross commission computation
  • Add transaction classification under CDF in listing and selling Personal lead
  • Add transaction classification under CDF in listing and selling Company Lead
  • Add transaction classification under CDF BPO, Landlord and Tenant
  • Add the pipeline cover sheet to BrokerWolf transaction
  • Create CDF for Personal Listing Side inside BrokerWolf
  • Create CDF for Personal Selling Side inside BrokerWolf
  • Create CDF for Company Listing Side inside BrokerWolf
  • Create CDF for Company Selling Side inside BrokerWolf
  • Create CDF with an outside broker to be paid by escrow company inside BrokerWolf
  • Create CDF with the option for all commissions payable to Real Estate Company
  • Invoice Sign installation charges inside BrokerWolf
  • Invoice PLP charges inside BrokerWolf
  • Invoice Active Listing Bonus inside BrokerWolf
  • Invoice Marketing Charges inside BrokerWolf
  • Invoice Copier Print Charges inside BrokerWolf
  • Invoice Short Sale Charges inside BrokerWolf
  • Invoice Cubicle fee inside BrokerWolf
  • Invoice Monthly fee inside BrokerWolf
  • Invoice CBA fee inside BrokerWolf
  • Generate Agents Monthly Statements
  • Post Agents’ Payment
  • Invoice SKCAR
  • Invoicing Active Listing Bonus on multiple Agents
  • Invoicing L & I (Quarterly)
  • Generating Outstanding Invoice
  • Generate Statement by Category for cross checking of amounts
  • Updating and posting of recurring fee on Monthly fees for newly on boarded agents
  • Archiving Agent Credit Card Information
  • Processing Credit Card Payments for Invoices
  • Posting Credit Card payments of Agents in BW
  • Rent Manager Experience
  • Able to finish the training video for accounting 101 at Rent Manager University
  • Posting Journal entries
  • Account Resolution Specialist
  • Posting insurance payment of patient claim at Meditouch
  • Crossover claims patient to secondary insurance
  • Posting unapplied payment of insurance
  • Posting unapplied patient payment
  • Gathering Statement of Billing on various insurance companies
  • Accounting Assistant of Australian CPA
  • Preparation of Balance Sheet, Profit and loss statement
  • Computation of Superannuation
  • Check for GST on all goods and services sold from the client
  • Preparation of BAS to the Australian Taxation Office
  • Input client Purchase order into Xero Accounting Software
  • Microsoft office
  • Xero
  • Accounting Supervisor/ Accountant
  • Supervises and ensures proper functioning of all internal controls
  • Supervises function of accounting staff
  • Implements best practice and standards in all accounting procedures
  • Ensures the proper reconciliation of bank accounts
  • Prepares and maintains various accounting records and a statement
  • Supervise in preparing payroll reports and statements
  • Train and assists accounting staff in performing various financial tasks, trains and develops subordinates, enhancing personal and professional growth
  • Creates innovative methods geared at enhancing the performance levels of all accounting staff
  • Assist accounting staff in dealing with banking transactions and handling customers’ needs and inquiries
  • Organize, direct and lead the team in the pursuit of corporate objectives
  • Oversee the implementation of the team activities through shrewd planning and effective monitoring and evaluation
  • Perform administrative tasks such as accurate accomplishment and timely submission of reports, and maintenance of files and records. The reports shall include but will not be limited to the following. Financial statement, trial balance, loan listing, saving, daily cash position
  • Performs basic process of staffing in coordination with my immediate superior such as recruitment, orientation of personnel, job-rotation, and managing manpower challenges and opportunities in the unit requiring hiring, firing or sizing-up people and confronting directs reports
  • Account Officer/ Collection Agent
  • Daily collection of client loan payment
  • Weekly monitoring of past due loans
  • Monthly monitoring of collection
  • Market loan product
  • Process loan application
  • Branch Accounting Clerk
  • Update AR collection
  • Bank reconciliation
  • Keep a book of record updated
  • Monthly report on sales and expenses
  • Monthly inventory of stocks in warehouse
  • Meet up with a client for collecting payment
  • Market product to a prospective client

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Accomplishments

  • Collaborated with team of 3 in the development of Monthly Budget
  • Achieved lower expense by completing monthly budget with accuracy and efficiency.

Software

Quickbooks Online

Lonewolf

Timeline

Accounting Assistant

Real Estate Brokerage
02.2022 - 08.2022

Accounting Assistant

Canada Real Estate Brokerage
05.2021 - Current

Accounting Assistant

Tender Home Health
01.2020 - 02.2025

Account Resolution Specialist

Medical Billing Company
10.2017 - 02.2020

Commission Accountant/AR Accountant

Real Estate Broker
02.2017 - 01.2022

Accounting Assistant of Australian CPA

Preston Chow Accounting firm
12.2016 - 02.2017

Accounting Supervisor/Accountant

Surigao City Evergreen Rural Bank Inc.
01.2010 - 01.2016

Account Officer/Collection Agent

Surigaonun Rural Banking Corp.
01.2010 - 01.2010

Branch Accounting Clerk

Tateh Feeds Corp.
01.2008 - 01.2010

Bachelor of Science in Commerce - Management Accounting

University of Mindanao
JOHN KELLY YTACAccounting/ Lonewolf Specialist/ Quickbooks Online