Manage customers & vendors¶
This guide shows you how to add and manage the parties you do business with: customers (who you sell to) and vendors (who you buy from). The two work almost identically, so they are covered together.
What this is¶
A customer or vendor record stores a party's GST identity, addresses, contacts and payment terms. Once a party exists, TrackBooks links every invoice, bill, payment and report to it, so you can see each party's documents and ageing position. You can create parties up front, import them from a spreadsheet, or add them on the fly while raising an invoice or bill. Customers live under Sales → Customers; vendors live under Purchases → Vendors.
Before you begin¶
- Role required: Admin or Accountant.
- Helpful to have: the party's GSTIN (for registered businesses) or PAN.
Add a customer¶
Go to Sales → Customers and click Add customer. Fill in:
- Customer GSTIN, for a registered (B2B) customer. Once you have typed all 15 characters a Verify button appears; click it and TrackBooks checks the number with the GST portal and fills in the legal name, PAN, state and registered address for you. Leave the GSTIN blank for an unregistered (B2C) customer.
- PAN, if there is no GSTIN. A GST Certificate (PDF, JPG or PNG, up to 10 MB) can be attached for your records.
- Customer Name (required): the trade name. An optional Display Name is what shows in lists and reports; a Legal Name appears after verification.
- The tabs below, Address (billing and shipping), Contact, Banking, Payment Terms (default terms such as Net 30 and a Credit Limit) and Remarks, hold the rest. Only the name is mandatory; add the rest as needed.
Click Create Customer. TrackBooks assigns the customer a code such as CUS-00001 and
opens the customer's page, which shows the profile fields and the Customer Code, the
customer's Addresses, and their Recent Invoices; View All opens the invoice
register filtered to them, and Edit reopens the form.
Whether a customer has a GSTIN matters for GST
A customer with a GSTIN is reported under B2B in GSTR-1; without one, the sale is B2C. So fill the GSTIN whenever the customer is a registered business.
Saving without verifying
You can save a GSTIN without clicking Verify. TrackBooks then keeps it as typed and tells you so: GSTIN saved as typed; it was not verified against the GST portal. Verify when you can; it catches typing mistakes before they reach your invoices.
The customers list¶
Sales → Customers lists every customer with the code under the name, their GST info, invoice count, revenue, source and created date. Search by name, GSTIN or location, and filter by GST status (All Customers, GST Registered or Non-GST) and by source (All Sources, Manual or Auto-created from a scanned document). From here you can open any customer, edit it, or Import from Excel.
Add a vendor¶
Vendors work the same way: Purchases → Vendors → Add vendor. The GSTIN Verify button, Vendor Name and Display Name behave as for customers. The tabs are Other Details, Address, Contact Persons and Remarks. Under Other Details you set the PAN, default payment terms, the vendor's bank details, and:
- MSME Registered Vendor: tick this if the vendor is MSME/Udyam registered and enter the Udyam Registration Number. It is needed for the Schedule III disclosure on overdue MSME payables.
Click Create Vendor. The vendor gets a code such as VEN-00001, shown as
Vendor Code on the vendor's page along with their Recent Invoices;
View All Invoices opens the bills list filtered to that vendor. The vendors list
mirrors the customers list, with bill and expense counts in place of invoices and revenue,
and the filters All Vendors and All Sources.
Import from Excel¶
If you are migrating from another system, click Import from Excel on the customers or vendors list. The wizard has three steps, shown across the top as Upload, Preview and Results:
- Upload: click Download Template, fill one row per party, and drop the file on the page. Only Name is required; Display Name, GSTIN, PAN, Email, Phone, Mobile, Credit Days, Registered Address and Remarks are optional. The customer template also has Credit Limit; the vendor template has Is MSME and MSME Registration Number. Keep the columns in the template's order.
- Preview: the rows appear with any validation errors marked. Click Check Duplicates; rows that already exist (by GSTIN or PAN) are unticked for you. Then click the import button, which reads Import 12 Records when 12 rows are ticked.
- Results: a summary of what was created and what failed, with the reason.
GSTINs in an import are saved as typed; verify them from the party's page later.
Tips & common issues¶
Create parties as you go
You do not have to set everyone up first. While raising an invoice or bill, typing a name that is not in the list offers Create new customer or Create new vendor. A small dialog takes the name, State, Phone and Email, enough to use the party now; add addresses and contacts later from their page.
Where is the outstanding balance?
The party page lists documents, not balances. For what a customer owes you, use Reports → Receivables Aging; for what you owe vendors, Reports → Payables Aging.
Deleting a party
Delete customer (in the menu on the customer's page) and Delete vendor are available only while the party has no invoices or bills. A party with documents stays on record, because those documents point to it.
Related guides¶
- Create & post a sales invoice: invoices link to customers.
- Create & post a purchase bill: bills link to vendors.
- Financial reports: receivables and payables ageing by party.
Last checked against TrackBooks on 24 October 2026.



