Merge transactions

CharlotteCharlotte Administrator Posts: 464 admin

Uploaded a receipt and have your bank account connected? Marked an invoice paid and have the payment import from the bank as well? Duplicated income or expense transactions are now easier than ever to manage with the merge function.

Simply select two transactions that are both deposits or both withdrawals, with matching amounts and accounts and click the merge button highlighted in the above image.

Merged a duplicate but need to reference some details of the source transaction? Click 'View source transactions' when viewing the details of the merged transactions to pull up all the details:

What do you think of this feature? Has it been useful? Anything you think we can improve? Let us know below!

Comments

  • ndjndj Member Posts: 2

    Wow, this is so useful. Let's me enter a transaction manually that I know is coming and when it shows up due to import I can just merge.

    Thanks!

  • EarlEarl Member Posts: 1

    Thank you very much for this feature! Now we dont need to delete bank transactions that match up with a receipt - awesome.

  • JustinAJustinA Member, Administrator Posts: 15 admin

    @ndj @Earl Good to hear you're both finding merge useful! Thanks for the feedback.

  • prmsssprmsss Member Posts: 2

    Awesome :) I've been waiting for this - very useful icw bank transactions import!

  • mmckiviganmmckivigan Member Posts: 1

    If a check is recorded in a money in transit account, and then it comes through on the bank import it would have been nice to do this with a one click merge. When I try to merge it says it can't merge from two different accounts. So to get around this, I have to move the money in transit record to the same account then do the merge.

  • JustinAJustinA Member, Administrator Posts: 15 admin

    @mmckivigan Thanks for the feedback! In this scenario you don't want to merge the transactions though. When the transaction comes in via the bank import you should be categorizing it as a transfer from the money in transit account.

    This will ensure the income/expense is correctly bookkept on the day you logged the check in the money in transit account, and your balance sheet correctly reflects both the balance of the money in transit, and the account the check was deposited in or withdrawn from.

  • ABKABK Member Posts: 1

    "When the transaction comes in via the bank import you should be categorizing it as a transfer from the money in transit account."
    YES. This is EXACTLY what I have been searching tutorials to figure out. To be clear, 1) I have a $200 check received (from an invoice payment) line item with "money in transit" account 2) And then now bank imports line item for the $200 check with 'ABC Checking Acct' as the account

    So...HOW to do what I just quoted??
    3) "Categorize IT as a transfer" referring to EDITING the bank import transaction to make it a transfer somehow? Or "Categorize it as a transfer" by adding a third transaction--a "Created Transfer" ? (I saw instructions on "created transfer" somewhere amidst all my confusion)
    Thanks in advance!

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @ABK.

    If you categorize the $200 transaction from your bank connection as "Transfer from Money in Transit" and choose your Money in Transit account, Wave will automatically create the other side of that transfer. So if categorize that transaction as a transfer, Wave will create a matching $200 expense to Money in Transit and categorize it as "Transfer to Bank Account".

  • StephanieZStephanieZ Member Posts: 1

    Does the receipt image show up on the transactions page after I merge? Or do I still have to go back to the purchases --> receipts page to see the image? THank you!

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @StephanieZ,

    The image of the receipt doesn't currently appear on the Transactions page regardless of whether the transaction was merged. You will see a mention of the receipt on top of the "Edit transaction" frame, but for the time being, there's no direct link between the transaction on the Transactions page and the image of the receipt.

    While I can't guarantee this will be added to Wave, it is something we've been asked for often, and we are aware of the demand for more of a connection between receipts and their transactions.

  • AprilSukAprilSuk Member Posts: 1

    Oh wow, when I looked up 'duplicate transactions' in the help center it told me to delete one, which was a huge hassle to do over and over again. I am so glad I searched again in here and see now you can merge them! Thank you! (You may want to have someone edit your help pages though).
    https://support.waveapps.com/hc/en-us/articles/115002894323-How-to-ensure-receipt-expenses-are-not-duplicated

  • JustinAJustinA Member, Administrator Posts: 15 admin

    @AprilSuk Thanks for flagging that article! I'll have someone update it. And glad to hear you're finding the duplicate function useful!

  • KopupKopup Member Posts: 5

    @Alexia said:
    Hi, @StephanieZ,

    The image of the receipt doesn't currently appear on the Transactions page regardless of whether the transaction was merged. You will see a mention of the receipt on top of the "Edit transaction" frame, but for the time being, there's no direct link between the transaction on the Transactions page and the image of the receipt.

    While I can't guarantee this will be added to Wave, it is something we've been asked for often, and we are aware of the demand for more of a connection between receipts and their transactions.

    One of my accounts still has an old interface, where I can also merge the receipt record and payment record, and the receipt image can be viewed directly. I don't know why this new interface removed this functionality, which I found it's super useful.
    (without the link to the image of the receipt, I found the value of keep receipt or even upload it, reduced a lot)
    I would really appreciate if you can bring the function back. thanks!

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @Kopup,

    It's absolutely fair for you to expect this feature after having used it in the old version. This feature wasn't as much removed from Wave as it simply hasn't been rebuilt for the new version.

    With that said, I can tell you that we are aware of the demand for this feature to return and that we are listening to your feedback.

  • rwall88rwall88 Member Posts: 9

    +1 Please add that link between the receipt picture and the transaction in the transaction screen.

  • rwall88rwall88 Member Posts: 9

    Is there a way to search for duplicate transactions? We have added several receipts and they automatically created duplicate transactions. I know I can merge now them but I have to find them first.

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @rwall88,

    No, there is no way to automatically detect them, but regular reconciliation can make it easier. If you bring up the transactions for a specific account on the Transactions page, you should be able to easily see the transactions with the same dates and amounts that should be merged.

    Once you've verified a transaction, make sure to check the "Verified" checkmark to its right. You'll be able to filter it out in the future, which can make reconciliation much easier later.

  • KristinKristin Member Posts: 1

    Is there a feature where the software automatically detects and alerts us of possible duplicated transactions?

Sign In or Register to comment.