Home›Templates›Accounting & Small Business Spreadsheets›Trading Account
Preview of the Trading Account template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Trading Account Format (Excel & PDF)

Opening stock, purchases and direct expenses on the debit side, sales and closing stock on the credit side; gross profit balances it.

✓ A4✓ Dr / Cr format✓ Auto gross profit✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated November 2026

Guide

About this trading account template

A trading account is the first part of the final accounts of a business that buys and sells goods. It compares net sales and closing stock (credit side) with opening stock, net purchases and direct expenses such as wages, freight inward and power (debit side). The balancing figure is gross profit, or gross loss if the debits are larger, and it is carried to the profit and loss account. This sheet uses the traditional "To" and "By" T-format, handles returns, and also shows cost of goods sold and the gross profit ratio.

How to prepare a trading account

  1. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Take opening stock, purchases, purchase returns and direct expenses from your trial balance and enter them on the debit side.

  3. 3

    Enter sales, sales returns and the closing stock value on the credit side.

  4. 4

    Read the gross profit (or gross loss), cost of goods sold and gross profit ratio, which update automatically.

  5. 5

    Carry the gross profit to the credit side of your profit and loss account.

Tips for an accurate trading account

Direct expenses only

Wages, carriage inward, freight, power and factory rent go here. Office rent, salaries and selling costs go in the profit and loss account.

Value closing stock right

Closing stock is normally valued at cost or net realisable value, whichever is lower.

Returns as negatives

Enter purchase returns and sales returns as negative numbers so they reduce purchases and sales.

Watch the ratio

Compare the gross profit ratio with last year. A sudden drop can point to pricing, theft or a stock counting error.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

The trading account works out gross profit from buying and selling goods. The profit and loss account starts from gross profit, deducts indirect expenses such as salaries, rent and depreciation, and shows the net profit.

Then there is a gross loss. The sheet shows it on the credit side as "By Gross loss c/d", and the gross profit line shows zero.

Gross profit divided by net sales, as a percentage. In the sample, 42,200 ÷ 117,500 = 35.9%.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
🧾

GST / Tax Calculator

Calculate GST, VAT, and tax amounts quickly

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF