Deferred Revenue Software Highlights..
Click.
Click. All monthly reports with two mouse clicks!
•
Trial Balance report for reconciling to general ledger
Supports any general
ledger chart of accounts
Record listing in date order with amortization
calculations
Subtotals for receipts, monthly income,
accumulated and deferral balance
Subtotals provided for each:
General ledger income account including branch, department, revenue center,
others
General ledger deferred liability accounts
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. |
|
...
..
History
- Automatic data and report archiving
| Save
time when you need it the most!
Out of balance at end of month?
• Run the 'What's Changed' report.
See what changes
have occurred since last month.
• Isolate additions, deletions, modifications.
• Retrieve by/for each or a single general
ledger account.
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 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. |
|
...
..
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.
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 |
|
...
..
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. |
|
...
..
Reporting
Features
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.
- View, print, export
these reports, too. |
|
...
..
On
Demand Reports
Calculate
amortized results:
As of any month or year
end period
For a range of future
months
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 deferral balance as of December 31st.
Report all new records
for the previous quarter with original deferral > $1,000.00.
Report all records in
three income accounts, send report to Excel. |
|
...
.
Converting
your records (or import, below)
Even
if you inherited a junker file, your existing records can be converted
to the software.
Retain current accumulated
and balance or
Recalculate accumulated
and balance from day one
Unique data conversion values can be incorporated,
too.
Be up and running with a solid system today! |
|
...
.
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 revenue center (evenly).
- A specific fixed percentage.
- Varying percentage,
based on:
Workstation count, employee count, department square feet, income revenue
stream, 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. |
|
.
.
Excel
import
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. |
|
...
.
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. |
|
.
Partial
list of clients using one or more of our software products....
Bank
of New York
Honeywell
NBC Universal
SafeAmerica CU
Canon USA
Medcenter One, Inc.
Arrowhead
xpient Solutions
Integrated Production
Penncro Associates
Legacy Texas Insurance
NBRS Financial
Credit Factor Corp
RAF Technology
Roanoke County
Cracker Barrel |
Houghton
Mifflin
Air Force Federal
First Tennessee
Metavante
Iowa HSAA
Baptist Health System
Carolina Alliance
United Community
Mecca, Inc
Safra National
MemberSource
US Global
Cloister Wash & Lube
Damariscotta B&T
Integrity
Hostelling International |
First
Horizon
ViDeOnline Inc.
Tioga County
Ektettab
Carthage Area Hospital
National Council
Equity Plus
Pullman Memorial
Franklin Savings
D&A Mortgage Funds
West Georgia Health
Axxya Systems
Midland Community
First American
Electro Savings
Omni Capital |
Alliance
Imaging
Crescent Bank
EUP Property Investment
West Point Underwriters
OST
Progressive Gaming
Holy Spirit Hospital
TELUS
Thomson Financial
Clark Nuber, PA
McCombs Enterprises
WESLA FCU
Seaway National
Mindworks, LTD
Cross County
Atlantis Marine World |
|
|
|