Compile & Analyse Categorised Financial Data in Excel
Budget: £20 – £250 GBP
Excel Expert Needed – Organise Categorised Bank Exports & Calculate 50/50 Profit Split (One Company, Two Properties)
Job Description
I have already categorised every transaction from multiple years of bank exports for one UK company that operates two properties. I now need an experienced Excel professional to take these cleaned files and build a clear, professional workbook for profit calculation and 50/50 split between Client A and Client B
Scope of work:
- Import the pre-categorised transaction files (provided as Excel or CSV) into a well-structured Excel workbook.
- Create one dedicated tab per calendar year showing all transactions with their categories (transactions relate to the single company across the two properties).
- Build additional summary tabs for specific items:
- Mortgage interest
- Client A management fees
- Liability caused by Client B (loss of income from not signing the remortgage)
- Incorporate a separate list of liabilities that I will provide.
- Perform the final calculation:
- Total Income
- Minus taxes due
- Minus all liabilities (including the ones listed above)
- = Net profit → split 50/50 between Client A and Client B to clearly show the amount owed to Client A.
Required skills:
- Advanced Excel skills (pivot tables, filters, structured tables, professional formatting, formulas)
- Experience working with bank transaction exports
- Strong attention to detail and ability to produce clean, easy-to-read financial summaries
- Good understanding of simple profit & loss calculations
Deliverables:
- One professional Excel workbook with:
- Yearly tabs (one per year)
- Dedicated tabs for Mortgage interest, Client A management fees, Client B liability, etc.
- Summary sheet showing the full calculation and final 50/50 split (amount owed to Client A)
- Clear layout that is easy for a non-accountant to understand
Additional details:
- Files will be Excel or CSV format.
- I will share the files via Freelancer messaging after the project is awarded.
The tabs will be Income & Outgoings Property 1, Income & Outgoings Property 2, Remortgage Default (loss), Management Fees, Professional Fees, Summary of Claim at the end.
I will also need to show -Capital Gains Tax (UK) at 50% liability each (but we can add this at the end)
Please quote your fixed price and estimated turnaround time (ideally within 3–5 days once files are supplied).
Only apply if you are confident you can deliver a polished, well-organised workbook quickly and accurately.
Thank you!
Job Description
I have already categorised every transaction from multiple years of bank exports for one UK company that operates two properties. I now need an experienced Excel professional to take these cleaned files and build a clear, professional workbook for profit calculation and 50/50 split between Client A and Client B
Scope of work:
- Import the pre-categorised transaction files (provided as Excel or CSV) into a well-structured Excel workbook.
- Create one dedicated tab per calendar year showing all transactions with their categories (transactions relate to the single company across the two properties).
- Build additional summary tabs for specific items:
- Mortgage interest
- Client A management fees
- Liability caused by Client B (loss of income from not signing the remortgage)
- Incorporate a separate list of liabilities that I will provide.
- Perform the final calculation:
- Total Income
- Minus taxes due
- Minus all liabilities (including the ones listed above)
- = Net profit → split 50/50 between Client A and Client B to clearly show the amount owed to Client A.
Required skills:
- Advanced Excel skills (pivot tables, filters, structured tables, professional formatting, formulas)
- Experience working with bank transaction exports
- Strong attention to detail and ability to produce clean, easy-to-read financial summaries
- Good understanding of simple profit & loss calculations
Deliverables:
- One professional Excel workbook with:
- Yearly tabs (one per year)
- Dedicated tabs for Mortgage interest, Client A management fees, Client B liability, etc.
- Summary sheet showing the full calculation and final 50/50 split (amount owed to Client A)
- Clear layout that is easy for a non-accountant to understand
Additional details:
- Files will be Excel or CSV format.
- I will share the files via Freelancer messaging after the project is awarded.
The tabs will be Income & Outgoings Property 1, Income & Outgoings Property 2, Remortgage Default (loss), Management Fees, Professional Fees, Summary of Claim at the end.
I will also need to show -Capital Gains Tax (UK) at 50% liability each (but we can add this at the end)
Please quote your fixed price and estimated turnaround time (ideally within 3–5 days once files are supplied).
Only apply if you are confident you can deliver a polished, well-organised workbook quickly and accurately.
Thank you!