20 Free Small Business Bookkeeping Templates

Updated: November 1st, 2021

Do you need a better way to track your expenses, accounting, and stay on top of bookkeeping for your small business?

We put together the 20 best bookkeeping templates and Excel spreadsheets, here they are:

1. Excel Bookkeeping Template

This bookkeeping template is a simple, more straightforward approach to bookkeeping. It can be used to track income, expenses, and your bank balance. It allows you to enter transactions, and see financial reports based on these transactions. (source)

See a preview of this template:

2. Statement Of Accounts Excel Template

The statement of accounts template lets you provide a record of client’s purchases and payments, along with the automatically calculated running balance. (source)

See a preview of this template:

3. Trial Balance Excel Template

The ready to use trial balance excel templates enables you to prepare the statement of all closing balances of ledger accounts on a particular date. (source)

See a preview of this template:

4. Small Business Income & Expenses Template

This simple income and expense worksheet lets you track your money. With this worksheet, you will be able to see all income streams and take note of all costs incurred in the course of doing business. (source)

See a preview of this template:

5. Accounts Receivable Ledger

The accounts receivable ledger lets you manage the outstanding balances owed by customers, so you can streamline the process of collection efforts. (source)

See a preview of this template:

6. Free General Ledger Template

This Free general ledger is a crucial component of your business because it assists in keeping your business running smoothly and making sure that all financial accounting details are correct. (source)

See a preview of this template:

7. Simple Cash BookTemplate

This simple cashbook template enables you t record all the receipts and payments from direct bank deposits or cash payments. At the end of month, the accounts clerk will post all these transactions to the general ledger. (source)

See a preview of this template:

8. Balance Sheet Excel Template

The balance sheet excel template lets you determine the financial position of your business in terms of assets and liabilities. (source)

See a preview of this template:

9. Expense Report Template

This simple expense report template lets you document the expense date, type of expense and the total amount for each expense. (source)

See a preview of this template:

10. Business Mileage Tracking Sheet

The business mileage tracking sheet is used by employees wherever they use their personal vehicles while on business trips. Therefore, accountants can keep track of the mileage expense for every work journey. (source)

See a preview of this template:

11. Small Business Cash Flow Forecast Template

The small business cash flow forecast template is a crucial instrument as it helps the business managers gain monthly insight into the company’s cash flow position, so adequate measures can be taken to ensure sufficient cash for business operations. (source)

See a preview of this template:

12. Bank Reconciliation Statement Excel Template

This bank reconciliation statement will help you identify the difference between checking account and the bank book. (source)

See a preview of this template:

13. Cash Flow Template

Statement of cash flows summarizes the amount of cash entering and leaving a company, illustrating the company performance over a certain period. (source)

See a preview of this template:

14. Accounts Payable Template

Use this accounts payable template to track the amounts due to your vendors or suppliers for materials received and have not been paid for. The total outstanding amounts owed to vendors appears as the accounts payable on the balance sheet. (source)

See a preview of this template:

15. Free Profit and Loss Template

This profit and loss statement template lets you create the monthly or annual income statement by simply entering your financial information. Use the P&L template to summarize the businesses income and expenses for any period. (source)

See a preview of this template:

16. Chart of Accounts Template

The simple to use chart of accounts template enables you to keep business records in one sheet. (source)

See a preview of this template:

17. Petty Cash Log Template

The petty cash log template simplifies the burden of recording sundry expenses, and ensuring you can account for the petty cash balance to the last coin. (source)

See a preview of this template:

18. Farm Bookkeeping Template

Use this farm bookkeeping template to keep track of every income and expenditure related to your farm. The bookkeeping template is designed to enter cash payments and bank deposits, and you can modify it to your farms unique operations. (source)

See a preview of this template:

19. Restaurant Bookkeeping Templates

This restaurant bookkeeping template will help you monitor cash flows, business growth and profitability. You can customize the template to suit your unique requirements. (source)

See a preview of this template:

20. Non Profit Financial Statement Template

This non profit financial statements template consist of automated reports you need to ensure proper reporting of your financial position. (source)

See a preview of this template:

meet the author
Pat Walls