Find missing bank-feed transactions and review possible duplicates
Check the account, filters and import result, then compare suspected duplicates with your bank statement.
On this page
Before you start
- Sign in to the correct landlord portfolio with accounting access. Follow any access or plan message shown on the page; demo and simulation accounts cannot save a duplicate-review decision.
- Have the bank statement or bank transaction history ready, including the account's last four digits, transaction date, amount and description.
- Use this guide for the accounting import feed. A linked feed reads bank transactions; it is separate from a renter's payment method and does not confirm that rent was paid or deposited.
Check the account and filters
Open Accounting, then Transactions and Import feed. Choose All accounts, set Status to Everything, and clear the description, amount and date filters. Select Apply. Look for the statement entry, then narrow the account or description if needed.
Check whether the account is linked or manual
Open Accounts in the accounting navigation. Match the account name, bank and last four digits. Check Linked Accounts, Manual Accounts, and the archived, unlinked, or merged accounts section. Use View all to inspect an account, or View surviving account when a previous account was merged.
Refresh a linked feed and inspect the result
Return to Import feed, open More beside Add transaction, and choose Refresh linked banks. Wait for the result, read the message, and search for the expected entry again with Status set to Everything.
Review the result of a manual CSV import
For a manual account, open More, then Import a CSV. Use the bank's CSV with a date, description, and amount, or debit and credit columns. Choose the intended Account name and Import. Read the counts for imported rows, skipped duplicates, possible overlaps, rows before the bookkeeping start date, and unreadable rows.
Compare a suspected duplicate before deciding
When a row offers Compare imports, open it and compare This imported row with Possible matches already in the feed and your bank statement. Review the dates, amounts, descriptions, import identities and original accounts. Under Reviewed decision, choose Keep this row as a distinct bank event only for a separate real event, or Exclude this row; retain the existing event when it represents the same event. Select Save reviewed decision only when the comparison supports your choice.
Check the saved decision or request help
Read the saved result and choose Refresh account view. A row kept as distinct remains unbooked for normal review. An excluded row remains in history as ignored and offers Review exclusion. If a save times out or the result is unconfirmed, use Reload comparison to check its current state before choosing again.
Move from manual entry to bank imports
Choose the connection’s import period and compare it with the dates you already entered manually. Keep the earlier records and their receipts available during the review.
An imported row can describe the same bank event as an existing manual entry. Compare account, amount, date and reference before booking it. Use the matching or duplicate-resolution action available for that row; do not count the same expense again just because it arrived through a bank feed.
Check the result
- The account and status filters show whether an existing import was hidden from the initial Unbooked view.
- The import result identifies rows added or skipped, or gives you a specific unresolved issue to share with support.
- A confirmed duplicate-review decision leaves a distinct row unbooked or retains an excluded row as ignored; existing bookkeeping is not reversed by that decision.
FAQs
Does Imported 0 new transactions mean my bank feed is up to date?
No. It can mean there were no new rows to add, but the count alone does not confirm every account's connection or refresh result. Check the correct account and Everything status against your bank history. If an expected entry is still absent, retain the displayed message and contact support. The feed shows a limited set of recent imported rows, so an older entry may also remain outside the current view even after filtering.
Why were some rows in my CSV not imported?
Read the import result. Previously imported rows can be skipped, rows before your bookkeeping start date are left out, and unreadable rows are counted separately. The file must be no larger than 5 MB and include a readable date, description, and amount or debit and credit columns. Check Settings, then Accounting, to review the Bookkeeping start date. Changing that date does not by itself import earlier rows. Keep the original CSV and review the cause before importing again.
Can I exclude every pair with the same amount and date?
No. Two legitimate bank events can share the same details. Compare the statement and original imports first. Exclude is an explicit decision about the selected imported row; it retains that row as ignored and leaves the existing event and bookkeeping in place. If two account cards appear to represent the same bank account, Accounts offers Review duplicate account for a separate review; similar names or balances alone are not enough to merge them.
Why is Save reviewed decision unavailable, or why must I reload the comparison?
Wait for the comparison to load and choose a decision. Demo and simulation comparisons are read only. Imports with existing bookkeeping, protected reconciliation history, or other restrictions cannot be changed through this comparison. A changed comparison or an uncertain save result also requires Reload comparison before another decision. If it remains unavailable, keep the displayed reason and contact support rather than trying another way to ignore or book the row.
Why can I see an import but not an expense or a rent payment?
An unbooked import has not yet become a booked accounting entry. Check its status and category, and review any existing match before booking. Your saved transaction rules may already have booked it, so check Everything or Booked before adding another entry. For a rent charge or payment attempt, use Payments and the payment-activity guide; the accounting feed is not a renter payment method or a confirmation of settlement.
Should I delete all manual expenses after connecting a bank?
No. Review the overlap and match the records first. A bank connection may not include all historical transactions, attachments or property assignments.