PDF and Excel exports
Every statement and schedule exports to PDF and Excel, with your logo and the options your bank or board expects.
What exports
These export to both PDF and Excel:
- Trial Balance
- Balance Sheet, Income Statement and Cash Flow Statement
- Consolidated and consolidating statements
- KPIs (see Exporting your KPIs)
- Budget Analysis
- Forecasts
- Loan amortization schedules
- The depreciation schedule for all your assets
A single asset's depreciation schedule exports as CSV. Scorecards can't be exported yet.
Look for Export on the page, or in its toolbar.
Common options
What's offered depends on the page:
- Show Logo and Show Name: your company's logo and name in the header.
- Mark as Unaudited.
- Round To: no rounding, the nearest dollar, thousands or millions.
- Hide Zero-Value Rows.
- Orientation: landscape or portrait.
Statements export with the template you're using.
Page by page
- Trial Balance: apply your current filters, include totals, include your comments (and Lou's suggested ones), and use Excel formulas for the totals.
- Balance Sheet: a check row, the net income row, a breakdown by account, or categories only.
- Income Statement: hide percentages, and choose divisions.
- Cash Flow Statement: a single month or year to date.
- Budget Analysis: the chart, the summary table and a monthly breakdown.
- Forecasts: the scenarios and statements to include; the supporting schedules come as a separate PDF.
- Loans: one loan or all of them, and inactive loans if you want them.
- Depreciation: the years to cover.
Exports are files you download or email. There are no shareable links.