A personal financial statement is a document, or set of documents, that outlines an individual’s financial position at a given point in time. It is usually composed of two sections – a balance sheet section and an income flow section. Although an individual can use more complex personal financial statements, this article will focus on a simple version. The format outlined in this article is a good starting point for individuals who are new to using personal financial statements to record their personal finances.
The Personal Balance Sheet
The balance sheet part of the personal financial statement lists the individual’s assets and liabilities, just as the balance sheet for a business lists all the assets and liabilities of the business.
The sample personal balance sheet shown above outlines John’s financial position as of August 8, 2017.
As can be seen from the balance sheet, John’s total assets are worth $353,600. His total liabilities are $260,500.
Thus, from analyzing the MS Excel balance sheet, we see John’s net worth is $93,100.
The simple format used above can be modified per an individual’s requirements. For instance, Bob might have 5 checking accounts, 5 savings accounts, 3 houses, and 3 cars. With a few modifications, the template used by John can also be used by Bob.
The Income Statement
Unlike the balance sheet, which lists out all stock variables affecting an individual’s financial position, the income statement lists out all flow variables affecting an individual’s financial position.
The sample personal income statement shown above lists John’s monthly income and expenses.
As can be seen from the income statement, John’s total monthly income is $12,000. His total monthly expenses are $9,350.
A combined view:
Why use a Personal Financial Statement?
A personal financial statement can be a very valuable tool in planning out one’s finances. It is usually goal-oriented and can help an individual reach his or her financial goals, especially for young professionals entering the workforce for the first time. Most of these people are new to financial planning and a simple personal financial statement is an easy place to start.
Why Create a Personal Financial Statement in MS Excel?
– It is easy to add entries, make changes, etc.
– Cloud services such as iCloud or Google Drive allow the user to access his or her financial statement remotely.
– As an individual gains experience regarding financial planning, he or she can make use of the tools offered by MS Excel for financial planning.
Download the Personal Financial Statement Template
Download the free Excel template now to advance your finance knowledge.
Thank you for reading CFI’s explanation of a personal financial statement. To learn more about finances, cash flows, and financial statements, see the following free CFI resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.