Accounting Worksheets

Search and download ready-to-use accounting worksheets and templates, which you can use to create your own version and use on the job!

Accounting Worksheets and Excel Templates

Browse the library of accounting worksheets and Excel templates to find the tools that best fit your needs.

What is Financial Accounting?

Financial accounting theory explains the “why” of accounting, in particular, the reasons why transactions are recorded and presented the way they are. An accountant must be familiar with how to record journal entries, differentiate all the common accounts used by businesses, understand how financial statements are created, as well as how to accurately compute debit and credit amounts for each account. Financial accounting is about reporting a company’s financial transactions to outside stakeholders including investors and lenders. This section has multiple Financial Accounting Templates that will save you time on your job.

What is Managerial Accounting?

Managerial accounting (a.k.a. cost accounting) is a type of accounting focused on identifying, measuring, analyzing, and interpreting accounting information for internal decision making by the management team of a business. Managerial accounts would use various techniques to provide detailed information about the individual product line, department, operating activity, or function of a company. These techniques include margin analysis, constraint analysis, capital budgeting, product costing, and trend analysis and forecasting. CFI’s Managerial Accounting Templates will reduce the work you have to do!

What You Need to Know About Accounting

For finance and accounting professionals working in the corporate finance, investment banking, financial planning and analysis (FP&A), equity research, and other areas of finance, there are many fundamental aspects of accounting they need to know. Below is a list of some of the most important accounting concepts and theories:

  • Bookkeeping: recording daily financial transactions of a business
  • T Accounts: tracking of debits and credits of company accounts
  • Trial balance: a report that contains all general ledger accounts balances at a specific point of time
  • Journal entries: record of transactions which involve two or more accounts at the same time with equal debits and credits
  • Revenue recognition principle: explains the matching of time and process for recording and recognizing revenue in the financial statements
  • Three financial statements: include the income statement, balance sheet, and cash flow statement
  • Depreciation methods: common ways to calculate depreciation expense for a capital asset (usually property plant and equipment) are (1) straight-line; (2) double declining balance; (3) units of production; (4) sum of years digits
  • Last-in-first-out (LIFO) vs. First-in-first-out (FIFO): the two most commonly used methods to calculate the cost of goods sold and ending inventory of a company
  • International Financial Reporting Standards (IFRS) vs. US Generally Accepted Accounting Principles (GAAP): the two widely adhered accounting standards around the world for financial reporting

Popular Accounting Worksheets

Examples of common accounting worksheets include:

  • Accounting rate of return
  • Cash flow worksheet
  • Profit margin spreadsheet
  • Marginal cost of production template
  • Journal entry worksheet
  • Balance sheet template
  • Income statement template
  • Depreciation worksheet
  • Bank reconciliation