Quickbooks Online Advanced - MASTERY LEVEL - HIGHLY PROFICIENT - Bookkeeper

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

Based on Mastery Level

HOURS PER WEEK

40

DATE UPDATED

Apr 1, 2026

JOB OVERVIEW

Established in 1984, PTFS, LLC is a commercial services company headquartered in Houston TX. Some of our clients have been longstanding customers of ours for over 40 years. We are extremely data driven and we use Excel heavily for most of our data metrics. We also use Quickbooks Online Advanced for Accounting among others. We utilize the spreadsheet sync function in QBO advanced, and we rely on many of the reports both standard & customized in QBO advanced to make informed decisions.

We are in process of building a fully remote team in the PH which will eventually take over all US based operations. We are looking for tea ---------- mbers LONG TERM. We value loyalty and tenure-ship and most importantly, availability. We would like all of the tea ---------- mbers we bring onboard to retire with us. We are firm believers that everybody working here deserves the opportunity to grow. Everyone will have a clear understanding of the trajectory of their career path with us. After 1 year, every tea ---------- mber will go through the process of performance review determining promotion / increase in compensation. The metrics we use are:

- Improved understanding of company processes
- Thoroughness & speed in taking proper actions
- Frequency of errors / how individual has corrected them
- New responsibilities assumed since hire
- Dependency & Availability
- Does the individual go above & beyond?
- Is the individual eager to take the lead in any situation?
- Does the individual possess other skills helpful to the company?

Our line of work is very fast paced with ever-changing requests from clients. Schedules are set but can change at any given ---------- nt. It is important for tea ---------- mbers to understand what needs to be done when a sudden change is requested by a customer as there are field workers who are dependent on the office to communicate such changes. As a tea ---------- mber, we need you to be versatile, stepping up or filling in at any given ---------- nt if another tea ---------- mber is busy or unavailable. Thus, we don't have a separation of duties. Each tea ---------- mber must be able to do EVERYTHING

We are seeking tea ---------- mbers who have a MASTERY PROFICIENCY LEVEL in Quickbooks Online Advanced and are able to quickly setup, repair, or upkeep ALL features at a high level. We are seeking those who have a strong accounting background & very high proficiency using MS EXCEL. When applying for the position, please respond with your self-assessed proficiency rating 1-10 to the following Quickbooks & Excel features. Please take some time to think about your rating with honesty and transparency.

QBO ADVANCED
-NEW Company setup & new connections
-Troubleshooting & fixing broken connections
-Mastery of migration -from QB Desktop or other
-High level use of journal entries
-Chart of Account design & organization
-High level use of all types of custom fields
-High level use of classes, locations & tags
-High level use of products / services / items - design & organization
-High level use of bundles for products / services / items
-Tracking Project profitability; estimates vs actuals
-Advanced knowledge of customized financial statements
-Mastery of customizing forms such as invoices, statements, bills etc.
-Mastery of building reports from scratch
-Mastery of payroll module within QBO
-Mastery of payroll liabilities & reporting
-Setting up or fixing customer payment links
-Setting up of form templates for invoices, statements etc
-Setting up or fixing QBO to bank connections
-Bank feed renaming rules & matching; over-riding
-Advanced understanding of Sales Tax setup for multi-location clients
-Mastery of batch invoicing & billing
-Mastery of batch reclassifying
-Complete mastery of using spreadsheet sync
-Setting up or fixing 3rd party app syncing with QBO Advanced
-Mastery of customer: sub-customer: projects -design & organization
-Mastery of setting up inventory & upkeeping
-Mastery of sales orders & purchase orders
-Setting up workflow automations
-Utilization of QB Online & all of its features at a high level

MS EXCEL
-Xlookup & Vlookup
-Index & Match
-Conditional Formatting
-Pivot Tables
-Power Query
-Data Validation
-Macros
-Dashboards
-Advanced Charting

Please list any and all other software / apps / programs you are proficient in: Scale 1-10

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Jobseekers / Job )  0.0129
Total Execution Time  0.0154
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,519,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Quickbooks-Online-Advanced-MASTERY-LEVEL-HIGHLY-PROFICIENT-Bookkeeper-1522552
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0061 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1522552
 LIMIT 1 
