Invoice-Bank Transactions Matching and File Organisation

# Match Invoices to Bank Transactions & Organise Files (Excel)

## Project Overview

I am looking for a reliable freelancer with excellent attention to detail to help organise a small accounting task.

### Tasks

1. Match approximately **50 supplier invoices** against an Excel spreadsheet containing bank transactions.
2. Identify which bank transaction relates to each invoice.
3. Record the matching transaction against each invoice in the spreadsheet.
4. Highlight **any invoices that do not have a matching bank transaction**.
5. Highlight **any bank transactions that do not have a matching invoice** (i.e. missing invoices or transactions requiring further investigation).
6. Organise all invoice PDF files into the following folders based on the invoice date:

* **01 October 2025 – 31 December 2025**
* **01 January 2026 – 31 March 2026**
* **01 April 2026 – 30 June 2026**
7. Rename invoice files consistently if required.

## Requirements

* Excellent Excel skills.
* Strong attention to detail and accuracy.
* Experience with bookkeeping, accounting support or bank reconciliations is preferred.
* Ability to communicate clearly in English.
* All information must remain strictly confidential.

## Deliverables

* Updated Excel spreadsheet showing all matched invoices and bank transactions.
* A clear list of:

* Invoices with no matching bank transaction.
* Bank transactions with no matching invoice.
* Organised invoice folders by quarter.
* Any observations or discrepancies identified during the reconciliation.

## Timeline

I would like the work completed within **24–48 hours**.

When applying, please include:

* Your experience with similar reconciliation work.
* How quickly you can complete the project.
* Confirmation that you understand the requirements and can complete the work accurately.