Dues and
subscriptions
Partial,
interim receipts
Professional
retainers
Any income over a term
Scroll down for
Highlights
Price page with free demo.
Evaluate the live
software right now.
Sample
records.
Your records.
Hard to find
(including custom)
GAAP
Amortization
Software to run on a
PC,
Network sharing or
Cloud based system
supporting Windows
Supports all of these
Amortization Recognition
Methods:
Method
1=Straight Line: 30 day
financial months. Same
amount each month. Any
odd amount is taken in
the first month.
1,200.00 over 12 months
= 100.00 per month.
7=Begin Date TO
Review/Maturity Date:
All months are 360 day
basis (internally, a
date of the 31st is
changed to the 30th).
Partial first month and
partial last month
recognition supported.
Any odd amount may be
taken in first and/or
final month. Begin Date
is included.
Review/Maturity Date is
TO, not Through. If
dates are the same,
nothing will be
recognized.
For Half Month
convention: Set Begin
Date to 16th. For a 12
month term, set
Review/Maturity Date to
1st of the month
following the 12th
month. For "in service"
period of one year, set
Review/Maturity Date to
the 16th of the Begin
Date month plus 1 year.
3=Begin Date TO
Review/Maturity Date:
All months are actual
days, 365/366 basis.
Partial first month and
partial last month
recognition supported.
Any odd amount is taken
in final month. Begin
Date is included.
Review/Maturity Date is
TO, not Through. If
dates are the same,
nothing will be
recognized.
2=Accelerated, also
known as
Sum-of-the-years digits
(S-Y-D): More is taken
in first month, then
declines. Any odd amount
is taken in final month.
1,200.00 over 12 months
= 12/78 for the first
month, then 11/78, then
10/78 and so forth.
5=Recurring item or
don't perform any
calculations: Use
Calculated field values
which you enter.
Typically represents a
record created for
balancing purposes or a
recurring amount when
Expense contains a
value.
Consider Method 5 as a
"wildcard" wherein the
software will report
whatever is entered into
the record.
Method 5 Review Date is
for Review Date
reporting only and does
not "end" a recurring
status. Begin Date,
Alternate field values
and Take Prior Thru date
are ignored.
6=Alternative
Recognition of Income
based upon Total Units
and Monthly Units, also
known as
"Amortize income however
your boss tells you to"
including monthly,
quarterly, semi-annual
.... Any
frequency.
The system can recognize
Income based upon a count
of Total Units reduced
by Monthly units
(including 0) which are
used or consumed in a
given month.
Total Units - A positive
number
Total Units might
represent:
● Percent, where Total
Units = 100
Monthly Units are the
percent of Income to
recognize in each month.
● Prepaid service, where
Total Units might =
Hours (such as 650
prepaid professional
services)
Monthly Units are the
number of hours utilized
or consumed.
When the record is first
entered to the system,
"hours utilized" are
likely to be unknown.
Simply enter zero for
Month1 Units. As "hours
utilized" become known,
enter the hours into the
appropriate Monthly
Units category.
● Inventory, where Total
Units = Inventory Count
(such as 2,950 widgets)
Monthly Units are the
count of items removed
from inventory and
entered each month.
Inventory can refer to
any physical count,
including office
supplies, such as
prepaid ink cartridges
and other expensive
items retaining a value.
● Dollar amounts, where
Total Units might =
Income
Monthly Units are
specific dollar amounts
to recognize each month.
● Virtually any other
type of Units.
The system recognizes
monthly Amortization by
multiplying Income times
(Monthly Units / Total
Units) where the "/"
means "divided by".
(Monthly Units / Total
Units) derives a
percentage. In effect,
all Amortization
utilizing Method 6 is a
reduction by percentage.
When the sum of Monthly
Units is less than Total
Units, the system
recognizes remaining
Book Value in the final
month.
And, as discussed below
under "Extend the Term",
if Monthly Units are not
entirely consumed during
the initial Term, you
can extend the Term
which will also extend
Book Value Amortization.
Monthly Units -
Positive, negative or
zero
Positive, to reduce
Total Units remaining.
Negative, to increase
Total Units remaining
(typically to correct an
error or return).
When Monthly Units are
negative:
Remaining Units will be
increased.
Amortization for the
month will be negative.
However, it will not
exceed the prior month's
Accumulated
Amortization. In other
words, Book Value will
increase but not exceed
original Income.
0, meaning zero units
were used in a month. No
Amortization will be
recognized.
Zero Monthly Units also
allow Amortization to be
recognized other than
monthly. Use zero
Monthly Units to "skip"
months, thus
accommodating Quarterly,
Bi-Monthly and other
Amortization
frequencies.
Monthly Units - Unknown
Current and future
Monthly Units can be
blank (nothing - no
entry or 0), meaning
Monthly Units have not
yet been determined.
Example:
Total Units = 960 based
upon future reductions
at an unknown rate.
Set Monthly Units to 0
or leave them blank
(nothing).
At the end of each
month, enter that
month's Monthly Units
including 0 if none were
used.
When Monthly Units are
blank or 0, the system
does not recognize any
Income. The system waits
until the final month to
recognize any/all
unentered Units, thus
allowing you enter
Monthly Units on a
monthly basis.
Caution: Once Monthly
Posting has been run for
a month, it is too late
to change Monthly Units
from blank or 0 unless
you run another Monthly
Posting (for the same
month).
Non-Monthly recognition
- Quarterly, bi-monthly,
annually ....
Amortization can occur
on an other than monthly
basis.
To accomplish this,
enter Total Units of
100, representing
Percent. Enter Monthly
Units in the months you
want recognition to
occur and zero in the
Months you don't want to
recognize anything.
Example:
Quarterly recognition
Total Units = 100
Set 25 into 4 of the
months, leaving other
months at 0.
Each month with 25 will
recognize 25/100 or 25%
You can enter Monthly
Units (including 0) into
any month to create a
recognition pattern of
any kind and frequency.
Extend the Term:
If Units remain at the
end of the Term, you
can:
1) Do nothing. The
system will recognize
remaining Book Value in
full.
2) Extend the Term (only
if the final month
Amortization has not
been booked to the
general ledger).
On the Field Editing
screen, select
"Adjustment F8" and
extend the Term, then
modify/enter Units for
the additional remaining
Term.
You can Extend the
original Term or
remaining Term at any
time for any purpose
utilizing "Adjustment
F8".
How it works
Each month, the system
divides Monthly Units by
Total Units to derive a
percentage. This
percentage is multiplied
by Income to determine how
much Income to recognize
in the given month.
If the total of Monthly
Units is less than Total
Units, the system
recognizes the remaining
Income in the final month.
The system keeps track
of Total Units and
Monthly Units by
appending the values to
Method in Field 6.
Price of our Basic
System:
Everything needed to
maintain records and run
monthly amortization
reports.
First year license less
than $21.00 a month.
Subsequent years less
than $8.00 a month.
Overview(click
a topic to expand/collapse)
Basic
System
Everything required to manage
and amortize Deferred Income and
Revenue
"2
click" monthly accounting reports
Select the desired amortization month from a dropdown menu
Generate a report stream with two mouse clicks
View on screen. Send to local or network printer
No monthly close out required
General
ledger
subsidiary
ledger
trial
balance
Records
sorted
and
grouped
within
general
ledger
accounts.
Subtotals for each account and report:
Count
Deferral
Amortized income
Accumulated
Book Value
(Reports can also be formatted and exported to Excel, available under "Additional Features", below)
Journal Voucher with debit and credit postings for
General ledger subtotal levels or
individual posting for each record
(Transactions can be formatted for uploading to the general ledger. See "Additional Features", below)
Take a full month's amortization in the first month.
Or, use half month convention for first month.
Or, take a partial month. For example, begin on the 22nd and recognize 9 days amortization in the first month.
Income, Accumulated and Book Values for current and future time periods
Single month or a range of months showing income, accumulated, book value
(To run reports covering prior periods, see "Additional Features" below)
New
records
report
Additions
for any
time
period,
such as
year to
date,
grouped
by
general
ledger
account
Review date report
Automatic
Review/Maturity
date
calculation
with
tickler
report
MySubtotals
report
Group
and
subtotal
records
by any
field
value
Filters:
Create
selective
reports
using
field
and date
filters
Determine Long Term vs. Short Term balances
Supports any chart of accounts
General
ledger
base
accounts,
branch,
department
and revenue centers
....
Add and edit records using a data input screen
Add new records in any order
Documentation provided for each data value
Instant amortization schedule helps verify monthly recognition is what is expected.
Testing for logical date and monetary values
Book values
Preserve current book values
or the software can calculate records from original
begin
dates
Eliminate headaches with new records
Capture
prior
months
income
if set
up late
Defer
amortizing
to a
future
"in
service"
future
month
If not ready to amortize yet, set Term to "0"
Adjustment
screen
with
single
step
entry
to
Increase
deferral,
such as
additional
charges
during
term
Decrease
deferral,
such as
partial
refund
during
term
Change
remaining
term
Write-off
this
month
Edit
other
values
at any
time
Terms for 1 through 999 months
Calculation
methods
supported
at the
record
level
Straight
line 30
day
financial
months
Half
month
convention
Date to
date
actual
calendar
days,
including
half
month
convention
Accelerated
sum of
the
years
digits
(rule of
78's for
any
term)
A Records Listing screen displays all records
Sort records by any column value
Easily delete old records at your convenience
Sort records by book value
Highlight and delete 0.00 book values in a single step
Default Record
Use the Default Record to prefill commonly used data values for a new record
Change applicable values for the new record
Duplicate an existing record
Create a new record using the same values as an existing record
Change applicable values for the new record
Windows
Operates
on
laptop,
PC,
workstations,
network
sharing
devices
and
Cloud
based
systems
supporting
Windows.
Developed
in
Microsoft
.NET
Framework
Visual
Studio
within
Azure.
Macs
Operates
on Macs
with
Parallels.
Parallels
is a
third
party
app that
allows
Macs to
run
Windows
software.
Process your records
Process client records
You might also want to see "Additional Features" (below) to include:
Additional Reporting, Export reports to Excel and Adobe
Import records from Excel
Meets
requirements for
GAAP
Record
keeping,
amortization
schedules,
subsidiary
ledger, journal
voucher, annual
recap and more.
AICPA
Many of our
clients are CPA
firms importing
client records
from Excel to
prepare monthly
financial
accounting
reports.
SOX - Sarbanes
Oxley
History
archiving (Additional Feature, below)
electronically
preserves all
reports for
recall at any
future date.
Scroll down for Price Page
You can also download a free demo from the Price page right now
The demo is a live version of the software limited to 100 records
If you obtain the software, any records you've entered can be retained
Additional Features
Include one or more of these options
now or at a later date
These export icons appear when viewing a report
"Populate Excel": Automatically format and populate Excel
with reports
"Populate Adobe": Automatically format and populate Adobe .pdf
file
Additional fields allow reporting by user defined Type, Payee and Link values
Generate reports with subtotals and file totals
Example: "Link code" to group some or all records having a common purpose regardless of income account
Example: "Type code" to group some or all records within Type codes
Description files for
General ledger account names
Type code names
Payee code names
Link code names
MyReports
Create and retain user defined sort and
subtotal values
Notes
Maintain and report Notes pertaining to
individual records
Graphs
Graph field values
View graph. Print. Copy data, paste to
Excel and insert graph
Monthly amortization reports can also produce an upload posting file suitable for importing to your general ledger system
Output consists of
Disk file plus
Display with ability to copy
posting file columns and paste to Excel or
with Additional Reporting Feature, automatically format, populate and open Excel
Posting transactions can consist of
Individual records or
Subtotals at the general ledger
account number summary level
The system comes with a standard 4 column upload
format in both a disk file and for exporting to
Excel.
If a format is not already supported, we will
create a format to update ANY general ledger
system at no charge.
Import existing records once, as a conversion
Import new records on a monthly basis
Import an entire file each month for amortization and reporting
Automatically add records from another source to
the software.
Import dozens, hundreds or thousands of
records.
The software verifies data values are of a
correct format and lists any data errors (an
invalid date, for example).
The software automatically calculates a
maturity/review/tickler file reporting date.
Current accumulated and book value for
existing records can be preserved or calculated
by the system.
Our clients use the import feature in a variety
of ways.
Some maintain all records in a spreadsheet
and always import their entire file for
accounting reports.
Many converted all their spreadsheet
records and now use the Editing screen to enter
new and edit records.
Some converted and now add (append) new
records to the software, such as on a monthly
basis.
New records come to them in a file(s):
Created at branch sites.
From their Accounts Receivable (A/R)
department.
We can also import and convert an Excel file at
no charge.
Distribute monthly income for one or more records to multiple multiple branch, revenue and
other centers using one or more Allocation
Methods maintained in the software.
Use one Method. Use many methods. Assign each Method a name that is meaningful
to you, perhaps "SQ" to mean the Allocation
Method is based on the amount of square feet
occupied by a department. Or "EMP" to allocate using the number of
employees in each branch.
Each Method contains your chart of account
branch numbers (or cost/revenue center numbers
or ....) along with the number of units each
contains, such as square feet, employee count
and even your own assigned percentage. Any type
of numerical value including "1" to allocate the same amount to each branch (if you have 6 branches, the software will allocate 1/6th to each branch).
To allocate a record,
merely replace the branch portion of a general
ledger account number with the Method name. More than one record can use the same Method.
The system will calculate the percentage being
allocated to each branch based on number of
units and create multiple posting records, each
for smaller amounts that add up to the original.
Monthly amortization and field change activity
for each record
General ledger account posting
History Audit Reports: Changes and Postings
Create Trial Balance subsidiary listing and other reports from a History month file
Audit Reconciliation (see "Audit Recap" Topic for more detail)
Reconciliation Report with Beginning
Balances, Activity and Ending Balances from any
Begin Month through any Ending Month
Create this report for audits and examinations in a matter of seconds
Notes History
View and report notes for records as they
existed as of the History/archived month
Generate your auditor's reconciliation worksheet in a matter of seconds.
Or utilize this feature to help pinpoint an out-of-balance condition
Select a time period, typically 12 months (can also be run for other periods including a single month)
Generate a report for the requested period displaying
Beginning of period balances
Monthly activity consisting of
+ New records (deferral) added during that month
including +/- Adjustments due to additional income, partial refunds for a record
- Income Amortization
= Ending Book Value for the month
Summary recap of all monthly activity during the period
The report can be run
For all general ledger accounts
For selected general ledger accounts or a single account
For all records or selected records only
With detail (records) and account number subtotals or subtotals only
For past and future period projections
This report is included with the History Feature
(We recommend also including the Additional Feature "Additional Reporting" for exporting reports to Excel)
Records are normally edited using the software's
setup/edit screen, either one record at a time
or in sequential order.
The editing screen:
Performs data value testing
Displays an immediate amortization
schedule
But there may be times when you'd prefer to use
Excel.
This 3 step option allows you to:
1) Copy the master file to a spreadsheet,
such as Excel.
2) Edit records using all of the
spreadsheet functions.
Edit records
Add records
Delete records
Fill down
Sort
Other Excel capabilities
3) Copy records from the spreadsheet and
paste back to/as the revised master file.
The software verifies all data
values and relationships, such as dates, are
valid and compatible.
Odd periods
• Irregular frequencies (e.g. take 20% in
months 1 and 2, then nothing for 6 months, then
40% and 20%)
• Pre-determined amounts (e.g. take
$10,000 in month 1, then $5,000 and then $2,000
each month for remainder of term)
• Send amortization schedule to person
requesting the above and verify results
Consumption
Recognize bulk items, such as ink
cartridges, stationery, marketing material and
other prepaid inventory based upon each month's
consumption (or zero).
Monthly income = consumption
count / original inventory count * Deferral.
Book value corresponds to
remaining inventory count (also provided by the
software).
Remaining terms can be shortened
if inventory is exhausted beforehand.
Remaining terms can be lengthened
to account for a remaining inventory.
Also applicable for retainers and other
income where monthly usage is unknown at setup
time. Enter as it becomes known.
Consumption can be entered as count,
hours (e.g. professional retainer), percentages,
dollar amounts, other numerical units.
We can modify the software to meet specific needs
Please contact us at 1-800-245-8444 to discuss any special requirements you have
Features
• No
monthly close
out
• No end of year
chores
• Post "as
of" any month with "undo" for errors or omissions
• Span calendar and fiscal years
• Amortize income over
1 - 999 months
• Other amortization
methods, date-to-date
terms
• Defer amortizing to future month
• Capture
prior month(s) amortization
• Audit year 12 month,
multi-column recap
• Instant amortization schedules
• Balance sheet reconciliation
• General
ledger transaction posting
file
• Records
retention
• Adjustment
screen for changes
during term
• Allocation to multiple revenue centers
• Month by month income projections
• Tickler
review/renew
date calculation
• Windows 7, 8,
8.1 and 10
• PC and
network sharing versions
• 1-800
and email
support
• Report
filters
• Graphing
functions
• My Subtotals
report
• Type
classification
• Date
range reporting
• Export records
and reports to Adobe and
Excel
• User defined
allocation methods
• Enter
records and/or import
records
• Paper reports or
go electronic
•
Documentation,
Help, Tips
Reports
Run.
Rerun.
Any
time.
Any
month.
View
Send to printer
Archive in Adobe
Export to Excel
General
ledger
posting
files
Formatted
postings
to
update
ANY
general
ledger
system
Disk file xlsx, txt, csv, iif ....
Or
send to Excel
Forget
to do
something?
"Undo" a
general
ledger
posting
if done
in error
This is just a quick note to let you know that the software is up and running.
More importantly, we love the software!
Thank you so much for your help and we look forward to working with your company in the future.
Hollywood, FL
Price page and free demo ....
PRICE PAGE
and FREE DEMO
Click to open and view
Price page
Download a free demo from the Price page which
includes:
• A live version of the software
• Sample records
• Run reports
• Add some of your records and rerun reports.
If you order the software you can keep whatever
records you entered or start out fresh.
Pressed for
time?
• Send us your existing records in an Excel file.
• Preserve current book values.
• We'll import the file, convert your records and provide
a turnkey
system at no
additional
charge.
Request more
information
Support@fdssi.com or
1-800-245-8444
Basic
System
consists
of these
features
Records:
Amortization
and
monthly
reporting.
Add
records
in any
order.
Sort list by any column value
Deferral
balances:
Preserve current deferral balances or
Software can calculate records current from original
begin
dates
New
record:
Capture
prior
months
income
if set
up late
Delay
amortizing
to a
future
"in
service"
future
month
Adjustment
screen
with
single
step
entry
to:
Increase
deferral,
such as
additional
charges
during
term
Decrease
deferral,
such as
partial
refund
during
term
Change
remaining
term
Write-off
this
month
Edit
other
values
at any
time.
Delete
old
records:
Sort by
deferral
balance
Delete 0.00 deferral balances in a single step
Amortization
schedule
for each
record.
Supports
any
chart of
accounts:
General
ledger
base
accounts,
branch,
department
and revenue
centers
....
Calculation
methods
supported
at the
record
level:
Straight
line 30
day
financial
months
Half
month
convention
Date to
date
actual
calendar
days,
including
half
month
convention
Accelerated
sum of
the
years
digits
(rule of
78's for
any
term)
Reports:
"2
click"
monthly
reporting.
Generate
a report
stream
with two
clicks
of the
mouse
No
monthly
close
out
required.
General
ledger
subsidiary
ledger
trial
balance:
Records
sorted
and
grouped
by
general
ledger
accounts.
Debit
and
credit
Journal
Voucher
postings
General
ledger
subtotal
level or
individual
posting
for each
record
General
ledger
base
accounts,
branch,
department,
cost and
revenue
centers
....
Calculations
for
future
time
periods
New
records
report
Additions
for any
time
period,
such as
year to
date,
grouped
by
general
ledger
account
Review
date
Automatic
Review/Maturity
date
calculation
with
tickler
report
MySubtotals
report
Group
and
subtotal
records
by any
field
value
Filters:
Create
selective
reports
using
field
and date
filters
Modular
pricing.
Add one
or more
of these
available
features
....
Import
records
from
Excel
and
other
spreadsheets
Automatically
add
records
from
another
source
to the
software.
Import
dozens,
hundreds
or
thousands
of
records.
The
software
verifies
data
values
are of a
correct
format
and
lists
any data
errors
(an
invalid
date,
for
example).
The
software
automatically
calculates
a
maturity/review/tickler
file
reporting
date.
Current
accumulated
and
deferral
book
value
for
existing
records
can be
preserved
or
calculated
by the
system.
Our
clients
use the
import
feature
in a
variety
of ways.
Some
maintain
all
records
in a
spreadsheet
and
always
import
their
entire
file for
accounting
reports.
Many
converted
all
their
spreadsheet
records
and now
use the
Editing
screen
to enter
new and
edit
records.
Some
converted
and now
add
(append)
new
records
to the
software,
such as
on a
monthly
basis.
New
records
come to
them in
a
file(s):
Created
at
branch
sites.
From
their
Accounts
Receivable
(A/R)
department.
Upload
posting
file
with
journal
entries
to
update
the
general
ledger
Creation
of a
General
ledger
upload
posting
file.
File
output
Disk
file
plus
Output
display
with
ability
to copy
posting
file
columns
and
paste to
Excel
Posting
transactions
can
consist
of
Individual
records
or
Subtotals
at the
general
ledger
account
number
summary
level
The
system
comes
with a
standard
4 column
upload
format
in both
a disk
file and
for
exporting
to
Excel.
If a
format
is not
already
supported,
we will
create a
format
to
update
ANY
general
ledger
system.
At no
charge.
Additional
Reporting
Type,
Payer
and Link
fields
for user
defined
values
MyReports:
Create
and
retain
user
defined
sort and
subtotal
values
Use this
feature
to
determine
Long and
Short
Term
definitions
Description
files:
General
ledger
account
names,
Type
codes,
Payer
code
names
Export:
Automatically
format
and
populate
Excel
with
reports
Automatically
format
and
populate
Adobe
.pdf
file
Notes:
Maintain
and
report
Notes
pertaining
to
individual
records
Graphs
Graph
field
values
View
graph.
Print.
Copy
data,
paste to
Excel
and
insert
graph.
History
Archive
-
Retrieve
any
report
from any
prior
month
Monthly
amortization
and
field
change
activity
for each
record.
General
ledger
account
posting
History
Audit
Reports:
Changes
and
Postings
Trial
Balance
and
other
reports
created
from a
History
month
file
Audit
Recap
Reconciliation
Report
with
Beginning
Balances,
Activity
and
Ending
Balances
form any
Begin
Month
through
any
Ending
Month
Notes
History
View and
report
notes
for
records
as they
existed
as of
the
History/archived
month
Edit
records
using
Excel
Records
are
normally
edited
using
the
software's
setup/edit
screen,
either
one
record
at a
time or
in
sequential
order.
The
editing
screen:
Performs
data
value
testing
Displays
an
immediate
amortization
schedule.
But
there
may be
times
when
you'd
prefer
to use
Excel.
This 3
step
procedure
allows
you to:
1)
Copy the
master
file to
a
spreadsheet,
such as
Excel.
2)
Edit
records
using
all of
the
spreadsheet
functions.
Edit
records
Add
records
Delete
records
Fill
down
Sort
Other
Excel
capabilities
3)
Copy
records
from the
spreadsheet
and
paste
back
to/as
the
revised
master
file.
The
software
verifies
all data
values
and
relationships,
such as
dates,
are
valid
and
compatible.
Allocate
amortized
income
Distribute
one or
more
general
ledger
posting
amounts
to
multiple
branch,
cost,
revenue
and
other
centers
using
one or
more
Allocation
Methods
maintained
in the
software.
You
assign
each
Method a
name
that is
meaningful
to you,
perhaps
"SQ" to
mean the
Allocation
Method
is based
on the
amount
of
square
feet
occupied
by a
department.
Or "EMP"
to
allocate
using
the
number
of
employees
in each
branch.
Each
Method
contains
your
chart of
account
branch
numbers
(or
cost/revenue
center
numbers
or ....)
along
with the
number
of units
each
contains,
such as
square
feet,
employee
count
and even
your own
assigned
percentage.
Any type
of
numerical
values.
To
allocate
a
record,
merely
replace
the
branch
portion
of a
general
ledger
account
number
with the
Method
name.
The
system
will
calculate
the
percentage
being
allocated
to each
branch
based on
number
of units
and
create
multiple
posting
records,
each for
smaller
amounts
that add
up to
the
original.
User
defined
Alternative
Recognition
Methods
The
system
can
recognize
a
Deferral
based
upon a
count of
Total
Units
reduced
by
Monthly
units
which
are used
or
consumed
in a
given
month
plus
these
additional
recognition
frequencies:
•
Bi-monthly
•
Quarterly
•
Tri-annual
•
Semi-annual
•
Annual
•
Irregular
frequencies
(e.g.
take 20%
in
months 1
and 2,
then
nothing
for 6
months,
then 40%
and 20%)
•
Pre-determined
amounts
(e.g.
take
$10,000
in month
1, then
$5,000
and then
$2,000
for the
rest of
the
year)
Total
Units
might
represent:
●
Percent,
where
Total
Units =
100
Monthly
Units
are the
percent
of the
Deferral
to
recognize
in each
month.
●
Prepaid
service,
where
Total
Units
might =
Hours
(such as
650
prepaid
professional
services)
Monthly
Units
are the
number
of hours
utilized
or
consumed.
When the
record
is first
entered
to the
system,
"hours
utilized"
are
likely
to be
unknown.
Simply
enter
zero for
Month1
Units.
As
"hours
utilized"
become
known,
enter
the
hours
into the
appropriate
Monthly
Units
category.
●
Inventory,
where
Total
Units =
Inventory
Count
(such as
2,950
widgets)
Monthly
Units
are the
count of
inventory
items
removed.
Inventory
can
refer to
any
physical
count,
including
office
supplies,
such as
prepaid
ink
cartridges
and
other
expensive
items
retaining
a value.
● Dollar
amounts,
where
Total
Units
might =
Deferral
amount
Monthly
Units
are
specific
dollar
amounts
to
recognize
each
month.
●
Virtually
any
other
type of
numerical
Units.
Monthly
Units -
Positive,
negative
or zero
•
Positive,
to
reduce
Total
Units
remaining.
•
Negative,
to
increase
Total
Units
remaining
(typically
to
correct
an error
or
return).
When
Monthly
Units
are
negative:
Remaining
Units
will be
increased.
Amortization
for the
month
will be
negative.
• 0,
meaning
zero
units
were
used in
a month.
No
Amortization
will be
recognized.
Zero
Monthly
Units
also
allow
Amortization
to be
recognized
other
than
monthly.
Use zero
Monthly
Units to
"skip"
months,
thus
accommodating
Quarterly,
Bi-Monthly
and
other
Amortization
frequencies.
Price page and free demo ....
PRICE PAGE
and FREE DEMO
Click to open and view
Price page
Download a free demo from the Price page which
includes:
• A live version of the software
• Sample records
• Run reports
• Add some of your records and rerun reports.
If you order the software you can keep whatever
records you entered or start out fresh.
Pressed for
time?
• Send us your existing records in an Excel file.
• Preserve current book values.
• We'll import the file, convert your records and provide
a turnkey
system at no
additional
charge.
Request more
information
Support@fdssi.com or
1-800-245-8444
Administrative reports
New records: List new records for the month,
Y-T-D and other time periods
Maturity/Review
date: A tickler file showing records that are
nearing the end of their term
Payers: If desired, add payer name or
code and get a list of total
income for each
Type: If desired,
assign a type code to group
records and get totals, such as
product category
Link: If desired, tie
records together by a common
purpose, such as geographical
source
Alpha: Alphabetical listing of
records in
description
order
Filters: Alpha and monetary values, dates
and date ranges
Select all records for a report
or
Use one or more filters to only
included specific records, such
as income > $1,000.00
Reconciliation: Beginning balances, new
records, amortization, ending
balances for month, year
MySubtotals: Filter and obtain records
and subtotals sorted by
selected values on the fly
MyReports: Create and retain reports,
filters and sorted subtotals you
need for repetitive runs
Records only or Subtotals only: Run
reports with or without
individual records for "Totals
only" (shorter report)
Amortization periods: Income plus ending
balances for 1 month, range
of months, entire year
Columns: Income for multiple months,
entire year, displayed in
multiple monthly columns, past
or future
Utilize this feature to generate
Waterfall reports
With reports:
View
on screen
Send to printer
Export to Excel
A great way to respond to a
request from your boss
Or export all or filtered
records and do whatever
reporting you want in Excel
Export to Adobe
Price page and free demo ....
PRICE PAGE
and FREE DEMO
Click to open and view
Price page
Try a free demo, also available on the
price page
Download the free demo right now.
The demo is the live software and can be rolled into a permanent system.
New!
Excel version
A fast, simple way to:
• AMORTIZE thousands of Excel records in one or
multiple
worksheets at
the same time
• Recognize monthly income using 30/360 and actual date-to-date/365
in-service days
• Generate
accounting
reports with
Journal Voucher
transactions
formatted for
posting to any
general ledger
system,
including
Quickbooks
• Provide
audit and exam
schedules
View
Excel
Deferred Income
Amortization
software page
Amortization frequency
and additional methods at
the record level
Odd
• Irregular frequencies (e.g. take 20% in months
1 and 2, then
nothing for 6
months, then 40%
and 20%)
• Pre-determined amounts (e.g. take $10,000 in
month 1, then
$5,000 and then
$2,000 each
month for
remainder of
term)
• Send amortization schedule to person requesting
the above and
verify results
Consumption
•
Applicable for
retainers and
other income
where monthly
usage is unknown
at setup time.
Enter as it
becomes known.
Amortize based
upon each
month's
consumption (or
zero).
Monthly income =
consumption
count / original
count * Deferred
income
Book value corresponds to remaining
inventory count
(which is
also provided by the
software).
Remaining terms
can be shortened
if inventory is
exhausted
beforehand.
Remaining terms
can be
lengthened to
account for a
remaining
inventory.
Consumption can be entered as count,
hours (e.g.
professional
retainer),
percentages,
dollar amounts, other
numerical units.
Defer amortizing a new record to a
future "in service" begin date
Catch-up and include prior month(s) income
this month if not entered
on time
Extend term, shorten, write-off at any time
Eliminate problems with additional
payments, partial refunds using
an adjustment entry screen
Debit and credit
postings to update ANY General Ledger
System
at no additional charge ....
A default general
ledger layout comes with the
software.
If yours is different, we will match your
layout including requirements
such as:
• File
type
Core system, in-house,
service bureau,
commercial software
As a disk file or
copy/paste
Tab-delimited (often for
Excel)
Fixed length
Variable length
Csv, txt, xlsx, other
delimiters, other
requirements
• Header
record, if required
Descriptive headings
Company/customer
identifier
Single or multiple lines
• Posting
transaction layout:
Db and Cr designators as
D and C, signed amounts,
1 and 2, other values
Date formats
Account number splitting
into separate columns
If this, then that testing
Table
lookup
$ postings as:
General ledger account
number summaries or
Each individual record's amount and
description
• Trailer
record(s), if required
End of file marker
File contents, count,
amount
• Other
requirements
Simply tell or show us what you need
We will provide an example prior to any
commitment on your part
There is no charge involved because this has
been a big selling
feature of our software
since 1995
Format and Document
External Postings, too!
The software includes a
stand-alone program to
format postings from
external sources.
• Copy and paste transactions from an Excel file,
such as daily journal
entries plus
• Copy and paste transactions which were output
from another software
application
Paste three columns to a
designated screen:
• Account Number
• Amount (+/-)
• Description
The program will:
• Prepare a Journal Voucher with debit and credit
columns as your source
document and
• Format transactions for uploading to your
general ledger system
CPA, client accounting firms
....
Utilize the software's Import
and Export features
• Import an Excel file with client records to the software
at any time
Service one client or
Multiple clients
• Generate all monthly accounting reports
• Export reports to Excel or Adobe
• Process accounting functions and/or send
reports file to client
• Import client file, generate all reports, export in a
matter of seconds
PRICE PAGE
and FREE DEMO
Click to open and view
Price page
Try a free demo, also available on the
price page
Download the free demo right now.
The demo is the live software and can be rolled into a permanent system.
l
Single step monthly processing
• Income
amortization for the desired month -
current, previous, other
Direct postings as well as
branch, department, revenue
center accounts
• Subsidiary listing with
subtotals for all income and unearned
income liability accounts
Supports any chart
of accounts
Post to direct accounts and
Post to branch, department, revenue
center accounts
• Journal voucher with debit,
credit column recap
Subtotals level or
At the record level
• Upload posting file for
importing to any
general ledger system
• Send reports to
screen, local or network printer,
Adobe. Export to Excel.
• Find a big mistake? Forgot
to enter some records?
Simply fix the problem and rerun the
reports.
Already updated the general ledger?
Run "Reversal" to undo.
Then fix the problem and rerun monthly
reports.
Managing your records
•
From within the software ....
Add existing
and new records using a data input screen with
user assigned default values
Instant amortization schedule helps
verify data was entered correctly
Edit records at any time for any purpose
Adjust a record during the amortization term
due to
Additional receipts
Partial refunds
Cancellation, early write-off
Easily delete fully amortized records
when you decide to purge the file
No end-of-year chores, carry forward
problems, file initialization ....
• Import records, too - several options
Import records from a
worksheet once, as a conversion
Import all records every month
Import new records each month
• Export records and reports to Excel and Adobe
First
month's income for a new record
Full and partial month recognition
choices at the record level
• Recognize entire month (default)
• Utilize Half Month convention
• Recognize actual remaining days in month. 9, 23, 4
....
• Defer recognizing until a future "in service" month
• Include prior month(s) amortization if the record
should have been set up a month or two
ago
Existing records
• Preserve current
book values or have the software
calculate them
Amortization methods
• Multiple amortization methods
assigned at the record
level:
30 day
financial months (default)
365/366 actual days in
each month
Half
month convention
Sum-of-the-years-digits for accelerated
recognition up front Daily,
days, weekly, 4-4-5, quarterly and other
periods amortization software
•
User defined recognition methods:
Variable
monthly percentage, such as 14% the
first month, 11.25% the second month
....
Specific dollar amounts each month, such as $400
the first month, $525 the second month
....
Contractual take-down and others, where
monthly recognition is deferral X
(number of units consumed / total
beginning units)
Amortization terms
- Months or Days
• Multiple amortization terms
assigned at
the record level:
1 month through 999 months (default = 12 months)
Partial months
Actual date to any date
period (e.g., April 12th to June 6th =
19/55 days, 31/55 days, 5/55 days)
Recurring amounts, fixed
or variable
• Adjusting a term - single step procedure
Use the record Adjustment screen to
change the remaining term to any shorter
or longer term
• Cancel, stop amortizing or write-off a record -
single step procedure
Use the record Adjustment screen and
change the remaining term to 1 month
The system will recognize the remaining
balance in full
Additional reporting capabilities
• Reconciliation Report,
Auditor's Worksheet
Any month. Range of months.
Entire year.
Columns: Beginning balances plus
New records minus Amortization equals
Ending Balances
• Administrative reports with filter
capabilities for internal purposes
• Product category type reporting
• Tickler, renewal date reporting
• Short Term, Long Term unearned totals
• Waterfall report - future period month-by-month
amortized income and unearned balances
• Income, accumulated
and balances (3 columns per month)
For a
range of months prior or future months
For entire calendar
or fiscal year
Retrieve old reports
• The system creates a
historical archive file each
month
• Run any report from any month and year at any
time in the future
• A great tool to have during audits and
examinations
Allocating monthly income
• Allocate at the record level
• Distribute amortized income for one ore more records to multiple branch,
revenue
center accounts
• Use one or multiple allocation
methods
PRICE PAGE
and FREE DEMO
Click to open and view
Price page
Try a free demo, also available on the
price page
Download the free demo right now.
The demo is the live software and can be rolled into a permanent system.
OTHER
VERSIONS
We also offer other versions of the software.
If you need something you don't see, please
contact us with your requirements
and we'll let you know whether or not they can
be met.
Email
Other versions of the software
HANDY
FEATURES
Delete:
An easy process to use whenever you want to
clear out old records.
• Sort records by current Deferral Balance.
• Records with a 0.00 Deferral Balance will be at the
top of the listing.
• Select some or all with a Deferral Balance of 0.00.
• Selected records will be deleted in a single step.
Quick
Totals:
Let's say you just added a bunch of new records.
Are you in balance with your general ledger?
Run Quick Totals:
• Select totals by Deferral Accounts.
• Old records: Deferral Balance will be as of
prior month end.
• New records: Deferral Balance will
be original Deferral Amount.
• The system will combine both into a single
Total amount.
• Each Deferral Account Total on the report
should tie to the general ledger.
My
Subtotals Report:
Generate an amortization report as of any
month.
• Select all records or use filters to limit
which should appear on the report.
• Generate subtotals for up to five (5) different
values.
• The report can include records or, for a
shorter report, subtotal rows only.
Example 1:
• Select all records with a Begin Date on or
after the 1st of the year.
• Sort records by Begin Month.
• Obtain Deferral Amount subtotals for each month.
Example 2:
• Select all
records with a remaining Deferral Balance greater than
$5,000.00.
• Sort records by Deferral Account account.
• Obtain Deferral Balance subtotals for each
Deferral Account number.
Export to
Excel:
Perhaps a My Subtotals Report (above) has to be
sent to someone who requested it.
While viewing it or any other report,
• Click a single icon to populate a worksheet.
• The system automatically copies all columns and
rows, formats a worksheet,
then opens an Excel file with
the
formatted worksheet and data.
• Save the Excel file under any assigned name.
• If applicable, send the Excel file attached to
an email.
REPORTS
LISTING
General
ledger reports:
• Monthly Posting Report Stream: Trial Balance
Subsidiary Listing + Journal Voucher + General
Ledger Posting File
• Monthly Posting short version: Journal Voucher
+ General Ledger Posting File
• Trial Balance Subsidiary Listing: Group and
subtotal by General Ledger Income within
Deferral Accounts
• Multiple Months: Income Amortization for prior
or future periods such as two months, a quarter,
full year and other date ranges
Reconciliation reports for deferral and income
accounts - 1 to 12 month range:
• History Audit Report: Posting activity for a
range of months, including Reconciliation for
the period
Beginning balances, plus new records deferral, minus
income amortization, plus or minus adjustments
= Ending Balances
Automatically create the annual schedule
utilized by your CPA auditor in a matter of
seconds. Export to Excel.
• History Audit Report: Changes that would impact
general ledger reconciliation
Administrative reports - Standard data:
• My Subtotals: Trial Balance Subsidiary Listing
with subtotals for one or multiple sort values
• Special Reports: Create a one-time report
containing records meeting specific date and
other field value filters
• My Reports: Create reports to be run on a
repetitive basis using your selection and
subtotal requirements Example: Create a report containing records
with a Remaining Term greater than, say, 12
months.
Determine Long Term classification balances.
• New Records Report: Records with Begin Date
falling within a date range
• Review/Maturing Report: Records with
Review/Maturity Date (calculated by the
software) falling within the current or future
month
• Method Report: Group and total by Calculation
Method
• Alpha Report: List Records alphabetically by
Description Calculate income and balances for a month
or multiple months. Export to Excel for
internal/external purposes.
Administrative reports - User defined, optional
entry data:
• Type Code Report: Group and subtotal by Type
Code Can be used for any purpose, such as a
Product Code or Type of Service classification
• Record Link Key Report: Group and subtotal by
Record Link Key Group and subtotal records based upon a
common bond such as a special marketing campaign
• Payer Code Report: Group and subtotal by
Payer Code or Name
Allocation
report:
• If desired, the system can distribute amortized
income for selected records to multiple revenue
center accounts.
• This report provides a detailed listing as to
exactly how income for each record was
distributed.
With
reports:
• View on screen
• Send to local or network printer
• Send to Adobe
• Send to Excel
ABOUT REPORTS
• Include all records or
use filters to select only the
records you want
•
Subtotal on any value, multiple
values
• Amortized income, deferral balances and totals. Any month. Any year.
Any period.
• Calculate income amortization and balances for multiple months, an entire year. Display monthly income in a
single column or multiple, month by month
columns.
Generate a Waterfall
Report.
• View reports
• Send to local or network printer
EXPORT
DATA and
REPORTS
•
EXCEL - Export to Excel - format and populate a
worksheet with a single click
•
ADOBE - Archive to Adobe, create a .pdf
file with a single
click
COPY
DATA and REPORTS
• Use the Copy feature to copy and paste
reports elsewhere
• Copy also creates a Tab-Delimited text
file which can be imported to other programs
Custom
The software can be modified to meet the needs
of a specific client.
Modifications typically fall into these areas:
• Importing, scrubbing files and records to the software
• Unique subtotals and totals
• Special reports
• Exporting records, reports, other results to
Excel
Options for existing
records and deferral balances
Option 1
Preserve existing deferral balance book values.
No
need for any adjusting journal entries.
Option 2
Calculate prior and current
deferral balance book values.
The software can amortize
deferred income
from original dates.
Option 3
Begin amortizing from an "as of" date.
Typically the beginning of a
calendar or fiscal year using prior EOY balances.
Options for
managing records
Option 1
Enter records directly into the software.
An easy to use setup screen and documentation guide you.
View an instant amortization schedule verifying
what was entered.
Option 2
Import Excel records once.
Import one or more worksheets as a conversion to the
software.
Option 3
Always import all records from an Excel
worksheet.
Maintain records in Excel.
Import to the
software at any time for monthly amortization
and reporting.
Option 4
Combinations of the above.
Enter records to the software. Import new
records from Excel.
Amortization and reporting for
• Your records
• Subsidiary records
• Client records - Maintain or import client records
from Excel.
Amortize records and provide a monthly set of
reports in Adobe or Excel.
Deferred income amortization
• Enter records to the software and
• Import records from Excel
"Thanks for your help today. We imported all of our records and
current balances without a problem. Your software is as advertised and will be most useful."
Texas
GENERAL
LEDGER
• Supports any general ledger chart of accounts
• Creates an upload posting file for any general
ledger system
• The software can "break apart" account numbers
and place specific portions into different
columns.
DIRECT
POSTING
• Monthly amortization for records can be posted
to direct income accounts
INCOME ALLOCATION
ACCOUNTING
• Allocate and distribute monthly amortization
for one or multiple records to:
Branch accounts
Department accounts
Revenue center accounts
Other designations
• Distribute amortized income using:
One allocation method
Multiple allocation methods
• Define your own allocation methods, such as but
not limited to:
Branch, department, revenue center count wherein
each receives the same income portion.
Create a single record for an income to be
distributed among branches.
If 5 branches, each receives 1/5 of monthly
amortized income.
Participating branch, department, revenue centers
wherein only some receive a portion.
Percentage. Assign varying percentages to
be allocated to each.
Square feet, such as allocating to departments
based upon space occupied.
Employee count, wherein allocation is assigned
based upon number of employees.
Workstation count, allowing IT incomes to be
allocated based upon assigned equipment.
Other user defined allocation methods.
• A branch, department or revenue center can be
located anywhere within your account number.
• Assign an allocation method within the income
account number at the record level.
An allocation method can be assigned to multiple
records.
• The software replaces a method with as many
branch, department, revenue centers assigned to the
method.
Examples: 4000-MMMM might
become 4000-0001, 4000-0002, 4000-0003 ....
01-MM-1655 might become 01-01-1655, 01-02-1655,
01-03-1655 ....
MMM8888 might become 0048888, 0078888, 0258888
....
Client testimonials ....
This is just a quick note to let you know that the software is up and running.
More importantly, we love the software!
Thank you so much for your help and we look forward to working with your company in the future.
Hollywood, FL
Thanks for your help today. We imported all of our records and
current balances without a problem. Your software is as advertised and will be most useful.
Houston, TX
We have been using your software for some time.
This system has always been so easy to utilize and we really appreciate the level of detail in the reports.
Albemarle, NC
Thank you so much for your help.
It’s so refreshing to talk to someone who understands!
Oakland,
CA
We just installed your software last month. The software has already saved me hours for forecasting models.
Paducah, KY
Thanks.
Your customer service is fantastic!
Have a great week.
Redmond, WA
Why others chose our software ....
•
Customizing
The needs of most
clients can be met with
capabilities and
features already found
within the software but
some had us write special programming, reports or export routines
to meet their unique
requirements
• Long Term
classifications
Report
deferred income liability
balances "as of" 12 months from now or
any other future date
• Waterfall
report
Month-by-month amortized income
covering any future period
• Income
allocation
Selectively distribute monthly
amortized income for a single record to
multiple branch or revenue center
accounts
• Export
Copy all reports to
Excel. Copy all records or
filtered (selected) records to Excel.
Importing records from Excel
The software
comes with
complete record
handling
capabilities:
Add, edit,
delete records.
List, sort,
export and more.
Nothing else is
required to
manage your data
records.
Additionally,
the software can
import data from
Excel and other
spreadsheet
files.
Importing allows
you to add
records from
another source
to the software.
Import dozens,
hundreds, even
thousands of
records.
Import once as
a conversion
and/or
Import on an
ongoing basis.
Always import
your entire
worksheet or
Add new records
from a file that
was created at
another source.
The software
verifies data
values are of a
correct format
and lists any
conflicts or
errors.
And
automatically
calculates a
maturity/review/tickler
file reporting
date.
Current
accumulated and
balance for
existing records
can be preserved
or calculated by
the system.
Importing a file
is easy:
1) Copy an
entire worksheet
or highlight and
select desired
rows.
2) Click the
Paste icon on
the software's
Import screen.
That's all it
takes!
An Import Table
maintains
worksheet Column
Letter cell
values.
Example:
"Description"
might be your
worksheet column
"A" or "C" or
....
An option switch
allows you to
replace all
existing records
or add (append)
new records.
The "Copy from"
source can be an
Excel worksheet,
other
spreadsheet
program or any
tab-delimited
file.
Reports
Full set of
accounting and
managerial
reports:
- Trial Balance
Subtotals and
report totals
for count and
amount
- Journal
Voucher
Undo
Reverse a
previously
created
debit/credit
upload posting
file
- New records
report
For the prior
month, year to
date or other
time period
-
Maturity/Review
date report
(tickler file)
Which records
will finish
their term this
month, next
month or other
time period
- Type report
by user defined
codes
- Payer report
by user defined
codes
- Record link
report
(aggregate
records by a
common purpose)
- Alpha list of
records in
Description
order
- Description
files to provide
meaningful
information at
report subtotal
levels:
• General ledger
chart of account
names
• Type codes
• Payer codes
• Record link
codes
• Enter
descriptions
into the
software or
copy/paste from
another source.
- Apply
filters, date
selections and
set calculation
month, range of
months and year
end periods
- Export
reports
Copy and paste
any report to a
spreadsheet
Copy column
headings,
records,
calculated
values and
subtotals
User defined
reports:
- MySubtotals report
Filter and group by
selected fields on the fly
- MyReports
Create and retain your
own commonly used reports
- Records only
Create a file amortized
for any period consisting of all or filtered records
- View, print, export reports to Excel
On Demand Reports
Calculate
amortized
results:
As of any month
or year end
period
For a range of
future months
For a
historical
month, range of
months, entire
fiscal year
Include:
All records
Selected
records
Select records
using filters
available for
all fields and
values
Sort and create
subtotals on
desired field
values
Examples:
Report all
records that
will have a zero
balance as of
December 31st.
Report all new
records for the
previous quarter
with deferred
income >
$1,000.00.
Report all
records in three
income
accounts, send
report to Excel.
General ledger systems
Supports any
chart of
accounts.
Post as:
Direct income
and
Allocation:
Monthly amortized income for a record can be
distributed to
multiple income accounts.
• Allocate using
different methods:
You define each method
Percentage, square feet, number of employees,
workstation count ....
• Allocated amounts flow into the journal voucher and posting file for automatically updating the general ledger
Format
monthly postings
as a:
Disk file and
Excel export.
Standard
worksheet format
with ability to
meet special
column layout
requirements at
no extra charge
("break up"
general ledger
account into
multiple
columns, single
or dual
debit/credit
columns, header
row, other
needs)
The software can
format
transactions for
posting to any
general ledger
system.
Output to disk file,
Excel worksheet,
other.
Columns and
data layout in
any order
(including
blank, filler
and generated
values)
Transaction
codes
Prior month
backdating (ex:
post in May with
effective date
of April)
Header, trailer
and totals
records
Multiple debit,
credit columns
or a single
column with
credits
identified by
"-" or "( )"
Undo (reversal)
Generate debit
and credit
transactions as:
Summary totals
for each general
ledger account
or
Individual
transactions for
each record
Monthly
amortization can
be:
A direct
posting to an
income account
or
Allocated
(distributed) to
multiple general
ledger revenue
center accounts
General ledger
account numbers
can be:
Uploaded as
entered or
Split into
multiple posting
file columns in
any order
(account number,
company code,
revenue center,
department,
region, sub
coding ....)
Exception
handling
Do you ever have
to ....
Increase or
decrease the
amount being
amortized?
The Adjustment
Screen
automatically
handles
additional
payments and
refunds.
Add a record
that should have
been added last
month?
Prior month
income for a
record can be
included with
the current
month.
Add a record
that shouldn't
begin amortizing
right away?
An alternate
begin date
defers
amortizing to a
future "in
service" month.
Change a term?
Write off
immediately?
The Adjustment
screen
automatically
handles these,
too.
Allocate income
to several
branches or
departments?
The Allocation
module
distributes
income using
one or more
methods.
Are you ever out
of balance?
The History
Audit Report
shows monthly
changes to each
general ledger
account.
History
- Automatic data
and report
archiving
Automatically
created History
archive files.
• No more
searching for
old reports.
• Recall
any report for
any month.
• View
and print.
• Export
- copy an entire
report to a
worksheet.
• History
allows you to go
paperless.
All text changes
plus monetary
adjustments are
maintained in
activity logs.
History tracks
any changes made
in Excel import
files, too!
Lifetime
amortization
schedules - past
and projected -
along with
critical memo
Notes.
Recall prior monthly
general ledger
income and
offset account
postings.
History allows
for reports to
span multiple
months.
Copy 12 month
fiscal year
recap to a
worksheet, email
to your auditor.
Account
reconciliation report - monthly, annual
Reconcile your deferred income liability accounts. In seconds!
Reconciliation Report columns:
Beginning balance for
each record (the previous month ending balance)
+ New record amount if the record was added during the period (Beginning balance would be zero)
- Amortized income
- Partial refund if an adjustment was made, funds returned
+ Additional receipts, partial increase
= Ending balance
Column totals for all records within each deferred liability account
Out of balance?
Simply compare the Reconciliation Report to your general ledger liability account activity.
Run the report for a single general ledger account or
all accounts.
Reconcile a single month or range of months.
Reconcile an entire year - great when auditors want to see annual changes to your deferred income liability accounts.
How our clients handled their
existing records
• Some entered their records directly to the software, doing a "clean up" as they went along.
• Some imported and converted their records to the software from an Excel worksheet or other spreadsheet.
• Some imported and converted existing records. And, they continue to import new records each month
from Excel worksheets created at branch sites.
• Some never converted.
They began entering new records to the software and allowed existing records to finish amortizing the "old" way.
• Others never converted.
They always import all of their existing plus newly added records to the software each month from Excel.
Supports all of these amortization
recognition methods at the record level
• Straight line monthly, 30 day financial months (typical recognition method)
• Straight line monthly, actual days in month with start and end dates
• Half month convention
• Partial first month and or last month
• Time: Hours, days ....
Recognize professional and other prepaid fees and retainers by actual hours or
other time periods (including zero) performed each month
• Dollars
Assign the specific dollar amount (including zero) to be recognized each month in advance or as it becomes known
• Percent
Assign the percentage to be recognized each month (including zero) in advance or as it becomes known
• Count
Recognition is based upon a monthly reduction of a beginning total count
• Products
Recognize income based upon the delivery of a prepaid product delivered over a staggered interval
• Services
Recognize income based upon the delivery of a prepaid service delivered over a staggered interval
• On demand
Enter the amount you want to recognize this month based on external factors
• Frequency, non-monthly
Recognize income in certain months only, such as quarterly or any other calendar or fractional period
• Units, other
Establish your own definition of units to determine monthly and non-monthly recognition
Price page and free demo ....
Click to
open and view
softwarePrice
page
Evaluate the software
with a free demo available on price page.
The demo is the live software and any records added can be rolled into a permanent system.
Customizing the
software ....
Need
something
unique
to your
operation?
We wrote
the
software
so we
could
modify it
to meet
client
requirements,
typically
through an import, export process:
1) IMPORT
You import an Excel worksheet(s) containing your records.
The software can modify
data
values.
Perform "if this, then
that"
routines.
Table lookup data assignments.
Other requirements.
2) EXPORT
Export calculations and reports to
Excel.
Export all or
filtered
records
meeting
your
selection
criteria.
Modify data values
during
the
export
process.
Specific column headings and column order.
Other requirements
you may
have.
To find
out more
about
customizing
the
software
for your
needs,
please
contact us at your convenience.
More about the software ....
Monthly amortization and income
recognition for terms of 1 month up to 999
months
Straight line, 30 day financial
months
Half month convention,
30 day financial months
Partial month amortization, 365 actual days in
each month
Actual in-service date to date,
365 actual days in each month
Alternative methods
- percentages, designated dollar amounts, take
down usage and more
• New records: Exceptions
Defer amortizing
a record until a future begin date
Catch up amortization from a prior month(s)
when not set up when it should have been
• Amortizing
records: Adjustments during term
Single step adjustment screen to handle
changes during amortization term
Increase or decrease
amount being amortized at any time
Write off the record immediately without
deleting it
Extend
or shorten a term
• Span
calendar and fiscal amortization years
Cross over EOM, EOY periods without doing anything
No monthly or annual close-out involved
• Historical archive reporting
Generate any report from any prior month at any time
• Deferred Income Liability account reconciliation
Compare balances and activity for one or more general ledger accounts over one or more months.
Pinpoint any out-of-balance conditions.
Beginning balances. New additions. Amortization. Adjustments. Ending balances. Net activity.
Audit schedule preparation.
Provide detail activity from beginning of through end of calendar or fiscal year.
• Audit and examination support
1-800 and email assistance
Many of our clients are CPA
and accounting firms
Some import and calculate files for their clients
• Allocation
Post as direct income and
Allocate one/some/all records to multiple income accounts - branch, revenue center, department ....
Use a single or multiple user-defined methods
• Multi-company operations
Parent
Subsidiaries
Other relationships
Same or different general ledger systems
Click.
Click. All
monthly reports
with two mouse
clicks!
• Trial
Balance report
for reconciling
to general
ledger
Supports any
general ledger
chart of
accounts
Records listed
in date order
with
amortization
calculations
Subtotals for
deferral, monthly
income,
accumulated and
deferral balance
Subtotals
provided for
each:
General ledger
income account
including
branch,
department,
revenue centers
General ledger
deferred
liability
Report totals
View and print:
Records and
subtotals
Subtotals only
• Journal
Voucher debit
and credit
column posting
source document
Posting
transactions can
be:
General ledger
subtotals or
Individual
records
Transactions
can be created:
For current or a
previous month
More than once
As reversal
entries (undo)
• General
ledger posting
file
Transactions
can be formatted
for any general
ledger system
Upload the file
to your general
ledger
Paste contents
to a spreadsheet
or elsewhere
• No close
out required.
Discover an
error afterward?
Merely fix and
rerun.
Calculate
amortization for
ANY month
(income and
deferral balances for
a previous
month, current
month,
future
month, end of
next year ....)
and ANY
range of months
(month by month
income and balances for any
period - three
months, an
entire year,
even longer) at ANY
time
(now or "as of"
now but five
years down the
road)
and
generate ANY
system report
(standard,
filtered, user
defined)
to ANY
output device
(screen,
printer, Excel
worksheet or other spreadsheet)
About
your existing
records ....
Getting started
....
Three ways to
address your
existing
records:
1) Enter them
directly into
the software
using the
Editing screen.
Afterward, enter
new records
using the same
screen.
2) Import Excel
and other
worksheet
conversion data.
Continue
importing new
records, too.
3) Short on
time?
Send us a file
and we'll
convert your
records.
Prior
calculations:
Preserve
current Balance and
Accumulated.
Or the software
can recalculate
everything in a
consistent
manner from the
original date.
Import - How our
clients use this
feature:
1) Most
converted their
spreadsheet
records and now
utilize the
Editing screen.
2) Some
maintain all
records in a
spreadsheet and
always import
their entire
file.
3) Other
clients
converted, now
use the Editing
screen but also
import new
records:
Files created
at branch sites.
Sent from their
Accounts
Receivable
(A/R)
department.
Even if you
inherited a
junker file,
your existing
records can be
converted to the
software.
Unique data
conversion
values can be
incorporated,
too.
Be up and
running with a
solid system
today!
Export, too.
Copy any report
and paste to a
worksheet.
Includes Balance,
Accumulated,
Remaining Term
Other
calculated
values "as of"
any month.
Copy all
records.
Use report
filters to
selectively
choose and
generate desired
subtotals.
Features
not found in
many other
systems ....
Easy to use set
up screen with
field entry
documentation
Plus, import
data from Excel
and other
spreadsheets
Automatic
Review/Maturity
date calculation
for tickler file
reporting
System generated
ID numbers. Or
assign your own
Terms of 1
through 999
months
Maintain up to
99,999 records
"How" the
record will
amortize is
displayed as
data is entered
Description,
date, amount and
term are the
only items
needed
Default values
create new
records quickly
and consistently
Copy (dupe) an
existing record
- only change
values that
differ
( very handy
when setting up
renewals )
Copy a single
field value from
all existing
values
Notes
• Maintain
important and
other
information
about a record
• View, print
and even include
Notes on a
report
• Retrieve old
Notes from a
prior month
History file
Edit Several
• Walk through
records while
editing
• Advance to
next or previous
Multiple
amortization
methods
• Financial
months
All months have
30 days.
Amortize an item
evenly over 1
thru 999 months.
• Actual days
in each month.
First and last
can be partial
months
Amortize an item
for the actual
date to date
"in-service"
days.
• Sum of the
years digits
Recognize
greater amounts
during earlier
months,
gradually taper
down.
• Non
amortizing
recurring
income, fixed
or monthly
variable
User defined
codes for
Payer, Type and
other reporting
• Link records
to aggregate by
common purpose
• Tables for
meaningful
subtotal
descriptions,
such as Payer
names
GAAP, AICPA,
FASB compliant.
Applicable for
these records
and more ....
• Deferred
income
• Deferred
revenue
• Prepaid,
unearned fees
• Partial,
whole, interim
receipts not yet
booked to income
• Leases,
rents, other
prepaid
occupancy
charges received
•
Maintenance
agreements
covering:
Hardware,
software,
professional
services
provided
• Bond and
investment
discounts
•
Memberships,
licenses, dues,
fees
• Loan
fees, direct and
indirect lending
fees as income
•
Recurring
transactions
Fixed amount
Variable amount
• Any amortizing
record with a
monthly credit
and offsetting
debit
Allocate
monthly
amortization
....
Generally,
monthly
amortization is
posted directly
to a general
ledger income
account.
If need be, the
software can
create posting
transactions for
a single record
to multiple:
Branch,
department, RC,
revenue center
accounts.
Allocate using
one or more
Methods defined
by you, such as:
- Same
percentage to
each center
(evenly).
- A specific
fixed
percentage.
- Varying
percentage,
based on:
Workstation
count, employee
count,
department
square feet,
revenue stream,
asset dollars,
more.
- Which centers
are to
participate in
an allocation
Method.
- Virtually any
number of
different
Methods for any
purpose that can
be expressed
numerically.
Allocating is
easy:
- Merely
substitute the
revenue center
portion of a
general ledger
account number
with a Method.
Revenue center
identifiers can
be of any
length.
They can be
located at the
beginning,
middle or end of
an account
number.
- A Method can
even be shared
among records
having different
base account
numbers.
Audit trail:
The system
creates a report
showing how each
amount was
allocated.
History
and File
Archiving ....
Never lose a
report again:
• Automatic
record and
report archiving
for retrieval at
a future date
• Review all
changes made
(old value, new
value) to a
record during
its entire term
• View and
print reports
for any prior
month and year.
Send reports to
Excel. Email
requested
information to
your
CPA/auditor.
Span fiscal year
- display
general ledger
annual income
for each month.
• Go
Electronic!
Monthly history
files allow you
to print reports
only when
necessary.
Evaluate the software
with a free demo available on price page.
The demo is the live software and any records added can be rolled into a permanent system.