Hey @ams , thanks for reaching out and for the feedback. We are working on enhancing our bank connections feature to ensure that it recognizes if a transaction exists already in your account, and prevents it from being entered again. This would avoid duplicate transactions and prevent you from having to go through your transactions and merge/delete duplicates as needed, which I know is time consuming. Building out features like this does take time, but we really appreciate your patience!
I agree that an add receipt button would also be a huge game changer, I am not sure if this is on our current roadmap, but I will pass the suggestion along to our product team and as always your feedback is greatly appreciated!
I'm a consultant with a number of clients that require to me to attend off site functions. Each offsite function I attend I create a liability account and include all my expenses. I can see over the year what each function has cost and bill the client correctly. I started to use my corporate credit card and now expenses come in under that account. I saw i can merge transactions, was hoping I could merge the credit card one to the manually entered one but I see I cannot. How can I keep track of expenses for each client per function I attend and use my corp card and keep an overall picture of my liquidity without duplicate transactions?
Having 2 transactions in Wave for the same one transaction, one automatically generated and the other by downloading the receipt, I merged the two as instructed. All good. Except that now I can't see or access the receipt I downloaded. How can I view the receipt after merging (where the automatic entry overrides the downloaded one)?
Hi @459consulting . You can only merge transactions that have the exact same details. This includes the amount, date, as well as account. It sounds like your transactions might be associated to different accounts due to the created liability account, and then the liability account associated to your Credit Card. If this is the case, just change the account on one of the transactions so that it matches, and then try merging them again.
Hey @francois12uk . Normally the transaction with the receipt does take precedence, although there are situations where this isn't the case. What was the nature of the transaction that did take precedence? Did it happen to have numerous line items? Was it a Bill payment? Either way, moving forward the best way to correct this would be to re-upload the receipt again so you can have it in the system.
Well I discovered that if you select the one with the receipt first, and then the bank transaction one, and then merge, it slects the receipt one - so far that's worked. I demerged the one in question, followed my own order and indeed it worked, this time the one with the receipt overrode.
A related question: in the case of invoices paid by bank transfer, the system automatically looks for the invoice number to allocate it, whereas a separate entry with payment also exists. When merging the two (since there was only 1 invoice and 1 payment) if you select the one with the invoice number allocated, you then cannot assign that income to a particular Income Account. If you choose the one with the with the income account that's fine, but then in invoices all of a sudden the invoice shows as unpaid. How can I allocate an invoice to both the invoice number it refers to and to the income account I want it to be allocated to?
Hi @francois12uk . When you create a product/service, you subsequently select the Income Account that you want it associated to. This means that when a payment is applied to an invoice, there's no need to manually apply it to the Income Account as it's already being done naturally when payment is applied.
Mmm. I see. I created an invoice and typed a product in the invoice (as a description rather than as a product category), I didn't create "the product" first and then the invoice. That means your system only works if you create a product first. Now that I know that I can live with it - I only wish that this had been made clearer in your instructions on how to create an invoice.
Will Wave be adding the ability to just add a receipt to a transaction? That would seriously simplify this process - then once an expense posts from your bank, you could just hit "Add Receipt" on the transaction itself and upload the receipt image.
@HCS We still don't have any immediate plans of adding this particular feature in Wave, although, it could be potentially added to a roadmap in the future. Appreciate the feedback that you've provided us here, and when/if we do have plans to implement something like this, we will be sure to let our users know.
@HappyCruisers66 Are you able to send us a screenshot of the issue as you see it? Provided that the transaction created by the receipt upload and the transaction imported to Wave are in the same amount and are assigned the same bank account, the option should appear to merge.
Hey @JamieD, I also think adding a receipt to an existing transaction would solve a big pain point for me. Since this is one of the primary features I was looking to get out of Wave, I think I'll need to look for another accounting solution. Could you please ping me if this feature is added to the roadmap?
Hi @evanbovie, thank you for sharing your feedback on this. I'm afraid that due to sheer number of Wave users, it is not possible for us to ping individual users with updates on when a feature is added to the roadmap. With this being said though, I can certainly understand your need for adding receipts to existing transactions. While I cannot promise that such a feature will be a part of Wave in the future, I also cannot rule out the possibility.
Could you please help here ?
25/02/2019: creation of an invoice. Amount 300 Euros
15/07/2019: payment with credit card through Wave. Amount 295.55. Transaction created automatically in Wave and impossible to change.
22/07/2019: Automatic transaction through bank connexion. Amount 294.53.
When trying to merge the transactions, it's impossible.
What should I do to keep one transaction ?
Along the same lines is there any way to merge three items? For example, when traveling I use Uber to get to/from airport and hotel, then I tip the driver in the app. The bank card makes it two bank transactions and I get one total receipt from Uber. Do I just delete the bank card transactions and save the posted receipt payment?
@Coachyz Interesting, you should be able to merge those duplicate transactions! Are they the exact same amount? You would only be able to merge them if they are for the exact same amount. If for some reason merging is causing you trouble, you can delete the bank imported transaction. Merging is ideal but making sure you only have one record of the transaction is the priority.
@Exechfm If your bank logs the payment and tip as two separate expenses, I'm afraid you wouldn't be able to merge these expense together as one. In this case, I would actually recommend keeping your bank imported transactions and not posting your total uber receipt payment (as it's ideal for your bank statement to match what's recorded in Wave)!
Quite useless as a manual process given that Wave could simply automatically merge the two transactions based on date, total and merchant. Not exactly in the spirit of Wave which otherwise strives to make life easier.
Question, when I upload my receipts, I am able to merge. The problem is that when I go to the transactions page, and I click on the line item, I do not see any receipt attached to the expense. When I used Exependigo.com, I was able to attach receipts to the line item, and when I downloaded my reports, all I had to do was click on any expense line item, and the receipt for that item would simply pop up. I guess my question is: Does Wave attach images of receipts to transaction line items?
At this point, when you upload a receipt, it creates a transaction. If your bank imports the same transaction you should be able to just merge these two. When you view the original transaction it should still contain the receipt, but I usually tell people to just delete the bank imported transaction, and keep their receipt, as the image is still available. I know that our accounting team is looking into future image attachments to your transactions, but there is no ETA for when that will be implemented.
Interestingly enough, the day before this article was posted/updated, I started seeing duplicate transactions appearing. The issue seemed to resolve itself, but the transactions are still there. And I don't use receipts... Hmm....
Hi @BarsinA
when we upload receipts is there any way we can enter a reference number of the receipt?
Also if we export CSV files of for example certain expense class is there any function we can costomise our report colums
Hey @abbeyJaye . Any idea where they came from? In the meantime, you can delete any duplicates that you're seeing to balance out your books.
@IACUser When you upload a receipt, it creates a corresponding transaction. You can add the reference number to the corresponding created transaction under the Transactions page.
In regards to the .csv function, I'm afraid when exporting, the file you get is the only one we can export as there's currently no customizability available for exporting.
Hi @IACUser! The 'notes' section of the transaction is where you'd want to enter the number! You could also add it to the description if you wish so when you complete a search it will surface this transaction.
@IACUser the notes will export with the transaction if you are exporting transactions through the Settings > Data Export method although these notes will not appear in the Report exports.
@RJ_Admin That would be the way to do it as there's no way to automate this process. My question to further understand your business needs is why do you choose to upload receipts into Wave if your bank is importing these transactions into Wave already? Do you find that it makes reconciliation easier, or does your accountant perhaps request the receipt images? Let me know!
@alch88vdet Can you give me your use case? How are you using a voucher and where are you using it in Wave? Is this a Bill or an Invoice?
Comments
Hey @ams , thanks for reaching out and for the feedback. We are working on enhancing our bank connections feature to ensure that it recognizes if a transaction exists already in your account, and prevents it from being entered again. This would avoid duplicate transactions and prevent you from having to go through your transactions and merge/delete duplicates as needed, which I know is time consuming. Building out features like this does take time, but we really appreciate your patience!
I agree that an add receipt button would also be a huge game changer, I am not sure if this is on our current roadmap, but I will pass the suggestion along to our product team and as always your feedback is greatly appreciated!
Hi @459consulting . You can only merge transactions that have the exact same details. This includes the amount, date, as well as account. It sounds like your transactions might be associated to different accounts due to the created liability account, and then the liability account associated to your Credit Card. If this is the case, just change the account on one of the transactions so that it matches, and then try merging them again.
Hey @francois12uk . Normally the transaction with the receipt does take precedence, although there are situations where this isn't the case. What was the nature of the transaction that did take precedence? Did it happen to have numerous line items? Was it a Bill payment? Either way, moving forward the best way to correct this would be to re-upload the receipt again so you can have it in the system.
A related question: in the case of invoices paid by bank transfer, the system automatically looks for the invoice number to allocate it, whereas a separate entry with payment also exists. When merging the two (since there was only 1 invoice and 1 payment) if you select the one with the invoice number allocated, you then cannot assign that income to a particular Income Account. If you choose the one with the with the income account that's fine, but then in invoices all of a sudden the invoice shows as unpaid. How can I allocate an invoice to both the invoice number it refers to and to the income account I want it to be allocated to?
Hi @francois12uk . When you create a product/service, you subsequently select the Income Account that you want it associated to. This means that when a payment is applied to an invoice, there's no need to manually apply it to the Income Account as it's already being done naturally when payment is applied.
Mmm. I see. I created an invoice and typed a product in the invoice (as a description rather than as a product category), I didn't create "the product" first and then the invoice. That means your system only works if you create a product first. Now that I know that I can live with it - I only wish that this had been made clearer in your instructions on how to create an invoice.
@HCS We still don't have any immediate plans of adding this particular feature in Wave, although, it could be potentially added to a roadmap in the future. Appreciate the feedback that you've provided us here, and when/if we do have plans to implement something like this, we will be sure to let our users know.
There is no option in my wave to merge these transactions.......I am wondering if I should be switching to Quikbooks
@HappyCruisers66 Are you able to send us a screenshot of the issue as you see it? Provided that the transaction created by the receipt upload and the transaction imported to Wave are in the same amount and are assigned the same bank account, the option should appear to merge.
Hey @JamieD, I also think adding a receipt to an existing transaction would solve a big pain point for me. Since this is one of the primary features I was looking to get out of Wave, I think I'll need to look for another accounting solution. Could you please ping me if this feature is added to the roadmap?
Hi @evanbovie, thank you for sharing your feedback on this. I'm afraid that due to sheer number of Wave users, it is not possible for us to ping individual users with updates on when a feature is added to the roadmap. With this being said though, I can certainly understand your need for adding receipts to existing transactions. While I cannot promise that such a feature will be a part of Wave in the future, I also cannot rule out the possibility.
Could you please help here ?
25/02/2019: creation of an invoice. Amount 300 Euros
15/07/2019: payment with credit card through Wave. Amount 295.55. Transaction created automatically in Wave and impossible to change.
22/07/2019: Automatic transaction through bank connexion. Amount 294.53.
When trying to merge the transactions, it's impossible.
What should I do to keep one transaction ?
Along the same lines is there any way to merge three items? For example, when traveling I use Uber to get to/from airport and hotel, then I tip the driver in the app. The bank card makes it two bank transactions and I get one total receipt from Uber. Do I just delete the bank card transactions and save the posted receipt payment?
@Coachyz Interesting, you should be able to merge those duplicate transactions! Are they the exact same amount? You would only be able to merge them if they are for the exact same amount. If for some reason merging is causing you trouble, you can delete the bank imported transaction. Merging is ideal but making sure you only have one record of the transaction is the priority.
@Exechfm If your bank logs the payment and tip as two separate expenses, I'm afraid you wouldn't be able to merge these expense together as one. In this case, I would actually recommend keeping your bank imported transactions and not posting your total uber receipt payment (as it's ideal for your bank statement to match what's recorded in Wave)!
@ckeen_1244 Ok...thought it could be something along those lines. Thanks for the advice on which to keep.
@Exechfm Always happy to help!
Quite useless as a manual process given that Wave could simply automatically merge the two transactions based on date, total and merchant. Not exactly in the spirit of Wave which otherwise strives to make life easier.
Question, when I upload my receipts, I am able to merge. The problem is that when I go to the transactions page, and I click on the line item, I do not see any receipt attached to the expense. When I used Exependigo.com, I was able to attach receipts to the line item, and when I downloaded my reports, all I had to do was click on any expense line item, and the receipt for that item would simply pop up. I guess my question is: Does Wave attach images of receipts to transaction line items?
Hey there @Expendigo
At this point, when you upload a receipt, it creates a transaction. If your bank imports the same transaction you should be able to just merge these two. When you view the original transaction it should still contain the receipt, but I usually tell people to just delete the bank imported transaction, and keep their receipt, as the image is still available. I know that our accounting team is looking into future image attachments to your transactions, but there is no ETA for when that will be implemented.
Interestingly enough, the day before this article was posted/updated, I started seeing duplicate transactions appearing. The issue seemed to resolve itself, but the transactions are still there. And I don't use receipts... Hmm....
Hi @BarsinA
when we upload receipts is there any way we can enter a reference number of the receipt?
Also if we export CSV files of for example certain expense class is there any function we can costomise our report colums
Hey @abbeyJaye . Any idea where they came from? In the meantime, you can delete any duplicates that you're seeing to balance out your books.
@IACUser When you upload a receipt, it creates a corresponding transaction. You can add the reference number to the corresponding created transaction under the Transactions page.
In regards to the .csv function, I'm afraid when exporting, the file you get is the only one we can export as there's currently no customizability available for exporting.
@AlexL
Can U please specify! i have attached a screen shot! i cudnt find any place whre i can enter the receipt reference number!
Hi @IACUser! The 'notes' section of the transaction is where you'd want to enter the number! You could also add it to the description if you wish so when you complete a search it will surface this transaction.
Thank you @EmmaP . If i enter it in notes will it be possible to export it to CSV with the notes
There must be an easier way than manually merging every receipt. Am I missing something? Can this be automated?
How are vouchers normally connected (referenced) to a row in the accounting? Thank you
@IACUser the notes will export with the transaction if you are exporting transactions through the Settings > Data Export method although these notes will not appear in the Report exports.
@RJ_Admin That would be the way to do it as there's no way to automate this process. My question to further understand your business needs is why do you choose to upload receipts into Wave if your bank is importing these transactions into Wave already? Do you find that it makes reconciliation easier, or does your accountant perhaps request the receipt images? Let me know!
@alch88vdet Can you give me your use case? How are you using a voucher and where are you using it in Wave? Is this a Bill or an Invoice?