Bookkeeper- QuickBooks Online, Profit First & Excel Reporting

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

TYPE OF WORK

Part Time

SALARY

$5/hr

HOURS PER WEEK

2

DATE UPDATED

Apr 6, 2026

JOB OVERVIEW

About this role
Collaborative RED (CRED) is a small owner's project management and real estate development firm based near Boston, MA USA. We're looking for an experienced, detail-driven bookkeeper to take full ownership of our ongoing financial operations across three related entities all managed within a single QuickBooks Online file using "locations".

Our previous bookkeeper built the foundation: the chart of accounts is set up, transaction rules are in place, and our custom Excel workbook for Profit First allocations and budget-vs.-actual tracking is complete. You're stepping into a clean, organized system and maintaining it,not rebuilding from scratch.

This is a long-term recurring engagement but limited hours per month. We value precision and reliability above everything else.

Core responsibilities

Monthly close & reconciliation
- Reconcile all four bank accounts and one credit card monthly across all three entities
- Review, categorize, and clean all transactions to ensure 100?curacy and correct entity allocation
- Close the books each month with complete, audit-ready records
- Identify and resolve discrepancies, duplicates, uncategorized entries, and misallocations
- Maintain and refine QuickBooks rules to improve automation accuracy over time

Profit First & budget-vs.-actual reporting
- Export QuickBooks data into our existing Excel reporting workbook on a regular cadence
- Populate Profit First allocation calculations (Revenue, Profit, Owner's Comp, Tax, Operating Expenses) in our pre-built template
- Update budget-vs.-actual tracking so the principal has clear visibility into financial performance
- Flag variances, anomalies, or trends that need attention

Data integrity & QuickBooks maintenance
- Keep the chart of accounts clean, logically organized, and consistently applied across all entities
- Maintain vendor records, transaction rules, and categorization logic
- Ensure inter-company transactions are properly recorded and reconciled
- Proactively flag any data quality issues or process improvement opportunities

----How we work together — please read this section carefully-----

We understand that great bookkeepers prefer deep, focused work over constant meetings, and we respect that. However, communication and visibility are non-negotiable parts of this role, especially in the first several months. If this doesn't sound like the right fit for you, this role is probably not right for you, and that is completely okay. We'd rather know now.

Here is exactly how this role works:

- Weekly async Loom recording (first 3–6 months): Each week you will send a short ~10-minute screen recording walking through your progress, open items, and any questions. You record it on your schedule, no live meeting required. This requirement phases out once we have established a strong working rhythm, typically after 3–6 months.
- Monthly 30-minute video call: One live synchronous check-in per month with the principal to review open items, answer questions, and align on priorities.
- Ad-hoc communication via Microsoft Teams and Outlook email for quick questions or clarifications.

The monthly call must fall within 8:00 AM – 8:00 PM Eastern Time (Boston, USA). For Philippines-based candidates, this translates to approximately 8:00 PM – 8:00 AM Philippine Standard Time. We are flexible within that window and will work with your schedule to find a time that respects your life. This availability requirement is firm — please do not apply if this window does not work for you.

---

Required qualifications

- Demonstrated expertise in QuickBooks Online, including multi-location setup, bank reconciliation, rules management, and chart of accounts configuration
- Strong working knowledge of Microsoft Excel, ability to work within structured workbooks with formulas, linked tabs, and formatted reporting templates
- Experience managing books for multiple related entities simultaneously
- Familiarity with the Profit First cash management methodology, or a willingness to learn quickly with guidance
- High attention to detail with a commitment to 100?curacy and clean, audit-ready records
- Professional, proactive communication, you flag issues and ask clarifying questions rather than making assumptions
- Comfort recording and sending Loom or similar screen-share videos as a regular part of your workflow
- Availability for one 30-minute monthly call between 8:00 AM and 8:00 PM Eastern Time, non-negotiable

---

Preferred qualifications

- Prior experience with Profit First reporting, including allocation percentages and target-vs.-actual tracking
- Experience working with real estate development, construction, or professional services firms
- Experience working with owner's project management companies
- Demonstrated track record with long-term remote client relationships

---

Scope at a glance

- Entities in scope: 3 (1 primary + 2 sister companies)
- Monthly transaction volume: ~100 transactions
- Bank accounts to reconcile: 4
- Credit cards to reconcile: 1
- Accounting software: QuickBooks Online
- Reporting tool: Microsoft Excel (existing template — already built)
- Async check-ins: Weekly Loom (~10 min) for first 3–6 months
- Sync meetings: Monthly · 30 min
- Call availability required: 8:00 AM – 8:00 PM Eastern Time (8:00 PM – 8:00 AM PHT)

---

How to apply, follow these instructions exactly

We receive many applications. The only applications we will review are those that follow all three steps below. This is intentional, it is a preview of how this role works.

1. Record a Loom video (or equivalent screen recording — Loom is preferred) of 3–5 minutes. In your video: introduce yourself, briefly walk through your QuickBooks Online experience including any multi-entity or multi-location work, confirm that you have read and understood the Loom and monthly call requirements in this post, and tell us your proposed monthly rate and your available window for the monthly call in Philippine Standard Time.
2. Send your Loom link along with a short written summary of your relevant experience and your proposed monthly retainer.
3. Begin your message with the phrase "I read the full post" so we know you did.

Applications without a Loom video will not be reviewed. We are not trying to be difficult, we are trying to find someone who communicates this way naturally, because that is how this role works from day one.

SKILL REQUIREMENT
Quickbooks Bookkeeping Accounting Management
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0008
Controller Execution Time ( Jobseekers / Job )  0.0122
Total Execution Time  0.0136
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,522,808 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Bookkeeper-QuickBooks-Online-Profit-First-Excel-Reporting-1617821
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0073 seconds)  (Hide)
0.0003   SELECT *
                                FROM exrates
                                WHERE rate_name = 'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1617821
 LIMIT 1 
0.0008   SELECT *
FROM `employers`
WHERE `employer_id` = 921511
 LIMIT 1 
0.0008   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1617821
AND `misc`.`id` IS NULL 
0.0004   SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-16',ej.date_added) duration_days, DATEDIFF('2026-04-16',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_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-16',ej.date_added) <= 14 ))
                                   AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1617821' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1617821 
0.0007   UPDATE employer_jobs SET hit_counts = '***Apr-06-2026=639***Apr-07-2026=287***Apr-08-2026=106***Apr-09-2026=71***Apr-10-2026=47***Apr-11-2026=33***Apr-16-2026=1' WHERE job_id= '1617821'  
0.0008   UPDATE employer_jobs SET monthly_hits = '***Apr-2026=1184' WHERE job_id= '1617821'  
0.0012   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1617821' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1617821 
0.0008   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '921511'
AND `date_added` >= '2022-06-08' 
0.0003   select * from teasers 
0.0002   SELECT * FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)