Codeinate
Find your tool

Menu

DocMaster guide: orders, invoices and stock in Google Sheets

DocMaster keeps your orders, products and customers in your own Google Sheet, makes the invoice as a PDF in your own Google Drive, and sends the emails from your own Gmail. This guide follows the screens in the order you will use them.

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. 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. 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. 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. 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. 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. 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. 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.

    Today: three numbers
  2. 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. 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. 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.

    The menu

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. 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.

    Add the products
  2. 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. 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. 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. 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. 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. 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.

    Find an order
  2. 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. 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.

    Change an order
  4. 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.

Order statuses
StatusMeaningWhat it does
NewMade, not paid yet. Also a quotation.Counts as to do. The New email can be sent if it is switched on.
ConfirmedThe customer agreed.The Confirmed email can be sent if it is switched on.
PaidThe money arrived.Books a payment for what is owed. The Paid email can be sent if it is switched on.
DoneDelivered or finished.Counts as done. The Done email can be sent if it is switched on.
CancelledThe order will not happen.Puts the stock back and removes the calendar event.
RefundedThe 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.

The Orders tab in your sheet
ColumnWhat it holds
IDA unique id DocMaster uses to find the order
Order NumberThe number on the invoice, such as ORD-20261015-A7K2, or your own numbers if you switched them on
StatusNew, Confirmed, Paid, Done, Cancelled or Refunded
Customer IDThe customer's email
Subtotal, Tax Total, Discount Amount, Grand TotalThe money on the order
Amount Paid, Due DateWhat has been paid so far and the day the balance is due
Invoice URL, Invoice Folder URLLinks to the invoice PDF and its folder in your Drive
Fulfillment DateThe delivery date, if you gave one
Shipping AddressThe address on this order, copied when the order was made so old invoices never change
Supply, Place of Supply, CGST/SGST/IGST TotalIndia GST details, when you use India GST
SourceBlank 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. 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. 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. 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. 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. 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.

    Choose the orders
  2. 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. 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. 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. 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. 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.

    See your products
  2. 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. 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. 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.

The Products tab in your sheet
ColumnWhat it holds
IDA unique id DocMaster uses to find the product
NameThe product name
Unit PriceThe price before tax
Tax %The tax rate for this product
Price After TaxWorked out for you
Stock QuantityHow many you have; empty means not counted
Auto DecreaseTRUE when stock goes down on each order
HSN/SACThe code printed on India GST invoices
Created At, Updated AtWhen the product was added and last changed
SourceBlank 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. 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.

    See your customers
  2. 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. 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.

The Customers tab in your sheet
ColumnWhat it holds
EmailThe customer's email, which is their unique key
NameTheir name
Phone, AddressOptional contact details
Total Orders, Last Order DateKept up to date as you make orders
Created At, Updated AtWhen the customer was added and last changed
SourceBlank 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. 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. 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. 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. 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. 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.

    Overdue reminders every day

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. 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.

    Give the order a delivery date
  2. 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. 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.

What the calendar event looks like
PartWhat you get
EventOne event for the order on its delivery date
Reminders1 day before, 2 hours before and at delivery time, as a pop-up and an email
When the date changesThe event moves to the new date
When the order is cancelledThe 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. 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. 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. 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. 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.

Android app at a glance
TopicWhat you get
Your dataStays 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 changesEvery change to an order, customer, product or payment asks you to confirm first, then saves to your sheet in the background.
Quotation or invoiceNew orders make a quotation. Paid or confirmed orders make an invoice. The document says which it is.
ImportsBring in products, customers and orders from a file in Google Drive™ or a pasted list, with a preview before anything is added.
Logging outLogging out removes everything stored on that phone. Your sheet in Google is not touched.
ProblemsMenu, 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. 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.

    Pick a ready look
  2. 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. 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. 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. 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.

Markers for your own invoice Doc
DetailMarkerWhat 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}}

Markers for your own invoice Doc
  • 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.

Marker namespaces
NamespaceEntityExample fields
customerCustomername, email, phone, address, totalOrders, lastOrderDate
orderOrderorderNumber, status, subtotal, taxTotal, discountAmount, grandTotal, amountPaid, balanceDue, dueDate, createdAt, notes, paymentInfo
lineItemLine itemname, quantity, unitPrice, taxPercent, subtotalBeforeTax, taxAmount, subtotalAfterTax, hsn
configYour businessbusiness_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.

