Free Small Business Bookkeeping Templates | Smartsheet (2024)

Download Cash Book Template — Microsoft Excel

Record debit and credit transactions in this double-column cash book template to monitor your cash balance. Enter the date, description, and amount for each transaction, and the template will calculate subtotals and total cash balance.

Download Balance Sheet Template

MicrosoftExcel | Smartsheet

Use this balance sheet template to report your business assets, liabilities, and equity. The template calculates common financial ratios, such as working capital and debt-to-equity ratio. Edit the example line items to list all of your current and long-term assets and liabilities, and view subtotals for each section and column.

Download Trial Balance Worksheet

MicrosoftExcel | Smartsheet

This trial balance worksheet compares beginning and ending balances on each of your financial accounts based on debit and credit transactions over a given period. The template also calculates the total balance across all accounts and the total variance. Customize account titles and categories as needed to reflect your specific business.

Download Business Expense Template — Microsoft Excel

Keep track of business expenses with this simple spreadsheet template. Columns include Payment Date, Method, Description, and Amount. If you’re self-employed, include home office expenses and other deductibles to help save time during tax season. The template keeps a running subtotal of expenses, adjusting the total sum with each new entry.

Download Billing Invoice Template

MicrosoftExcel | Smartsheet

Save time on invoicing with this basic billing template. Customize with a logo and business details, and enter an invoice number, date, customer ID number, and payment terms for each invoice. Fill in the itemized list of payments due, and adjust the tax percentage to calculate the total amount owed.

Download Invoice Tracking Template — Google Sheets

Track all of your invoices with this simple spreadsheet. List each invoice by ID number, date, customer name, description, and amount. Add the date of payment when you receive a remittance. The template provides a running total each time you enter a new invoice and calculates the total amount invoiced to date.

Download Statement of Account Template — Microsoft Excel

This statement of account template shows all of the financial transactions that occurred between your business and a customer during a certain time period. The template provides an account summary, including the customer’s previous balance, credits, current charges, balance owed, and due date. Customers also receive an itemized list of charges and credits, including invoice numbers, dates, and amounts.

Download Inventory Tracking Template
Microsoft Excel | Google Sheets

Track the value of your current inventory and determine the cost of goods sold with this inventory tracking template. List physical inventory by item number, name, description, type, and location, and record purchases, including purchase dates, vendors, and prices. Compare the number of items sold to your monthly sales figures to make sure your inventory tracking sheet matches actual sales.

Download Accounts Receivable Template

Microsoft Excel | Smartsheet

This template includes a ledger for tracking customer payments and an accounts receivable aging tab to track outstanding payments. The template automatically populates the accounts receivable aging sheet after you fill in the payment ledger. Add invoice terms, amounts, and payments received to view current and overdue balances.

Download Accounts Payable Template

Microsoft Excel | Smartsheet

This accounts payable template helps you track the money your business owes to vendors. List balances due, payments made, and supplier names, invoice numbers, and amounts. The template subtracts payments to show a running balance for each line item and displays the total amount due to all vendors at the top of the spreadsheet.

Download Simple Cash Flow Template

Microsoft Excel | Smartsheet

This basic cash flow statement tracks the movement of money in and out of your business and compares financial data between time periods. The template lists example cash receipts, payments, operating expenses, and additional costs. Use this template to review each item and determine the overall month-end cash position for each time period.

Download Quarterly Cash Flow Projections Template — Microsoft Excel

Create a detailed report that displays quarterly cash flow projections. This template allows you to track the variance between your projected and actual cash position for each month and calculates total cash payments and net cash change.

Download 12-Month Cash Flow Forecast Template

Microsoft Excel | Smartsheet

This simple but comprehensive template allows you to create a 12-month cash flow forecast for your small business. The spreadsheet includes monthly columns for recording forecasted and actual cash flow. List cash receipts and cash paid out to view your projected and actual cash position for each month.

Download Income Statement Template

Microsoft Excel | Smartsheet

Review revenue, expenses, and net income before and after taxes with this income statement template. The template accounts for all revenue sources and business expenses when calculating net income. Example revenue sources include sales, services provided, and interest. Business expenses include advertising, office equipment, insurance, utilities, and depreciation.

Download Profit and Loss Dashboard Template — Microsoft Excel

This profit and loss dashboard template provides a visual overview of financial data, including total business income, cost of goods sold, gross profit, earnings before interest and taxes, and net revenue. Get a snapshot of your monthly profit and loss report by entering your financial data and selecting the month that you want to view in the dashboard.

Download Accounting Journal Template

Microsoft Excel | Smartsheet

Record debit and credit transactions and balances for multiple accounts in this accounting journal template. Edit the list of account descriptions and codes to match your business accounts. The template includes space to record trial balance, adjusting entries, adjusted trial balance, income statement and balance sheet for each account.

Download Expense Report Template

Microsoft Excel | Smartsheet

Track business expenses such as transportation, entertainment, lodging, and meals with this expense report template. Specify the time frame at the top of the spreadsheet and list all expenses with dates for each transaction. The template provides space to add notes or detailed descriptions as needed.

Download Chart of Accounts Template — Microsoft Excel

Create a complete record of all the financial accounts listed in your general ledger. For each account, include the code, a brief description, and the account type, such as asset, liability, equity, or expense. The template also lists the financial report associated with the account, such as a balance sheet or income statement, and specifies whether a debit or credit increases the amount in the account.

Download Monthly Bank Reconciliation Template

Microsoft Excel | Google Sheets

Reconcile a financial account by creating a record of transactions to compare to your bank statement. This reconciliation template includes sections for recording deposits in transit and outstanding checks, and it automatically calculates your statement balance. Duplicate the template to create a continuous monthly report.

For related templates, including those for reconciling petty cash and general ledger accounts, see our collection of free reconciliation templates.

Download Small Business Budget Template — Microsoft Excel

This budget template includes tabs for recording income, expenses, and cash flow. Create a list of income sources and business expenses. As you add amounts received or spent on each item, the template calculates monthly and yearly totals. Use the cash flow tab to record transactions and monitor your cash balance.

Download Monthly Mileage Log Template

Microsoft Excel | Microsoft Word | Adobe PDF

Use this mileage log template to track business vehicle use and mileage costs. The template includes columns for travel dates and purpose, starting and ending points, odometer readings, and total miles. If you are using this sheet to reimburse employees, enter the reimbursem*nt rate at the top of the template to determine the total amount owed.

Download Employee Timesheet Template — Microsoft Excel

Track employee hours and calculate wages due on a weekly basis. This timesheet template includes break time, regular and overtime hours, sick days, vacation time, and holidays. Enter the starting date for the week at the top of the template, and the dates will automatically populate the timesheet. View hourly rates, total hours, and total pay for each day and week.

Download Payroll Register Template

Microsoft Excel | Smartsheet

This payroll register template includes a pay stub and a register of employee information to help you process payroll. The pay stub tab displays payment and withholdings for an individual employee, while the register lists employee job titles, salaries, vacation and sick allowance, and pay schedule. It also shows pre- and post-tax deductions, such as 401(k) contributions and insurance, and federal and state taxes.