เทมเพลต Excel / Google Sheets

Shop & Freelance Accounts Template

Quotation and invoice with auto VAT 7% and withholding tax
Business ledger by category
Monthly tax summary
Customer dropdowns

฿99Lifetime

About this template

An accounts kit for small shops and freelancers. Print-ready quotations and invoices with 7% VAT and withholding tax calculated, a business ledger, and a monthly tax and profit summary for the whole year.

Screenshots from the real file

Who it is for

Freelancers who send quotations and invoices
Small shops and sole traders without accounting software
Anyone preparing VAT and withholding tax figures

What you get out of it

Professional documents in minutes
No manual VAT or withholding sums
See your business profit every month
Tax figures ready when it is time to file

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean

Business infoBusiness name, address, tax ID and bank account, shown on every document

QuotationEnter the client and items; totals, VAT and withholding are calculated. Ready to print or save as PDF

InvoiceSame layout as the quotation, with a payment status

LedgerRecord business income and expenses by category; VAT and withholding are split out

Tax summaryMonthly income, expenses, profit, output VAT, input VAT, VAT payable and tax withheld

SettingsAccount categories, VAT options and statuses

How to use it

In "Business info", enter your name, address and bank account
Fill in a quotation or invoice, then print or save as PDF
Record income and expenses in "Ledger"
Check monthly tax and profit in "Tax summary"

What you receive

Excel file (.xlsx), 61 KB, ready to download right after payment
A Google Sheets link that makes your own copy in Google Drive, usable on mobile
Sample data on every tab so you can see how to fill it in, then replace it with yours
Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is Shop & Freelance Accounts Template for?

Freelancers who send quotations and invoices; Small shops and sole traders without accounting software; Anyone preparing VAT and withholding tax figures

What's inside the file?

6 tabs: Business info, Quotation, Invoice, Ledger, Tax summary, Settings, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet