Import bank and card history
Build historical books from CSV or Excel exports in Settings, review the detected accounts and categories, then import the checked package.
Open CSV Import
Select the company, open Settings > Import & Export, and choose CSV Import. This is the place to start or resume a bank and card CSV import. Tally chat does not run this workflow.
Upload one CSV or Excel export for each bank or credit-card account you want to build. ZIP packages are accepted. Include the full period that belongs in the company and avoid sending overlapping files for the same account.
Check The Files
Choose Check files after the package is attached. LedgerHQ identifies the date and amount columns, groups rows into accounts, checks duplicate files and rows, and reports files that need attention.
The import is saved for the selected company. You can leave the page and return to Settings > Import & Export > CSV Import to continue it.
Confirm Accounts
Review each detected account. The review can include:
- account name and register type;
- Books begin date;
- opening balance;
- covered date range; and
- any coverage gap that needs an explicit acceptance.
Use the correct register type for a bank, credit card, asset, or loan account. Correct anything the export did not prove before moving on.
Review Merchant Coding
The review stage groups activity for Merchant coding review. Groups with orange Review labels need a decision. Green Ready groups can continue with the suggested category. Use the search field to find a vendor or research a group, and inspect transfer and credit-card-payment candidates before assigning an income or expense account.
The import keeps confirmed transfers separate from ordinary vendor categories. Do not force a transfer into an expense account just to clear a review group.
Approve The Package
When the account setup and categories are correct, review the financial preview and the summary of vendors, changed suggestions, Ask Client groups, confirmed transfers, and source rows.
- Approve Categories & Import posts the checked package.
- Save categories only keeps the coding decisions without importing the history.
- Cancel and start over discards the in-progress import before posting.
The final import screen can show Import CSVs after the files are ready. The import runs on LedgerHQ's servers, so closing the browser does not stop it.
Import only after the company, date range, account setup, and financial preview are correct. A completed package is not reopened by uploading the same files again; correct resulting activity through the normal coding, journal, and review workflows.
Review The Completion Summary
After verification, the summary can show Accounts, Source rows, Imported, Posted, Parked, Excluded, Duplicates, Ask Client groups, matched transfers, and verification checks. Parked or excluded rows remain visible for follow-up rather than becoming ordinary posted history.
Open View Registers to inspect the imported accounts. Then collect statements and use Bank Recs to set up or confirm the account's next reconciliation. Current Plaid activity and historical CSV imports share the same accounting workflow after the history is in LedgerHQ.