0.0003   SELECT *
FROM `employers`
WHERE `employer_id` = 861611
 LIMIT 1 
0.0006   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1522552
AND `misc`.`idIS NULL 
0.0004   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-18',ej.date_added) duration_daysDATEDIFF('2026-04-18',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-18',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1522552' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1522552 
0.0011   UPDATE employer_jobs SET hit_counts '***Nov-26-2025=27***Nov-27-2025=172***Nov-28-2025=33***Nov-29-2025=20***Nov-30-2025=8***Dec-01-2025=14***Dec-02-2025=17***Dec-03-2025=11***Dec-04-2025=12***Dec-05-2025=4***Dec-06-2025=5***Dec-07-2025=5***Dec-08-2025=3***Dec-09-2025=4***Dec-10-2025=3***Dec-11-2025=3***Dec-12-2025=2***Dec-13-2025=2***Dec-14-2025=4***Dec-15-2025=2***Dec-16-2025=2***Dec-17-2025=4***Dec-19-2025=2***Dec-20-2025=2***Dec-21-2025=2***Dec-23-2025=3***Dec-27-2025=1***Dec-30-2025=1***Jan-01-2026=1***Jan-02-2026=1***Jan-03-2026=1***Jan-06-2026=3***Jan-07-2026=2***Jan-08-2026=59***Jan-09-2026=19***Jan-10-2026=10***Jan-11-2026=2***Jan-12-2026=3***Jan-13-2026=1***Jan-14-2026=2***Jan-15-2026=2***Jan-16-2026=5***Jan-17-2026=1***Jan-18-2026=5***Jan-19-2026=1***Jan-20-2026=3***Jan-21-2026=5***Jan-22-2026=3***Jan-23-2026=1***Jan-24-2026=3***Jan-25-2026=3***Jan-26-2026=4***Jan-27-2026=2***Jan-29-2026=2***Jan-30-2026=3***Feb-01-2026=2***Feb-02-2026=3***Feb-05-2026=2***Feb-08-2026=2***Feb-12-2026=1***Feb-13-2026=192***Feb-14-2026=15***Feb-15-2026=8***Feb-16-2026=13***Feb-17-2026=22***Feb-18-2026=6***Feb-19-2026=9***Feb-20-2026=5***Feb-21-2026=3***Feb-22-2026=3***Feb-23-2026=8***Feb-24-2026=4***Feb-25-2026=3***Feb-26-2026=7***Feb-27-2026=5***Feb-28-2026=2***Mar-01-2026=3***Mar-02-2026=3***Mar-04-2026=2***Mar-05-2026=2***Mar-06-2026=5***Mar-07-2026=11***Mar-08-2026=209***Mar-09-2026=64***Mar-10-2026=24***Mar-11-2026=22***Mar-12-2026=17***Mar-13-2026=10***Mar-14-2026=4***Mar-15-2026=3***Mar-16-2026=7***Mar-17-2026=9***Mar-18-2026=367***Mar-19-2026=23***Mar-20-2026=22***Mar-21-2026=26***Mar-22-2026=3***Mar-23-2026=628***Mar-24-2026=130***Mar-25-2026=45***Mar-26-2026=20***Mar-27-2026=19***Mar-28-2026=5***Mar-29-2026=4***Mar-30-2026=13***Mar-31-2026=20***Apr-01-2026=418***Apr-02-2026=34***Apr-03-2026=51***Apr-04-2026=23***Apr-05-2026=7***Apr-06-2026=30***Apr-07-2026=19***Apr-08-2026=8***Apr-09-2026=10***Apr-10-2026=12***Apr-11-2026=4***Apr-18-2026=2' WHERE job_id'1522552'  
0.0009   UPDATE employer_jobs SET monthly_hits '***Nov-2025=260***Dec-2025=108***Jan-2026=147***Feb-2026=315***Mar-2026=1719***Apr-2026=618' WHERE job_id'1522552'  
0.0003   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1522552' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1522552 
0.0004   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '861611'
AND `date_added` >= '2022-06-08' 
0.0004   select from teasers 
0.0004   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)