What importing does
Importing a bank statement brings your real transactions into NexerIQ so you can match them against your records. It's the first half of reconciling — once the transactions are in, NexerIQ even tries to match them for you.
Importing a statement
- Open the account under Banking → Bank Accounts.
- In the Statements section, choose Import Statement.
- Pick the Format, then use Select File to upload the file your bank gave you.
- Select Import Statement. NexerIQ reads the file and lists every transaction, ready to reconcile.
Which file formats work
NexerIQ accepts two common formats banks export:
- OFX — the standard most banks offer, and usually the smoothest choice if you have it.
- CSV — a simple spreadsheet export, handy when OFX isn't available.
If you're not sure which to download, OFX is usually the easiest to work with. Files can be up to 10 MB.
Reading the statement
Once imported, the statement opens with its Statement Date, Opening Balance, Closing Balance, and a list of every line — each showing the date, reference, description, amount, and a Status. You can re-open any statement from the account's Statements list at any time.
Automatic matching
As soon as a statement is imported, NexerIQ matches what it can — lining up each bank line with the matching record in your books using the amount, the date, and any reference. Matched lines show as Matched; anything it isn't sure about is left as Unmatched for you to review.
Good to know
An imported statement is a fixed record of what the bank sent, so you can always trace each line back to the original. When you're ready to clear the remaining lines, see Reconciling your bank account.
Related Articles
Setting up bank accounts in NexerIQ
Why add your bank accounts Adding your bank accounts to NexerIQ lets you track where money comes in and goes out, import statements, and reconcile — so your books always match your real-world balances. Each bank account is linked to a ledger account ...
Reconciling your bank account in NexerIQ
What reconciling means Reconciling is simply checking that your records agree with your bank. You match each line on the statement to a record in your books, then balance to the statement's closing figure. It's how you catch missed entries, bank ...
Fixing unmatched and excluded bank lines when reconciliation won't balance
When a reconciliation won't balance If the status stubbornly stays In Progress or Not Balanced, it almost always comes down to a few statement lines or a balance figure that needs a second look. This article walks you through the usual causes so you ...
Supplier contacts and bank accounts
Beyond a supplier's name and terms, NexerIQ keeps two practical lists on each supplier record: the people you deal with, and the bank accounts you pay into. Keeping these up to date means the right person gets the call and payments land in the right ...
Reading the Profit & Loss (income statement) report
The Profit & Loss report (also called the income statement) shows what your business earned and spent over a year, and whether you came out ahead. It's the report most owners look at first. You'll find it under Finance → Profit & Loss. NexerIQ totals ...