--- title: Accounting Worksheet | Example, Benefits, Limitations, Preparation description: The accounting worksheet simplifies the process of creating financial statements for each accounting period. Click for more information. --- [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo-white.4f6047d4.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) [![Carbon collective](https://www.carboncollectiveinvesting.com/hubfs/raw_assets/public/CarbonCollective_August2021%20copy/images/carbon-collective-green-investing-logo.53b28bee.svg "Carbon collective")](https://www.carboncollectiveinvesting.com/) - About - Employers - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - [401(k) Comparison Tool](https://www.carboncollectiveinvesting.com/401k/plan-comparison-tool) - Individuals - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [ETF](https://www.carboncollectivefunds.com/) - Learn - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Blog](https://blog.carboncollective.co/) - [Tools](https://tools.carboncollective.co/calculator/) - Log in - [Carbon Collective](https://app.carboncollective.co) - [Altruist](https://app.altruist.com) [Talk to a human](https://ask.carboncollective.co/f4o5dylkg) [Sign up](https://app.carboncollective.co/sign-up) [Log In](http://app.carboncollective.co/) **[Home](https://www.carboncollectiveinvesting.com/) > [Sustainable Investing](https://www.carboncollectiveinvesting.com/sustainable-investing) >** Accounting Worksheet # Accounting Worksheet ![](https://www.carboncollectiveinvesting.com/hubfs/Brooke%20Tomasetti.png) Written by Brooke Tomasetti | Reviewed by [Subject Matter Experts](https://www.carboncollectiveinvesting.com/subject-matter-experts) Updated on October 1, 2024 Fact Checked Why Trust Carbon Collective? ### Table of Contents An accounting worksheet is a tool used to determine the accuracy of the financial statements prepared by a company at the end of the accounting period. It also assists in keeping track of the steps involved in the accounting cycle. It’s essentially a spreadsheet used specifically for internal purposes and not meant to be seen or used by external stakeholders like shareholders, creditors, etc. [![Learning for school or work and want to make sure your personal finances are set up for success? Read the free guide on how to be a smart investor.](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/20345524/2fd649c5-a2f6-4eb4-8d90-a66a46238496.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/20345524/2fd649c5-a2f6-4eb4-8d90-a66a46238496) ## The Accounting Cycle Example Throughout this series on the accounting cycle, we will look at an example business, Bob’s Donut Shoppe, Inc., to help understand the concepts of each part of the accounting cycle. Below is the complete list of accounting cycle tutorials: 1. [Journal Entries](https://www.carboncollectiveinvesting.com/sustainable-investing/journal-entries/) 2. [T-Accounts](https://www.carboncollectiveinvesting.com/sustainable-investing/t-accounts/) 3. [Unadjusted Trial Balance](https://www.carboncollectiveinvesting.com/sustainable-investing/unadjusted-trial-balance/) 4. [Adjusting Entries](https://www.carboncollectiveinvesting.com/sustainable-investing/adjusting-entries/) 5. [Adjusted Trial Balance](https://www.carboncollectiveinvesting.com/sustainable-investing/adjusted-trial-balance/) 6. [Preparing Financial Statements](https://www.carboncollectiveinvesting.com/sustainable-investing/preparing-financial-statements/) 7. **Accounting Worksheet (you are here)** 8. [Closing Entries](https://www.carboncollectiveinvesting.com/sustainable-investing/closing-entries/) 9. [Income Summary Account](https://www.carboncollectiveinvesting.com/sustainable-investing/income-summary-account/) 10. [Post-Closing Trial Balance](https://www.carboncollectiveinvesting.com/sustainable-investing/post-closing-trial-balance/) 11. [Reversing Entries](https://www.carboncollectiveinvesting.com/sustainable-investing/reversing-entries/) We also have an accompanying spreadsheet which shows you an example of each step. [Click here to download the Accounting Cycle template](https://www.carboncollectiveinvesting.com/hubfs/Bobs-Donut-Shoppe-Apr-24-2022-11-50-22-91-AM.xlsx) ## Accounting Worksheet Benefits The accounting worksheet simplifies the process of creating financial statements for each accounting period. Additionally, for already created financial statements, an accounting worksheet can be used to investigate why they might not be balancing. It serves as an analytical and a summary tool to reflect how the accounts had been initially posted, the adjustment entries made and the final presentation in the form of financial statements. Using an accounting worksheet is a reliable process to determine the financial health of a company even before the financial statements have been prepared. Due to the internal nature of this spreadsheet, the format of it can vary from company to company as per requirements—there is no standard format. ## Accounting Worksheet Limitations We have looked into the several advantages that an accounting worksheet provides. However, some limitations can exist as well: - Since it is a labor-intensive process and requires human effort (if not automated), there are always chances of errors or inconsistencies. - It cannot avoid errors of omissions. - Duplicate entries are possible. - Other others could exist too. ## Accounting Worksheet Preparation There are usually five columns of data with each column sub-divided into a debit and a credit column. ### Unadjusted Trial Balance This is the first column in an accounting worksheet and will include all the components that are part of the unadjusted trial balance such as revenue accounts, expense accounts, assets accounts, etc. The total of the debit columns for this should be equal to the total of the credit column. If not, this would mean there has been an error in the preceding steps of the accounting cycle. ### Adjusting Entries Adjusting items would make up the second column. The debit and credit column should match here again. ### Adjusted Trial Balance The adjusted trial balance is simply a combination of the unadjusted trial balance and the adjusting entries. ### Income Statement This income statement column will contain values pertaining to only the revenues and expenses accounts. If the total revenues exceed the expenses, then the difference will be recorded as [net income](https://www.carboncollectiveinvesting.com/sustainable-investing/net-income) for the year. The opposite will hold if expenses are more than revenues and a net loss would be recorded. In either case, a balancing entry is needed to be passed by the company. ### Balance Sheet This is the last column on the accounting worksheet and will include the assets, liabilities and equity accounts. Like the other columns, the total of debit and credit should match here as well. ## Accounting Worksheet Example We have already covered how Bob’s financial statements were prepared and presented. The next step for Bob’s bookkeeper is to create an accounting worksheet to ensure that all of it ties together. His accounting worksheet would look something like this: ![](https://studyfinance.com/static/media/image-23.png) Below are some important points regarding Bob’s accounting worksheet: - This accounting worksheet is an internal document and has been prepared for internal management consumption only. External shareholders, creditors or prospective investors can use the financial statements for their decision making. - It begins with a list of all accounts such as revenue, expense, assets, liabilities and equity in the unadjusted trial balance. These have been compiled by posting journal entries to their ledgers and from there the balances have been transferred to the unadjusted trial balance report. - Adjusting entries are then prepared for Bob’s company to account for revenue and expenses that are related to this period but haven’t been paid out yet. This follows the accounting concept of match and accrual accounting. - After adjusting entries have been made, the ledger balances are recalculated and posted to the adjusted trial balance. This report would include additional accounts such as depreciation expense, accumulated depreciation, prepaid rent, unearned income, etc. - The income statement for Bob is the combination of operating revenues, operating expenses, non-operating revenues and non-operating expenses. You will usually find the revenue and expense accounts related to the incomes statement at the very end as per chronological order defined by the accounting worksheet. - The balance sheet for Bob includes asset accounts like renovations and improvements, cash, accounts receivable, prepaid rent and inventory. The liability accounts for Bob and his company include accounts payable, accrued expenses, unearned income and long-term liabilities. The equity accounts consist of common stock, dividend and retained earnings. ## Accounting Worksheet Conclusion In summary, an accounting worksheet is an internal document for the accounting department to analyze the accounts and its balances. It is a useful mechanism to identify any accounting errors that could have been made in the accounting process thus far. All the company records are shown in one sheet in different columns; thus, it is easier for a bookkeeper to visualize the whole process up to the point of creation of financial statements. While a company doesn’t need to prepare an accounting worksheet, it is still a useful process and it is highly recommended to prepare one. ## Next Step The next step in the accounting cycle is to create closing entries. These are manual journal entries at the end of an accounting cycle to close out all the temporary accounts and shift their balances to permanent accounts. In other words, temporary accounts are reset for the recording of transactions for the next accounting period. By doing so, companies move the temporary account balances to the permanent accounts of the balance sheet. We will discuss this in more detail in the next section. ## FAQs ### 1. What is an accounting worksheet? An accounting worksheet is a document where all the company records are shown in one sheet in different columns. ### 2. How do you write an accounting worksheet? An accounting worksheet follows the following sequence: i. Revenue accounts are listed in the first column; ii. Expense accounts are listed in the second column; iii. Asset, liability, and equity accounts are listed according to chronological order; iv. All ledger balances (both primary and secondary) are posted to the unadjusted trial balance; v. Adjusting entries are then prepared for the company to account for revenue and expenses that have been earned but not yet received. This follows the accounting concept of match and accrual accounting; vi. After adjusting entries have been made, the ledger balances are recalculated and posted to a new adjusted trial balance report. This includes additional accounts such as depreciation expense, accumulated depreciation, prepaid rent, unearned income, etc. vii. The report concludes with the presentation of a company income statement and balance sheet for a specific period of time. ### 3. What is the purpose of an accounting worksheet? The main purpose of an accounting worksheet is to help identify any errors that could have been made in the accounting process. This is the first step you will take before preparing financial statements. For example, if a bookkeeper accidentally posts the wrong account as income, or if he is not sure about an entry and posts it as a temporary account to figure it out later, this mistake will be identified by the accounting worksheet. By doing so, you can fix these mistakes before they make their way into financial statements. ### 4. Is an accounting worksheet a journal? No, a worksheet is not a journal. Neither is it part of the general journal. Journal entries are for recording financial transactions, while an accounting worksheet is used to prepare adjusting entries. Closing entries are also included in the accounting worksheet. ### 5. Is an accounting worksheet a permanent accounting record? A worksheet is a temporary accounting record. It will be used to prepare adjusting entries that might need to be changed once the company receives more information. For example, if revenue has been recorded from a customer but payment has not been received yet, this information will need to be updated once the cash comes in. For this reason, a worksheet can be used to prepare at least two sets of financial statements. ### Related Topics - [Sustainable 401(k) Plan](https://www.carboncollective.co/401k) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing/) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - [Retirement Glossary](https://www.carboncollective.co/sustainable-investing/retirement-planning-glossary) - [Best Retirement Plans](https://www.carboncollective.co/sustainable-investing/the-10-best-retirement-plans) - [Wealth Manager Vs Financial Advisor](https://www.carboncollective.co/sustainable-investing/wealth-manager-vs.-financial-advisor) ![Attend Our Next Webinar](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-webinar.12af7b6e.svg) ### Attend Our Next Webinar Join our next Sustainable Investing 101 webinar, get our favorite DIY options, and walk through how we build our portfolios. [Watch Now](https://www.carboncollective.co/sustainable-investing-webinar-green-retirement-month) ![Get Our Newsletter](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-demo.6ed28722.svg) ### Get Our Newsletter Go a level deeper with us and investigate the potential impacts of climate change on investments like your retirement account. Join Newsletter ![close-typeform](data:image/gif;base64,R0lGODlhEQARAIAAAODn7P///yH5BAEHAAEALAAAAAARABEAAAIqBIKpab3v3EMyVHWtWZluf0za0XFNKDJfCq5i5JpomdUxqKLQVmInqyoAADs=) ![Talk To A Human](https://www.carboncollectiveinvesting.com/hubfs/carbon-collective-green-investing-icon-chat.49d48c5b.svg) ### Talk To A Human Joining a new investment service can be intimidating. We’re here for you. Click below to email us a question or book a quick call. [Ask a Question](https://ask.carboncollective.co/f70pooobq) Topics ## Sustainable Investing Topics View our list of some topics below. See More - Portfolios - [Performance](https://www.carboncollectiveinvesting.com/returns) - About - [Sustainable 401(k)](https://www.carboncollectiveinvesting.com/401k) - Learn - [FAQ](https://www.carboncollective.co/en/knowledge/faqs) - [Sustainable Investing](https://www.carboncollective.co/sustainable-investing) - [Investing Basics](https://www.carboncollective.co/sustainable-investing/investing-basics) - Contact - [Contact us](mailto:hello@carboncollective.co) - [Legal](https://www.carboncollective.co/legal) - [Privacy Policy](https://www.carboncollectiveinvesting.com/hubfs/2022-11%20Carbon%20Collective%20Privacy%20Policy.pdf) - [Back to top](https://www.carboncollectiveinvesting.com/sustainable-investing/accounting-worksheet#top-of-page) DISCLAIMERS: Advisory services provided by Carbon Collective Investment LLC (“Carbon Collective"), an SEC-registered investment adviser. A copy of Carbon Collective's current written disclosure statement discussing Carbon Collective’s business operations, services, and fees is available at the SEC’s investment adviser public information website – [www.adviserinfo.sec.gov](https://adviserinfo.sec.gov/firm/summary/310129) or [our legal documents here](https://blog.carboncollective.co/legal-documents/). The articles and research support materials available on this site are educational and are not intended to be investment or tax advice. Carbon Collective does not make any representations or warranties as to the accuracy, timeliness, suitability, completeness, or relevance of any information prepared by any unaffiliated third party, whether linked to Carbon Collective’s web site or incorporated herein, and takes no responsibility therefor. All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly. Investments in securities: Not FDIC Insured • No Bank Guarantee • May Lose Value. Investing in securities involves risks, and there is always the potential of losing money when you invest in securities. Before investing, consider your investment objectives and Carbon Collective's charges and expenses. Carbon Collective's internet-based advisory services are designed to assist clients in achieving discrete financial goals. They are not intended to provide comprehensive tax advice or financial planning with respect to every aspect of a client's financial situation and do not incorporate specific investments that clients hold elsewhere. For more details, see our Form CRS, Form ADV Part 2 and other disclosures. Past performance does not guarantee future results, and the likelihood of investment outcomes are hypothetical in nature. Not an offer, solicitation of an offer, or advice to buy or sell securities in jurisdictions where Carbon Collective is not registered. © 2026 Carbon Collective Corporation. All rights reserved. × #### Fact Checked Carbon Collective partners with financial and climate experts to ensure the accuracy of our content. Our team of reviewers are established professionals with years of experience in areas of personal finance and climate. They have contributed to top tier financial publications, such as Reuters, Axios, Ag Funder News, Bloomberg, Marketwatch, Yahoo! Finance, and many others. This team of experts helps Carbon Collective maintain the highest level of accuracy and professionalism possible. × #### Why Trust Carbon Collective Carbon Collective is the first online investment advisor 100% focused on solving climate change. We believe that sustainable investing is not just an important climate solution, but a smart way to invest. We follow ethical journalism practices, which includes presenting unbiased information and citing reliable, attributed resources. Much of our research comes from leading organizations in the climate space, such as Project Drawdown and the International Energy Agency (IEA). Our goal is to deliver the most understandable and comprehensive explanations of climate and finance topics. Our writing and editorial staff are a team of experts holding advanced financial designations and have written for most major financial media publications. Our work has been directly cited by organizations including MarketWatch, Bloomberg, Axios, TechCrunch, Forbes, NerdWallet, GreenBiz, Reuters, and many others. We strive to empower readers with the most factual and reliable climate finance information possible to help them make informed decisions. } ```json { "@context" : "https://schema.org", "@type" : "Organization", "alternateName" : "Carbon Collective", "contactPoint" : { "@type" : "ContactPoint", "areaServed" : "US", "availableLanguage" : "en", "contactType" : "customer service", "telephone" : "(650) 868-2697" }, "logo" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png", "name" : "Carbon Collective Investing LLC", "sameAs" : [ "https://www.facebook.com/carboncollectiveinvesting/", "https://twitter.com/carbncollective", "https://www.instagram.com/carbon.collective/", "https://www.youtube.com/channel/UC769Y-F-L_B37kyQfdpvyXA", "https://www.linkedin.com/company/carbon-collective/", "https://www.crunchbase.com/organization/carbon-collective", "https://adviserinfo.sec.gov/firm/summary/310129", "https://www.wikidata.org/wiki/Q110243690" ], "url" : "https://www.carboncollective.co/" } ``` ```json { "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [{ "@type": "Question", "name": "What is an accounting worksheet?", "acceptedAnswer": { "@type": "Answer", "text": "An accounting worksheet is a document where all the company records are shown in one sheet in different columns." } },{ "@type": "Question", "name": "How do you write an accounting worksheet?", "acceptedAnswer": { "@type": "Answer", "text": "An accounting worksheet follows the following sequence: i. Revenue accounts are listed in the first column; ii. Expense accounts are listed in the second column; iii. Asset, liability, and equity accounts are listed according to chronological order; iv. All ledger balances (both primary and secondary) are posted to the unadjusted trial balance; v. Adjusting entries are then prepared for the company to account for revenue and expenses that have been earned but not yet received. This follows the accounting concept of match and accrual accounting; vi. After adjusting entries have been made, the ledger balances are recalculated and posted to a new adjusted trial balance report. This includes additional accounts such as depreciation expense, accumulated depreciation, prepaid rent, unearned income, etc. vii. The report concludes with the presentation of a company income statement and balance sheet for a specific period of time." } },{ "@type": "Question", "name": "What is the purpose of an accounting worksheet?", "acceptedAnswer": { "@type": "Answer", "text": "The main purpose of an accounting worksheet is to help identify any errors that could have been made in the accounting process. This is the first step you will take before preparing financial statements. For example, if a bookkeeper accidentally posts the wrong account as income, or if he is not sure about an entry and posts it as a temporary account to figure it out later, this mistake will be identified by the accounting worksheet. By doing so, you can fix these mistakes before they make their way into financial statements." } },{ "@type": "Question", "name": "Is an accounting worksheet a journal?", "acceptedAnswer": { "@type": "Answer", "text": "No, a worksheet is not a journal. Neither is it part of the general journal. Journal entries are for recording financial transactions, while an accounting worksheet is used to prepare adjusting entries. Closing entries are also included in the accounting worksheet." } },{ "@type": "Question", "name": "Is an accounting worksheet a permanent accounting record?", "acceptedAnswer": { "@type": "Answer", "text": "A worksheet is a temporary accounting record. It will be used to prepare adjusting entries that might need to be changed once the company receives more information. For example, if revenue has been recorded from a customer but payment has not been received yet, this information will need to be updated once the cash comes in. For this reason, a worksheet can be used to prepare at least two sets of financial statements." } }] } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "https://20345524.fs1.hubspotusercontent-na1.net/hubfs/20345524/Brooke%20Tomasetti.png", "url" : "https://www.carboncollectiveinvesting.com/sustainable-investing/author/brooke-tomasetti" }, "dateModified" : "2024-10-01", "datePublished" : "2021-03-24", "description" : "The accounting worksheet simplifies the process of creating financial statements for each accounting period. Click for more information.", "headline" : "Accounting Worksheet | Example, Benefits, Limitations, Preparation", "image" : "", "mainEntityOfPage" : { "@id" : "https://www.carboncollectiveinvesting.com/sustainable-investing/accounting-worksheet", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.carboncollective.co/hubfs/CarbonCollectiveLogo.png" }, "name" : "Carbon Collective" } } ```