Friday, April 25, 2008

Introduction To The Finance Module

From Dwayne Wright - Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com
TWITTER: dwaynewright

Most of us have used some version of a money management software package. I’ve used Quicken for years but I wanted more control, like to have my financial transactions to be linkable to my other business operations. As with most “shrink wrapped” software packages, your ability to customize screens, fields and operations can be very limited. In some cases, it appears that you have to adapt your business to fit the software package and it really should be the other way around. That is one of the many things that is so great about a solution designed with FileMaker Pro! The finance module currently has three main tabs. The first is transactions, which allow you to see all the transactions for an account. The second tab is for accounts such as checking accounts, credit cards, savings accounts, 401K accounts and the like. The third tab is for calculating a budget.


The Finance module allows you to enter in financial transactions that are linked to a particular account. Across the top of the screen, you will see a collection of buttons used to work with the current account. Here is a listing of the buttons and a quick description of what they do.

New Transaction - creates a regular new transaction for the account you are browsing. This transaction can be a withdrawal or a deposit of any kind.

New Check - creates a new check withdrawal transaction for the account you are currently browsing.

ATM Withdrawal - creates a new withdrawal record and automatically flags it as an ATM transaction for the account you are currently browsing.

Pre Authorized Credit - creates a pre authorized deposit record for the current account. I tend to use this to record successful batch deposit transactions.

Internet Payment - allows you to create a transaction (normally a payment) and flag it as an internet related account

New Deposit - creates a new deposit records for the currently browsed account.

Add Bank Fee - create a new withdrawal record and flags it as a bank fee.

Below the bank of transaction specific buttons is the account information section. This is the most basic information of an account such as the account name, type, main phone number and the accounts current balance. This view of basic account information is generally all you need as you work with a set of transactions. There is more detailed account record information can be found in the second tab, aptly named Accounts.

The lower tab panels hold the most important information for the entire finance transaction module. Here you can see the actual transactions that make up an account. You can see the Transaction Date, Check #, Description, Deduction or Deposit, Reconcile Cleared Indicator and Tax Type fields. There is a magnifying glass icon on one side of each listed record (to view the specifics of that transaction) and a trash can icon on the far right side of each transaction (to delete it).

Key Features Of The Finance Module
- Ability to link to multiple transactions
- Common transactions are button activated
- Ability to see not reconciled transactions
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

No comments: