Transform QuickBooks Transactions to Journal Entries
Fetch QuickBooks transactions using JournalReport API and transform to Costpoint journal entry format.
Note: - Use QuickBooks JournalReport API endpoint (key breakthrough from PoC) - Fetch all transaction types: Deposits, Bills, Invoices, Payments, Expenses, Journal Entries - Filter by date range provided in import workflow - JournalReport returns transactions in proper journal entry format with debits/credits - Apply account mapping: QB account ID → Costpoint account code - Apply project code rules: P&L accounts get project codes, balance sheet accounts don't - Validate double-entry accounting: debits = credits for each transaction - Track unmapped accounts: identify transactions with accounts not in mapping - Generate line-item level entries: one row per journal line (not per transaction) - Preserve audit trail: include QB transaction ID, type, date, QB account info - Reference PoC transformation logic
Open questions: - How to handle transactions with unmapped accounts during transformation? - Should we attempt to auto-map common accounts or require all mappings upfront?