Portfolio demonstration | Corporate card workflow
AMEX Statement to QuickBooks GL Import
Controlled transaction coding and balanced journal output from a recurring AMEX statement export.
A repeatable finance workflow converts an AMEX statement export into a reviewer-ready QuickBooks journal. Vendor rules assign GL accounts, classes, and memos, while uncertain items are isolated before the journal is released.
Corporate-card activity often arrives as a flat statement with inconsistent merchant descriptions. Manual coding is slow, hard to review, and can create incomplete or unbalanced journal uploads.
Short demo video using synthetic data. The workflow is illustrative and designed to show the control logic, not a live client system.
What the model demonstrates
- Structured AMEX transaction intake and source traceability.
- Finance-owned vendor-to-account and class mapping rules.
- Exception routing for unknown or review-only merchants.
- Two-sided QuickBooks journal lines with debit-credit controls.
Automation workflow
- Load the monthly AMEX statement export into a standardized input table.
- Normalize merchant keys and apply maintainable vendor coding rules.
- Review unmapped or sensitive transactions before release.
- Generate balanced QuickBooks journal lines with account, class, name, and memo.
Controls and auditability
- Transaction count and statement-total completeness checks.
- Visible coding-review queue with clear ownership.
- Debit-credit balance test and model-level PASS status.
- Source transaction ID retained through the journal output.
Workbook deliverables
- AMEX input table and vendor mapping library.
- GL coding review with formula-driven recommendations.
- QuickBooks-ready two-sided journal output.
- Control-check sheet and documented reviewer handoff.
Reviewer-ready finance automation output
The synthetic demonstration processes 34 transactions totaling $11,760.96. Thirty items are ready for journal preparation, four remain visible for finance review, and all 68 journal lines are balanced before upload.
Important note
This portfolio demonstration uses synthetic data and does not represent a client engagement or guaranteed results. It is not a live QuickBooks API integration and does not post entries automatically. Final coding, tax treatment, business purpose, and upload approval remain with the finance team.
Want to automate a similar workflow?
Share one recurring finance process and I will help identify the practical automation path, expected controls, and likely implementation effort.
Book a Finance Automation Review