FASB
91
Effective Interest Method
|
Excel
Import
Paste Worksheet Data
|
| Financial
Data Support Systems, Inc.
|
|
.
.
For
PC, laptop,
workstation and
shared devices
running Windows®
7,
Vista, XP, ME, NT and
other network versions |
|
|
.
..
..
The
simplest way yet to amortize spreadsheet records!
Maintain
your data in one or more Excel worksheets:
• Click worksheet upper left corner to
highlight all data
• Click "Copy"
Copy rows containing:
- Description
- Begin date
- Amount to calculate
- End of term date
- 4 more columns for user defined codes and reporting
- General ledger grouping account numbers are place on applicable rows
• 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 |
|
...
.
Calculation periods supported
•
Daily
• Multiple days or date range
• Weekly, multiple weeks
• 4-4-5
• Monthly (actual days in month)
• Quarterly
• Any other date to date periods |
|
.
Just
some of the benefits provided by this software ....
 |
Comes
with Excel worksheets (or use your own/other spreadsheet) |
|
Add,
insert records and general ledger accounts at any time |
|
Include
adjustments for partial refunds, increases |
|
Amortize
for terms of any length |
|
Amortize
for current, prior, future period |
|
No
rollover, carry forward or other end of year hassles |
|
Subsidiary
Ledger trial balance report |
|
Journal
Voucher source document report |
|
General
ledger upload posting file |
|
Supports
any chart of accounts |
|
Management
reporting, including graphs |
|
Calculate
for multiple periods, too, or your entire fiscal year |
|
|
...
Two easy steps
1)
Copy
Excel, other worksheets containing
- Prepaid, deferred,
capitalized expenses
- Bond premiums and
discounts
- Deferred income, revenue,
fees
- Fixed assets, leaseholds
- Accruing expenses
- Other accounting records
2) Paste
to the software
• Set calculation
calendar to any two date period
• Amortize
• Depreciate
• Full set of
accounting reports prepared on demand |
|
. |
|
|
|
