A single system
to amortize, generate accounting reports and journal postings
for all of your accounting worksheet records ....
Use multiple worksheets or
a single worksheet for
PREPAIDS ....
• Prepaid,
capitalized
expenses
• Deferred
charges, costs
•
Insurance
premiums
•
Maintenance
agreements
• Deferred loan fee income and expense
DEFERRALS ....
• Deferred income,
revenue
• Unearned fees
• Partial, interim receipts
ACCRUALS
....
• Taxes -
Federal, state,
county
• Audit and
regulatory fees
• Assessments
and reserves
FIXED ASSETS ....
• Tangible assets
• FF&E
• Property, equipment
BONDS
....
• Bond
premiums
• Bond
discounts
•
Amortization and
accretion
OTHER
....
Other records requiring amortized recognition over 1 to 999 months
Copy a worksheet
Paste to the software for
- Calculations
- Trial Balance report
- Journal Voucher
Subtotals or records
- Upload posting file
Total Debits and Credits may be higher when posting each individual record because no "netting" occurs for negative amounts. |
Copy worksheet records to the software for calculations and reporting at any time.
Use as many different general ledger account numbers as required.
Methods:
- Full months
- Partial months
Sample reports:
Calculations for February, 2012
- Prepaids
- Deferred and
- Accrued expenses copied from a single worksheet
The software creates
- This Trial Balance for balancing
- Journal Voucher (scroll to next image)
- General ledger upload posting file
Journal Voucher #1 of 2
Postings at general ledger account Subtotal Level
Journal Voucher #2 of 2
Postings for each individual record (supports other posting subtotals, too)
 |
Sample worksheet ....
Available in 2
calculation
versions
1) Term
is in months, includes these three methods:
• 30 day financial months
• Actual days in each month, including partial first and last months
• Accelerated sum of the years digits (more is recognized during earlier months)
2) Term
is from a date
to a maturity or
ending date
Calculation
periods are from
a date to a
date.
Set any
beginning and
ending date.
Amortize for
• Daily
periods (day to
day, such as
recognizing
amortization
each day of the
month) plus
•
Multiple days or
date range to
include the
weekend
• Weekly,
multiple weeks
• 4-4-5
• Monthly
(actual days in
month - 31, 30,
28)
•
Quarterly
• Any
other date to
date periods
Simply copy
and paste
worksheet
records to the
software
Paste dozens,
hundred,
thousands of
records.
• A
flexible, easy
to use
accounting
system your
auditors will
appreciate
•
Complete
reporting
capabilities
• Span
calendar/fiscal
years
No "end of year"
hassles or
initialization
or need to
create new
worksheets
•
Supports any
general ledger
chart of
accounts.
• Adjust for
partial refunds,
additional
disbursements
• Generate
monthly
accounting and
posting reports
•
Additional
reporting
available for up
to 4 separate
user defined
code values
• View.
Print.
Export all
reports to
Excel.
• The
software comes
with a complete
set of
templates.
Or keep all
records in a
single
worksheet.
Maintain
other accounting records
in
worksheets, too
• Any
amounts needing
to be amortized
over 1 to 999
months requiring
general ledger
balancing,
posting and
reporting
|
How it
works
Amortize and run
reports at any
time.
Simply
• Copy an
entire worksheet
as if copying to
another
worksheet
Worksheet rows
contain:
- Description
- Begin date
- Amount to
calculate
- End of term
date or a term
in months
- 4 more columns
for user defined
codes and
reporting
- General ledger
account numbers
to be debited
and credited
• Click
"Paste" on
software's
import window
Set calendar
dates to
amortization
calculation
period
View, print,
even export
(copy/paste) all
reports
Create general
ledger posting
file
Direct post or
allocate to
branch, cost, RC
accounts |
