Skip to content

Accounting feature status

Reconcile from an uploaded bank statement

Invoice Crowd does not connect to your bank. Download a structured statement from your bank, upload it, review the server-generated preview and reconcile it against recorded activity without sharing online banking credentials.

  • Structured statement import
  • Credential-free bank review
  • No live bank connection needed
Invoice Crowd Import Bank Statement wizard with detected columns, a month-first date format and a preview of 14 normalized transactions from an uploaded statement file

What is actually available

Bring bank activity in without inventing a live connection

The current workflow is file-based and deliberate. Importing bank rows never creates accounting entries or marks anything reconciled by itself.

Upload a structured statement

Private, bounded processing

Invoice Crowd Import Bank Statement step for CSV, Excel, OFX, QFX, QBO, QIF, CAMT.053, MT940 and BAI2 files up to 10 MB

Use the file your bank exports

Upload CSV, TXT, XLS, XLSX, OFX, QFX, QBO, QIF, CAMT-style XML, MT940 or BAI2 up to 10 MB. Scanned PDFs and images are not parsed.

  • Structured formats only
  • 10 MB upload limit
  • No OCR claim
Invoice Crowd statement import with the detected amount layout, date format and header row, read again on the server before anything is imported

Parse without trusting the browser

The server detects and normalizes dates, amounts, debit and credit direction, currency and running balance. Unsafe XML, spreadsheet expansion and unsupported row layouts are rejected.

  • Preview built by our server
  • No spreadsheet formula calculation
  • XML network access disabled

Review before import

Nothing posts automatically

Invoice Crowd statement import mapping with the amount layout options, month-first date format and each column assigned before import

Correct the mapping and inspect every row

Header and column detection are assistance. The user can correct the mapping before import, and the server re-reads the private source rather than trusting client preview values.

  • Header scan is bounded
  • Locale-aware amount and date handling
  • Mapping stays business and account scoped
Invoice Crowd refusing the same statement file twice for one bank account, and skipping transactions that were already imported

Reject duplicates and overlap

The exact file hash is unique within the owner, business and account scope. Normalized row fingerprints prevent overlapping imports while retaining legitimate repeated transactions.

  • Exact duplicate file rejected
  • Overlapping rows skipped
  • Repeated legitimate rows preserved

Reconcile deliberately

Import is not reconciliation

Invoice Crowd uncategorized statement lines with matched rows ticked and an unmatched bank fee opening a prefilled Create Expense form

Match against recorded activity

Imported rows enter the Bank Reconciliation workspace. An unmatched line can prefill an Income or Expense form, but the user must review and save through the normal accounting workflow.

  • No automatic accounting post
  • No automatic payment
  • User reviews missing entries
Invoice Crowd bank reconciliation that will not close while a $28.00 difference remains between the statement and the cleared balance

Close at exact zero, with audit evidence

Closing succeeds only when server-authorized ledger entries exactly cover the statement and the server-calculated difference is zero. A permitted reopen records the actor, time and reason.

  • Exact-zero close
  • Durable match evidence
  • Audited reopen

Reconciliation workflow

Import, review and reconcile bank statements

Use a structured statement file from your bank, in CSV, Excel, OFX, QFX, QBO, QIF, CAMT.053, MT940 or BAI2, as reviewable evidence. Invoice Crowd does not connect to your bank or pull transactions automatically.

  • Private statement workflow

    Upload a structured export from the bank without entering online banking credentials into Invoice Crowd.

  • Bank-independent import

    Use the same supported statement workflow regardless of which bank produced the structured export.

  • No live connections

    Invoice Crowd does not connect to banks.

  • Review before reconciliation

    The supported path begins with a structured statement file downloaded from the bank.

  • Wide structured-format support

    CSV/TXT, XLS/XLSX, OFX family, QIF, CAMT-style XML, MT940 and BAI2 are supported within parser limits.

  • Structured data for reliable matching

    Images and scanned statements need a structured export from the bank.

  • Duplicate protection

    Exact files and overlapping normalized rows are rejected or skipped in the same account scope.

  • Your business only

    Owner, business profile, account, currency and period are verified server-side.

  • Review before creating records

    Statement rows are evidence to reconcile, not accounting entries.

  • Account-currency integrity

    A statement must use one ISO currency matching the accounting-currency account.

  • Exact-zero close

    Client-supplied difference values are ignored and the server recomputes the close.

  • Audit-preserving reopen

    Authorized reversal keeps the original statement, match history and reason.

Questions

Bank feed availability, answered

Does Invoice Crowd connect directly to my bank?

No. Invoice Crowd does not currently connect directly to a bank-data provider. Upload a supported structured statement from Bank Reconciliation instead.

Can I connect Plaid or Yodlee?

No. There is no active provider onboarding, token storage, scheduler or transaction-sync service. Historical provider rows remain read-only evidence only.

Which statement files can I upload?

CSV, TXT, XLS, XLSX, OFX, QFX, QBO, QIF, CAMT-style XML, STA/MT940 and BAI/BAI2 are accepted within the documented size, row and parser limits.

Does importing a statement create accounting entries?

No. Import creates normalized reconciliation rows. An unmatched line can prefill an Income or Expense form, but a user must review and save it normally.

Can a reconciliation close with a difference?

No. The server requires selected, authorized ledger activity to cover the statement exactly and the calculated difference to be zero.

Why keep this bank-feed URL?

It tells people who search for bank feeds that Invoice Crowd does not offer them, and shows the statement upload that does the job instead, rather than implying an integration that does not exist.

Use the bank evidence your accounting can prove

Download a structured statement, preview and import it, then reconcile against the records already in the correct business, account, currency and period.

  • No bank credential sharing
  • No automatic accounting writes
  • Close and reopen stay auditable