01What DocMaster does
DocMaster is an invoice, order and stock manager that lives inside Google Sheets and Google Docs. You type an order once. The invoice, the stock change and the customer email all come from it.
- Orders, products and customers are saved in tabs of your own Google Sheet, so you can always see and sort them yourself
- Every invoice is made as a PDF and saved in a Google Drive folder named DocMaster, or in the folder you choose
- Pick a ready invoice look, or use your own Google Doc and tap in the details you want
- Make one invoice with the order, or invoices for many orders at once, with a progress bar you can leave and come back to
- Stock goes down when you make an order and comes back when you cancel or refund it
- A ready email for every stage of an order: new, confirmed, paid, done, cancelled, refunded, and a payment reminder
- Payments, part payments, due days and overdue reminders, with GST or VAT lines when you need them
- Import products, customers and orders from CSV, Excel, JSON, a Google Sheet or a pasted list, and undo an import
- Reports, a History of what changed, and delivery dates added to your Google Calendar
- Free to start. Plus and Pro add more room and conveniences (see Plans and limits)
02What is new
A short summary of what changed in the new DocMaster, so you can find things fast. Your orders, products, customers and settings are exactly where you left them. Only the screens changed.
- One New order screen makes the order and its invoice, and you can email the invoice right after.
- Invoices for many orders make 20 at a time with a progress bar you can leave and come back to.
- Ready invoice looks (Classic, Modern, Simple, Compact), or use your own Google Doc.
- Import products, customers and orders from CSV, Excel, JSON, a Google Sheet or a pasted list, and undo an import.
- Payments with part payments, due days and overdue reminders; India GST and VAT lines when you need them.
- Reports, a History of what changed, and delivery dates in your Google Calendar.
Where things moved
Create Order is now New order. Manage Inventory is Products. Invoice and Tasks is Invoices for many. Configuration is My business and More settings. Email Configuration is Emails. Product, order and email history are all in History.
Plans and limits
Free makes up to 30 orders and 30 invoices a month. Plus makes up to 200 of each. Pro has no monthly limit. Limits start on 1 December 2026.
Your data stays yours
Orders, products and customers live in your own Google Sheet. Invoices are PDFs in your own Drive. Emails are sent from your own Gmail.
This guide follows the screens in the order you will use them. Tap a title in the left menu to jump to it.
03Install DocMaster
DocMaster installs from the Google Workspace Marketplace and opens in the side panel of Google Sheets. It takes about a minute.
- 1
Install from the Google Workspace Marketplace
Open the DocMaster page in the Marketplace and tap Install. Sign in with the Google account you use in Sheets. Your plan, if you buy one, is unlocked for that account.
- 2
Allow the permissions
Google asks you to allow DocMaster once. In plain words: it works on the spreadsheet you have open, saves the invoices it makes in your Drive, sends email from your Gmail only when you tap send, and adds delivery dates to your Google Calendar when you switch that on. It opens only the files you pick and the files it makes itself.
Note: If you ever see a message to sign in again, close the side panel and open DocMaster again from the side panel icon. Your data is not affected.
- 3
Open a Google Sheet and open DocMaster
Open any Google Sheet, or make a new one. Click the DocMaster icon in the side panel on the right. If you do not see it yet, tap the three dots at the bottom of the side panel and choose DocMaster.
04Make your first invoice
The first time you open DocMaster in a sheet it asks two quick questions, sets everything up and makes a sample invoice so you can see what your customers will get.
- 1
Answer two questions
Type your business name and choose your currency. That is all DocMaster needs. Below the button it tells you what will happen: invoices are saved in a Drive folder named DocMaster.
Tip: Already have orders or products in this sheet? Choose Skip the samples, start empty, and import them later with Import data.
- 2
Tap Make my first invoice
DocMaster adds the tabs it needs to your sheet (Products, Customers, Orders, Payments and Order Items), makes the DocMaster folder in your Drive, adds a few sample products and one sample customer, and makes a sample invoice. It takes about a minute and shows its progress.
- 3
Look at your first invoice
The screen shows the sample invoice with your business name on it, and tells you where the PDF was saved. Tap Make it mine to put your own business details on it.
Note: The sample invoice and the sample products are only there to show how it works. A banner on Home offers to remove them (it asks first, and only the sample is removed). They never count toward your plan.
05Home screen
Home shows what needs you today. Open the menu with the three lines at the top left to reach every other screen. The round arrow at the top right refreshes the data if you changed the sheet by hand.
- 1
Today: three numbers
Orders to do, money not paid yet, and products running low. Tap the first two to open Orders, or the third to open Products.

- 2
Needs you
The invoices that are overdue and the products that are almost out. Tap the tick to mark an invoice paid, or the plus to add stock, without leaving Home.
- 3
Getting started and recent orders
A short checklist: make your first invoice, add your business details, add your own products, email invoices to customers. Below it are your most recent orders. The big New order button is always at the bottom.
- 4
The menu
Home, New order, Orders, Invoices for many, Products, Customers, Import data, My business, Invoice look, Emails, Reports, History and More settings. At the top of the menu is your plan card with how many orders and invoices are left this month.

06Make a new order
One screen makes the order, works out the total and tax, and makes the invoice. The same screen is how you make a quotation.
- 1
Add the products
Search your products and tap one to add it. Use the plus and minus to change the amount. Selected in sheet adds the products you highlighted in the Products tab of your sheet. Shipping or another charge adds a line that is not a product, such as delivery.

- 2
Choose who it is for
Type a name or an email. If the customer has ordered before, their details fill in. A new customer can be added right there, with just an email and a name.
- 3
Choose how the order starts
New means not paid yet, and it is also how you make a quotation. Confirmed means the customer agreed. Paid books a payment for the whole total. The matching email is sent only if you switched it on in Emails.
- 4
More details (optional)
Open More details to add a discount, a note and a delivery date. The delivery date can add an event to your Google Calendar. If you use India GST, the order also asks whether the sale is within your state or to another state.
- 5
Tap Create order and invoice
DocMaster saves the order in your sheet, takes the stock down, and makes the invoice as a PDF in your Drive. The next screen shows the order and lets you email the invoice to the customer from your Gmail, or mark whether they have paid. If the invoice could not be made, the order is still saved and the screen says why and how to fix it.
Tip: Tapping the button twice never makes two orders. A repeated tap returns the order that was already made.
- 6
Or write the order instead
Tap Write the order instead, then type or paste the customer's message in your own words. DocMaster reads it and shows a draft for you to check. Nothing is saved until you tap Create. Only the words you type are sent to be read. Your products, customers and sheet are never sent. There is a daily number of readings, shown on the screen.
Note: You can always tap Make it myself instead and fill the order in by hand.
07Orders: find, change, cancel and refund
Every order you make is a row in the Orders tab of your sheet. The Orders screen shows them newest first.
- 1
Find an order
The chips at the top show All, To do, Not paid and Done, with a count on each. Made here and Imported show where orders came from. Search by name or order number. Each row shows the customer, the order code and total, the status, and how many days overdue it is if money is still owed.

- 2
Quick actions on a row
Each row has small icons: open the invoice, change the status, change the order, and cancel it. At the top, the icons make invoices for many orders, add many orders from a file, and show all orders in a wide table.
- 3
Change an order
Tap an order to change its status, products, delivery date, discount and payments. If a change moves the order to a stage whose email is switched on, the screen tells you before you save (for example: Marking it Paid emails Anna, because that email is switched on). Otherwise it says no email is sent. A quotation has a button Turn into order for when the customer agrees. Tap Save changes to keep your edits.

- 4
Cancel or refund
Cancelling an order puts its stock back and removes its calendar event. Refunded is a status you can choose when you give the money back, and it also puts the stock back. Their history stays in History.
Note: An order you cancel or refund no longer counts as work to do, but it stays in your sheet so your records are complete.
08Order statuses
What each status means and what it does.
| Status | Meaning | What it does |
|---|---|---|
| New | Made, not paid yet. Also a quotation. | Counts as to do. The New email can be sent if it is switched on. |
| Confirmed | The customer agreed. | The Confirmed email can be sent if it is switched on. |
| Paid | The money arrived. | Books a payment for what is owed. The Paid email can be sent if it is switched on. |
| Done | Delivered or finished. | Counts as done. The Done email can be sent if it is switched on. |
| Cancelled | The order will not happen. | Puts the stock back and removes the calendar event. |
| Refunded | The money was given back. | Puts the stock back. The Refunded email can be sent if it is switched on. |
09The Orders tab in your sheet
These are the columns DocMaster keeps in the Orders tab. You can sort and filter them like any sheet. Change an order in DocMaster rather than typing over these columns, so the stock, payments and history stay right.
| Column | What it holds |
|---|---|
| ID | A unique id DocMaster uses to find the order |
| Order Number | The number on the invoice, such as ORD-20261015-A7K2, or your own numbers if you switched them on |
| Status | New, Confirmed, Paid, Done, Cancelled or Refunded |
| Customer ID | The customer's email |
| Subtotal, Tax Total, Discount Amount, Grand Total | The money on the order |
| Amount Paid, Due Date | What has been paid so far and the day the balance is due |
| Invoice URL, Invoice Folder URL | Links to the invoice PDF and its folder in your Drive |
| Fulfillment Date | The delivery date, if you gave one |
| Shipping Address | The address on this order, copied when the order was made so old invoices never change |
| Supply, Place of Supply, CGST/SGST/IGST Total | India GST details, when you use India GST |
| Source | Blank for orders made here or typed by hand, Imported for orders added by an import |
- Rows you type straight into the sheet still count toward your monthly orders.
- The Order Items tab holds one row per product line of every order.
10Invoices: make, open and email
An invoice is a PDF saved in your Drive folder. Each order has at most one invoice, so asking again never makes a second file.
- 1
Make the invoice with the order
Create order and invoice makes both at once. Invoice numbers, tax, discounts and totals are filled in for you, using the invoice look and business details you chose.
- 2
Open or preview an invoice
The open-invoice icon on an order shows the invoice. A preview is a temporary copy that is removed after a few minutes, with Download PDF and Email it buttons. If the order has no invoice yet, you can make it from there.
- 3
Email the invoice
After making an order, tap Email invoice. The email is sent from your own Gmail with the PDF attached, in the wording of the email for that stage. Gmail has its own daily limit, and DocMaster shows how many emails are left today.
- 4
Where the files go
Every PDF goes into one Drive folder, named DocMaster unless you choose another in More settings, Where invoices are saved. Files are named by the pattern you choose in How invoice files are named. Invoices you already made stay where they are if you change the folder.
11Invoices for many orders
Make the invoices for a whole day or month of orders in one go. DocMaster works 20 at a time and shows a progress bar.
- 1
Choose the orders
Open Invoices for many from the menu. The chips show Not invoiced yet, This month and All. Everything without an invoice is ticked. Untick any you want to skip. The button always says exactly how many it will make, such as Make 12 invoices.

