Chart of Accounts for a Trading Company in Excel

A chart of accounts for a trading company in Excel is a controlled list used to design or document the ledger before importing it into accounting software. It should distinguish inventory, receivables, payables, sales, returns, cost of goods sold, freight, duties, payment clearing, and operating expenses.

Steady bookkeeping services can help map a working Excel list to a reconciled accounting system. The spreadsheet should be a design and governance tool, not an uncontrolled substitute for a general ledger.

Recommended Excel columns

Illustrative trading-company chart

This example is not a universal chart or a claim about U.S. GAAP, tax reporting, regulated accounts, or another prescribed framework. Adapt types and policies to the entity and reporting requirements.

Inventory controls

The inventory account should agree to an item-level quantity and valuation report. Preserve purchases, receipts, returns, transfers, landed costs, sales, shrinkage, write-downs, and ending quantities. Negative quantities or a growing gap between the subledger and general ledger require investigation.

Use separate accounts only when the distinction is recurring and supported. Warehouses, product lines, brands, and sales channels are often better captured as dimensions or item attributes than cloned ledger accounts.

Gross sales and net settlements

Processor and marketplace deposits can be net of fees, refunds, chargebacks, taxes, and reserves. Use clearing accounts to bridge gross activity to cash. The remaining clearing balance should equal unsettled platform detail at the reporting date.

How to build the Excel file

1. List required financial statements, margin reports, and control schedules.
2. Freeze the column definitions and allowed account types.
3. Enter current accounts and balances from the existing ledger.
4. Mark duplicates, inactive accounts, wrong types, and proposed survivors.
5. Add trading-specific inventory, settlement, return, and landed-cost controls.
6. Map old codes to new codes without deleting historical references.
7. Test representative purchases, sales, refunds, tax, freight, and settlements.
8. Obtain accounting approval before import.

Spreadsheet controls

Use data validation for account types and status, protect formula and mapping columns, keep one header row, avoid merged cells, and give every row a stable identifier. Record the preparer, reviewer, approval date, version, and target system.

Do not embed balances in the chart design unless they are clearly labeled conversion values tied to a trial balance. A chart is a list of accounts; a trial balance is a list of account balances.

Useful formulas and validation checks

Add a duplicate-key check such as a count of each account number and name, but convert the final result to reviewed values before import if the target requires a plain file. Validate that every active row has a number, unique name, allowed type, status, and destination code. Flag parent accounts that do not exist and subaccounts whose types conflict with their parent.

Version and approval control

Keep a change log with requestor, reason, old account, new account, effective date, affected imports, affected reports, approver, and implementation date. Use a version such as Draft, Approved for Test, or Approved for Production. Do not email several files named final.

After go-live, update the approved master when an account is added or inactivated. Periodically compare the production export with the master and investigate unauthorized differences.

Trading-company reporting views

The general ledger should produce a balance sheet and P&L, while dimensions and subledgers support sales and margin by channel, product group, customer, warehouse, and location. A stock ledger supports quantity and value. A receivable aging supports customer collection. These are connected reports, not reasons to duplicate the chart.

For multi-currency trading, preserve transaction currency, functional-currency amount, exchange rate, remeasurement or translation treatment, and settlement differences according to the applicable framework. Do not solve currency reporting by creating random income accounts for every bank movement.

Example change-control register

The register helps future users understand why the chart looks the way it does. It also prevents the same rejected request from returning under a slightly different name without new facts.

Handoff package

Deliver the approved Excel chart, old-to-new map, account definitions, dimension dictionary, import file, test results, opening trial balance, reconciliation package, change log, and owner list. Store them together with a read-only copy of the prior system reports.

A future bookkeeper should be able to reproduce the conversion and understand which accounts permit direct posting, which are controlled by subledgers, and who reviews each material balance.

Include contact details for the accounting owner and system administrator, plus the date of the next planned chart review.

Import acceptance tests

• Every active account imports once with the intended type.
• Parent and subaccount relationships remain intact.
• Control accounts connect to the correct subledgers.
• Opening balances reproduce the approved trial balance.
• Inventory, receivables, payables, tax, debt, and equity reconcile to schedules.
• Comparative financial statements remain intelligible.
• Unused proposed accounts do not enter production.

Start with the chart of accounts structure guide, then use the general chart guide to validate the hierarchy.