Marker modifiers
ModifierExampleResult
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. 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.

    Switch emails on or off
  2. 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.

    Change the wording
  3. 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. 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. 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. 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.

The emails and when they are sent
EmailSent whenDefault subject
NewAn order is made as New. It reads as a quotation, valid for 30 daysQuotation - order number
ConfirmedAn order becomes ConfirmedOrder Confirmation - order number
PaidAn order becomes PaidPayment Received - order number
DoneAn order becomes DoneOrder Completed - order number
CancelledAn order is cancelledOrder Cancelled - order number
RefundedAn order is refundedRefund Processed - order number
Payment reminderYou 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. 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. 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. 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. 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.

    India GST
  3. 3

    VAT

    The invoice shows VAT with your VAT number in Tax ID, using the rate of each product.

  4. 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.

Settings: what you can set and where
ScreenWhereWhat it does
My businessMenuBusiness name, address, email, phone, currency, usual tax, logo and email signature. This goes at the top of every invoice.
Invoice lookMenuPick Classic, Modern, Simple or Compact, or use your own Google Doc.
Where invoices are savedMore settingsThe Drive folder for invoice PDFs. Choose another folder any time; old invoices stay where they are.
How invoice files are namedMore settingsBuild the file name from the order number, the customer and the date, with an example shown.
Currency and taxMore settingsThe currency for new orders (old orders keep theirs) and the usual tax added to new products.
Payments and remindersMore settingsThe due day for new orders and the daily overdue reminder.
Invoice numbers and tax IDMore settingsUse 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 emailsMore settingsCustomers can open the invoice from the email.
Summary emailsMore settingsWho gets the daily or weekly summary, and when.
Your own fieldsMore settingsExtra details you can put on an invoice, such as a company number.
Delivery dates in Google CalendarMore settingsAdd delivery dates to your calendar by default.
Recent importsMore settingsFiles you added, and undo one.
Save a copy of my settingsMore settingsDownload 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. 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.

    Choose where the list is
  2. 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. 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. 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. 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. 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.

    Undo an import

32Files DocMaster can read

What you can bring in and from where.

Files DocMaster can read
KindNotes
CSV and textThe first row should hold the column names. Commas, semicolons and tabs all work.
Excel .xlsxA workbook with one or several tabs. DocMaster lists the tabs and you choose.
Google SheetChoose it from Drive; pick a tab.
JSONA list, or an object that holds a list, including shop exports with variants.
A pasted listCopy 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. 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.

    Read the report
  2. 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.

What the numbers mean
NumberMeaning
SalesThe total of orders made in the period, not counting cancelled or refunded ones
Not paid yetWhat is still owed on orders in the period
Money still owedEverything owed, grouped as not due yet, 1 to 30 days late, 31 to 60 days late and over 60 days late
Best sellersThe 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. 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.

    Open History
  2. 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. 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.

What History records
KindLines you will see
OrdersMade, marked Paid, Done, Cancelled or Refunded, changed, deleted
StockProduct added, stock changed from one number to another, price changed, deleted
CustomersNew customer, changed, deleted
EmailsEmail 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. 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.

    What counts
  2. 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. 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. 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. 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.

Plans at a glance
FreePlusPro
New orders and invoices each monthUp to 30Up to 200Unlimited, fair use applies
Invoices made in one run550100
Made with DocMaster line on invoices and emailsYesNoNo
Overdue reminders sent for you every dayBy hand onlyYesYes
Daily and weekly summary emailsBy hand onlyYesYes
Priority supportNoNoYes
  • 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 row in your sheet
Order NumberCustomer IDStatusSubtotalTax TotalGrand Total
ORD-20261015-A7K2anna@example.comPaid21.002.1023.10

What your customer gets

Invoice lines
Invoice URLAmount PaidStock of Notebook A5Email
https://drive.google.com/file/d/…/view23.105 down to 3Paid email sent to anna@example.com
Example: one order, one invoice
  • 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.