- 2
Make them
Tap the button. DocMaster makes them in steps of up to 20 and shows Making invoices 21 to 40 of 40. Keep the panel open until it finishes. Invoices made this way are saved as PDF files in your folder. They are not emailed; you can email any of them from its order.
- 3
Stop, carry on, or come back
Stop after this step finishes the step in hand and then pauses. Carry on does the rest. If you close the panel, open Invoices for many again and it lists only what is still left. An order that already has an invoice is never made twice.
- 4
If something goes wrong
One order that fails does not stop the others. At the end DocMaster says how many were made and lists the ones that were not, each with a plain reason and a Try these again button. If the invoice look or the folder is missing, it stops once and tells you where to fix it.
- 5
How many at once
The size of a run depends on your plan: Free makes up to 5 per run, Plus up to 50 and Pro up to 100. If you choose more, a page shows the real numbers and offers to make the allowed part now.
12Products and stock
Products are the things you sell. DocMaster keeps your stock right: it goes down when you make an order and comes back when you cancel or refund it.
- 1
See your products
The Products screen lists every product with its price, tax and stock. The chips show All, Running low, Made here and Imported. A product you count with 5 or fewer left shows as running low, and also appears on Home.

- 2
Add or change a product
Tap Add a product. A name and a price are enough. Tax is optional and uses your usual tax from Currency and tax when left empty. Type an In stock number to count stock, and the switch Take from stock on each order turns on. Leave stock empty for something you do not count, such as a service. Tap a product to change or delete it.
- 3
Update stock
From a product or from Home, tap the plus to update stock. Type how many units arrived and the new total is shown before you save. See stock history opens the changes for that product.
- 4
How stock moves by itself
Making an order takes each product's amount off its stock. Cancelling or refunding the order puts it back. If an order needs more than you have, DocMaster says so instead of letting stock go below zero.
Tip: Prices on an order are copied when the order is made, so changing a price later never changes an old invoice.
13The Products tab in your sheet
The columns DocMaster keeps for each product.
| Column | What it holds |
|---|---|
| ID | A unique id DocMaster uses to find the product |
| Name | The product name |
| Unit Price | The price before tax |
| Tax % | The tax rate for this product |
| Price After Tax | Worked out for you |
| Stock Quantity | How many you have; empty means not counted |
| Auto Decrease | TRUE when stock goes down on each order |
| HSN/SAC | The code printed on India GST invoices |
| Created At, Updated At | When the product was added and last changed |
| Source | Blank for products made here or typed by hand, Imported for products added by an import |
- Products you add by typing in the sheet are picked up the next time DocMaster refreshes.
14Customers
Customers are saved in your sheet. The email is how DocMaster recognises someone, so their orders and invoices stay together.
- 1
See your customers
The Customers screen lists each customer with how many orders they made and how much they spent. The chips Made here and Imported show where they came from.

- 2
Add or change a customer
Tap Add a customer and type the email and the name. Phone and address are optional. The email cannot be changed later because it keeps their orders together. Tap a customer to change their name, phone or address.
- 3
Use a customer on an order
On a new order, type a name or an email. A returning customer's details fill in. The address on an order is copied when the order is made, so changing a customer's address later never changes an old invoice.
15The Customers tab in your sheet
The columns DocMaster keeps for each customer.
| Column | What it holds |
|---|---|
| The customer's email, which is their unique key | |
| Name | Their name |
| Phone, Address | Optional contact details |
| Total Orders, Last Order Date | Kept up to date as you make orders |
| Created At, Updated At | When the customer was added and last changed |
| Source | Blank for customers made here, Imported for customers added by an import |
16Payments and reminders
DocMaster keeps a list of payments for each order, so part payments and balances are always right.
- 1
See what is owed
Home shows how much is not paid yet. Reports lists money still owed by how late it is: not due yet, 1 to 30 days, 31 to 60 days and over 60 days. An order shows Paid so far and Balance due.
- 2
Add a payment
Open an order and tap Add a payment. Type the amount, the day and an optional note such as Deposit. You can add several part payments. Marking an order Paid books one payment for what was still owed.
- 3
Due day
New orders that are not paid get a due day. Set how many days in Payments and reminders under More settings, or type 0 for none. You can change the due day on any order.
- 4
Remind a customer
Tap Remind on an order to send the Payment reminder email for that order from your Gmail. You can do this by hand on any plan.
- 5
Overdue reminders every day
Switch on Remind customers about overdue invoices in Payments and reminders and DocMaster sends the reminder for you each day. This is part of the Plus plan. It uses your Gmail, up to 20 reminders a day, and never the last 30 emails of the day. The wording is the Payment reminder email in Emails.

17Delivery dates in Google Calendar
Give an order a delivery date and DocMaster can add it to your Google Calendar with reminders, so nothing is late.
- 1
Give the order a delivery date
On a new order, open More details and choose a delivery date, and a time if you like. In More settings you can choose to add delivery dates to your calendar by default.

- 2
Switch the calendar on or off for this order
On the Delivery date screen, Add to my Google Calendar can be on or off for the order. If it is off, the date still shows in your follow-ups list.
- 3
Change or cancel
Change the date and the event moves. Cancel the order and the event is removed.
18What the calendar event looks like
What DocMaster adds to your Google Calendar.
| Part | What you get |
|---|---|
| Event | One event for the order on its delivery date |
| Reminders | 1 day before, 2 hours before and at delivery time, as a pop-up and an email |
| When the date changes | The event moves to the new date |
| When the order is cancelled | The event is removed |
19DocMaster for Android
The same Google Sheet™ on your phone. Make a quotation or invoice between two clients, see who owes you and keep stock right. Your data stays in your own Google account.
- 1
Sign in with Google
Sign in with the Google account that owns your sheet. DocMaster for Android can only open the sheet you choose or create; it cannot see your other files.
- 2
Choose your sheet
Pick your DocMaster sheet from Google Drive™, or start a new one. The first time, tell DocMaster about your business in a few sentences, and the app uses the words of your trade (for example Packages, Events and Clients).
- 3
Make a quotation or invoice
Tap New order, pick products and the customer. An order marked New is a quotation; a paid or confirmed order is an invoice. Choose from 29 ready-made looks, then share the PDF.
- 4
Share your sheet with your team
Under Members, the owner can add an Editor or a Viewer. Viewers can look but not change anything. Google decides who can do what.
20Android app at a glance
What to expect from the phone app.
| Topic | What you get |
|---|---|
| Your data | Stays in your own Google Sheet™ and Google Drive™. The app keeps a copy on the phone so screens open at once and work with a weak connection. |
| Saving changes | Every change to an order, customer, product or payment asks you to confirm first, then saves to your sheet in the background. |
| Quotation or invoice | New orders make a quotation. Paid or confirmed orders make an invoice. The document says which it is. |
| Imports | Bring in products, customers and orders from a file in Google Drive™ or a pasted list, with a preview before anything is added. |
| Logging out | Logging out removes everything stored on that phone. Your sheet in Google is not touched. |
| Problems | Menu, Diagnostics shows what the app has recorded. You can copy it and send it to support@codeinate.com. |
21Invoice look: ready looks or your own Google Doc
The invoice look is the Google Doc every invoice is made from. Pick a ready look in a minute, or use your own Doc.
- 1
Pick a ready look
Open Invoice look from the menu and browse Classic, Modern, Simple and Compact. Each uses your business name, address and tax ID from My business, and a drawn sample shows how it will look. Tap Use and the name of the look, for example Use Classic, and DocMaster makes the Doc in your Drive and uses it for new invoices.

- 2
Change how it looks
After you pick a look, open the Doc from the link on the screen and change the fonts, colours or wording in Google Docs. Your changes are used for every new invoice. Invoices you already made do not change.
- 3
Use your own Google Doc
Choose Keep my current invoice and pick the Google Doc from your Drive that you already like. Type the markers where you want each detail to go, for example the customer's name or the order total. The Markers section below lists every marker. Make an invoice from a real order to see how it looks. A marker DocMaster cannot fill prints nothing, or what you set with default.
- 4
Switching back
Picking a ready look never deletes your own Doc. It stays in your Drive and DocMaster just stops using it for new invoices. If the Doc is ever moved to the bin, the screen tells you and offers to pick a look again.
- 5
New looks
When DocMaster improves a ready look, the Invoice look screen shows New design ready. Tap it to use the new design for new invoices. Older invoices stay as they were.
22Markers for your own invoice Doc
If you use your own Google Doc as the invoice look, type markers where each detail should go. DocMaster replaces every marker with the data of the order when it makes the invoice.
| Detail | Marker | What it prints |
|---|---|---|
| Order | {{order.orderNumber}} | The invoice number |
| Order | {{order.createdAt | date:DD-MM-YYYY}} | The order date |
| Order | {{order.dueDate | date:DD-MM-YYYY}} | The day the balance is due |
| Customer | {{customer.name}} | The customer's name |
| Customer | {{customer.email}}, {{customer.phone}}, {{customer.address}} | Their contact details |
| Money | {{order.subtotal}}, {{order.taxTotal}}, {{order.discountAmount}}, {{order.grandTotal}} | Subtotal, tax, discount and total |
| Money | {{order.amountPaid}}, {{order.balanceDue}} | What has been paid and what is still owed |
| Your business | {{config.business_name}}, {{config.business_address}}, {{config.business_email}}, {{config.business_phone}} | The details from My business |
| Your logo | {{config.logo}} | Your logo picture, if you added one |
| Items | {{lineItem.name}}, {{lineItem.quantity}}, {{lineItem.unitPrice}}, {{lineItem.subtotalBeforeTax}} | Put these in ONE row of a table; the row is repeated for every product |
INVOICE {{order.orderNumber}}
Date: {{order.createdAt | date:DD-MM-YYYY}}
Bill to: {{customer.name}}
{{customer.email | eol}}
Item | Qty | Price | Total
{{lineItem.name}} | {{lineItem.quantity}} | {{lineItem.unitPrice}} | {{lineItem.subtotalBeforeTax}}
Subtotal: {{order.subtotal}}
Tax: {{order.taxTotal}}
Total: {{order.grandTotal}}

