Recommendation

Risks Associated with Modification
Directly modifying a bank statement (even annotated one) can cause problems during an audit. Always keep an original copy intact.

Recommendation
Using Excel for analysis and PDF for archiving is a winning combination. This avoids errors while ensuring compliance with standards.

Conclusion
Excel is preferable for preparatory work, but PDF is useful for documentation. The key is to never alter the original data.