and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95
wwwwwp
5/4/00
<A Expense 4
} Expense 1
Expenses Information
Expenses Total
This section is used to define the names of the expense catagories. When you make a change, you have to click the
Save The Changes
Button. If you make a change but decide against submittng it, you can click the
Undo The Chages
button to bring it back to the previouse state. If a record already has expenses totals entered. If you change the name of the expense, it's possible the totals shown will reflect the wrong numbers. If you change the name of a record that already has totals, maB ke sure you re-run the numbers.
Save The Changes
ZA#Undo The Changes before being saved
Profit and Loss Define Expenses
Expense 11
3A Expense 9
Expense 10
5A Expense 8
6A Expense 7
7A Expense 6
8A Expense 3
9A Expense 2
Expense 20
;A Expense 5
Expense 19
Expense 17
Expense 18
Expense 16
Expense 14
Expense 13
Expense 15
Expense 12
(LIST
LISTAUJanuary
February
March
April
August
September
October
November
December
VDEFA(
(LIST
LISTA
Advertising
Cost of Goods
Direct Payroll
Indirect Payroll
Insurance
Interest On Loans
Entertainment
Office Expense
Other Expenses
Other Taxes
Phone
Postage
Professional Fees
Promotions
Sales Expenes
Shipping
Transportation
Travel
Utilities
VDEFA(
(LIST
LISTA
VDEFA(
(LIST
LISTAO1995
VDEFA(
her Income
Open Returns
Open Bad Debt
Open Expenses
Pro 2.0 - 2.1F!
Pro 3.0 - 4.1
USENGLSH.MPR Spelling
USER.UPR
Templates
FTwist and Shout:Desktop FoB0lder:NoFrills Business:Templates:PettyCsh.FM
Twist and Shout
PettyCsh.FM
FMPRFMPR
Templates
FTwist and Shout:Desktop For than incomeB
Sales ExpensesB
Entry
Auto Month
A Auto Year
Define Expenses
Tab 5
DEV: All Fields
PRINT: Entry
PRINT: Define Expenses
PRINT: Help
EntryB
d Shout:Desktop For than incomeB
Sales ExpensesB
Sales ExpensesB
RINT: Define Expenses
PRINT: Help
Open All
ABDG>>k <<
ABDE>>l <<
ABDF>>m <<
ABDD>>n <<
ABDB>>o <<
ABDA>>p <<
ABDC>>q <<
ABCP>>r <<
ABCO>>s <<
ABCM>>t <<
ABCN>>u <<
ABCL>>v <<
ABCK>>w <<
ABCJ>>x <<
ABCG>>y <<
ABCF>>z <<
ABDH>>{ <<
ABCI>>| <<
ABCH>>} <<
ABCE>>
Other Income Total
Interest Total
Bad Debt Total
Returns Total
Sales Total
Q Run Date
Income Information
Expenses Information
Profit & Loss Totals
Income Total
Expenses Total
Net Income
Income Tax
After Tax Net Income
Period
ACIAAB>>
ACIAAC>>
ACIAAD>>
ACIAAE>>
ACIAAF>>
ACIAAG>>
ACIAAI>>
| New Entry
} Find Mode
~ Main Menu
Go / Do
List ViewA*
Print
Reports
incomeB
Sales ExpensesB
OPS: Opening Script
OPS: Go/Do Master
OPS: Set All Tabs To Dark Gray
OPS: New Record
[sub] New Record
OPS: Find Record
)OPS: Expense Change Entered Not Submitted
OPS: Submit Change
OPS: Reset Change
&OPS: Shouldn't Change Existing Records
OPS: Open All
NAV: Main Menu
NAV: Help
NAV: List View
NAV: Bring Payments To The Front
NAV: Bring Expenses To The Front
[sub] Run It
NAV: Go To Tab 1
NAV: Go To Tab 2
NAV: Go To Tab 3
NAV: Go To Tab 4
NAV: Go To Tab 5
NAV: Go To Tab 6
Run It (for Month / Year)
[sub] Payment Totals
[sub] Interest Totals
[sub] Returns Totals
[sub] Other Income Totals
[sub] Bad Dept Totals
[sub] Expense 1 Totals
[sub] Expense 2 Totals
[sub] Expense 3 Totals
[sub] Expense 4 Totals
[sub] Expense 5 Totals
[sub] Expense 6 Totals
[sub] Expense 7 Totals
[sub] Expense 8 Totals
[sub] Expense 9 Totals
[sub] Expense 10 Totalsotals
11 Totals
AGREE
BAD DEBT TOTAL
DARKGRAYTAB
ENTRY MONTH YEAR
: EXPENSE 1
EXPENSE 1 TOTAL
EXPENSE 10
EXPENSE 10 ENTRY MONTH YEAR
EXPENSE 10 ENTRY YEAR
EXPENSE 10 TOTAL
EXPENSE 11
EXPENSE 11 ENTRY MONTH YEAR
EXPENSE 11 ENTRY YEAR
EXPENSE 11 TOTAL
EXPENSE 12
EXPENSE 12 ENTRY MONTH YEAR
EXPENSE 12 ENTRY YEAR
EXPENSE 12 TOTAL
EXPENSE 13
EXPENSE 13 ENTRY MONTH YEAR
EXPENSE 13 ENTRY YEAR
EXPENSE 13 TOTAL
EXPENSE 14
EXPENSE 14 ENTRY MONTH YEAR
EXPENSE 14 ENTRY YEAR
EXPENSE 14 TOTAL
EXPENSE 15
EXPENSE 15 ENTRY MONTH YEAR
EXPENSE 15 ENTRY YEAR
EXPENSE 15 TOTAL
EXPENSE 16
EXPENSE 16 ENTRY MONTH YEAR
EXPENSE 16 ENTRY YEAR
^ENTRY YEAR
^NTRY MONTH YEAR
EXPENSE 16 ENTRY YEAR
EXPENSE 18
EXPENSE 18 ENTRY MONTH YEAR
EXPENSE 18 TOTAL
EXPENSE 19
EXPENSE 19 ENTRY MONTH YEAR
EXPENSE 19 TOTAL
EXPENSE 2
EXPENSE 2 ENTRY MONTH YEAR
EXPENSE 2 ENTRY YEAR
Helvetica
Geneva
eWorld Tight
Aplgaram
Zapf Dingbats
Zapf Chancery
Woodtype Ornaments 1
Wingdings
Trajan
Times New Roman
Espy Sans Bold
Espy Sans
Delphian
Courier
Cooper Black
Charcoal
Times
Arial
YyTt@
NnFf.N
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
Profit and Loss 2.0 is a FileMaker template that allows you to link up to whatever FileMaker created sales and expense tracking system you have and run your reports with ease! It uses a modular set of scripts, fields and relationships so you can link it to almost any FileMaker designed system. In this document we will explain how to use Profit and Loss to the already linked example files. We will start with the buttons, then the interactive pop down list, then the navigation TABs and the
elements on those TABs.
ABOUT THE BUTTON BAR
A button bar is available on the top of each Profit and Loss screen. The selection are New, Delete, Find, List, Print, Invoices, Expenses and Register. Most of these require no further discussion except possibly the last three. Invoices goes to that module in list format. Expenses goes to that module in list format. When you register the database, you may Register goes to a screen where you can enter in your registration information for purcha
FPTHATHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Register.FP3
MSPCA
NAMEA
Register.FP3
RPTHA
Register.FP3
Hard Disk
Register.FP3
FMP3FMP3
Profit & Loss 2.0
THard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Register.FP3
uring information)
Clicking the third TAB titled
Auto Year
takes you to a screen that allows you to select the totals for each field for a particular year. This will then go out to the linked databases and capture the appropriate totals and display them on an individual record here. The data is not
related
to the associated files. They will not update if the information is changed in that file. Instead the totals represented are a snapshot
DEFINE EXPENSES TAB (for expense capture clas
sification)
Clicking the fourth TAB titled
Define Exp
and takes you to a screen that allows define the names of the expenses you want to capture. The names of the expenses has to match perfectly the names of the individual expenses in your expenses module. This is key to building the expense total capturing relationship. After you have made the changes, you need to click the
Save The Changes
button. Since the names have to be perfect, if you have not clicked the
Save The Changes
nses you want to capture. The names of the expenses has to match perfectly the names of the individual expenses in your expenses module. This is key to building the expense total capturing relationship. After you have made the changes, you need to click the
Save The Changes
button. Since the names have to be per
Define ExpensesB
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
Tab 5B
sing this product.
INTERACTIVE DO POP DOWN LIST
To the right of the button bar, you will see the Interactive Do area. The instructions are simple. You make a choice from the pop down menu, then click the
button and it does. This is great for folks that want to add a list of macros that can work across the entire database system or unique to a particular screen. Editing does require registration and ownership of a copy of FileMaker Pro by FileMaker Inc.
DRILL DOWN DETAILS
Another ni
ce feature of Profit and Loss 2.0 is the ability to drill down to examine the records that make up one of the totals. If the total for an income or expense area is greater than zero, you can click it
s name and drill down to the individual records in the related file. For example on the test record, you will see an advertising expense of $55.60. Click on the words
Advertising
to see each individual records that made up that total!
Checking out the specific screens are done by clicking t
See Related Expenses20
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
jA NAV: Bring Payments To The Front
s To The Front
Expense 19
Expense 17
Expense 18
Expense 16
Expense 14
Expense 13
Expense 15
Expense 12
Cost Of Goodse
Sales Expensesf
Shippingg
Direct Payrollh
Indirect Payrolli
Postagej
Advertisingk
Promotionsl
Travelm
Office Expensen
Entertainmento
Phonep
Transportationq Insurancer Utilitiess
Professional Feest
Interest On Loansu
Rentv
Other Expensesw
Other Taxes
Cost Of Goods
Office Equip
Software
Payroll
Shipping
Postage
Advertising
Bank Fee
Travel
Office Expense
Industry Pub
Phone
Online Fee
s Insurance
t Utilities
Professional Fees
Interest On Loans
Other Expenses
Other Taxes
|axes
||Taxes
|axes
|axes
|The Profit & Loss Totals section contains the Net Income Total (Income - Expenses), Income Tax and Grand Total.
Cost Of Goodse
Sales Expensesf
Shippingg
Direct Payrollh
Indirect Payrolli
Postagej
Advertisingk
Promotionsl
Travelm
Office Expensen
Entertainmento
Phonep
Transportationq Insurancer Utilitiess
Professional Feest
Interest On Loansu
Rentv
Other Expensesw
Other Taxes
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
This section is used to define the names of the expense catagories. When you make a change, you have to click the
Save The Changes
Button. If you make a change but decide against submittng it, you can click the
Undo The Chages
button to bring it back to the previouse state. If a record already has expenses totals entered. If you change the name of the expense, it's possible the totals shown will reflect the wrong numbers. If you change the name of a record that already has totals, maB ke sure you re-run the numbers.
Save The Changes
ZA#Undo The Changes before being saved
Save The Changes
ZA#Undo The Changes before being saved
Save The Changes
ZA#Undo The Changes before being saved
LA NAV: Help
See Related Sales
t tosses up a dialog box and exits the script.
If there are related records, it goes to them and goes to a list format in that database and brings that window into the foreground.B9
c = "Month / Year"
Month / Year
() < 1
Cancel
There does not seem to be any related records to go to.E)
c = "Year"
)) < 1
SRPTH
FPTHASHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Returns.FP3
MSPCA
NAMEA
Returns.FP3
RPTHA
Returns.FP3
Hard Disk
Returns.FP3
ckFMP3FMP3
Profit & Loss 2.0
SHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Returns.FP3
TRPTH
See Related Sales
!See Related Interest Transcations
%See Related Other Income Transcations
See Related Returns
!See Related Bad Debt Transactions
See Related Expenses1
See Related Expenses2
See Related Expenses3
See Related Expenses4
See Related Expenses5
See Related Expenses6
See Related Expenses7
See Related Expenses8
See Related Expenses9
See Related Expenses10
See Related Expenses11
See Related Expenses12
See Related Expenses13
See Related Expenses14
See Related Expenses15
See Related Expenses16
See Related Expenses17
See Related Expenses18
See Related Expenses19
See Related Expenses20
PRINT: P&L
PRINT: Define Expenses
PRINT: Help
[sub] Expense 12 Totals
[sub] Expense 13 Totals
[sub] Expense 14 Totals
[sub] Expense 15 Totals
[sub] Expense 16 Totals
[sub] Expense 17 Totals
[sub] Expense 18 Totals
[sub] Expense 19 Totals
[sub] Expense 20 Totals
5A Expense 8
6A Expense 7
7A Expense 6
8A Expense 3
9A Expense 2
Expense 20
;A Expense 5
<A Expense 4
} Expense 1
<A Expense 4
Expense 11
3A Expense 9
Expense 10
Other Income Total
Interest Total
Bad Debt Total
Returns Total
Sales Total
For Month of
Made By
Date
Income Information
Expenses Information
Profit & Loss Totals
Income Total
Expenses Total
Net Income
Income Tax
After Tax Net Income
Define Exp
About / Reg
| Auto Year
Auto Month
Profit & Loss
Print
IPick the option you want to do or go to. Then click the yellow Do button.
Delete
Register
Invoices
Expenses
FPTHATHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:OtherInc.FP3
MSPCA
NAMEA
OtherInc.FP3
RPTHA
OtherInc.FP3
Hard Disk
OtherInc.FP3
ckFMP3FMP3
Profit & Loss 2.0
THard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:OtherInc.FP3
FPTHATHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Interest.FP3
MSPCA
NAMEA
Interest.FP3
RPTHA
Interest.FP3
Hard Disk
Interest.FP3
ckFMP3FMP3
Profit & Loss 2.0
THard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Interest.FP3
TRPTH
FPTHATHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Interest.FP3
MSPCA
NAMEA
Interest.FP3
RPTHA
Interest.FP3
Hard Disk
Interest.FP3
ckFMP3FMP3
Profit & Loss 2.0
THard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Interest.FP3
SRPTH
FPTHASHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:BadDebt.FP3
Hard Disk
BadDebt.FP3
ckFMP3FMP3
Profit & Loss 2.0
SHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:BadDebt.FP3
MSPCA
NAMEA
BadDebt.FP3
RPTHA
BadDebt.FP3
Hard Disk
BadDebt.FP3
ckFMP3FMP3
Profit & Loss 2.0
SHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:BadDebt.FP3
TRPTH
FPTHATHard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Expenses.FP3
MSPCA
NAMEA
Expenses.FP3
RPTHA
Expenses.FP3
Hard Disk
Expenses.FP3
ckFMP3FMP3
Profit & Loss 2.0
THard Disk:Desktop Folder:LMS Backup:January Additions:Profit & Loss 2.0:Expenses.FP3
A change was made to one of the expense account titles but it has not be submitted. Do you want to submit the change, reset the title or simply continue.C+
) = 1
) = 2
) = 3
(LIST
LISTA`Open All
Open Invoice
Open Interest
Open Other Income
Open Returns
Open Bad Debt
Open Expenses
VDEFA(
MonthB
ExpensesC
Month ChoiceD
Year ChoiceE
Go/Do Master
FMRLA
d = "Open All"
Open All
d = "Open Invoice"
Open Invoice
d = "Open Interest"
Open Interest
d = "Open Other Income"
Open Other Income
d = "Open Returns"
Open Returns
d = "Open Bad Debt"
Open Bad Debt
d = "Open Expenses"
Open Expenses
[sub] Expense 9 Totals
[sub] Expense 10 Totals
[sub] Expense 11 Totals
[sub] Expense 12 Totals
[sub] Expense 13 Totals
[sub] Expense 14 Totals
[sub] Expense 15 Totals
[sub] Expense 16 Totals
[sub] Expense 17 Totals
ACIAAB>>
ACIAAC>>
ACIAAD>>
ACIAAE>>
ACIAAF>>
ACIAAG>>
ACIAAI>>
f New Entry
g Find Mode
h Main Menu
Go / Do
List View
See Related Expenses18
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses19
Month!!
Yearel)))
Cancel)
ZProfit and Loss creates new records from either the Auto Month or the Auto Year screens. Which would you like to go to?B+
) = 1
) = 2
) = 3
OPS: Find Record
8 = "1"
"January"
8 = "2"
"February"
8 = "3"
"March"
8 = "4"
"April"
8 = "5"
"May"
8 = "6"
"June"
8 = "7"
"July"
8 = "8"
"August"
8 = "9"
"September"
8 = "10"
"October"
8 = "11"
"November"
"December")
& " " &
January
February
March
April
August
September
OctoB(ber
November
December
"Entered"
EnteredG.
"Month / Year"
Month / YearH
& " " &
January
February
March
April
August
September
OctoB(ber
November
December
"Entered"
EnteredG.
"Month / Year"
Month / Year
[sub] Payment Totals
[sub] Interest Totals
[sub] Returns Totals
[sub] Other Income Totals
[sub] Bad Dept Totals
[sub] Expense 7 Totals
[sub] Expense 1 Totals
[sub] Expense 2 Totals
[sub] Expense 3 Totals
Payment Month YearB
Interest Month YearC
Returns Month YearD
Other Income Month YearE
BadDebt Month YearF
Expense7 Month YearG
Expense1 Month YearH
Expense2 Month YearI
Expense3 Month YearJ
Expense4 Month YearK
Expense8 Month YearL
Expense5 Month YearM
Expense6 Month YearN
Expense9 Month YearO
Expense10 Month YearP
Expense11 Month YearQ
Expense12 Month YearR
Expense13 Month YearS
Expense14 Month YearT
Expense15 Month YearU
Expense16 Month YearV
Expense17 Month YearW
Expense18 Month YearX
Expense19 Month YearY
Expense20 Month YearZ
Payment Year[
Interest Year\
Returns Year]
Other Income Year^
BadDebt Year_
Expense1 Year`
Expense2 Yeara
Expense3 Yearb
Expense4 Yearc
Expense5 Yeard
Expense6 Yeare
Expense7 Yearf
Expense8 Yearg
Expense9 Yearh
Expense10 Yeari
Expense11 Yearj
Expense12 Yeark
Expense13 Yearl
Expense14 Yearm
Expense15 Yearn
Expense16 Yearo
Expense17 Yearp
Expense18 Yearq
Expense19 Yearr
Expense 20 Year
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
Cancel
You must define a month to capture.C
Cancel
You must define a Year to capture.
8 = "1"
"January"
8 = "2"
"February"
8 = "3"
"March"
8 = "4"
"April"
8 = "5"
"May"
8 = "6"
"June"
8 = "7"
"July"
8 = "8"
"August"
8 = "9"
"September"
8 = "10"
"October"
8 = "11"
"November"
"December")
& " " &
January
February
March
April
August
September
OctoB(ber
November
December
"Entered"
Entered
5210.52^
-4138.52`
-4138.52a
Dwayne Wright
Month / Year
Entered
2/2/99B July 1998C
1072D
1072I
18.5O
1113Q
119.97S
65.25U
21.25V
49.95X
1000Z
24.65\
49.95]
5210.52^
-4138.52`
-4138.52a
Dwayne Wright
Month / Year
Entered
2/2/99B July 1998C
1072D
1072I
18.5O
1113Q
119.97S
65.25U
21.25V
49.95X
1000Z
24.65\
49.95]
5210.52^
-4138.52`
-4138.52a
Dwayne Wright
Month / Year
Entered
2/10/99B
March 1997C
Dwayne Wright
Month / Year
Entered
2/10/99B
1997C
11191.27D
203.75E
152.8125F
101.875G
101.875H
11038.4575I
75.25P
892.5Q
405.64S
471.57V
2149.46^ 8888.9975` 8888.9975a
Dwayne Wright
3/4/2000a
Dwayne Wright
3/4/2000a
Dwayne Wright
3/4/2000B
December 1996C
SOFTWARE LICENSE AGREEMENT - PLEASE READ THIS LICENSE CAREFULLY BEFORE USING THE ENCLOSED FILEMAKER TEMPLATE. BY USING THIS PRODUCT, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE. IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THIS PRODUCT AND DELETE IT FROM YOUR SYSTEM.
The enclosed template is licensed, not sold, to you by Dwayne Wright - LeSaux Media Services (
Author
) for use only under the terms of this License, and Author reserves any rights not expressl
y granted to you. You own the floppy disk, if you purchased the template in that manner, on which the template is recorded or fixed, but Author and its licensors retain ownership of the enclosed product. Only those users that have paid the complete registration fee for the associated database is allowed access to field creation, field modification, scripting or relationship setting access. The locked password with these templates can only be acquired from LeSaux Media Services. Any acqui
FPTHA>iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:BadDebt.FP3
MSPCA
NAMEA
BadDebt.FP3
RPTHA
BadDebt.FP3
alisA
iMac Main
BadDebt.FP3
oLFMP3FMP3
Files
>iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:BadDebt.FP3
FPTHA?iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:Expenses.FP3
NAMEA
Expenses.FP3
Expense 12 TotalB
Expense 15 TotalB
Expense 13 TotalB
Expense 14 TotalB
Expense 16 TotalB
Expense 18 TotalB
Expense 17 totalB
Expense 19 TotalB
Total ExpensesB
Net IncomeB
Income TaxB
Net Income after taxB
Made ByB
HelpB
$A Expense 1B
%A Expense 2B
obalB
HelpB
$A Expense 1B
%A Expense 2B
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
65.25]
2490.72^
-1418.72`
-1418.72a
Dwayne Wright
1/10/99C
1072D
1072I
18.5O
1113Q
119.97S
Expense 6 Entry Month YearB
Expense 9 Entry Month YearB
Expense 10 Entry Month YearB
Expense 11 Entry Month YearB
Expense 12 Entry Month YearB
Expense 13 Entry Month YearB
Expense 14 Entry Month YearB
Expense 15 Entry Month YearB
Expense 16 Entry Month YearB
{A&OPS: Shouldn't Change Existing Records
{ = 1
Cancel
Continue
This record already has expenses totals entered. If you change the name of the expenses, it's possible the totals will reflect the wrong totals. Be sure to run the totals again if you are going to continue.C+
) = 1
) = 2
OPS: Open All
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
See Related Returns
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
TA!See Related Bad Debt Transactions
Expense 17 Entry Month YearB
Expense 18 Entry Month YearB
Expense 19 Entry Month YearB
Expense 20 Entry Month YearB
Expense1 Entry YearB
Expense 2 Entry Year B
Expense 3 Entry YearB
Expense 4 Entry YearB
Expense 5 Entry Year B
Expense 6 Entry YearB
[sub] Expense 14 Totals
[sub] Expense 15 Totals
[sub] Expense 16 Totals
[sub] Expense 17 Totals
[sub] Expense 18 Totals
[sub] Expense 19 Totals
[sub] Expense 20 Totals
z = 1
Submit
e18 Month Year
Resetle19 Month Year
Expense2
Continueear
Invoice Year
A change was made to one of the expense account titles but it has not be submitted. Do you want to submit the change, reset the title or simply continue.C+
) = 1
) = 2
) = 3
OPS: Submit Change
See Related Expenses12
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses13
Expense 18 Entry YearB
Expense 19 Entry YearB
Expense 20 Entry YearB
Run TypeB
Go Do GlobalB
Record Status TypeB
Set Expense 1B
Set Expense 2B
Set Expense 3B
Set Expense 4B
Set Expense 5B
Set Expense 6B
Set Expense 7B
Set Expense 8B
Set Expense 9B
Set Expense 9B
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
RA%See Related Other Income Transcations
EXPENSE 9 TOTAL
!EXPENSE CHANGE ENTERED UNSUBMITED
EXPENSE1 ENTRY MONTH YEAR
EXPENSE1 ENTRY YEAR
GLOBALTABPICTURE
GO DO GLOBAL
INCOME TAX
INCOME TOTAL
INTEREST TOTAL
LICENSE
LIGHTGRAYTAB
MADE BY
MONTH CHOICE
NET INCOME
NET INCOME AFTER TAX
NO EXPENSES ENTERED
OTHER INCOME TOTAL
RECORD COMMENTS
RECORD STATUS
RECORD STATUS TYPE
REPORT RUN INFO
RETURNS TOTAL
RUN TYPE
SALES TOTAL
SET EXPENSE 1
SET EXPENSE 10
SET EXPENSE 11
SET EXPENSE 12
SET EXPENSE 13
SET EXPENSE 14
SET EXPENSE 15
SET EXPENSE 16
SET EXPENSE 17
SET EXPENSE 18
SET EXPENSE 19
SET EXPENSE 2
SET EXPENSE 20
SET EXPENSE 3
SET EXPENSE 4
SET EXPENSE 5
SET EXPENSE 6
SET EXPENSE 7
SET EXPENSE 8
SET EXPENSE 9
TAB1NAME
TAB2NAME
TAB3NAME
TAB4NAME
TAB5NAME
TAB6NAME
TOTAL EXPENSES
YEAR CHOICE
See Related Expenses16
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses17
Dwayne Wright
Month / Year
Entered
A 3/19/2000B
December 1999C
157.56V
157.56^
-157.56`
-157.56a
Dwayne Wright
Month / Year
Entered
A 3/19/2000B
1999C
1203.15Q
254.32S
181.62T
335.54V
444.9Z
106.72]
2526.25^
-2526.25`
-2526.25a
Dwayne Wright
A 4/28/2000B
2000C
868.166666666666D
868.166666666666I
166.75M
166.75[
166.75\
4.75]
299.166666666666`
299.166666666666a
Dwayne Wright
A 4/28/2000B
April 2000C
Dwayne Wright
Month / Year
Entered
A 4/28/2000B
April 2000C
868.166666666666D
868.166666666666I
850.166666666666
EXPENSE 16 TOTAL
EXPENSE 17
EXPENSE 17 ENTRY MONTH YEAR
EXPENSE 17 ENTRY YEAR
EXPENSE 17 TOTAL
EXPENSE 18
EXPENSE 18 ENTRY MONTH YEAR
EXPENSE 18 ENTRY YEAR
EXPENSE 18 TOTAL
EXPENSE 19
EXPENSE 19 ENTRY MONTH YEAR
EXPENSE 19 ENTRY YEAR
EXPENSE 19 TOTAL
EXPENSE 2
EXPENSE 2 ENTRY MONTH YEAR
EXPENSE 2 ENTRY YEAR
EXPENSE 2 ENTRY YEAR
OPS: Reset Change
No Expenses EnteredB
LicenseB
AgreeB
GlobalTabPictureB
DarkGrayTabB
LightGrayTabB
Tab1Name
LicenseB
AgreeB
GlobalTabPictureB
DarkGrayTabB
LightGrayTabB
Tab1NameureG
Run It (Year)
Cancel
You must define a Year to capture.C
"Year"
YearE
sub] Returns Totals
[sub] Other Income Totals
[sub] Payment Totals
[sub] Interest Totals
[sub] Returns Totals
[sub] Other Income Totals
sub] Interest Totals
[sub] Returns Totals
[sub] Other Income Totals
ACIAAB>>
ACIAAC>>
ACIAAD>>
ACIAAE>>
ACIAAF>>
ACIAAG>>
ACIAAI>>
h New Entry
i Find Mode
j Main Menu
Go / Do
List View
Payments
Expensesncome Information
Sales Total
Returns Total
Bad Debt Total
Interest Total
Other Income Total
Income Total
ABCE>>
ABCH>>
ABCI>>
ABDH>>
ABCF>>
ABCG>>
ABCJ>>
ABCK>>
ABCL>>
ABCN>>
ABCM>>
ABCO>>
ABCP>>
ABDC>>
ABDA>>
ABDB>>
ABDD>>
ABDF>>
ABDE>>
ABDG>>
Expenses Information
Expenses Total
Profit & Loss Totals
Net Income
Income Tax
After Tax Net Income
Period
Record Notes or Comments
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
[sub] Bad Dept Totals
[sub] Expense 1 Totals
[sub] Expense 2 Totals
[sub] Expense 3 Totals
[sub] Expense 4 Totals
[sub] Expense 5 Totals
[sub] Expense 6 Totals
[sub] Expense 7 Totals
[sub] Expense 8 Totals
red access to these areas from other sources than LeSaux Media Services is a breach of this software license and this product must be removed from your system immediately.
1. License. This License allows you to use this template with an authorized copy of the FileMaker Pro application software or FileMaker Pro Runtime User application if distributed in that manner. To
the enclosed template means that templates are either loaded in the temporary memory (i.e., RAM) of a computer or
installed on the permanent memory of a computer (i.e., hard disk, etc.). You may make an additional copy of these templates for backup purposes. Furthermore, if you have more than one authorized copy of the FileMaker Pro application, you may use the template on any machine in the immediate office - one copy for each authorized copy of FileMaker Pro .
The Licensee agrees that:
1. the Licensee will not copy the template except as necessary to run the template on each computer in the imm
850.166666666666a
Dwayne Wright
Month / Year
Entered
5/2/2000B
May 2000C
Dwayne Wright
Month / Year
Entered
5/2/2000B
May 2000C
Dwayne Wright
Month / Year
Entered
FMRLA
FMRLA
FMRLA
FMRLA
FMRLA
This script first does a count for related records. If there are none, it tosses up a dialog box and exits the script.
If there are related records, it goes to them and goes to a list format in that database and brings that window into the foreground.B9
c = "Month / Year"
Month / Year
() < 1
Cancel
There does not seem to be any related records to go to.E)
c = "Year"
)) < 1
Cancel
There does not seem to be any related records to go to.
QA!See Related Interest Transcations
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses14
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses15
DEV: All FieldsB
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
ediate office
2. the Licensee will not copy the documentation except for inter-office use
3. the Licensee will not transfer to another party except as authorized by LeSaux Media Services in writing
4. the Licensee will not reverse engineer or disassemble the template to be marketed as a separate FileMaker template product
5. the Licensee wlll not remove or obsure any copyright or trademark notices on the software or documentation
6. Licensee will pay the registration fee if the product is
used regularly over the first 30 day trial period
2. Restrictions.
(a) WITHOUT LIMITATION, YOU MAY NOT USE, COPY, MODIFY OR DISTRIBUTE LESAUX FILEMAKER TEMPLATE PRODUCTS FOR USE IN ANY OTHER WAY THAN INTEROFFICE USE WITHOUT WRITTEN PERMISSION FROM DWAYNE WRIGHT OR LESAUX MEDIA SERVICES. EXCEPT AS SPECIFICALLY SET FORTH IN THIS LICENSE, YOU MAY NOT OTHERWISE USE, COPY, MODIFY, DISTRIBUTE, ADAPT, TRANSLATE, RENT, LEASE, LOAN, RESELL FOR PROFIT, DISTRIBUTE, OR CREATE DERIVATIVE WORKS BA
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
SED UPON A LESAUX FILEMAKER TEMPLATE OR ANY PORTION OF A LESAUX FILEMAKER TEMPLATE WITHOUT WRITTEN PERMISSION FROM DWAYNE WRIGHT OR LESAUX MEDIA SERVICES.
(b) Each LeSaux FileMaker template is protected by copyright law. As an express condition of this License, you must reproduce on each copy the Authors copyright notice and any other proprietary legends that were on the original copy supplied by the Author.
3. Termination. This License is effective until terminated by LeSaux Media
Services or Dwayne Wright. This License will terminate immediately without notice from the Author or judicial resolution if you fail to comply with any provision of this License. Upon such termination you must destroy this LeSaux FileMaker template, all accompanying written materials, and all copies thereof. You may also terminate this License at any time by destroying this LeSaux FileMaker template, all accompanying written materials and all copies thereof.
4. Limited Warranty and D
NAMEA
Main.FP3
RPTHA
Main.FP3
Stuff (1)
Main.FP3
FMP3FMP3
Fund Raiser BETA
#Stuff (1):Fund Raiser BETA:Main.FP3
Dwayne Wright
s Computer
Stuff (1)
Dwayne Wright
&RPTH
FPTHA&Stuff (1):Fund Raiser BETA:Payment.FP3
MSPCA
Stuff (1)
Payment.FP3
FMP3FMP3
Fund Raiser BETA
&Stuff (1):Fund Raiser BETA:Payment.FP3
Dwayne Wright
s Computer
Stuff (1)
Dwayne Wright
isclaimer, Limitation of Remedies and Damages. EVERY LESAUX FILEMAKER TEMPLATE IS LICENSED
AS IS.
THE AUTHOR EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN THE EVENT THAT ANY WARRANTY IS IMPOSED BY LAW, AUTHOR
S ENTIRE LIABILITY AND YOUR SOLE AND EXCLUSIVE REMEDY FOR ANY WARRANTY WILL BE, AT THE AUTHORS
OPTION, REPLACEMENT OF THE SHIPPED MEDIA, REFUND OF THE PURCHASE PRICE, OR REPAIR/
REPLACEMENT OF THE PARTICULAR LESAUX FILEMAKER TEMPLATE.
5. Limitation of Remedies and Damages. In no event will the Author, or any of the licensors, directors, officers, employees or affiliates of any of the foregoing be liable to you for any consequential, incidental, indirect or special damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information and the like), whether foreseeable or unforeseeable, arisin
g out of the use of or inability to use the Solutions or accompanying written materials, regardless of the basis of the claim and even if the Author or a Author's representative has been advised of the possibility of such damage. Author
s liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the money paid for this LeSaux FileMaker template that caused the damages.
Profit & Loss
Auto Month
Auto Year
Define Expense
About / Help
See Related Expenses10
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses11
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
he TABs underneath the button bar.
PROFIT AND LOSS TAB (for viewing)
Clicking the first TAB titled
Profit and Loss
takes you to a screen that allows you to see totals for sales, returns, bad debts, expenses and their combined overall totals (which is basically the total of combining various totals). This screen is for viewing records only. You can see for which period of time the report was run for, who ran the report and the actual date the report was run. Another nice
AUTO MONTH TAB
(for capturing information)
Clicking the second TAB titled
Auto Month
takes you to a screen that allows you to select the totals for each field for a particular month and year. This will then go out to the linked databases and capture the appropriate totals and display them on an individual record here. The data is not
related
to the associated files. They will not update if the information is changed in that file. Instead the totals represented are a snapshot
AUTO YEAR TAB (for capt
NAV: List View
OPS: Set All Tabs To Dark Gray
ACIAAC>>
ACIAAD>>
ACIAAE>>
ACIAAF>>
ACIAAG>>
ACIAAI>>
New Entry
Find Mode
Main Menu
Go / Do
List View
Payments
Expenses
Income Information
Payment Total
Returns Total
Bad Debt Total
Interest Total
Other Income Total
Income Total
Expenses Information
Profit & Loss Totals
Net Income
Income Tax
After Tax Net Income
ABCE>>
ABCH>>
ABCI>>
ABDH>>
ABCF>>
ABCG>>
ABCJ>>
ABCK>>
ABCL>>
ABCN>>
ABCM>>
ABCO>>
ABCP>>
ABDC>>
ABDA>>
ABDB>>
ABDD>>
ABDF>>
ABDE>>
ABDG>>
Expenses Total
A Auto YearB
See Related Expenses8
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
See Related Expenses9
c = "Month / Year"
Month / Year
) < 1
Cancel
There does not seem to be any related records to go to.D)
c = "Year"
) < 1
Cancel
There does not seem to be any related records to go to.
alisA
iMac Main
Register.FP3
oLFMP3FMP3
Files
?iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:Register.FP3
>RPTH
FPTHA>iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:Returns.FP3
MSPCA
NAMEA
Returns.FP3
RPTHA
Returns.FP3
alisA
iMac Main
Returns.FP3
oLFMP3FMP3
Files
>iMac Main:Desktop Folder:Profit & Loss 2.0.2:Files:Returns.FP3