- Type markers exactly as shown, with two curly brackets on each side. Extra spaces inside the brackets are fine.
- If a marker has no value, it prints nothing, or what you give with default. For example {{customer.phone | default:none}}.
- The ready invoice looks already use these markers. Open one from Invoice look to see them in a working Doc.
- India GST and VAT add markers such as {{order.cgstTotal}}, {{order.sgstTotal}}, {{order.igstTotal}}, {{order.supplyType}} and {{config.tax_label}}.
23Marker namespaces
Namespaces prevent ambiguity. Use the right namespace for each entity.
| Namespace | Entity | Example fields |
|---|---|---|
| customer | Customer | name, email, phone, address, totalOrders, lastOrderDate |
| order | Order | orderNumber, status, subtotal, taxTotal, discountAmount, grandTotal, amountPaid, balanceDue, dueDate, createdAt, notes, paymentInfo |
| lineItem | Line item | name, quantity, unitPrice, taxPercent, subtotalBeforeTax, taxAmount, subtotalAfterTax, hsn |
| config | Your business | business_name, business_address, business_email, business_phone, logo |
- lineItem markers only work inside the table row that is repeated for each product.
- The names are the column names of your sheet without spaces, for example Grand Total becomes grandTotal.
24Marker modifiers
Modifiers transform values using a pipe syntax inside the marker.
| Modifier | Example | Result |
|---|---|---|
| uppercase | {{customer.name | uppercase}} | JOHN DOE |
| lowercase | {{customer.email | lowercase}} | john@example.com |
| capitalize | {{customer.name | capitalize}} | John doe |
| trim | {{customer.phone | trim}} | 555-1234 |
| truncate | {{customer.name | truncate:10}} | John Doe |
| multiply | {{order.grandTotal | multiply:0.8}} | 80.00 |
| divide | {{order.grandTotal | divide:2}} | 50.00 |
| add | {{order.subtotal | add:10}} | 110.00 |
| subtract | {{order.grandTotal | subtract:5}} | 95.00 |
| round | {{order.grandTotal | round:2}} | 100.55 |
| abs | {{order.discountAmount | abs}} | 10.00 |
| currency | {{order.grandTotal | currency:USD}} | $100.00 |
| number | {{order.grandTotal | number:2}} | 100.50 |
| percent | {{lineItem.taxPercent | percent}} | 15% |
| date | {{order.createdAt | date:DD/MM/YY}} | 20/01/26 |
| default | {{customer.phone | default:N/A}} | N/A |
| label | {{order.notes | label:Notes}} | Notes: thank you (prints nothing at all when empty) |
| eol | {{customer.email | eol}} | The email followed by a line break (nothing when empty, so no blank line) |
| hide0 | {{order.discountAmount | hide0}} | The discount, or nothing at all when it is zero |
- Modifiers can be chained: {{order.grandTotal | multiply:0.8 | currency:USD}}.
- Invalid modifiers are ignored safely.
25Advanced marker rules
These rules keep templates safe, reliable, and predictable.
- A marker can use the plain field name, such as order.grandTotal, or the heading of your sheet column.
- Markers tolerate extra whitespace or line breaks inside braces.
- Put the lineItem markers in a single table row. DocMaster repeats that row once for every product, then fills the rest of the Doc.
- Missing fields return empty strings unless you add a default modifier.
- Money is shown with your order currency automatically; the currency modifier is for when you want a different one.
- Before you rely on a Doc, make an invoice from a real order and read it. DocMaster points out any marker it could not fill.
26Emails to your customers
DocMaster sends emails from your own Gmail when an order changes. Each stage has its own ready email, and you choose which ones are on.
- 1
Switch emails on or off
Open Emails from the menu. Each stage has a switch: New, Confirmed, Paid, Done, Cancelled and Refunded. Turn off the ones you do not need. The pencil changes the wording. Payment reminder has a clock icon instead of a switch: it opens the reminder settings, because reminders are sent when you tap Remind or by the daily reminder (Plus). The page also shows how many emails are left today, because Gmail has its own daily limit.

- 2
Change the wording
Tap an email to open its editor. Type your own words. Tap Add a field to put in the customer's name, the order number, the total or your business details with a tap, so there is nothing to type and no typos. A preview shows the email with real values.

