Moving Company Balance Sheet Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Vehicle & Equipment Schedule sheet: list every box truck, cargo van, and trailer your company owns or is financing. Enter the purchase price, how much depreciation has accumulated, and the current outstanding loan balance for each unit. This step feeds both the non-current assets and long-term liabilities sections of the main Balance Sheet, so getting it right first means you won't be adjusting the same numbers in two places. Most moving companies with two to five trucks can complete this sheet in under 20 minutes.

Move to the Balance Sheet sheet and enter the remaining figures. On the asset side: your current cash balance, any outstanding accounts receivable from jobs invoiced but not yet paid, your packing supplies inventory (a quick physical count of boxes, tape rolls, and pads works fine), and prepaid items like insurance deposits or DOT registration fees. On the liability side: any accounts payable to fuel or supply vendors, accrued wages for the most recent pay period, and the current-year portion of your truck loans. The equity section calculates automatically. If assets don't equal liabilities plus equity, the template flags the imbalance so you can track down the missing entry.

Once your snapshot is complete, use the Period Comparison sheet to track changes over time. Copy your current balance sheet into the first column, then update it each quarter with fresh numbers. Pay particular attention to working capital as you move from summer into fall — this is the number that tells you whether you have enough cash on hand to cover the slow season without dipping into a line of credit. Lenders evaluating a vehicle financing request will typically want to see two to three years of year-end balance sheets. Having them pre-built in this template means you're always ready.

Moving companies carry a financial structure that most generic spreadsheets don't account for. The bulk of your assets are box trucks — typically $30,000–$80,000 each depending on size and age — and most of those are financed, which means significant long-term liabilities sitting alongside the asset value. Add seasonal cash swings where summer peak revenue can be three to four times winter revenue, and you have a business where the balance sheet snapshot matters far more than a single month's income. Owners who track only their P&L often don't realize their equity position is eroding until they try to refinance a truck or sell the business.

A proper moving company balance sheet organizes assets the way lenders and accountants expect. Current assets should include cash, receivables from recent jobs and any corporate or real estate firm accounts, packing supplies on hand, and prepaid items like DOT operating authority fees and insurance deposits. Non-current assets are your vehicles at net book value — purchase price minus accumulated depreciation — plus major equipment like piano boards and appliance dollies. The liability side mirrors this: current liabilities cover the next 12 months of loan payments, vendor payables, and accrued crew wages; long-term liabilities cover remaining vehicle financing. The difference is owner's equity, which is the true measure of what the business is worth if you paid off all debts today.

The balance sheet becomes a practical management tool when you track it across seasons. A moving company with three trucks and a crew of ten should be building cash reserves from May through August to cover the January through March slow period. If your current ratio — current assets divided by current liabilities — drops below 1.0 heading into fall, that's a signal to cut discretionary spending before winter hits, not after. This template is built around that workflow: take a snapshot quarterly, compare periods in the comparison view, and use the Key Ratios sheet to track whether your financial position is improving or you're slowly over-leveraged on equipment relative to your equity base.