Keep the PDF and the spreadsheet
Submit the original PDF when the lender asks for source documents. Use the spreadsheet to explain cash movement, identify regular revenue, and flag transfers between company accounts.
A clean export also helps directors answer follow-up questions without searching through pages of bank PDFs.
Show cash flow without retyping
Convert each statement month into Excel, then group inflows and outflows by category. Sales deposits, supplier payments, payroll, rent, and financing charges become easier to review.
- Revenue deposits by month
- Supplier and operating payments
- Existing loan repayments
- Closing balance trend
Use bank-specific converters
Maybank2u, CIMB Clicks, PBe, HLB Connect, and other portals export different table formats. Pick the matching bank converter so references and balances stay intact.
Checklist
Use this workflow
- 01Download the requested statement months from online banking.
- 02Convert each PDF to Excel.
- 03Group deposits and withdrawals.
- 04Keep the original PDF beside the spreadsheet.
- 05Send the lender the format they requested.