NetClose - Amortization Reports
Overview
NetClose offers two amortization reports designed to provide accurate data and clear insights: the Amortization Roll Forward report and the Amortization Waterfall report.
Step-by-step process
Both reports can be accessed via NetClose > Reports.
- The Amortization Roll Forward report shows the initial balance, additions, amortizations, adjustments, and ending balance for each amortization and is organized by amortization type. This report can show processed activity or expected activity. See Expected vs Processed below.
- The Amortization Waterfall report shows amortization activity by period and is organized by amortization type. This report can be viewed by month or by fiscal year and may be useful for forecasting.
If desired, additional detail from the amortization record can be added as columns for more context. This can be done using the preferences icon in the top right of each report next to the export button.
Expected vs. Processed (Roll Forward only)
Use the Show toggle in the Amortization Roll Forward filter panel to switch between Expected and Processed.
- Expected includes every scheduled amortization line in the date range, whether or not it has been processed. Use it to see what the balances will be once all scheduled activity runs, including activity that is still pending.
- Processed includes only lines that have been processed and whose journal entries have posted to the general ledger. A journal entry that is still waiting for approval is not counted. Use it to tie the report to the GL.
Negative balances in the Processed view
Because unapproved journals are left out, the Processed view can show a negative prepaid balance. For example, if the capitalization journal for February is still pending approval but the March amortization has posted, the March row ends with a negative balance. Approve the pending journal, or switch to Expected, and the balance corrects.
Filters
Both reports share the same filters. The filters available depend on your account configuration:
- From, To, and Period - the date range and accounting period for the report.
- Amortization Type - limit the report to selected amortization types.
- Subsidiary and Consolidated Subsidiary - shown when OneWorld is enabled. Use Consolidated Subsidiary to roll results up to a parent subsidiary.
- Accounting Book - shown when Multi-Book Accounting is enabled. Limits the report to amortizations assigned to the selected book.
- Vendor, Department, Class, and Location - filter by segment.
How Thereafter is calculated (Waterfall only)
The Thereafter column on the Amortization Waterfall report holds amortization activity dated after the report's To date.
NetClose places each schedule line in an accounting period by matching the line's start date to the period that contains it. If that period is one of the report's columns, the amount appears in that column. If the period falls after the To date, the amount appears in Thereafter.
A schedule line only appears in the report if NetClose finds a matching accounting period. The period must be:
- Active
- Not an adjustment period
- A posting period, or a fiscal year period when Show by is set to Fiscal Year
If you use multiple fiscal calendars, NetClose matches against the default calendar.
If a Thereafter balance is missing
A schedule line with no matching accounting period is left out of the report entirely. It does not move to Thereafter, so you see no balance at all. Check the following:
- Confirm the periods exist. Go to Setup > Accounting > Manage Accounting Periods and check that the period containing the schedule line date exists, is active, and is a posting period, not an adjustment period. If the periods are missing, create the fiscal year and run the report again.
- If Show by is set to Fiscal Year, confirm a fiscal year period exists for the year the line falls in. Without it, those lines are left out.
- Check the line type. The Waterfall counts only Amortization and Write-Off schedule lines. Initial and Modification lines are excluded.
- Check the date filters.
- Lines dated before the From date are excluded.
- If the To date runs past a line's period, the amount appears in that period's column, not in Thereafter. Thereafter holds only amounts after the To date.
- If Date Filter Type is set to Posting Period, a line with a journal entry follows that journal's posting period. A line with no journal entry yet uses its schedule line date.
- Check the amortization record. It must be active. Its accounting book, from the amortization override or the amortization type, must be active for the subsidiary. Otherwise its lines do not appear.
Currency and consolidated display
When Multi-Book Accounting is enabled, report amounts (Additions, Amortizations, Adjustments, Initial Balance, and Ending Balance on the Roll Forward; period activity on the Waterfall) display in each row's accounting book base currency rather than the amortization's own currency. The currency symbol shown on each row matches that book's base currency.
Consolidated and book-specific amounts
When you apply a Consolidated Subsidiary filter, amounts convert to the parent subsidiary using the consolidated exchange rate and rows display the consolidated currency symbol. A book-specific amortization - one that posts only to a secondary book - displays in that book's currency using that book's consolidated rate, so the value ties back to the corresponding NetSuite report. A book-specific amortization on a book that is not set to consolidate is excluded from the consolidated report.
For how NetClose resolves these rates, see NetClose - Amortization Exchange Rate Handling.
