The formulas in these columns calculate the opening balance, total income & receipts, total expenses & payments, total contra transactions and the closing balance for each transaction source based on the date range that is defined by entering the appropriate Start Date and End Date. ![]() All the columns with a light blue column heading contain formulas that are automatically copied when a new row is added to the table. The template includes four default source codes but additional source codes can be created by simply entering a new source code in the first empty cell below the Excel table - the table will be extended automatically to include the new source code.Īfter entering a new transaction source code, users should also enter a unique description of the source code in column B. We recommend using an alphanumeric code when creating the required source codes and to use descriptive codes that make it easy to distinguish between different transaction sources. The source codes that are created on this sheet are then selected when recording transactions on the Transactions sheet. Reporting periods can be amended by simply changing the Start Date in cell C2 on the Sources sheet.Īs we mentioned before, an unlimited number of bank accounts and credit cards can be included in the template by simply creating a unique transaction source code for each account. All the calculations on this sheet are automated and the only user input that is required is to ensure that all the accounts that have been added to the Accounts sheet are included on the report. Report - this sheet includes a 12 month personal income & expenses report. Income should be recorded as positive values and expenses as negative values. Transactions can be recorded by entering the data or copying the data from a bank or credit card statement before pasting the data into the appropriate columns. Transactions - all personal income and expense transactions should be recorded on this sheet and allocated to the appropriate account by selecting an account code from the list box in column G. The reporting periods that are included in the 12 month personal finance report is also defined on this sheet by simply entering the appropriate Start Date in cell C2.Īccounts - this sheet includes the default accounts list and can be used to edit account descriptions and to add additional accounts to the default accounts list. This sheet also includes transaction totals that can be calculated by simply entering the appropriate Start Date and End Date. ![]() Sources - create a unique source code for each transaction source that you want to include in the template. The template consists of the following sheets: This template is the ideal solution for measuring household income and expenditure. Transactions can be recorded from an unlimited number of transaction sources like bank accounts and credit cards and the functionality that has been included in the template enables users to easily reconcile the reports to bank account or credit card statements. This template enables users to record their personal income & expenses and to generate a comprehensive personal finance report for any user defined 12 month period.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |