DEV Community: Ashish Srivastava

Multi-currency creator tracker in Excel — sales, expenses & goals (USD/GBP/EUR)

Ashish Srivastava — Wed, 04 Nov 2026 17:13:44 +0000

If you sell digital products across USD, GBP, and EUR, this is a plain Excel workbook to log sales and expenses in those currencies, pick a base currency, and see a simple dashboard, product catalog, marketing planner, and goals.

Buy / open ($27): https://ashishsrivastavajay.gumroad.com/l/hytkwb

Includes the Excel workbook (.xlsx) plus a Quick Start Guide (ZIP). Instant download. No macros.

Also live on the same shop (global Excel templates):

Order & Shipping Tracker — $3.20 · https://ashishsrivastavajay.gumroad.com/l/dcbkqg
Freelance Income Tracker — $3.60 · https://ashishsrivastavajay.gumroad.com/l/vcqscv
Agency Admin Workbook — $6 · https://ashishsrivastavajay.gumroad.com/l/fhoirr
Shop: https://ashishsrivastavajay.gumroad.com

Free Order & Payment Tracker stays $0: https://ashishsrivastavajay.gumroad.com/l/free-order-payment-tracker

Created with AI assistance; formulas checked before release. A tracking tool — not financial, tax, or earnings advice. No income results promised.

Order & Shipping Tracker for online sellers — $3.20 through 6 Nov (Excel, no macros)

Ashish Srivastava — Wed, 04 Nov 2026 17:10:54 +0000

Update: Sale price already on through Fri 6 Nov 2026, 11:59 PM IST — open the link, no code needed on this one.

If you sell on Etsy, Shopify, eBay, Amazon, Instagram, or your own site and ship physical orders, this is a plain Excel workbook for:

orders + channel/carrier dropdowns
ship-by dates (working days) and LATE flags
revenue, profit, margin per order
a one-page-wide Orders sheet + Summary by channel

Buy / open: https://ashishsrivastavajay.gumroad.com/l/dcbkqg — $3.20 (usually $8).

Also live on the same shop (buyable now):

Freelance Income Tracker — $3.60 · https://ashishsrivastavajay.gumroad.com/l/vcqscv
Simple Bookkeeping — $6 · https://ashishsrivastavajay.gumroad.com/l/hpuzo
Invoice & Receivables — $7 · https://ashishsrivastavajay.gumroad.com/l/bxwjyy
Small Business Sheets Bundle — $19 · https://ashishsrivastavajay.gumroad.com/l/lozujz
Shop: https://ashishsrivastavajay.gumroad.com

Free Order & Payment Tracker stays $0: https://ashishsrivastavajay.gumroad.com/l/free-order-payment-tracker

Made with AI tools under my direction; formulas checked. Not tax/legal advice. Microsoft Excel (.xlsx), no macros.

BREAKNOW: 60% off my Excel templates for freelancers and small shops (through 6 Nov)

Ashish Srivastava — Tue, 03 Nov 2026 12:44:31 +0000

Update (last days): these four are already at sale price through Fri 6 Nov 2026, 11:59 PM IST — no code needed.

BREAKNOW — Excel templates on sale through 6 Nov

Short cash break on the Excel (.xlsx) templates I publish for freelancers and small shops.

Priority picks are already at sale price through Fri 6 Nov 2026, 11:59 PM IST — do not use code BREAKNOW on these four; just open the link.

Agency Admin Workbook — now $6 (usually $15)
Admin Data Consolidation — now $6 (usually $15)
Order & Shipping Tracker — now $3.20 (usually $8)
Freelance Income Tracker — now $3.60 (usually $9)

Shop: https://ashishsrivastavajay.gumroad.com

Free starter (no code): Order & Payment Tracker

Made with AI tools under my direction. Global templates — not tax, payroll, or legal advice. Questions welcome in the comments.

Payroll register in Excel: gross pay, deductions and net pay for a small team

Ashish Srivastava — Sat, 31 Oct 2026 13:34:36 +0000

Written with AI assistance.