- 3
Send yourself a test
Tap Send me a test email to see exactly what a customer would get. A message tells you where it was sent.
- 4
Add a link to the invoice
Switch on Add a link to the invoice so the email carries a link customers can open. You can also find it in More settings.
- 5
Write an email for me
Tap Write an email for me, say what you want to tell the customer, and DocMaster drafts it for you to check. Only the words you type are sent to be read. Nothing from your sheet is sent. There is a daily number of drafts.
- 6
Your signature
Add an email signature in My business. It is added at the end of every email DocMaster sends.
27The emails and when they are sent
Each email goes out when the order reaches that stage, if its switch is on.
| Sent when | Default subject | |
|---|---|---|
| New | An order is made as New. It reads as a quotation, valid for 30 days | Quotation - order number |
| Confirmed | An order becomes Confirmed | Order Confirmation - order number |
| Paid | An order becomes Paid | Payment Received - order number |
| Done | An order becomes Done | Order Completed - order number |
| Cancelled | An order is cancelled | Order Cancelled - order number |
| Refunded | An order is refunded | Refund Processed - order number |
| Payment reminder | You tap Remind, or the daily reminder runs (Plus) | Payment reminder - order number |
- An email goes out only when the order reaches that stage and its switch is on, and never twice for the same order and stage. The Change order screen tells you before you save.
- Emails are sent from your own Gmail, so replies come straight back to you.
28Emails you sent
Every email DocMaster sends is recorded, so you can check what went out.
- 1
See them in History
Open History and choose Emails. Each line says who the email went to, and whether it was sent or could not be sent.
- 2
In your sheet
The same record is kept in a hidden tab named Email History in your sheet, with the subject, the time and a link to the email.
29Tax: Simple, India GST or VAT
Choose how tax is shown on your invoices in More settings, Invoice numbers and tax ID. Prices and tax per product work the same in every style.
- 1
Simple
One tax line on the invoice, using each product's tax rate. This is the default and is what most small shops need.
- 2
India GST
Tax is split into CGST and SGST for a sale within your state, or IGST for a sale to another state. On a new order you choose Within my state or Another state, and you can type the customer's state. Products can carry an HSN or SAC code that is printed on the invoice. Your GSTIN goes in Tax ID.

- 3
VAT
The invoice shows VAT with your VAT number in Tax ID, using the rate of each product.
- 4
Your own invoice numbers
Switch on Use my own invoice numbers to get numbers like INV-1042. DocMaster keeps your current numbers going and skips any number already used. Off, orders are numbered like ORD-20261015-A7K2.
30Settings: what you can set and where
My business and Invoice look are in the menu. Everything else is under More settings. Most settings save by themselves as you type.
| Screen | Where | What it does |
|---|---|---|
| My business | Menu | Business name, address, email, phone, currency, usual tax, logo and email signature. This goes at the top of every invoice. |
| Invoice look | Menu | Pick Classic, Modern, Simple or Compact, or use your own Google Doc. |
| Where invoices are saved | More settings | The Drive folder for invoice PDFs. Choose another folder any time; old invoices stay where they are. |
| How invoice files are named | More settings | Build the file name from the order number, the customer and the date, with an example shown. |
| Currency and tax | More settings | The currency for new orders (old orders keep theirs) and the usual tax added to new products. |
| Payments and reminders | More settings | The due day for new orders and the daily overdue reminder. |
| Invoice numbers and tax ID | More settings | Use your own invoice numbers, choose how tax is shown (Simple, India GST or VAT) and add your tax ID. |
| Add a link to the invoice in emails | More settings | Customers can open the invoice from the email. |
| Summary emails | More settings | Who gets the daily or weekly summary, and when. |
| Your own fields | More settings | Extra details you can put on an invoice, such as a company number. |
| Delivery dates in Google Calendar | More settings | Add delivery dates to your calendar by default. |
| Recent imports | More settings | Files you added, and undo one. |
| Save a copy of my settings | More settings | Download your settings as a small file, load one back, or put all settings back to the starting ones. Your orders, products and customers are not in the file. |
- Everyone who uses the sheet saves invoices in their own Drive folder unless they choose a shared one.
- The settings screens use plain words and show a Saved note when a change is kept.
31Import products, customers and orders
Bring in a list you already have. DocMaster reads it, asks what is in it, shows what it will add, and adds nothing until you have checked it.
- 1
Choose where the list is
Open Import data from the menu. Choose a file from Google Drive, or paste a list. DocMaster reads CSV, JSON, text, Excel and Google Sheets files, up to 5 MB and 5000 rows. If your file is another kind, save it as a CSV or Google Sheet first.

- 2
Say what it is, then match the columns
Choose whether the list holds products, customers or orders. DocMaster matches your columns by their names and shows how it matched them. Change any column that is wrong. Messy files are fine: it understands prices written as 1,234.50 or 3,50, names written as Last, First, headers on a different row, and files with several tabs.
- 3
Help me understand this file
If the file is confusing, tap Help me understand this file. DocMaster describes the columns and asks a few plain questions. Only the shape of the file is sent to be read, with names, emails and phone numbers hidden. Your real rows stay in your account.
- 4
Check the preview
The preview shows what will be added, what is already there and what cannot be used, with the reason for each, such as an order number that already exists or a customer who is already in your sheet. For customers and products you choose whether to skip the ones already there or update them.
- 5
Add them
Tap the button and DocMaster adds them in steps with a progress bar. Orders can also add the customers and products they mention, if you choose. Things you add are marked Imported, and the lists have an Imported chip to find them.
- 6
Undo an import
Open More settings, Recent imports, and tap Undo on a run. It takes out what that file added. Anything you changed or used since stays. An import that is too old to undo says so.
Note: Imported orders count toward your monthly orders, and an undone import gives them back. If an import would go over your plan's orders, only the part that fits is added and the rest is listed as skipped with the reason.

