NatWest / RBS
Download NatWest/RBS business statements (PDF) and convert to Excel
Updated January 2025 · 5 min read
NatWest and RBS business accounts provide PDF statements that are essential for reconciliation when clients can't share account access. Statement formats can vary between the two brands.
This content is informational only and does not constitute legal, tax, or financial advice.
Download a NatWest/RBS PDF statement
- Sign in to NatWest Business Online or RBS Business Banking.
- Navigate to Statements or Account Services.
- Select the account and statement period.
- Download the monthly PDF statement.
- Verify the PDF includes transaction details and opening/closing balances.
Convert to Excel for reconciliation
- Upload the PDF to StatementScribe for transaction extraction.
- NatWest/RBS statements may have varying formats—validate column extraction carefully.
- Export to Excel with consistent columns for date, description, amount, balance.
Common challenges
- Statement formats may vary between NatWest and RBS accounts (same parent company).
- Multiple accounts may be bundled in one statement PDF—split before conversion.
- Business accounts may have complex transaction formats with multiple sections.
Tips for accountants
- PDF statements are preferred over CSV exports for NatWest/RBS business accounts.
- When clients can't provide account access, request PDF statements directly.
- Keep original PDFs as audit evidence alongside your Excel reconciliation.
FAQ
Do statement formats vary between NatWest and RBS?
Yes, statement formats may vary between NatWest and RBS accounts (same parent company). Validate column extraction carefully for each.
Are PDF statements preferred over CSV exports?
Yes, PDF statements are preferred over CSV exports for NatWest/RBS business accounts. PDFs include balances and are more consistent.