If you pay a handful of people, you don't need payroll software to stay organised. You need one register with a row per employee per month, and formulas that work out gross pay, deductions and net pay. This guide builds that register in Excel, so you type each number once and can print a payslip for anyone.

Note: deductions, contributions and reporting duties depend on where you operate. This article shows spreadsheet mechanics only, with rates you enter yourself. It is not tax, payroll, legal or accounting advice; check the rules with a qualified adviser.

Sheet 1: Employees

Col	Field
A	Emp ID
B	Name
C	Job title
D	Start date
E	Monthly base pay
F	Fixed allowances
G	Deduction 1 % (for example tax withholding)
H	Deduction 2 % (for example pension)
I	Fixed deduction per month
J	Employer contribution % (optional)

You enter the rates that apply to you; nothing is preset. Keep only what you need. Full bank and ID numbers don't belong in a spreadsheet you email around.

Sheet 2: Register (one row per employee per month)

Col	Field
A	Month (first day, e.g. 2026-10-01)
B	Emp ID
C	Days in month
D	Days paid
E	Base pay
F	Allowances
G	Other earnings
H	Gross
I	Deduction 1
J	Deduction 2
K	Fixed deduction
L	Other deductions
M	Total deductions
N	Net pay

Days in month (C2): =DAY(EOMONTH(A2,0)). If you pay on working days (Monday to Friday), use =NETWORKDAYS(A2,EOMONTH(A2,0)) instead.

Pro-rated base pay (E2), for someone who started mid-month or took unpaid leave:

=IF($B2="","",ROUND(INDEX(Employees!$E:$E,MATCH($B2,Employees!$A:$A,0))*D2/C2,2))

Copy the same pattern for allowances (column F of Employees).

Gross, deductions, net:

H2: =IF($B2="","",E2+F2+N(G2))
I2: =IF($B2="","",ROUND(H2*INDEX(Employees!$G:$G,MATCH($B2,Employees!$A:$A,0)),2))
J2: =IF($B2="","",ROUND(H2*INDEX(Employees!$H:$H,MATCH($B2,Employees!$A:$A,0)),2))
K2: =IF($B2="","",INDEX(Employees!$I:$I,MATCH($B2,Employees!$A:$A,0)))
M2: =IF($B2="","",I2+J2+K2+N(L2))
N2: =IF($B2="","",H2-M2)

The percentage deductions here are taken from gross pay. If a rule you follow works on a different base, change the formula to match it. Keeping the rates in the Employees sheet means that when one changes, you update one cell, not a formula.

Quick check: base pay 4,200 plus allowances 300 for a full month is a gross of 4,500. At a 15% deduction 1 that is 675. Half a month (15 of 30 days) gives a gross of 2,250 and a deduction of 337.50.

Add checks

Days paid can't exceed days in month. Select column D, Data > Data Validation, whole number between 0 and =C2.
Duplicates. A check column catches the same person and month entered twice:

=IF(COUNTIFS($A:$A,A2,$B:$B,B2)>1,"Duplicate","OK")

Unknown IDs. Wrap the lookups in IFERROR(...,0) and add a Name column that shows "Check ID" when the ID isn't in the Employees list.

A monthly summary without a pivot table

On a Summary sheet, list months down column A and use SUMIFS:

Gross:      =SUMIFS(Register!$H:$H,Register!$A:$A,A2)
Deductions: =SUMIFS(Register!$M:$M,Register!$A:$A,A2)
Net pay:    =SUMIFS(Register!$N:$N,Register!$A:$A,A2)

For a year-to-date total, add a start and end date:

=SUMIFS(Register!$N:$N,Register!$A:$A,">="&DATE(2026,1,1),Register!$A:$A,"<="&DATE(2026,12,1))

Overtime and one-off payments

Bonuses, overtime and reimbursements don't belong in the Employees sheet because they change each month. Put them in the Register's Other earnings column and include them in gross, as above. Label them clearly on the payslip so the employee can see where the extra amount came from.

Employer cost (optional)

