Prepaids Automated
- Regular price
- $129.00
- Sale price
- $129.00
- Regular price
-
Prepaids Automated is a purpose-built Excel engine for managing prepaid expenses across their full lifecycle—from initial setup through monthly amortization, roll-forwards, and reconciliation.
Unlike formula-driven spreadsheets, the tool is designed around real accounting workflows: changing terms, mid-month starts, renewals, policy alignment, and audit traceability.
The product is available in two editions:
- Core – structured schedules and standardized logic for teams that want consistency and control.
- Pro – a fully automated Power Query–driven engine that eliminates manual amortization work during the close.
Included in all editions
- Structured prepaid schedules with standardized logic
- Clean amortization tables and balance tracking
- Support for custom start/end dates and accounting policies
- Excel-native design (no external systems or add-ins)
Pro edition
- Power Query–based automation engine
- One-click refresh for monthly amortization and roll-forwards
- Automated journal entry outputs
- Built-in reconciliation and audit traceability
Choose your edition
Both editions manage prepaid expenses and amortization. Pro eliminates the manual work.
Core
Structured prepaid amortization
Pro
Fully automated, subledger-style amortization engine
From setup to close-ready outputs in a few steps
Set up your foundation
Begin by defining your companies, dimensions, and chart of accounts. The system supports multiple entities and unlimited dimensions, allowing it to mirror your real organizational structure. This setup is typically done once. From there, the system automatically connects everything for consistent amortization and reporting.
Enter prepaid activity
Enter prepaid expenses as they occur — one line per item. Assign the company, dimensions, prepaid account, amortization account, amount, and dates. Once entered, prepaid records carry forward automatically into future periods. No re-entry, no manual schedule maintenance.
Refresh and calculate
Click Refresh to run the automation engine. The system recalculates amortization schedules, rollforwards, balances, and period activity across all prepaids. If nothing has changed, no action is required — existing schedules remain accurate without extra work.
Review, post, and analyze
The system generates close-ready outputs including journal entries, balance sheet reconciliations, and an auditors’ report. Reports are fully filterable by company, account, time period, and dimensions. Detailed general ledger support is included, giving you complete transparency and audit traceability.
Key Features
These features support automated amortization, close-ready outputs, and audit-grade reliability at scale.
Automated Amortization
Generate complete monthly amortization schedules automatically using a controlled automation engine. No manual rebuilds, no broken formulas.
Journal Entries & Rollforwards
Produce close-ready journal entries and rollforward schedules that reconcile beginning balances, activity, and ending balances every period.
Balance Sheet Reconciliation
Built-in reconciliation views tie prepaid balances directly to the general ledger, eliminating manual tie-outs and variance hunting.
Audit-Ready Structure
Transparent logic, consistent calculations, and period-by-period traceability make auditor review straightforward and repeatable.
Multi-Entity & Dimensional Support
Support unlimited entities, accounts, and dimensions, allowing the system to scale from simple environments to complex organizations.
Excel-Native, No Add-Ins
Runs entirely inside Excel using native capabilities. No external systems, no add-ins, no IT implementation required.
Forecasting & Planning Friendly
Load future prepaids and renewals to project expense timing, balance sheet impacts, and forward-looking views for FP&A.
Designed for Recurring Close Cycles
Built to operate month after month without rework. Once set up, the system carries forward activity automatically for consistent, repeatable closes.
Core vs Pro at a glance
Both editions standardize prepaid amortization. Pro adds full automation, reconciliation, and close-ready outputs at scale.
| Capability | Core | Pro |
|---|---|---|
| Standardized prepaid schedules | ✓ | ✓ |
| Formula-driven calculations | ✓ | ✓ |
| One-click automation engine | — | ✓ |
| Automated journal entries | — | ✓ |
| Rollforwards & balance sheet tie-outs | — | ✓ |
| Multi-entity & dimensional scale | Limited | Unlimited |
| Designed for recurring close cycles | — | ✓ |
| Audit-ready outputs | Partial | ✓ |
Pricing & Licensing
Prepaids Automated is a one-time purchase with flexible licensing based on team size. Choose Core for standardized amortization, or Pro for a fully automated, subledger-style solution.
Core
- One-time purchase
- Formula-driven standardization
- Best for low-volume or straightforward environments
Pro
- One-time purchase
- Includes the full automation engine
- License tiers scale by number of users/devices
- Designed for recurring close cycles
FAQs
Prepaids Automated is built for controllers, accounting managers, senior accountants, and CFOs running lean teams. If you’re responsible for accurate month-end financials and want consistent, repeatable workflows without adding new systems, this tool is for you.
Yes. You can load future renewals, prepaid purchases, or contract start dates to generate forward amortization, expense timing, and projected prepaid balances. This makes the tool valuable for budgeting, forecasting, and planning — not just accounting.
Prepaids Automated runs natively in Microsoft Excel — no additional software is required.
To use the full functionality, you need:
- Excel for Windows or Mac
- Macros enabled (VBA)
- Power Query (included in current versions of Excel)
- Ability to run local activation (no network transmission required)
If macros are disabled, the workbook opens in read-only mode until activated.
Licensing is simple. Each purchase covers one user, who may install the tool on up to two machines (typically a desktop and laptop).
When the file opens, your machine is automatically recognized and activated. Activation happens locally on your device — no data is transmitted.
Additional user tiers can be added at checkout, and larger teams can contact us anytime for enterprise licensing options.
If a machine isn’t licensed, the workbook opens in read-only mode until a valid license is added.
Your download includes:
- Prepaids Automated (.xlsm) — full automation engine
- Sample dataset for testing and onboarding
- Getting Started guide
- Troubleshooting resources
- Support access for licensing and activation
- Free updates for the current version
Yes. You receive free updates for the current version of the tool.
Major enhancements released in the future will be available as optional upgrades.
You have full access to our Getting Started resources, troubleshooting guides, and file re-downloads. If you need additional help, reach out — we’re here to make sure you get up and running quickly.