Dashboards and Reports

Dashboards and reports are downstream of account, balance, holding, transaction, category, and source health. If the inputs are clean, the views become easier to trust.

Home overview

Home is the fastest place to review the workspace. It shows high-level financial metrics such as net worth, assets, debts, and cash on hand.

Use it as a check-in:

• Are the headline numbers directionally right?
• Did net worth change for an explainable reason?
• Are assets or debts missing?
• Is cash on hand complete?
• Does a source look stale?
• Do spending summaries reflect the right date range?

Click metric cards that support breakdowns to inspect the accounts behind the number.

Net worth history

The net worth history chart is built from included account balances over time. It becomes more useful after Tablewealth has enough balance history.

If the chart is empty or sparse, it may simply need more days of balance history. If the chart jumps unexpectedly, check for a new account, duplicate account, stale manual value, liability sign issue, or source refresh.

Cash flow views

Cash flow is only as good as transaction cleanup.

Before trusting cash flow:

• Review the date range.
• Confirm income transactions are categorized correctly.
• Confirm spending transactions are categorized correctly.
• Mark transfers.
• Check pending transactions.
• Check ignored records.
• Review large transactions.
• Look for broad rules that changed a category total.

Transfers and duplicates create many false spikes. Fix those before changing the report design.

Holdings and allocation reports

Investment reports depend on holdings, cash, price dates, and account inclusion.

Before reading allocation:

• Confirm investment accounts are present.
• Confirm holdings synced or were entered manually.
• Check market values and price dates.
• Decide how investment cash should be represented.
• Check for duplicate securities across accounts.
• Confirm private investments have current manual valuations.

Allocation can look wrong when a brokerage cash position is counted both as cash and as an investment holding.

Custom dashboards

Custom dashboards let you create and revisit dashboards built around your own questions. A dashboard can have a draft, saved versions, recent conversation threads, and a published or archived state.

Use custom dashboards for questions that the default Home view does not answer well, such as:

• Advisor review screens.
• Liquidity and debt planning.
• Portfolio allocation workspaces.
• Subscription audits.
• Monthly cash-flow planners.
• Family-office review surfaces.

Keep dashboard prompts specific. "Show net worth by source and flag stale accounts" is more useful than "make a finance dashboard."

Spreadsheet reports

Spreadsheet sync is often the best reporting layer when you want formulas, pivots, custom formatting, or a model that lives outside the app.

Use Google Sheets or Microsoft 365 sync for live workbooks that should not count against API usage. Use local Excel sync only after Tablewealth enables access for your workspace; local Excel sync usage counts against API usage.

For the Tablewealth Comprehensive Sheet, use the Summary, Monthly Cash Flow, Net Worth Trend, Categories, Rules, and Settings tabs as the working surface. Avoid editing app-managed source columns in Transactions Raw, Balances Raw, and Holdings Current.

Sharing reports

When sharing a dashboard, spreadsheet, export, or screenshot, include enough context for another person to understand the number.

Include:

• Date range.
• Account scope.
• Source types included.
• Whether manual or imported records are included.
• Whether pending transactions are included.
• Whether ignored records are excluded.
• Whether transfers are excluded from spending.
• Whether the spreadsheet uses latest values or history snapshots.
• Any manual adjustments.

If values are sensitive, use privacy mode or hide values before sharing a screen.

When a chart looks wrong

Check data in this order:

1. Source freshness.
2. Duplicate accounts.
3. Included or excluded account settings.
4. Balance date.
5. Manual account values.
6. Uncategorized transactions.
7. Internal transfers.
8. Ignored records.
9. Category rules.
10. Spreadsheet sync scope.
11. Manual adjustments.

The dashboard is usually the messenger. The fix usually lives in Accounts, Transactions, Categories & tags, Spreadsheet sync, or Settings.

Recurring review routine

For a monthly or quarterly review:

1. Refresh provider data.
2. Update manual values.
3. Review source health.
4. Clean transactions.
5. Review categories and rules.
6. Check net worth and cash.
7. Review holdings and allocation.
8. Rerun spreadsheet syncs.
9. Review custom dashboards.
10. Save notes for anything that required judgment.