If you track an employer contribution, add one more column: =ROUND(H2*INDEX(Employees!$J:$J,MATCH($B2,Employees!$A:$A,0)),2). Total payroll cost for the month is then gross plus that column.

Common mistakes

Overwriting last month's rows. Add new rows each month; the register is your history.
Rates hard-coded in formulas. Keep them in the Employees sheet.
Duplicate rows for the same person and month. Use the check column.
Sharing the whole file. Send each person a PDF of their own slip, not the register.

Written with AI tools. This is general spreadsheet guidance for Excel (.xlsx), not tax, legal or accounting advice.

Practical spreadsheet templates for small businesses, made with AI assistance.

FLASH40 has ended — Excel templates for freelancers and small shops (full price)

Ashish Srivastava — Fri, 30 Oct 2026 18:55:20 +0000

FLASH40 has ended — templates still available at full price

The FLASH40 40% off window closed after 30 Oct 2026 11:59 PM IST. The same Excel templates remain on Gumroad at regular prices.

Live paid templates

Free starter (always $0): Order & Payment Tracker

Made with AI tools under my direction. Plain formulas where noted — check each product page for macros/VBA. Global templates — not tax, payroll, or legal advice. Questions welcome in the comments.

Sales tax / VAT on an Excel invoice — rates, inclusive prices, and rounding

Ashish Srivastava — Fri, 30 Oct 2026 18:54:59 +0000

Sales tax, VAT and similar taxes all work the same way in a spreadsheet: a percentage applied to an amount. What differs is the rate, whether prices include the tax, and how you round. This guide shows a simple, generic tax % column for an Excel invoice template and the logic behind it, using plain formulas that work in older Excel versions too.

Note: which rate applies, whether you must charge tax and what an invoice must show depend on where you operate. This is about spreadsheet logic only. It is not tax, legal or accounting advice; check the rules with a qualified adviser.

1. Keep one default rate in Settings

Make a Settings sheet and type your default tax rate in one cell, say Settings!B7 = 8%. Type 0% if you don't charge tax. Every formula points at this cell, so you never type the rate twice.

2. The invoice log

On an Invoices sheet, one row per invoice: B = date, C = customer, D = amount before tax, E = tax % (optional, leave blank to use the default).

Rate used (H2):

=IF($B2="","",IF(E2="",Settings!$B$7,E2))

A blank means "use the default". A typed 0% means "no tax on this one", so the two cases stay different.

Tax (F2) and total (G2):

F2: =IF($B2="","",ROUND(D2*H2,2))
G2: =IF($B2="","",D2+F2)

Quick check: 1,000 at 8% gives tax 80 and a total of 1,080. The same 1,000 with 5% typed in column E gives 50 and 1,050, and with 0% gives 0 and 1,000.

3. When your prices already include tax

Some businesses quote one price that includes tax. Then you work backwards from the price. In a spare area, put the tax-inclusive price in P2, the rate in Q2, and:

Net amount (R2): =ROUND(P2/(1+Q2),2)
Tax part (S2):   =P2-R2

With 1,080 at 8%, the net is 1,000 and the tax part is 80. Use the tax part as a difference, not as a second rounded calculation, so net and tax always add back to the total.

4. Mixed rates on one invoice

If different items carry different rates, put the rate on each line instead of the invoice. On an Items list add a tax % column (blank = default). The line formula picks the item's rate if there is one and the default if not:

=IFERROR(IF(INDEX(Items!$C:$C,MATCH($A10,Items!$A:$A,0))="",Settings!$B$7,INDEX(Items!$C:$C,MATCH($A10,Items!$A:$A,0))),Settings!$B$7)

5. Round each line, then add

Rounding can make totals differ by a cent. Take three items at 0.50 with 5% tax:

Round each line: 0.03 + 0.03 + 0.03 = 0.09
Add first, then round: 1.50 x 5% = 0.075, which rounds to 0.08

Neither is "wrong". What matters is picking one method and using it everywhere. Rounding each line means the tax column always adds up to what's printed on each line, which is why the formulas above round per line. If you need a particular rounding method, ask your adviser.

6. A tax summary by rate