32Files DocMaster can read
What you can bring in and from where.
| Kind | Notes |
|---|---|
| CSV and text | The first row should hold the column names. Commas, semicolons and tabs all work. |
| Excel .xlsx | A workbook with one or several tabs. DocMaster lists the tabs and you choose. |
| Google Sheet | Choose it from Drive; pick a tab. |
| JSON | A list, or an object that holds a list, including shop exports with variants. |
| A pasted list | Copy rows from a sheet or Excel, or paste the text of a JSON file. |
- Up to 5 MB and 5000 rows at a time.
33Reports and summary emails
Reports show what sold and what is still owed, for today, this week or this month.
- 1
Read the report
Open Reports from the menu and choose Today, This week or This month. You see sales and the number of orders, what is not paid yet, money still owed by how late it is, and your best sellers.

- 2
Get a summary by email
At the bottom of Reports, choose a daily summary (at a time you pick) and a weekly one (on a day you pick). Send me this week's summary now sends it straight away. Daily and weekly summaries sent for you are part of the Plus plan; sending one now by hand is on every plan.
Note: Summaries go to the email address shown on the screen. Change who gets them in More settings, Summary emails.
34What the numbers mean
How each number on the report is worked out.
| Number | Meaning |
|---|---|
| Sales | The total of orders made in the period, not counting cancelled or refunded ones |
| Not paid yet | What is still owed on orders in the period |
| Money still owed | Everything owed, grouped as not due yet, 1 to 30 days late, 31 to 60 days late and over 60 days late |
| Best sellers | The products that sold the most in the period, with how many were sold |
35History: what happened and when
History is one list of what changed, newest first, so you can check any order, stock change, customer or email.
- 1
Open History
Choose History from the menu. Use the chips to see Everything, Orders, Stock, Customers or Emails. Lines are grouped by day. Scroll to the end to see older changes.

- 2
Read a line
Each line says what happened, such as Order #A7K2 made or Notebook A5 stock 5 to 3, who did it, and the time. Stock changes show the old and new number.
- 3
Stock history for one product
On Update stock, tap See stock history to see the changes for that product.
36What History records
The kinds of lines in History.
| Kind | Lines you will see |
|---|---|
| Orders | Made, marked Paid, Done, Cancelled or Refunded, changed, deleted |
| Stock | Product added, stock changed from one number to another, price changed, deleted |
| Customers | New customer, changed, deleted |
| Emails | Email sent to an address, or could not be sent |
- History is kept in hidden tabs of your sheet, so it stays out of your way but you can still unhide and read it.
37Plans and limits
DocMaster is free to start. A plan is a single payment for 30 days or 12 months. It does not renew by itself, so there is nothing to cancel.
- 1
What counts
Each new order and each new invoice counts toward the month, in your report time zone. Changing an order, marking it paid, previews, the sample invoice, products, customers, emails and reports never count. Opening an invoice you already made never counts, and asking again for an order that already has one does not make a second.

- 2
See where you are
The plan card at the top of the menu shows how many orders and invoices are left this month, and the Your plan screen shows the same with the date they come back. You get a calm notice at 80%.
- 3
When you reach the limit
Everything else keeps working: look at and change orders, take payments, send emails, read reports. New orders, or new invoices, wait until the 1st of next month, or you can move to a bigger plan. The message says exactly how many your plan allows and when they come back.
- 4
Free, Plus and Pro
Free makes up to 30 orders and 30 invoices a month and adds a small Made with DocMaster line to invoices and emails. Plus makes up to 200 of each, leaves the line off, makes runs of up to 50 invoices, and sends the daily overdue reminders and the daily and weekly summary emails for you. Pro has no monthly limit, runs of up to 100 invoices and priority support. See the plans page on codeinate.com for the current prices.
- 5
Buy, add time or check
Open Your plan and choose See the plans or Add more time. After you pay, tap I've paid: refresh my plan. Paying again before your plan ends adds the new time after the time you have left. When a plan ends you go back to Free, and your data and invoices are kept.
38Plans at a glance
What each plan gives. Prices are on the plans page.
| Free | Plus | Pro | |
|---|---|---|---|
| New orders and invoices each month | Up to 30 | Up to 200 | Unlimited, fair use applies |
| Invoices made in one run | 5 | 50 | 100 |
| Made with DocMaster line on invoices and emails | Yes | No | No |
| Overdue reminders sent for you every day | By hand only | Yes | Yes |
| Daily and weekly summary emails | By hand only | Yes | Yes |
| Priority support | No | No | Yes |
- Limits start on 1 December 2026. Until then nothing is blocked and the counters only show your numbers.
- Fair use for Pro means one business. If you need heavy volume, write to Codeinate.
39Example: one order, one invoice
Follow a sample order to see what DocMaster keeps in your sheet and what your customer gets.
In your sheet
| Order Number | Customer ID | Status | Subtotal | Tax Total | Grand Total |
|---|---|---|---|---|---|
| ORD-20261015-A7K2 | anna@example.com | Paid | 21.00 | 2.10 | 23.10 |
What your customer gets
| Invoice URL | Amount Paid | Stock of Notebook A5 | |
|---|---|---|---|
| https://drive.google.com/file/d/…/view | 23.10 | 5 down to 3 | Paid email sent to anna@example.com |

