Comptabilité & Factures Indépendants
Journaux, factures avec suivi des retards, un vrai compte de résultat, estimation d'impôt trimestrielle et frais kilométriques — un seul fichier pour toute l'année.
Téléchargement immédiat · licence usage personnel · mises à jour à vie
Payez avec PayPal ou une carte
- 12 feuilles · 12774 formules
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 199 KB
Installez le produit, utilisez-le au moins une semaine et, s'il ne vous convient vraiment pas, écrivez-nous dans les 14 jours avec une capture d'écran de votre installation : nous vous remboursons intégralement.
Le détail du produit est pour l'instant en anglais.
Freelancers and side hustles do not need accounting software; they need one file that answers "how much did I make, what did I spend, who still owes me and how much tax should I set aside". This workbook does exactly that. Log money in on the Income Ledger and money out on the Expense Ledger, add your invoices, and everything else calculates: the Dashboard, a month-by-month profit and loss report, an invoice aging table and a quarterly tax estimate.
Twelve linked sheets and 12,774 formulas: a 1,000-row income ledger with client and category dropdowns and automatic sales tax / VAT, a 1,500-row expense ledger that applies the right deductible percentage per category (meals at 50%, entertainment at 0%, everything else 100%) and lets you override any row, 300 invoices whose paid amount comes straight from the income ledger by invoice number, with Paid / Partial / Overdue / Open status, days overdue and 0–30 / 31–60 / 61–90 / 90+ aging buckets. There is also a 400-row mileage log at your own rate, a 30-client table with billed / paid / outstanding, a 50-item inventory and COGS sheet with low-stock flags, and an annual summary with your top clients and biggest costs.
It ships filled with eight months of a fictional freelance design studio so every chart and report is alive on first open — clear the yellow cells in a couple of minutes and it is yours. Any currency, any fiscal-year start month, your own tax and mileage rates. Classic formulas only (no macros, no XLOOKUP, no add-ins), so it behaves identically in Excel 2016+, Excel 365 and Google Sheets.
Ce que vous recevez
- 12 linked sheets · 12,774 formulas · no macros, nothing locked
- Dashboard: revenue, expenses, net profit, margin, outstanding and overdue invoices, tax set-aside, cash collected this month, plus 4 charts
- Income Ledger (1,000 rows) with client and category dropdowns, taxable Y/N and automatic sales tax / VAT
- Expense Ledger (1,500 rows) with a deductible % per category that you can override row by row
- Invoices (300) — due date from your terms, paid pulled from the ledger by invoice number, status, days overdue and aging buckets with a summary block
- Profit & Loss laid out like a real report: income by category × 12 months, cost of sales, gross and net profit, margins and a YTD column
- Quarterly tax estimate with revenue, deductible expenses, mileage, estimated tax, set aside to date and what is left (estimate only — not tax advice)
- Mileage Log (400 trips) at your own rate with round-trip doubling and monthly totals
- 30 clients with billed / paid / outstanding, 50-item inventory with low-stock flags, annual summary with top clients and biggest costs
- Any currency · any fiscal year start month · Excel 2016+ and Google Sheets · PDF set-up guide included
Voir toutes les pages
Cliquez sur une page pour l'agrandir.
Ce qu'il y a dedans
Questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it and choose File → Save as Google Sheets. Every formula uses functions Sheets supports (SUMIFS, COUNTIFS, INDEX/MATCH, LARGE, EOMONTH, TEXT); there are no macros, no XLOOKUP and no dynamic arrays. The included PDF walks you through it.
Is this a substitute for an accountant?
No. It keeps your books tidy and gives you an estimate of what to set aside, but the Quarterly Tax Estimate sheet says plainly that it is an estimate for planning only. Tax rules differ by country, state and business type — check the numbers with a professional before you file.
Can I use it outside the US?
Yes. Set any currency symbol, any fiscal-year start month, your own sales-tax or VAT rate and your own mileage rate on the Settings tab. The expense ledger has a "tax paid" column for reclaimable VAT.
How does the invoice tracker know what has been paid?
When you log a payment in the Income Ledger you type the invoice number. The Invoices sheet adds up every ledger row with that number, so balance, status, days overdue and the aging bucket update by themselves. Partial payments work — the invoice shows as Partial until the balance reaches zero.
What about deductible percentages?
Each expense category on Settings has a deductible % — meals default to 50%, client entertainment to 0% and everything else to 100%. The ledger looks it up automatically, and you can type a different % on any single row when a purchase is part personal, part business.
How many rows does it hold?
1,000 income rows, 1,500 expenses, 300 invoices, 400 mileage trips, 30 clients and 50 inventory items — comfortably a full year for most freelancers. Email us if you need a bigger version; it is free.
Avis
Pas encore d'avis — ce produit est nouveau. Chaque avis publié ici provient d'un achat vérifié.
Licence d'usage personnel pour un foyer. Ni revente ni redistribution. Livré sous forme de fichier ZIP à télécharger immédiatement après le paiement. Aucun article physique n'est expédié.