If you use more than one rate, list the rates in a small table (say M2:M5) and use SUMIFS on the "rate used" column:

Amount at this rate: =SUMIFS($D$2:$D$500,$H$2:$H$500,M2)
Tax at this rate:    =SUMIFS($F$2:$F$500,$H$2:$H$500,M2)

Add a check that the table's total equals =SUM(F2:F500). If it doesn't, a row uses a rate that isn't in your list.

7. Why every formula starts with `IF($B2="","",…)`

You'll fill formulas down 500 rows ahead of time. If they aren't wrapped, empty rows show 0 or errors, and your totals and charts get messy. Using the date cell as the "is this row in use?" check keeps unused rows blank.

8. Turn the log into a receivables list

Add columns for due date (I = date + payment terms) and amount received (J), then:

Balance (K):      =IF($B2="","",G2-N(J2))
Days overdue (L): =IF($B2="","",IF(AND(K2>0,TODAY()>I2),TODAY()-I2,0))

A per-customer SUMIFS on balance and days overdue then gives 0-30 / 31-60 / 61-90 / 90+ buckets, which is your follow-up list for the week.

Common mistakes

Hard-coding the rate inside formulas. Keep it in a cell.
Mixing amounts before tax and after tax in one column.
Leaving the tax cell blank when you mean zero. Type 0%.
Using a rate from an old invoice for a new one. Check your rates when they change.

Written with AI tools. This is general spreadsheet guidance for Excel (.xlsx), not tax, legal or accounting advice.

Practical spreadsheet templates for small businesses, made with AI assistance.

Order & Shipping Tracker in Excel — ship-by dates and late flags (40% off through 30 Oct)

Ashish Srivastava — Thu, 29 Oct 2026 16:02:31 +0000

Order & Shipping Tracker — 40% off with FLASH40 through 30 Oct

Update (30 Oct): FLASH40 ends tonight at 11:59 PM IST — last hours at 40% off. After that, full price.

For freelancers and small shops who track orders in scattered notes: one Excel file with ship-by dates, late flags, and simple profit-per-order math.

What's in it

Order log with ship-by date
Late / on-time flags (plain formulas — no macros)
Basic profit / order view

Price: usually $8. Code FLASH40 = 40% off (~$5) through 30 Oct 2026 11:59 PM IST.

→ Order & Shipping Tracker on Gumroad

Same sale (same code):

Free (no code): Order & Payment Tracker

Made with AI tools under my direction. Global templates — not tax or legal advice. Questions welcome in the comments.

ChatGPT Prompts for Small Business Owners: 8 Fill-in Templates and How to Use Them

Ashish Srivastava — Thu, 29 Oct 2026 13:38:00 +0000

Written with AI assistance. The prompts below are starting points; results depend on the details you add and the tool you use.

A prompt is a short brief. The more specific it is, the less editing you do afterwards. The shortcut is a fill-in template: a prompt with [brackets] where your details go, saved so you only fill the blanks.

Below are eight, covering parts of a small shop that people often forget about. Each is written to be pasted into ChatGPT or any other AI chat tool.

1. How to fill the brackets

Replace every [bracket]. A prompt with a bracket left in gets generic output.
Give real numbers: the date, the order number, the price.
Say who's reading. "A customer who has waited a week" gets a different reply from "a new customer".
Ask for a length. "Three sentences" or "under 80 words" saves trimming.

2. Eight fill-in prompts

Product description (listing)

Write a product description for [product]. Buyer: [who]. Key features: [features]. Tone: [tone]. Under [80] words.

Listing titles

Give me 10 listing title options for [product] sold on [platform]. Include [keyword] and keep each under [60] characters.

Shipping update (customer email)

Write a shipping update for order [order number]. It left on [date] with [carrier]; tracking number [number]. Friendly, three sentences.

Delay apology (customer email)

Write a polite apology for a delay on order [order number]. New date: [date]. Offer [remedy]. No excuses, no blame.

Supplier quote

Write a short message to [supplier] asking for a quote on [quantity] of [item], delivery to [place] by [date].

Pricing sums