- The order is a row in your Orders tab. The invoice is a PDF in your DocMaster folder, and its link is written back to the same row.
- Making the order took 2 Notebook A5 out of stock, and a payment for the whole total was booked because the order started as Paid.
- Everything above appears in History, so you can check it later.
40Common problems and what to do
DocMaster tells you what went wrong in plain words and what to do. These are the ones people meet most.
- Pick how your invoices should look first: you have not chosen an invoice look yet. Open Invoice look and tap Use and the name of a look, for example Use Classic.
- Codeinate couldn'ts find your invoice Doc. It may have been moved to the bin: restore it in Drive, or pick a ready look again in Invoice look.
- Codeinate couldn'ts make the DocMaster folder in your Drive: check you have space in Drive and try again, or choose another folder in More settings.
- You've made all of your invoices (or orders) of your plan this month: new ones wait until the date shown, or you can see the plans. Looking at and changing orders, payments, emails and reports keep working.
- The invoice couldn't be made. Nothing was changed: tap Try again. If it keeps happening, make sure the invoice Doc still opens and the folder still exists.
- Insufficient stock for a product (it shows how many are available and how many were asked for): add stock from Update stock, or lower the amount on the order.
- A list I imported added fewer rows than I expected: the preview lists what was skipped and why, such as an order number that already exists. Anything you did not want can be undone from Recent imports.
- I changed the sheet by hand and DocMaster does not show it yet: tap the round arrow at the top of the screen to refresh.
- Google asks me to sign in again: close the side panel and open DocMaster again. Your data is not affected.
- An email could not be sent: check the Emails page for how many are left today, because Gmail has its own daily limit. The email is listed in History as could not be sent.
41Power tips
Small habits that keep your orders and invoices tidy.
- Make a quotation by starting an order as New, send the New email, and use Turn into order when the customer agrees.
- Use Selected in sheet on a new order to add the products you highlighted in the Products tab, then change the amounts.
- Send yourself a test email after you change any wording.
- Add your logo and email signature once in My business; every invoice and email uses them.
- At the end of the month, open Invoices for many, leave the ticks as they are and tap the button. Come back later if you close the panel.
- Change an order in DocMaster, not by typing over its row in the sheet, so stock, payments and History stay right.
- Use Save a copy of my settings before big changes; you can load it back any time.
- Check Reports each week for money still owed, and tap Remind on the late ones.
Frequently asked questions
How do I create an invoice in Google Sheets?
Open your Google Sheet, open DocMaster from the side panel, tap New order, pick the products and the customer, and tap Create order and invoice. The invoice is made as a PDF in your Google Drive with the number, tax and totals filled in.
How do I make many invoices at once from Google Sheets?
Open Invoices for many from the menu. Everything without an invoice is ticked. Tap the button that says how many it will make. DocMaster works 20 at a time, shows a progress bar, and lets you stop and carry on. Free makes up to 5 per run, Plus up to 50 and Pro up to 100.
Where are my invoices saved?
Every invoice is a PDF in a Google Drive folder named DocMaster, or in the folder you choose in More settings, Where invoices are saved. You can open it from its order in one tap.
Can I use my own invoice design?
Yes. Pick one of the ready looks (Classic, Modern, Simple, Compact), or choose your own Google Doc in Invoice look and type markers such as {{customer.name}} and {{order.grandTotal}} where each detail should go. For the items, put the lineItem markers in one table row and DocMaster repeats the row for every product.
How does stock tracking work?
Give a product a stock number and DocMaster takes the amount off each time you make an order. Cancel or refund the order and the stock goes back. A product with 5 or fewer left shows as running low on Home. Update stock and its history are on the Products screen.
Can DocMaster email my customers?
Yes. Each stage of an order has its own ready email: New, Confirmed, Paid, Done, Cancelled and Refunded, plus a payment reminder. You choose which are on and can change the wording. Emails are sent from your own Gmail, and you can send yourself a test first.
How do I make a quotation?
Start an order as New. New means not paid yet and is also how you make a quotation. When the customer agrees, open the order and tap Turn into order.
Can I import my products, customers or orders?
Yes. Open Import data and choose a CSV, Excel, JSON or Google Sheets file from Drive, or paste a list. DocMaster matches your columns, shows what it will add and skips, and adds nothing until you have checked it. You can undo an import from More settings, Recent imports.
Does DocMaster handle GST, VAT and part payments?
Yes. Choose Simple, India GST or VAT in More settings, Invoice numbers and tax ID. GST splits the tax into CGST and SGST, or IGST. Every order keeps a list of payments, so part payments, balances, due days and overdue reminders are always right.
Is my business data safe?
Your orders, products and customers live in your own Google Sheet, and invoices are PDFs in your own Drive. DocMaster opens only the files you pick and the files it makes itself. Emails are sent from your own Gmail only when you choose.
What does it cost and what are the limits?
DocMaster is free to start: up to 30 new orders and 30 new invoices a month, with a small Made with DocMaster line on invoices and emails. Plus makes up to 200 of each and removes the line. Pro has no monthly limit. A plan is a single payment that does not renew by itself. Limits start on 1 December 2026.
Do I need other software?
No. DocMaster works inside Google Sheets, Docs, Drive, Gmail and Calendar. There is no separate account to manage and no data to move.
Can I get reports and summaries?
Yes. Reports shows sales, what is not paid yet, money owed by how late it is, and best sellers for today, this week or this month. Plus can send a daily or weekly summary email for you.
How do delivery reminders work?
Give an order a delivery date and switch on Add to my Google Calendar. DocMaster adds an event with reminders a day before, two hours before and at delivery time. Change the date and the event moves; cancel the order and it is removed.



