Bank reconciliation on Business HQ matches bank CSV export lines to sorted invoices already in your Ledger. It helps confirm which PDFs correspond to outgoing payments without manual spreadsheet work.
What this guide covers
Exporting a bank CSV, uploading it on Business HQ, reading match results, and interpreting unmatched lines.
Before you begin
- Business plan with bank reconciliation enabled.
- Processed vendor invoices in Ledger for the period you are reconciling.
- Bank CSV export from your financial institution (not PDF statements on this panel).
Step-by-step: export bank data
- Log in to your bank and download a transaction CSV for the date range.
- Include description, amount, and date columns when the bank offers format choices.
- Save the file on your computer before opening FilePile.
Step-by-step: run reconciliation
- Log in at /login and open Business HQ (/account/business).
- Scroll to Bank reconciliation in the Reconciliation & reporting section.
- Click Choose file and select your bank CSV.
- Click Match transactions.
- Wait for matched and unmatched counts to appear.
Step-by-step: review matches
- Read Matched and Unmatched stat tiles at the top of results.
- Each match row shows vendor, invoice amount, bank description, and confidence.
- Investigate Unmatched lines for missing PDFs you still need to upload.
- Upload missing vendor PDFs on Dashboard Upload tab, then re-run if needed.
What you should see
- Match list with vendor name, amounts, and bank line description.
- Confidence labels such as high, medium, or low on each match.
- Sample unmatched rows when bank lines have no invoice counterpart.
Tips and common issues
- Reconciliation reads Ledger data, not live bank feeds.
- Upload vendor PDFs first; matching cannot invent invoices you never filed.
- Monthly bank import limits apply per plan; retry next month if capped.
- Pair with Vendor Payment Command Center for due-date context.
Related guides
Tip: Reconcile after your month-end upload batch so Ledger includes every bill you paid that month.
Frequently asked questions
Does FilePile connect to my bank?
No. You upload a CSV export manually.
What file type is required?
CSV from your bank, not PDF statements, on the reconciliation form.
Which plan includes reconciliation?
Business only.
Scenario walkthrough
Imagine it is the 28th of the month. You log in at /login, land on Dashboard (/dashboard), and scan the stat tiles: Tracked spend, Estimated tax (if on Business), Account credit, and Open invoices for your FilePile subscription. You open the Upload tab, add any PDFs that arrived today, then switch to Processing until each row shows completed. You check Ledger for amounts and Browse for folder paths. If Business HQ (/account/business) applies to your plan, you open the relevant panel next. Finally you visit /docs if you need a deeper guide.
Glossary (FilePile terms)
- Dashboard: main workspace at /dashboard with Upload, Processing, Ledger, Tasks, Browse tabs.
- Business HQ: owner tools at /account/business including Payment Command Center, Email Invoice Inbox, Spend Budgets, Approval Workflows, Bank Reconciliation, Tax estimates, Executive P&L, and Accounting export/import.
- Profile: separate business archive under one login; see /account/profiles.
- Ledger: searchable table of processed vendor invoices.
- Tasks: review queue for missing fields or billing mismatches.
Keyboard and navigation habits
Use the left sidebar consistently: Dashboard for daily PDF work, Business HQ for payables and reporting, Reminders at /account/reminders for email preferences, Help center at /docs for articles like this one. The Invoice workspace never uses a tab named Process; uploads always start on Upload.
When to contact support
Contact support if a valid PDF fails after three retries on Processing, if team invites never arrive, if billing charges look incorrect on /account/invoices, or if Business HQ panels stay locked after a confirmed upgrade. Include your account email, active profile name, and screenshot of the error row.
Record-keeping reminder
FilePile sorts and extracts PDFs you provide. It does not replace professional tax, legal, or accounting advice. Keep original vendor emails and bank records alongside your FilePile Browse archive for audit readiness.
Unmatched lines workflow
When a bank payment has no match, search Ledger for the vendor. If missing, obtain the vendor PDF and upload on Upload before the next reconciliation run.
Quick reference card
| Item | Value |
|------|-------|
| Login | /login |
| Register | /register |
| Dashboard | /dashboard |
| Business HQ | /account/business |
| Company | /account/company |
| Reminders | /account/reminders |
| Help | /docs |
| Plans | Free (25/mo), Pro, Business |
| Upload types | PDF only on Dashboard |
| Workspace tabs | Upload, Processing, Ledger, Tasks, Browse |
Keep this table handy when onboarding teammates so nobody searches for a Upload tab that does not exist.