The bookkeeper is responsible for daily bank feed matching and month-end reconciliation in QuickBooks Online. This role manages vendor reconciliations, handles transaction queries, and ensures accurate financial records for VG through systematic processes.
§ 01
Role and Contact
Role: Reconciler / QB bank feed operator. Contact details on file with management.
§ 02
Pipeline Stages
- 05 Recorded (daily bank feed matching)
- 06 Reconciled (month-end)
§ 03
Key Workflows
- Stream 02 (Money Out, Proofs) + Stream 06 (Reconciliation)
- Transaction Query Sheet
- Vendor Reconciliation Sheets
- JJ Crew allocation
- Second QB review
- Recurring payments tracker
§ 04
QB Bank-Feed Matching Process
01
Initial Login & Setup
Log into QBO, update data; go to Chase 9357 → For Review tab
02
Handling Transactions with Matches
Verify Payee/Bank Account/Date/Reference/Property/Amount/Cost codes/Receipts → click Match; non-property transactions: categorize without receipt
03
If No Match Found
Search Dropbox; found: enter in QB with cost code/receipt; not found: ask Mark → Query Sheet
04
Assigning Queries
Vendor queries → Ritchie; Deposits/bank transfers → Shlomo
05
Temporary Lodging
Delayed receipts (property) → `94.0 Other Expenses`; Unknown transfers → `101.26`; Unknown deposits → `101.29`
06
Finalizing and Cleaning Up
Categorize properly; move from temporary accounts; update Query Sheet
07
Final Audit Preparation
Review 'Categorized' tab; delete duplicates; proceed with reconciliation
§ 05
Credit Card Reconciliation
01
Pull Monthly Statement
e.g., 4948, 5524, 7135
02
Match Statement Items
Against QB transactions (expenses/bank charges/reimbursements)
03
Record Missing Transactions
04
Record Payments
CC payment from bank account to CC liability account (NOT as expense)
05
Verify
Charges categorized; QB balance matches statement; no double-counting
§ 06
Daily Output
- EOD report to Ritchie + Randall (Cc: —)
- Subject: `EOD.YYMMDD` (occasional `YYYY.MM.DD_EOD`)
- Body: 'Task of the Day!' ... signed off with a closing line
- Sections: Matched Transactions, Vendor Reconciliations, Personal Reimbursements, Dropbox Manifest, Updated VPT, Reclassifications, Side Tasks
§ 07
Monthly Close-Out Work
- Download Chase statements → Dropbox EOM folder (e.g., `202603EOM Chase`)
- Reconcile Chase accounts: Beginning/Deposits/Withdrawals/Fees/Ending
- Reconcile credit cards (4948, 5524, 7135) via Credit Card Sub-Flow
- Generate Monthly Financial Report (Reconciliation Summary + P&L) → Google Drive + Dropbox
- Identify 'NO Invoices/Receipts' list (placeholder: `205.64` or `94.0`)
- Property close-outs for sold properties (YNAB + Dropbox + GSheets)
§ 08
Side Tasks
- Update Project/Customer fields in QB
- Audit PRA files from Jenn
- Audit for duplicate entries
- Organize Dropbox files after PRA reconciliation
- Upload merged Statements of Account (Ashpa/Jaeger/Blue Ridge) + match to Google Sheets
- Audit QB transactions (duplicates, Property/Payee fields)
- Monitor Jaeger Lumber account