Handling statement bundles: multiple accounts, multiple months, mixed PDFs

When clients send multiple accounts or months bundled together, you need a systematic approach to keep reconciliations clean and avoid mixing data.

Common bundle scenarios

• Multiple accounts in a single PDF (checking, savings, credit card)
• Multiple months combined into one file
• Mixed statement types (personal + business accounts)
• Multi-entity statements (parent company + subsidiaries)

Processing strategy

1. Split multi-account PDFs before conversion—one account per upload for clean balance validation.
2. Use consistent naming: ClientName_AccountType_YYYY-MM.pdf to track which file is which.
3. Convert each account separately, then combine in Excel only after validating individual balances.
4. Create separate reconciliation tabs per account to avoid cross-contamination.

Excel organization tips

• Use separate worksheets per account or entity
• Add a summary sheet that references all accounts
• Include account numbers in column headers for clarity
• Color-code by account type for quick visual scanning