Excel add-ins for accounting firms
Planned tools for CPA firms and finance teams that take the re-keying out of busy season: pulling trial balances, posting journal entries, reconciling bank accounts and preparing 1099s. None of these are available yet. We are looking for firms to help shape them.
Accounting & Finance roadmap
Trial Balance Bridge
GL imports and account mapping
Pull trial balances from client systems such as QuickBooks Online, Xero, Sage Intacct and NetSuite, and map accounts to your workpaper and tax formats.
Journal Entry Builder
Build and post entries
Prepare journal entries in Excel with balancing checks, validate them against the client chart of accounts, and post them to the GL.
Bank Rec Automator
Bank reconciliations
Match bank activity to GL transactions and produce reconciliation workpapers with outstanding items listed.
1099 and W-2 Prep Bridge
Year-end compliance
Pull vendor payments from the GL, apply 1099 thresholds, compare with the prior year and export for filing.
Client Data Collector
PBC requests
Track prepared-by-client requests and pull data from uploaded documents into workpaper templates.
Workpaper Sync
Linked workpapers
Link workpaper cells to their source data and flag when the source changes after you pulled it.
Consolidation Bridge
Multi-entity consolidation
Combine trial balances from several entities with ownership percentages, eliminations and currency translation.
Lease Accounting Assistant
ASC 842
Calculate lease liabilities and right-of-use assets, build amortization schedules and produce the journal entries.
Firm data in SQL Server or another database?
If your firm or your clients keep data in SQL Server, PostgreSQL or another supported database, Data Bridge Pro is in early access today. It lets staff update that data from Excel with validation, an audit log and rollback.
Built with practitioners
Optalytic also builds Practice Ledger, its time, billing and firm economics software for CPA firms. We want these tools shaped by firms that will use them, so early conversations directly influence what we build first.
Tell us where busy season hurts
Book a call with our team. Tell us which tasks eat your staff time and we will tell you where these tools stand.