Accounts and Connections
Understand how account connections and account records work in Tablewealth.
Accounts are the backbone of Tablewealth. They determine what appears in net worth, holdings, transactions, dashboards, spreadsheet syncs, and API responses.
Account records
An account is the canonical financial object Tablewealth uses across the workspace. It may represent a checking account, credit card, brokerage account, retirement account, mortgage, private investment, real estate property, cash balance, collectible, vehicle, or other asset or liability.
The account record answers "what financial object is this?" Source details answer "where did this record come from?"
That distinction lets one workspace include:
- Provider-backed accounts from connected institutions.
- Manual accounts you enter yourself.
- Imported accounts from supported offline files.
- Accounts that feed spreadsheet or dashboard workflows.
Source types
Provider-backed sources are connected through an external financial data provider. Plaid is the current provider for institution linking. Provider-backed sources can update balances, holdings, transactions, and connection health when the provider supports them.
Manual sources are entered and updated by you. Use them for assets and liabilities that do not have a live provider connection or that you intentionally want to manage yourself.
Imported sources come from supported file-based flows. They are useful for historical records, offline investments, private market data, and cases where an integration is not available.
Add an account
Use Add account from Accounts, Transactions, Holdings, or other account-aware surfaces.
The add-account flow starts with account lanes:
- Banks: checking, savings, cash balances, and other bank accounts.
- Investments, retirement, and private markets: brokerage, retirement, pension, private equity, venture, angel investments, crypto, and related records.
- Credit cards and loans: credit cards, mortgages, student loans, and other liabilities.
- Real estate: homes, rental properties, land, and other real estate holdings.
- Other assets: collectibles, valuables, vehicles, and other manually tracked assets.
Some lanes offer institution linking. Some lanes go directly to manual entry because those assets usually do not come from a live provider.
Connected institutions
Provider-backed accounts are linked through a connection. A connection can represent one institution login and may bring in multiple accounts.
Common connection states:
- Active: the provider connection is healthy and can be used for sync.
- Login required: the provider needs you to reauthenticate or refresh access.
- Pending expiration: the provider connection may soon require attention.
- Pending disconnect: the connection is in the process of being removed.
- Disconnected: the provider connection is no longer active.
- Error: Tablewealth or the provider could not complete a sync.
You can manage financial connections from Settings > Financial connections > Sync.
Refreshing data
Use Refresh on Accounts, Transactions, or Holdings when you want a fresh provider pull. A refresh can update balances, holdings, and transactions depending on the account type and provider support.
Refresh is not a fix for every issue. If the connection needs reauthorization, reconnect it first. If the account is manual or imported, update the manual value or import a newer file instead.
Manual accounts
Use manual accounts for records that should exist in Tablewealth even without a live connection.
Good examples include:
- A home or rental property.
- A private company investment.
- An angel investing or venture portfolio record.
- A vehicle.
- A personal loan.
- A collectible or valuable.
- A cash balance that is not connected.
- An old account kept for historical tracking.
For manual accounts, keep the account name, source label, current value, ownership percentage, and valuation date understandable. A future reviewer should be able to tell what the value represents and when it was last updated.
Imported accounts
Imported accounts behave like account records with an import-backed source. They can support net worth, holdings, and reporting workflows without being tied to a live provider.
Imports are best when the source is a bounded dataset, such as a statement, an investment export, or a historical account range. If the data changes often and a provider or spreadsheet sync is available, use a recurring source instead.
Account settings
Account settings control how an account participates in the workspace.
Common settings include:
- Include or exclude from net worth.
- Include or exclude from the default transactions view.
- Manual account details such as account type, value, source label, and ownership percentage.
- Source details for provider-backed accounts.
Use exclusion settings carefully. Hiding a noisy account can make a report cleaner, but excluding a real asset or liability can make net worth misleading.
Duplicate accounts
Duplicates usually appear when the same real account is added through more than one source.
For example, the same brokerage account might be connected through a provider and imported from an old statement. A real estate asset might be entered manually and later imported from another source.
Before deleting or hiding anything, compare:
- Institution or source name.
- Account nickname or official name.
- Last four digits when available.
- Current balance and balance date.
- Transaction history range.
- Holding list.
- Whether one record exists only for historical reporting.
If both records are useful, rename them clearly. If one is accidental, hide, archive, or remove the accidental copy before trusting net worth, cash flow, or allocation totals.
Troubleshooting account health
When an account looks wrong, check in this order:
- Is the source connected, imported, or manual?
- Is the connection healthy?
- Did the account sync recently?
- Is the balance date current?
- Is the account included in net worth?
- Is the account included in the transactions view?
- Does another source contain the same real account?
- Does the provider support the data type you expect, such as holdings or transactions?
If a connected account shows healthy but data is missing, contact support with the workspace, institution, affected account, expected date range, and what value or record is missing.