QuickBooks
Three-tab financial operations hub integrating ACH remittance validation, vendor contact management, and QuickBooks Online financial views across all 11 Wasteology entities.
This page covers the Palantiri UI. For the complete ACH remittance process including batch generation, approval, and bank upload steps, see the ACH Remittance documentation.
Page Overview
QuickBooks
Validate ACH batches, manage vendor contacts, and browse QBO financial data across all 11 entities
How to Use
Features
ACH Validation
Browser-based inspection of the daily ACH remittance batch with vendor payment breakdown and account code extraction
Contact Management
Full CRUD for ACH vendor contacts — the only management surface since the N8N form was decommissioned
Financial Views
QBO financial analysis — bank accounts, AP/AR summaries, and transaction detail across all 11 entities
QBO Integration
Data sourced from qbo.* schema in PostgreSQL Dev, populated by the daily QBO ETL pipeline
Tab 1: ACH Validation
The ACH Validation tab loads automatically on first visit, showing the most recent completed batch (typically the previous business day).
What It Shows
| Column | Source | Description |
|---|---|---|
| Vendor Name | QuickBooks | Payee name exactly as it appears in QBO |
| Amount | QuickBooks | Payment amount for this batch line |
| Account Code | QB private_note | Account code extracted from the bill's private note field |
| Check Number | QB | ACH check/reference number |
| Entity | QB | Which of the 11 QuickBooks entities issued the payment |
Filtering
Use the filter bar at the top of the table to narrow down by:
- Vendor — type-ahead search on vendor name
- Account Code — filter to a specific GL account
- Entity — select one or more of the 11 QB entities
Manual Reload
Click Reload Batch to pull a fresh copy of the batch data from the database. You can also select a different date from the date picker to view historical batches.
"Previous business day" skips weekends and federal holidays. If today is Monday, the auto-loaded batch is from Friday.
Tab 2: Contacts
The Contacts tab is the only management surface for qbo.ach_vendor_contacts in PostgreSQL Dev. The N8N form that previously served this function has been decommissioned.
Contact Fields
| Field | Required | Notes |
|---|---|---|
| Vendor Name | Yes | Must match QuickBooks exactly (case-sensitive) |
| Bank Routing Number | Yes | 9-digit ABA routing number |
| Bank Account Number | Yes | Vendor's checking account number |
| Account Type | Yes | checking or savings |
| Entity | Yes | Which QB entity this contact is for |
| Notes | No | Internal reference notes |
The ACH generation script joins contacts to QuickBooks payees by vendor_name. A mismatch (including extra spaces, capitalization differences, or legal entity suffixes) means the vendor will not receive an ACH payment and will fall back to check.
CRUD Actions
| Action | Description |
|---|---|
| Add Contact | Opens inline form to create a new contact record |
| Edit | Inline edit of an existing contact row |
| Delete | Removes the contact — prompts for confirmation |
Tab 3: Financial Views
The Financial Views tab provides read-only QBO financial analysis.
Available Views
| View | Description |
|---|---|
| Bank Accounts | Current balances across all linked bank and credit accounts |
| Accounts Payable | Outstanding AP by vendor with aging buckets |
| Accounts Receivable | Outstanding AR by customer with aging buckets |
| Transaction Detail | Full transaction ledger with date, account, entity, and amount filters |
All views span all 11 QuickBooks entities simultaneously and can be filtered to a single entity using the entity selector at the top of each view.
Data Source
| Layer | Details |
|---|---|
| Database | PostgreSQL Development (wasteology_dev) |
| Schema | qbo.* |
| ETL | qbo-daily-extract Prefect flow — runs nightly |
| Freshness | Data reflects the previous night's QBO sync |
Financial Views show data as of the most recent nightly sync. For real-time balances, log in to QuickBooks Online directly.