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 intended landlord portfolio with accounting access. Follow any access or plan message. Duplicate-review decisions cannot be saved in read-only demo or simulation mode.
- Have the original bank statement or transaction history ready, including the masked account, transaction date, signed amount and description. Keep existing receipts and bookkeeping records available for comparison.
- Use this guide for accounting imports. A linked feed reads bank activity; it does not confirm a renter payment, a payout or a change to your rent-deposit destination.
Step 1: Check the feed state and available filters
Choose Open Import feed below, or open Transactions and To book. If Next: import your transactions appears, check Accounts before expecting imported rows or filter controls. Once imported activity exists, choose All accounts, set Status to Everything, clear Description, Amount from ($), Amount to ($), From date and To date, then choose Apply filters.
Step 2: Check the account and its retained history
Open Accounts in the accounting navigation, or More and Manage accounts from Import feed. Match the account name, institution and visible last four digits. Check linked and manual accounts and any collapsed archived, unlinked, or merged accounts section. Use View all for an account, or View surviving account for merged history, when offered.
Step 3: Refresh linked banks and read every result message
For linked activity, return to Import feed, open More beside Add transaction and choose Refresh linked banks. Wait for the result. Read the imported-row count, any failed refreshes or banks needing reconnection, and whether Your bank is still fetching transactions appears. Follow Manage accounts or Check again when offered, then look for the entry with the appropriate account and Everything status.
Step 4: Check the statement upload and skipped-row counts
For manual imports, choose More and Upload transactions, or Upload a statement from setup. In Account, choose the intended active manual account, or Use a new account and supply Account name. Select Statement file, verify the destination and period, then choose Import. Read the imported, duplicate, possible-overlap, before-start-date, unreadable and rules-booked counts.
Step 5: 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 statement. Check dates, signed amounts, descriptions, import identities and original accounts. Under Reviewed decision, choose Keep this row as a distinct bank event for a separate real event, or Exclude this row; retain the existing event for a repeated event. Choose Save reviewed decision only after the evidence supports that choice.
Step 6: Confirm the saved decision or reload its current state
Read the saved result and choose Refresh account view. A row kept as distinct remains unbooked for normal review. An excluded row stays in history as ignored and offers Review exclusion. If a save times out, reports a changed comparison or has an unconfirmed result, choose Reload comparison before another decision.
Compare manual records before adding bank imports
Compare the bank connection or statement period with activity you have already recorded manually. Keep earlier records, receipts and property assignments available while reviewing overlaps.
Compare imports reviews imported bank rows. It does not by itself find or correct every duplicate manual expense, undo a booked entry or reconcile a bank balance. Review existing accounting records before booking another copy of the same event.
The feed loads up to 500 recent imports for the selected status before applying account, description, amount and date filters. Narrowing those filters does not fetch an older page of bank history. If the expected event falls outside the visible window, ask support to trace the retained record instead of repeatedly uploading it.
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. Read any failure, pending-fetch or reconnection message and check the intended account against your bank history. Zero new rows can also mean no rows were added. It does not certify every connection, and older activity can be outside the feed’s recent window.
Why were some rows in my statement file not imported?
Read the result: exact duplicates can be skipped, rows before the default book’s Bookkeeping start date are left out, and unreadable rows are counted separately. Use a supported file within the upload limits and check its dates and amount columns. Accounting settings shows Bookkeeping start date; changing it does not itself import an earlier period. Keep the original export and inspect saved rows before retrying.
Can I exclude every pair with the same amount and date?
No. Distinct bank events can share details. Compare the statement and import identities first. Exclude retains the selected row as ignored and leaves existing bookkeeping in place. Review duplicate account in Accounts is a separate account-level review; similar account names or balances alone do not establish that accounts should be merged.
Why is Save reviewed decision unavailable, or why must I reload the comparison?
Wait for the comparison to load and choose a decision. Read-only demo or simulation mode and protected history prevent saving. A changed comparison, timeout or unconfirmed save also requires Reload comparison before another decision. Keep the stated reason for support instead of trying to bypass the comparison through another booking action.
Why can I see an import but not an expense or a rent payment?
An unbooked import is separate from a booked accounting entry. Check its status and any existing match; rules may already have booked matching rows, so review Everything or the booked transaction list before adding another entry. For a rent charge, payment attempt or payout, use Payments and its payment-activity guide. The accounting feed does not confirm settlement.
Should I delete manual expenses after connecting a bank?
Keep the records while reviewing overlap. A connection may not include all historical transactions, receipts or property assignments. Compare actual events and use the appropriate reviewed correction workflow only after confirming what already exists.