I pay [cost] per unit plus [shipping] shipping and want about [margin]% margin. Show the maths for a selling price, step by step, so I can check it.

Packing checklist

Make a checklist for packing and posting an order, for a shop that sells [product]. Keep it to [8] steps.

Review request

Write a short, friendly message asking a customer who received [product] to leave a review. Do not offer anything in return.

3. Always check what it writes

AI tools write fluently, including when they're wrong. Before you send or publish anything:

Check facts, prices, dates and policies against your own records. The tool doesn't know your stock, your carrier or your refund rules unless you told it.
Redo any maths. The pricing prompt asks for the steps so you can follow them; confirm the answer with a calculator or a spreadsheet.
Read it aloud. If it doesn't sound like you, change it.
Don't promise anything on your behalf (refunds, delivery dates, discounts) that you haven't decided yourself.

I haven't measured how well these prompts perform. Results depend on the details you add and the tool you use.

4. Keep them in a sheet you can search

Once you have a few dozen, paste them into a sheet: A Category, B Prompt. Put a search word in B1, then in C4:

=IF($B$1="","",IF(ISNUMBER(SEARCH($B$1,B4)),"match",""))

Fill it down, and filter column C for "match". Count the matches with:

=COUNTIF(C4:C104,"match")

SEARCH ignores capital letters, so "Tracking" and "tracking" both find the shipping prompt. With the eight prompts above, searching "tracking" finds one match (the shipping update).

5. Don't paste private details

Leave out customers' full names, addresses, phone numbers and payment details when you use a public AI tool. Use "a customer" and the order number instead.

Written with AI tools. This is general guidance, not business, legal or accounting advice.

Practical spreadsheet templates for small businesses, made with AI assistance.

Admin Data Consolidation Workbook — merge messy admin tables in Excel (40% off through 30 Oct)

Ashish Srivastava — Thu, 29 Oct 2026 08:29:04 +0000

Admin Data Consolidation — 40% off with FLASH40 through 30 Oct

Update (30 Oct): FLASH40 ends tonight at 11:59 PM IST — last hours at 40% off. After that, full price.

One Excel workbook for merging messy admin tables into a clean working file. LibreOffice-tested. Plain formulas — no macros / no VBA. UI notes in English + Spanish. Built with AI tools under my direction.

Usually $15. Code FLASH40 = 40% off (~$9) through 30 Oct 2026 11:59 PM IST.

→ Admin Data Consolidation Workbook

Also in the same sale:

Free starter (no code): Order & Payment Tracker

Global templates — not tax, payroll, or legal advice. Questions welcome in the comments.

Agency Admin Workbook — clients, income/expense, and reports in one Excel file (40% off through 30 Oct)

Ashish Srivastava — Thu, 29 Oct 2026 03:42:16 +0000

Agency Admin Workbook — 40% off with FLASH40 through 30 Oct

Update (30 Oct ~8 PM IST): Final hours — FLASH40 ends tonight at 11:59 PM IST. After that, full price.

I put together an Excel workbook for freelancers and small agencies who juggle clients, money in/out, and simple reports in separate sheets (or worse, in their head).

What's in it

Client list
Income and expense log
Auto-built summary reports (plain Excel formulas — no macros)

Price: usually $15. Code FLASH40 = 40% off (~$9) through 30 Oct 2026 11:59 PM IST.

→ Agency Admin Workbook on Gumroad

Other paid Excel templates in the same sale (same code):

Free (no code needed): Order & Payment Tracker

Made with AI tools under my direction. Global templates — not tax, payroll, or legal advice. Happy to answer setup questions in the comments.

FLASH40: 40% off my Excel templates for freelancers and small shops (through 30 Oct)

Ashish Srivastava — Wed, 28 Oct 2026 14:46:43 +0000

Written with AI assistance. I edited it.

Update (30 Oct ~8 PM IST): Final hours — FLASH40 ends tonight at 11:59 PM IST. After that, full price.

I'm running a short flash sale on the Excel (.xlsx) templates I publish for freelancers and small shops — orders, invoices/receivables, bookkeeping, shipping, inventory, and a sheets bundle.

