You might want to remove a transaction from your Ambrook because it's a duplicate, because it will be included in a journal entry, to correct a bank error, or because it was synced/added by mistake. The option you'll see depends on where the transaction came from.
Transactions from a bank connection or csv import can be excluded, but not deleted. Excluding removes the transaction from your Ledger, your reports and the account's Ambrook balance. It doesn't change the synced balance from your bank, and you can undo it at any time.
Manual transactions can be deleted. Deleting permanently removes the transaction from Ambrook and can't be undone.
How to exclude or delete a transaction
On Web:
Go to your Ledger
Click the three dots next to the transaction
Click Delete or Exclude
If excluding, select a reason: Including in journal entry, Correcting bank error, Incorrect transaction details, Duplicate transaction, or type your own under Other. Then click Exclude Transaction.
On Mobile App:
Go to your Ledger
Tap the transaction
Scroll to the bottom
Tap Delete Transaction or Exclude Transaction
If excluding, select a reason
Finding excluded transactions
Excluded transactions are hidden from your Ledger by default. To see them, on web or mobile, go to your Ledger and open Filter → Status → Excluded Only.
To see excluded transactions alongside the rest of your Ledger, choose Recorded or Excluded under Status instead.
How to undo an exclusion
First, find the transaction using the steps in Finding excluded transactions above. Next -
On Web: Click the three dots next to the transaction, then click Undo exclusion.
On Mobile App: Tap the transaction, scroll to the bottom, and tap Undo exclusion.
The following transactions cannot be excluded:
Transactions with multiple line items. To exclude these transactions, remove the line items first, then exclude the whole transaction.
Any payments on invoices. Instead, unmatch these payments by clicking on the three dots on the right of the transaction and selecting "unmatch."
Any transaction tagged with a transfer. First untag the transaction, then exclude. See Unlinking Transfer Tags for instructions.
Manually recorded transactions. Instead, delete the transaction.
Internal transfers. Instead, delete the internal transfer.
Journal entries, which can be edited or deleted directly.
If you want to exclude a large number of transactions due to an issue with your bank account connections, please reach out to our support team via the support chat or at support@ambrook.com, and we can apply an account merge for you.
Frequently Asked Questions
Can I exclude several transactions at once?
Can I exclude several transactions at once?
Not right now. You can bulk select transactions on the Ledger to tag or untag them, but you have to exclude transactions one at a time.
A transaction is on my bank statement. Should I exclude it?
A transaction is on my bank statement. Should I exclude it?
Usually not. If a transaction is on your bank or card statement, keep it on your books, even if you didn’t expect it or don’t think of it as a business expense. If you exclude it, your Ambrook balance won’t match your statement and that month won’t reconcile. Re-tag it to the category that fits instead.
There are two main exceptions:
It shows up twice in Ambrook but once on your statement. Exclude the extra copy and choose Duplicate transaction as the reason.
You’re recording it in a journal entry instead. Exclude it and choose Including in journal entry as the reason.
What should I do with personal transactions in my business account?
What should I do with personal transactions in my business account?
Don’t exclude them. Excluding personal transactions makes your bank balance inaccurate. Instead, tag them so they stay out of your business numbers:
Personal Expense category. Use this for occasional personal purchases from the business account. They show in a separate Personal section of your P&L and stay off your Schedule F or C.
Equity Adjustment to an owner’s equity account. Use this when you move money out of the business for personal use, such as an owner’s draw.
See Managing Personal Expenses to decide which fits.
I imported transactions by mistake, or my CSV had errors. How do I remove them?
I imported transactions by mistake, or my CSV had errors. How do I remove them?
You can exclude imported transactions one at a time, the same way as synced transactions. If you need to remove most or all of a file, it may be faster to remove the whole import and upload a corrected one:
Go to Settings → Import.
Click the three dots next to the import.
Choose Delete imported data. This removes every transaction in that file from your Ambrook.
Fix the errors in the CSV and import it again (if applicable). See How to Bulk Import Transactions.
Note: if you've tagged the imported transactions those tags are removed when the import is deleted.
I connected the wrong bank account. How do I remove those transactions?
I connected the wrong bank account. How do I remove those transactions?
Stop new transactions from coming in. If the account shouldn’t be in Ambrook at all and you don’t need anything tagged to it, choose Hide (or Delete if it's a manual account). That removes its data from your Ledger and reports. If you need to keep some of what synced, choose Stop Sync instead. See Closing or Reopening an Account for the difference between Close, Delete, Hide and Stop Sync.
Exclude what’s left. If wrong transactions are mixed into an account you’re keeping, filter the Ledger by Account and Date and exclude each one.
If you manage more than one business in Ambrook, make sure you’re in the right one before you remove accounts or transactions.
I see the same transaction twice. Which one should I exclude?
I see the same transaction twice. Which one should I exclude?
Check your statement to confirm it only happened once. Then exclude the copy you haven’t tagged or matched, and choose Duplicate transaction as the reason.
A transaction disappeared from my Ledger. Was it excluded?
A transaction disappeared from my Ledger. Was it excluded?
It may have been. Excluded transactions are hidden by default. Filter your Ledger by Status → Excluded Only to check (see Finding excluded transactions above). If it isn't there and it came from a bank connection, see Fixing a Bank Connection That Stopped Syncing. If it was a manual transaction, it may have been deleted, which can't be undone.