Personal Finance Manager Software (Beta) for Microsoft® Excel®

Transactions 2

This sheet is where you maintain/add the actual income and expenditure you have recorded in the current year.  You can type all these details in from your paper bank statement but it is easier to download data from an online bank account.  If your online bank account allows you to download a QIF file (the file extension is .qif) you can import the file and automatically add the transactions to this application.  Simply save the bank statement file to the hard drive on your computer.  Click the button at the top of this sheet, browse to the file and click ‘Open’.

If your bank statement data is in another format that you can edit with Microsoft Excel then you can prepare this first in another Excel file and copy to this sheet, just make sure your columns are set correctly before you paste the data.

Below are definitions of each of the columns to be completed:

Date: the date of the transaction shown in the format day-month-year

Transaction Reference: can be any text you want but usually used for the transaction description on your bank statement.

Explanation 1: Type any of your own comments here.

Value: The value of the transaction shown to 2 decimal places.  Minus figures represent income and positive numbers are expenditure.

Min Cat: select from a list of minor category codes you have set up in the Plan by Period sheet.

Maj Cat: This is populated automatically and shows the major category of the transaction based on your Min Cat selection.  This will show as ‘#N/A’ when the minor category selection is not recognised, you will need to reselect the minor category.

Period: The period that relates to the transaction date.  This is populated automatically from the date used in column A.  If you see the error message ‘#N/A’ in this column then you know the date is before the range specified on the ‘Periods’ sheet.  Adjust the period ranges if you want to include these transactions in the reports and analysis.

Important Notes:

You cannot have gaps in your list of transactions.

All transactions must have a date.

Using the cut and paste functions can stop the file working properly.

Copy and paste should only be used within the same columns.

You should only have values in column D.

You will need to select a Min Cat  for each transaction before you can complete the sheet.

Help for this application:

| General | Main Menu | Periods | Major Categories | Minor Categories and Plan | Import Transactions | Income/Expense Analysis | Actual and Forecast | Transaction Reporting |

All pages and downloads Copyright © 2006 Spreadsheets for Finance

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.