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.