Bank Statement & Fund Flow Analyst

# Finance Analyst Required – Bank Statement Analysis & Fund Flow Mapping We are looking for an experienced **Finance Analyst / Forensic Financial Analyst** to analyse bank statements and prepare a detailed **transaction-by-transaction fund flow mapping** for audit purposes. ### Scope of Work The selected freelancer will be required to: * Review and analyse bank statements covering the specified period. * Identify and classify **all inflow and outflow transactions**. * Prepare a comprehensive transaction-level Excel/Google Sheets report. * Map the movement of funds from **source to destination**. * Trace incoming funds and identify where those funds were subsequently transferred or utilised. * Identify transfers between related accounts/entities, where applicable. * Match transactions based on **amount, date, reference number, narration and beneficiary/remitter details**. * Track fund movement across multiple transactions/accounts wherever the trail can be established. * Highlight potentially related, unusual, duplicate or unexplained transactions. * Categorise transactions such as: * Customer/client receipts * Vendor payments * Salary/payroll * Bank transfers * Inter-company transfers * Refunds * Cash withdrawals/deposits * Other expenses and receipts * Prepare a clear **fund-flow trail** showing how money moved through the accounts. * Identify transactions where the ultimate destination or source cannot be established and clearly flag them for further investigation. ### Expected Deliverable The final output should be an **audit-ready Excel workbook** containing, at minimum: | Date | Bank Account | Transaction ID/Reference | Narration | Inflow | Outflow | Balance | Counterparty | Category | Source of Funds | Destination of Funds | Linked Transaction | Remarks | | ---- | ------------ | ------------------------ | --------- | -----: | ------: | ------: | ------------ | -------- | --------------- | -------------------- | ------------------ | ------- | We also require a **summary fund-flow analysis** highlighting: 1. Total inflows and outflows. 2. Major sources of funds. 3. Major destinations of funds. 4. Transfers between accounts/entities. 5. Significant or unusual transactions. 6. Unexplained/unmatched transactions. 7. Transaction chains where funds move through multiple accounts. 8. Any patterns or observations relevant to an audit. ### Ideal Candidate You should have experience in: * Financial analysis * Forensic accounting * Bank statement analysis * Transaction reconciliation * Fund-flow analysis * Audit support * Excel / Google Sheets * Large-volume financial data analysis Experience with **forensic audits, transaction tracing, corporate investigations or fund-flow reconstruction** will be strongly preferred. ### Important This is **not simply a data-entry or bank reconciliation project**. The key objective is to **reconstruct and map the movement of funds** — i.e., understand **where money came from, where it went, and how funds moved between transactions/accounts/entities**. The freelancer must be highly detail-oriented and capable of working with potentially large volumes of transactions while maintaining complete accuracy and confidentiality. **Please include in your proposal:** * Your relevant experience with forensic/transaction analysis. * Examples of similar work you have completed. * Your proposed methodology for tracing fund movements. * Your expected turnaround time. * Your pricing structure. Confidentiality is extremely important as the information may contain sensitive financial data.