Code FLASH40 = 40% off every paid product through 30 Oct 2026, 11:59 PM IST.

Start free, then grab what you need:

Free Order & Payment Tracker: https://ashishsrivastavajay.gumroad.com/l/free-order-payment-tracker
Simple Bookkeeping ($6): https://ashishsrivastavajay.gumroad.com/l/hpuzo?code=FLASH40
Invoice & Receivables ($7): https://ashishsrivastavajay.gumroad.com/l/bxwjyy?code=FLASH40
Order & Shipping Tracker ($8): https://ashishsrivastavajay.gumroad.com/l/dcbkqg?code=FLASH40
Sheets Bundle ($19): https://ashishsrivastavajay.gumroad.com/l/lozujz?code=FLASH40

Shop: https://ashishsrivastavajay.gumroad.com

All templates are made with AI tools under my direction, Excel only, no macros. They're for record-keeping — not tax, legal, or accounting advice.

If you've sold low-price utility templates before: did a free tracker → niche paid files → bundle convert for you, or did one mid-priced bundle win first? Still looking for the first buyers and hard lessons on discovery.

Invoice format in Excel: a simple layout with an optional tax % column

Ashish Srivastava — Wed, 28 Oct 2026 13:42:10 +0000

You don't need billing software to send a clean invoice. A well laid out Excel workbook can keep your details in one place, pull customer and item details from lists, add tax if you charge it, and print or save a PDF. This guide builds a simple, worldwide invoice format in Excel step by step.

Note: whether you charge tax, which rate applies and what an invoice must show depend on where you operate. This article covers spreadsheet layout and formulas only. It is not tax, legal or accounting advice.

Step 1: A Settings sheet

Make a sheet called Settings with the details that appear on every invoice:

