What this screen is for
Rather than keying bank activity by hand, you import the statement file your bank provides and review what it contains. The screen lists each import with its status and shows how many imports you have made, how many are pending review, how many are completed and how many individual transactions are still waiting to be dealt with. Filters and a search narrow the list.
When to use it
Use it at the point in the month when your bank statement becomes available and you want the entries in the books without typing each one. Import the file first, then review the transactions it produced before they are recorded.
What you see on this screen
Five cards: Total Imports, Pending Review, Completed, Pending Txns (individual transactions still awaiting a decision) and Deleted. The table carries:
- Import Date — when the file was uploaded, with the time beneath
- Bank Account — the bank name and the account the statement was imported against
- Statement Period — the from and to dates the statement covers, with the original file name beneath; Not available where the file gave no dates
- Opening and Closing — the opening and closing balances read from the statement, or a dash where it carried none
- Txns — how many new transactions the file produced, and after a slash how many were recognised as duplicates
- Status — the stage the import has reached, or Deleted
- Actions — view the import's detail; delete it; restore or permanently delete one already deleted
Import Date, Statement Period, Opening, Closing, Txns and Status can all be sorted on.
Filters and actions
Show Filters carries a count of what is set and opens Search over file name and bank, Bank Account, Status, and Statement From and Statement To dates. Two chips toggle Show Deleted / Deleted Only and Newest First / Oldest First, with Reset Filters to clear. Import Statement starts a new import and Rules opens the auto-categorisation rules.
Status values
- Pending — uploaded, not yet read
- Parsing — being read now
- Ready for Review — read successfully, waiting for you to work through its transactions
- Reviewing — being worked through
- Importing — the accepted transactions are being written to the books
- Completed — finished; every transaction has been dealt with
- Failed — the file could not be read
- Cancelled — abandoned before completion
Related
- Auto-Categorization Rules — decide automatically where recurring transactions go
- Bank Reconciliation — agree the account to the statement once the entries are in
- Bank Accounts — the account each statement is imported against