Anybody also stuck in Uploading Invoice using Google Sheets?
emcreditscentral
Member Posts: 9
I just want to know if it's my machine or what. After validating i can't seems to upload my invoices. Uploading loading animation just goes on forever.
1
Comments
Ditto. Any luck resolving issue?
Hey @emcreditscentral & @Acton! Thanks for reaching out here! Have you added your customers and products into your Wave business prior to uploading your invoices? This is the usual cause of the upload not working. If not, navigate to your business in Wave, add the customers and products, and re-attempt the invoice upload through Google Sheets. You can find some tips for uploading in this Wave Connect guide. Let us know if you continue to run into problems!
Hi Emma,
Tried just about everything. Last attempt was deleting all invoices, customers and products and uploading them first customers, then products then invoices. Customers and products went like clockwork. I tried to upload a simple invoice generated in google sheets using the drop-down menus for the customer and product column, with no other data. Validation went well, but again the process hung up in step 3 when trying to upload.
Some odd things:
I tried from a different computer. I bought a new lap top to see my computer was having problems: No effect.
I tried from a different google account: No effect.
Please let me know if you have any ideas.
I have the same problem. Tried several variations no luck.
Looks like a bug on Wave connect.
Wave please advise.
@EmmaP Wave Connect pre-validates entry of Customers and Products so bad data should not be the cause here (in any case it should report an error instead of hanging)
Thanks for your prompt attention - keen to get this sorted.
I tried using Zapier as a workaround for the meantime. I am getting below error:
We had trouble sending your test through.
Got 500 calling POST https://api.waveapps.com/businesses/585de63b-257e-4626-add2-f3e698576781/invoices/, expected 2xx.
@Acton @emcreditscentral @xenium Hi guys. Looks like we've been having a recent issue with certain aspects of Wave Connect and it seems like it's most likely affecting you as well. We're currently working on getting this fixed so I'd suggest checking back in a few days to see if we've implemented the solution yet.
@emcreditscentral How are you using Zapier? Which app are you integrating with Wave? I'm curious what your workflow is! For Zapier related questions, it might be more helpful to submit a support ticket with them here: https://zapier.com/app/contact-us/
Hi is there any update regarding WaveConnect?
Hey there @emcreditscentral
Really sorry you're one of the users affected by this. Currently no update, but our team is working on fixing this issue
Any update on this?
Hey @ffletch, @emcreditscentral, @xenium & @Acton! Thanks for reaching out about this issue, we appreciate your patience while we work on this. The team have provided a workaround that should allow you to upload in the mean time while they work towards a resolution.
When creating the invoice upload sheet with Wave Connect, select the following additional / optional fields, and consider them mandatory:
• Invoice Date
• Due Date
• Currency
• Invoice Number Label
Note that the Invoice Number Label is the ‘name’ of the invoice document, usually just “Invoice”.
Hope this helps!
Thanks @EmmaP I was missing the Invoice Number Label field. Once I added that with the value "invoice" on every line, then I was able to upload invoices.
I am running into another issue. Whenever I upload an invoice it shows as unpaid once its uploaded. I've tried adding the following columns with appropriate values in them and it hasn't worked:
Payment Date, Last Payment Date, Status, Payment Account and Payment method
I even tried downloading sample existing invoices to see what fields I should be looking for and I think I have all of the columns from those sample invoices. Not sure what I'm missing. It'd be great if there were some sort of log so that I could better understand why it didn't work.
Any idea what might be going on? Or perhaps do you have any suggestions for addressing this issue?
Thanks again for your help!
Hey @ffletch! I think I can see what's happening here! When you mark an invoice as paid, it creates an income transaction for that invoice. If you're importing invoice into Wave, and they've already been paid, then you would need an income transaction in your Accounting > Transactions page that would mark that invoice as paid. We can't mark an invoice as paid without showing income for that invoice.
@ConnorM - Thanks for your response - I understand what you're saying and that makes sense. So my conundrum is that I'm starting from scratch. All I have is invoices. I do want to capture the pay date and the fact that they were paid as that's obviously important information that I need for historical purposes. Any suggestions? What are my options?
@ffletch Sure thing. Definitely doable within Wave, you've got two options here! One is to record a payment, by navigating to the invoices from your Sales > Invoices page (once it has been imported), and you'll see a button that says 'Record a payment'. That's going to let you punch your payment information in just from a records perspective, and it will also automatically create a transaction in order to reconcile that invoice as paid. I'm thinking that's going to be your best bet!
@ConnorM Thanks again for your response. Is there a way to handle this on import? I'm importing 100's of invoices. So entering payment manually for each of them is going to take awhile. It also leaves open the strong possibility of human error with the manual entries.
Hey @emcreditscentral! Thanks for reaching out, that's definitely an odd one. I'd recommend continuing to upload with alternating customers, if that's working out!
@ffletch I totally hear you, that's a tough one. There isn't a way, unfortunately, to handle this on import, which I understand puts you in a bit of a bind. I'm sorry that we don't have a better workaround for that at this time.
@ConnorM Thanks once again for your response. I really appreciate the transparency. At this point I just need to know how high the mountain that I need to climb is . We'll import invoices without payment information for now. It might be nice to have some sort of note or something (perhaps in the validation step) that mentions those fields are not used on import. Thanks again for your help.
Hey @emcreditscentral I'd love to see what's causing it! Let's start by having you send a screenshot of that invoice upload in your Wave Connect sheet. Happy to get some eyes on that and we can start there!
I am still having issues with Wave Connect, I have used the option "Prepare Input Sheet" and selected the following mandatory fields as suggested by EmmaP
• Invoice Date
• Due Date
• Invoice Currency
• Invoice Number Label
It just sits there pulsing on step 2.
is there a fix for this?
thanks
Ok, it finally validated, now its sooooo slow at uploading. Been running maybe 5 minutes now. I have a very fast internet connection, so its not ISP speed issue.
@ConnorM i sent you a message with the links to the screenshots. Hope we can fix these. Thank you.
ok, after 24 hours and multiple attempts it has still not uploaded invoices
This is as far as it gets, I have tried different PC, made sure browser up to date etc.
Hi everyone. This seems to be an ongoing issue that we're having which causes an infinite load time. We do have a temporary solution to this until we can get it fixed. When creating the invoice upload sheet, select the following additional / optional fields, and consider them mandatory:
Invoice Date
Due Date
Currency
Invoice Number Label
The only one that should not be intuitive to complete is Invoice Number Label. This is simply the 'name' of the invoice document, usually just “Invoice”.