The Guide to Free Excel Bookkeeping Templates
Who handles your bookkeeping? Small business owners have plenty of options, from hiring a part-time bookkeeper to using cloud-based accounting software. Entrepreneurs who outsource these financial tasks want to save time, lower the risk of human error, and minimize tedium. But those who keep their books via Excel enjoy a fuller view and firmer grip on their business’ finances.
Thankfully, doing your bookkeeping doesn’t have to mean creating each spreadsheet from scratch. The following are the best free excel bookkeeping templates we could find for everyday use, including financial statements, bank reconciliation, and startup costs. Click on the name of the template to download an .xls file you can start using immediately. (We’ve tested each one for accuracy and safety, so don’t worry about downloading the file!)
Financial Statement Templates
- Balance Sheet: The balance sheet is a snapshot of what you owe and own so that you can calculate your business’ net worth. This template is simple, straightforward, and easy on the eyes.
- Income Statement: The income statement is also known as a “profit and loss statement” because it shows how much you’ve earned and spent over some time. This second template of ours is as beautiful and simple as the balance sheet.
- Cash Flow Statement: This statement tracks the cash moving in and out of your business to help you see what drives your cash over time. The QuickBooks template comes with notes, tips, and an example.
Basic Bookkeeping Templates
- Chart of Accounts: This COA template from Double Entry Bookkeeping is the table of contents of your double-entry bookkeeping system.
- Accounting Journal: Smartsheet’s accounting journal gives you a bird’s eye view of each step of the accounting process, all in one place.
- Accounting Ratio Calculator: Accounting ratios can help you understand trends and measure performance. Double Entry Booking offers tutorials on the topic in addition to its Excel spreadsheet.
- Accounts Payable: Beginner Bookkeeping offers explicit instruction along with their accounts payable ledger, which helps you track what you owe to each vendor and supplier at any time.
- Accounts Receivable: The accounts receivable ledger from Beginner Bookkeeping helps you track invoices customers pay over time.
- Expense Report: This expense report by Vertex42 has everything you need to track, record, and itemize each expense.
- Bank Reconciliation Statement: Beginner Bookkeeping has useful instructions in addition to a simple template for reconciling your bank statements.
- Petty Cash Log: This Beginner Bookkeeping spreadsheet and voucher in Excel helps you manage your petty cash box.
- Employee Timesheets: If you have employees, you can use this sheet from SME Toolkit to track the hourly, weekly, and monthly hours of your staff.
- Initial Cash Requirements: This template from SME Toolkit helps startups plan for set-up costs, business operations cost, and living expenses over six months.
- Financial Projections: This template from Double Entry Bookkeeping enables you to layout your projections over five years, including revenue, profit, and cash graphs, ratio analysis, and break-even revenue for each year.
You can find more PDF and free Excel bookkeeping templates at Double Entry Bookkeeping; courses, worksheets, and templates at SME Toolkit; free versions of the advanced accounting templates at Smartsheet; simple PDF and Excel templates for basic bookkeeping at Beginner Bookkeeping; and hundreds of financial and general spreadsheets at Excel Templates.