Cell	Value
B2	Business name
B3	Address
B4	Email
B5	Currency label, e.g. `USD`
B6	Tax name (for example VAT or Sales tax)
B7	Default tax % (type `0%` if you don't charge tax)
B8	Invoice prefix, e.g. `INV-`
B9	Payment details

Every invoice formula points at these cells, so if your address changes you edit one cell.

Step 2: Customers and Items lists

On a Customers sheet: A = customer name, B = email, C = billing address, D = payment terms in days.

On an Items sheet: A = item or service, B = unit price, C = tax % (leave blank to use the default from Settings).

Turn both into Excel Tables (Ctrl+T) so new rows appear in your dropdowns automatically.

Step 3: The invoice header

On an Invoice sheet:

F2: a running number you type, e.g. 41
F3: =Settings!B8&TEXT(F2,"0000") gives INV-0041
F4: the invoice date
B6: the customer, as a dropdown (Data > Data Validation > List, pointing at the customer names)
F5, due date: =F4+IFERROR(INDEX(Customers!$D:$D,MATCH($B6,Customers!$A:$A,0)),30)

If the customer isn't in the list, the due date falls back to 30 days.

Pull the customer's address the same way:

B7: =IFERROR(INDEX(Customers!$C:$C,MATCH($B$6,Customers!$A:$A,0)),"")

Step 4: The line items

Start the item rows at row 10 with these columns:

Col	Field
A	Item (dropdown from the Items list)
B	Qty (you type)
C	Rate
D	Amount
E	Tax %
F	Tax
G	Line total

C10: =IF($A10="","",IFERROR(INDEX(Items!$B:$B,MATCH($A10,Items!$A:$A,0)),0))
D10: =IF($A10="","",ROUND(B10*C10,2))
E10: =IF($A10="","",IFERROR(IF(INDEX(Items!$C:$C,MATCH($A10,Items!$A:$A,0))="",Settings!$B$7,INDEX(Items!$C:$C,MATCH($A10,Items!$A:$A,0))),Settings!$B$7))
F10: =IF($A10="","",ROUND(D10*E10,2))
G10: =IF($A10="","",D10+F10)

The IF($A10="","",…) wrapper keeps unused rows blank. Copy row 10 down for as many lines as you need. These are plain IF, INDEX and MATCH formulas, so they work in older versions of Excel as well as Excel 365.

The tax % column is optional. An item with a blank tax % uses the default; an item with 0% stays at zero, which is handy for items you don't charge tax on.

Step 5: Totals

Below the items (say rows 25 to 27), with the tax label pulled from Settings:

Subtotal:        =SUM(D10:D24)
=Settings!B6:    =SUM(F10:F24)
Total due:       =SUM(G10:G24)

Add the currency label next to the total with ="Total due ("&Settings!B5&")".

Step 6: Keep a register of every invoice

Before you clear the invoice for the next customer, copy its number, date, customer, subtotal, tax and total into an Invoices register sheet, one row per invoice. Add columns for Amount received and Balance (=F2-N(G2)). That register is what you use for monthly totals and for chasing payments. A pivot table on it (Rows: month; Values: sum of total) gives a quick monthly view.

Step 7: Print or save as PDF

Select the invoice area, Page Layout > Print Area > Set Print Area, choose Fit to 1 page wide, then File > Export > Create PDF. Name the file with the invoice number so it's easy to find later.

Common mistakes

Hard-coding a tax rate in formulas. Keep rates in Settings and Items.
Typing customer details by hand each time. Look them up from the list instead.
Overwriting the last invoice without logging it. Add it to the register first.
Rounding only the grand total. Round each line's tax so the lines add up to the total.
Reusing invoice numbers. A check such as =COUNTIF(A:A,A2)>1 on the register's number column flags duplicates.

Written with AI tools. This is general spreadsheet guidance for Excel (.xlsx), not tax, legal or accounting advice.

Practical spreadsheet templates for small businesses, made with AI assistance.

DEV Community: Ashish Srivastava

Multi-currency creator tracker in Excel — sales, expenses & goals (USD/GBP/EUR)

Order & Shipping Tracker for online sellers — $3.20 through 6 Nov (Excel, no macros)

BREAKNOW: 60% off my Excel templates for freelancers and small shops (through 6 Nov)

BREAKNOW — Excel templates on sale through 6 Nov

Payroll register in Excel: gross pay, deductions and net pay for a small team

Sheet 1: Employees

Sheet 2: Register (one row per employee per month)

Add checks

A monthly summary without a pivot table

Overtime and one-off payments

Employer cost (optional)

Common mistakes

FLASH40 has ended — Excel templates for freelancers and small shops (full price)

FLASH40 has ended — templates still available at full price

Sales tax / VAT on an Excel invoice — rates, inclusive prices, and rounding

1. Keep one default rate in Settings

2. The invoice log

3. When your prices already include tax

4. Mixed rates on one invoice

5. Round each line, then add

6. A tax summary by rate

7. Why every formula starts with IF($B2="","",…)

8. Turn the log into a receivables list

Common mistakes

Order & Shipping Tracker in Excel — ship-by dates and late flags (40% off through 30 Oct)

Order & Shipping Tracker — 40% off with FLASH40 through 30 Oct

ChatGPT Prompts for Small Business Owners: 8 Fill-in Templates and How to Use Them

1. How to fill the brackets

2. Eight fill-in prompts

3. Always check what it writes

4. Keep them in a sheet you can search

5. Don't paste private details

Admin Data Consolidation Workbook — merge messy admin tables in Excel (40% off through 30 Oct)

Admin Data Consolidation — 40% off with FLASH40 through 30 Oct

Agency Admin Workbook — clients, income/expense, and reports in one Excel file (40% off through 30 Oct)

Agency Admin Workbook — 40% off with FLASH40 through 30 Oct

FLASH40: 40% off my Excel templates for freelancers and small shops (through 30 Oct)

Invoice format in Excel: a simple layout with an optional tax % column

Step 1: A Settings sheet

Step 2: Customers and Items lists

Step 3: The invoice header

Step 4: The line items

Step 5: Totals

Step 6: Keep a register of every invoice

Step 7: Print or save as PDF

Common mistakes

7. Why every formula starts with `IF($B2="","",…)`