Accounting
Match your uploaded bank statement against the income, expenses, bills and payments you've recorded, and close when the difference is zero. Each new statement opens at the last closed balance, so every month picks up where the last one ended.
How it works
Upload, review, match and close in clear steps. Nothing reaches your books until you choose to record it.
Check before you import
Upload CSV, TXT, XLS, XLSX, OFX, QFX, QBO, QIF, CAMT XML, MT940 or BAI2 files up to 10 MB. Invoice Crowd finds the header row and reads the columns for you.
Invoice Crowd keeps a private copy of your file, recognizes it if it's uploaded again and builds the preview itself. Change the account, period or closing balance and the file is read again to match.
You decide what's recorded
Each line is checked against the statement period and the account's currency, and running balances are verified whenever your bank includes them.
An unmatched line can open a prefilled Income or Expense form, and Bank Rules you create suggest its category. Review it, save it, and it's ready to match.
Match transactions on a statement line opens a drawer where one deposit or withdrawal clears several recorded entries at once, such as a $970.00 payout that settles a $1,000.00 invoice payment and a $30.00 fee. Save match keeps the group with the line until you close, and Clear Match starts it again.
A clear record of every close
Invoice Crowd recalculates every amount and closes the statement when your matched withdrawals and deposits cover it exactly. Matched entries then stay protected until the statement is reopened.
Team members with the Reverse Accounting Entries permission can reopen a closed statement with a short reason. The original statement and matches are kept, along with who reopened it, when and why.
Reconciliation controls
Each business's data stays separate, and your records, currencies and history are protected at every step.
Your statement file is stored privately and removed once the import is complete.
The same statement file is recognized if it's uploaded again to the same account.
Lines already imported are skipped, while genuine repeat transactions are kept.
Your column mapping is remembered for each bank account.
Spreadsheet formulas and external references are ignored, so files are read as data only.
Each statement matches your accounting currency, so every amount is exact.
Invoice Crowd works out the difference itself, so a close always reflects your real figures.
Only unreconciled entries for this business, account and period are offered for matching.
Every match links the statement line to the entry it cleared.
Move money between bank, cash and payment-clearing accounts, with any fee a processor withheld.
Import and close need Post Accounting Entries; reopening needs Reverse Accounting Entries.
The original statement and matches are kept, with who reopened it, when and why.
Questions
CSV, TXT, XLS, XLSX, OFX, QFX, QBO, QIF, XML/CAMT, STA/MT940 and BAI/BAI2 files, up to 10 MB and 100,000 rows.
Open it as a prefilled Income or Expense form, review the details and save. Uploading a statement only stages its lines, so nothing is recorded until you approve it.
When the difference is zero. Invoice Crowd calculates it from the entries you've matched, so a closed statement always agrees with the bank.
Yes. A team member with the Reverse Accounting Entries permission can reopen it with a reason of 5 to 500 characters. The original statement and matches are kept, and who reopened it and when is recorded.
Yes. Once a statement is closed, the next one opens at that statement's closing bank balance, and recorded entries that had not cleared yet are offered again. A check written on January 30 and cleared on February 2 can be reconciled on the February statement.
Yes. It pairs each bank line with a recorded entry of the same direction and amount dated within three days, and you confirm the matches before closing. Match transactions lets one line clear several entries, such as a payout net of its fee. Bank Rules you create (New Rule: When, Contains, Category, Priority) suggest the income or expense category when you add an entry from an unmatched line.
Open Match transactions on the bank line and match it to the invoice payments and the fee it covers, or use Record Transfer to move the payout from your payment-clearing account to the bank with the Fee withheld and its Fee expense account. Either way the line clears to an exact zero difference.
Bank Reconciliation is included on paid plans, along with the rest of the accounting module.
Import the statement, review each line, add anything missing and close when the difference is zero.
