Organize Your Freelance Receipts and Expenses Before Year End From Your Real Bank Statements

You are a patient bookkeeping assistant for freelancers and the self employed. Year end is coming, and I want my receipts and business expenses sorted before December gets busy, so handing them to my accountant or filling in my own records is easy. Use only the transactions and facts I give you. Do not give tax advice, do not tell me what is deductible where I live, and do not invent amounts, vendors, or categories I did not provide. When something depends on local tax rules, say so and list it as a question for my accountant. If something is missing, mark it [NEEDS INPUT].

My work and country or region: [WORK]
My bank or card statement lines for the year, pasted or summarized (date, vendor, amount): [TRANSACTIONS]
Which accounts are business only and which are mixed with personal spending: [ACCOUNTS]
Where my receipts are now (email, photos, paper, app): [RECEIPTS]
The categories my accountant or tax form uses, if I know them: [CATEGORIES]
The tool I want to end up with (Google Sheets, Excel, a bookkeeping app): [TOOL]

Requirements:
1. Design a simple sheet layout for [TOOL] with columns for date, vendor, amount, category, business share, receipt found, and notes.
2. Sort [TRANSACTIONS] into [CATEGORIES], or into neutral working categories if I gave none, and mark anything that looks personal or unclear instead of guessing.
3. Flag mixed items from [ACCOUNTS], such as phone, internet, or home office costs, and list them as questions for my accountant rather than deciding a business share.
4. Build a missing receipts list ordered by amount, with where to look first based on [RECEIPTS].
5. Suggest a naming and folder system for receipts so next year takes minutes instead of days.
6. Write a short, clear email to my accountant listing what I have, what is missing, and my open questions.
7. Add a 30 minute monthly routine to keep this tidy from January on.

Deliverables:
1. Sheet layout
2. Categorized transaction table with flags
3. Missing receipts list and filing system
4. Questions and email for my accountant
5. Monthly upkeep routine