Receipts for tax advisors Excel template 2027, receipt list & checklist, accounting for self-employed individuals, small businesses, Google Sheets

Suitable for 2026 and 2027: You enter the year yourself on the start sheet.

Your receipts for tax advice, neatly organized: a receipt list and monthly checklist for Excel and Google Sheets, in German. You enter each receipt, check off the items on the checklist at the end of the month, and send everything to your tax advisor along with a handover protocol. Complete and clearly organized.

For self-employed individuals, freelancers, and small business owners whose accounting is handled by a tax advisor. Handing over all your documents helps avoid queries and the need for additional information.

WHAT YOU GET
✓ Homepage with traffic light status for each month (handed over, complete, something missing, still open), counters and your next handover deadline, monthly or quarterly
✓ A message in plain text, e.g. "3 documents are still missing." or, if everything is there: "All documents are complete."
✓ Document list with 1,000 lines: Date, document number, type, partner, description, gross amount, payment method, filing location, folder or file name, and status (missing, available, submitted). The month is automatically detected.
✓ A check column that reports what is missing for each line, e.g., amount, status, or occasion and attendees on hospitality receipts.
✓ Monthly checklist with 14 typical items and tips: Bank statements for all accounts, credit card and PayPal, cash register, outgoing and incoming invoices, online bills, entertainment expenses, travel costs, contracts, private deposits and withdrawals, and more. Freely customizable, with progress tracking in %.
✓ Handover protocol as a print-ready A4 page for month, quarter or year: Receipts of each type with quantity and amount, checklist status, missing receipts, open questions, space for notes and signature
✓ A list of follow-up questions for tax advisor inquiries, including answers and status updates. Questions about a specific document can be addressed directly in the document list.
✓ Selection lists for document types, payment methods and filing, freely customizable
✓ Instructions directly in the file and a sample file with a fictional graphic designer to try out.

IT'S THAT EASY
1. Enter name, tax advisor, frequency and deadline
2. Enter supporting documents as soon as they are available, or mark them as "missing" if they are not yet available.
3. Check off the items on the checklist at the end of the month.
4. Print the handover protocol or send it as a PDF, done.

Yellow fields are for entering data, grey fields calculate automatically. The formulas are protected (without a password) to prevent any errors.

DELIVERY CONTENTS (INSTANT DOWNLOAD)
• Receipts_TaxConsulting.xlsx: the blank template
• Receipts_TaxConsulting_Demo.xlsx: the same template with sample data
• Quick guide.pdf: Explained step by step

COMPATIBILITY
• Microsoft Excel (Windows and Mac, from Excel 2010 onwards)
• Google Sheets (free, also on mobile)
• LibreOffice Calc (free)
Only standard formulas, no macros.

FREQUENTLY ASKED QUESTIONS
Does this template replace accounting software?
No. It doesn't book anything or calculate taxes. It helps you to collect all your receipts and hand them over to your tax advisor in an organized manner.

I hand over my responsibilities quarterly. Is that okay?
Yes. On the homepage, select "Quarterly", then the deadline, traffic light status and minutes will be calculated quarterly.

I'm starting in the middle of the year.
No problem. The file automatically starts with the first month in which there is an entry.

How long do I have to keep receipts?
Several years; as of 2026, generally 8 years for accounting documents and 10 years for books and annual financial statements. It's best to consult your tax advisor to determine the specifics that apply to you. Information provided without guarantee.

NOTES
• Digital product, nothing will be shipped.
• This template is an organizational aid for collecting and submitting receipts. It does not replace tax or legal advice. All information is provided without guarantee.
• The templates are developed with the support of AI tools and are checked and tested before being sold.

Questions? Message me on Etsy, I'm happy to help.